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
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 updatedTime Variant
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.