Data Warehouse Prerequisites. Familiarity with Microsoft SQL Server System Administration for Microsoft SQL Server 7.0 and Implementing a Database on Microsoft SQL Server 7.0 Knowledge of Transact-SQL Usage in Developing OLTP Systems
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
What is Data Warehousing?
Special Thanks to Bill Inmon, the “grandfather”
of data warehousing.
A data warehouse is a:
collection of data in support of management's decision making process.
Current valued data
Time horizon: 60 – 90 days
Key fields may or may not have an element of time
Data can be updated
Time horizon: 5 – 10 days
Keys do not have an element of time
Once snapshot is made, records cannot be updated
The different components of the data warehouse are:
collection of data in support of management's decision needs.
lightly summarized data, and
highly summarized data.
Peter Rawsthorne, B.Tech, MCSD, MCT, CCR
President, Eclectic Endeavours Inc.
559A Artisan Lane
PO Box 281
Bowen Island, BC
CANADA V0N 1G0