SEARCH

Google

Friday, February 23, 2007

DATA WAREHOUSING CONCEPTS

characterization of data warehouses

a datawarehouse is

1) Subject-oriented, meaning that the data in the database is
organized so that all the data elements relating to the same
real-world event or object are linked together.

2) Time-variant, meaning that the changes to the data in the
database are tracked and recorded so that reports can be
produced showing changes over time.

3) Non-volatile, meaning that data in the database is never
over-written or deleted, but retained for future reporting.

4) Integrated, meaning that the database contains data from
most or all of an organization's operational applications, and
that this data is made consistent.

No comments: