Data explosion and attributes in BI

Published 10 May 07 06:04 AM | SQL Master 

One of our Business Manager has asked can we handle the data explosion and BI requirement to handle billions of rows for their Sales pitch using SQL Server Analysis Servers. The obvious answer was 'yes' using the latest version of SQL Server and before that I have asked myself to get a complete information on set of attributes associated within that Data Warehouse, how effectively we can analyzer the amount of data based on their characterists. Well, there was much more drilling of data is required and necessity is a business high requirement to handle and I don't want to miss this opportunity to enhance my skills in BI Big Smile.

Then my next task was where can I get such information, immediately searched for MSDN blogs on BI aspect that can keep me calm to understand the requirement.

Bingo! Eugene Asahara's blog insight had shown me the path to identify and plan a design in this regard and I would like to cross post the 2 relevant blogs I have been to:

Growing-Number-of-Object-Attributes - part 1

Growing-Number-of-Object_Attributes - part 2

Comments

No Comments
Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.

Search

Go

This Blog

«May 2007»
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

Syndication