Friday, September 18, 2009

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

1 comment:

  1. This is one of the reputable data warehouse services companies which helped me in supporting the various effective decision-making procedures. The data sources and the data extracting features provided in this article helped me in managing the large quantity of data comfortably. I must say it is one of the topmost blog that had assisted me in making various challenging decisions.

    ReplyDelete