Twelve Rules That Define a Data Warehouse

1. Data Warehouse and operational environments are separated

2. data are integrated

3. contains historical data over a long time horizon

4. snapshot data captured at a given point in time

5. subject-oriented

6. mainly read-only

7. development is data driven; the classical approach is process driven

8. contains data with several levels of detail

9. characterized by read-only transactions to very large data sets

10. traces data resources, transformation, and storage

11. metadata are a critical component of this environment

12. contains a charge-back mechanism for resource usage