July 6, 2011 at 7:09 am
What is the concept of Dataware house,How it is install and all?
In MSDN also I am continuos seraching I am not getting good start.
PLS HELP
Thanks
July 11, 2011 at 2:59 am
Data warehouse concept:
http://en.wikipedia.org/wiki/Data_warehouse
The most simple (and of course oversimplified) defination I can think of:
"a data warehouse is a database with a time aspect"
The time aspect means that if a record changes, the older record is kept (these are called slowly changing dimensions in data warehousing).
Another important difference with traditional databases is that a database is (usually) normalized, while a data warehouse is more denormalized.
I recommend the book "The Datawarehouse Toolkit" by Ralph Kimball to get you started.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2011 at 1:22 pm
A data warehouse is a database that consolidates data across the entire enterprise or organization. The database should be nonvolatile, meaning that data which is updated or deleted in the operational database(s) would be versioned, keyed on time, and retained for archival purposes when migrated to the data warehouse database. The data warehouse should be optimized for reporting, but whether the data is actually staged, transformed, or contained in a denormalized model are implementation details that don't define a data warehouse and arn't required.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 12, 2011 at 1:38 pm
Analysis Services is the data warehousing capability provided in SQL Server.
The wiki above is a good start for DW in general
The below link gives details of SSAS as a data warehouse
http://msdn.microsoft.com/en-us/library/ms175609%28v=sql.90%29.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply