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
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