stickleprojects Level: Moderator

 Registered: 09-09-2002 Posts: 891
|
Re: what is data warehousing and Olap??
DW- The storage of related data in query-based format.
So if you search for sales by dept. The data is stored against dept. If you search by sales, dept, loc, the data is stored by dept & loc.
OLAP
Online Analytical Processing, the process of querying a DW (in theory).
Performing OLAP queries (bulk-data informatino gathering) against an OLTP (online transaction processing) database is not recommended. OLAP/DW is an industry, your question is like saying "tell me about database, in detail from scratch".
If you're using SQL Server 2k, MSDN.microsoft.com has loads of articles, otherwise, books available from MSDN Press, Amazon, TheComputerBookshop and others.
Keywords,
Snowflake,
OLTP
OLAP
Data Wharehousing
____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)
|