I will be covering mostly the Crux of the discussion i had with my Client on which to use for a Major Warehouse project.
Planning Plays a very important role in the effieient design and development of the application.
I am not talking about the waterfall model, as it is in-efficient in many circumstances and specially while software is concerned, where things are Ad-Hoc in nature and making one change in the waterfall model, is not possible unless to RIP-Apart the Code.
So the Ad-hoc method of development sometime (always) shows Faster Development and more integrated structure than you may imagine, still keeping the integrity and Scalability in place.

Star Schema is efficient in large Warehouse projects.
Snow Flake on the other hand is efficient in Small/mid warehouse project

Star Schema, as the name suggests is a star like model, with one core (Fact) and branches directly connected to the core, signifying the (dimensions).

SnowFlake Schema has outer branching from the parent dimensions(dimensions connected to parent dimensions) which are connected to facts/Core.

Star requires less Normalization while Snow Flake requires more normalization.

This in turn presents issues with snowflake as the Query needs more joins to retrieve results and in majority of the cases the queries are slow.

Performance consideration is a major factor in choosing a schema, and STAR performs as it should… It SHINES…

Again it depends on the busines needs as well..

Ever wondered who is connected to SSAS or about the processes going on in SSAS, well here was an answer from Microsoft Samples Code. if you haven’t already downloaded the samples update you can do it now from here: http://www.codeplex.com/MSFTASProdSamples

You can download the activity Viewer for SSAS for SQL 2005 as well as a updated SQL 2008 Samples release 4. here http://msftdbprodsamples.codeplex.com/releases/view/37109

Remember you have to build the Activity Monitor, so read the readme file before running into subfolders and ending up with a stroke. (build = compile only.. i am not talking about coding from scratch.. which would be fun)

Trust me i have been using this SSAS activity Viewer for more than a year now and it has been the best tool for tracking down the processes.

you can also use the windows performance monitor (perfmon) and SQL Profiler to track down the performance activity on your SSAS.

If you want Microsoft SQL Server 2005 Analysis Services (SSAS) to be accessed from IIS web app and using IIS anonymous access setting, you need to SET the Security\RequireClientAuthentication server configuration to False in SSAS Properties.

Check the “Show Advanced Properties”  at the bottom of the Properties Dialog.

image

Change the “RequireClientAuthentication” value to false:

image

And if you can Restart the SSAS Service.(NOT Required).

© 2010 D B A N A T I O N Suffusion WordPress theme by Sayontan Sinha
Better Tag Cloud