Wednesday, September 26, 2007
Data Warehouse
Data warehouse is a collection of historical data as well as current data.
Data warehouse is defined with the help of subject-oriented, time-variant, non-volatile and integrated data.
Share It:
Data warehouse is defined with the help of subject-oriented, time-variant, non-volatile and integrated data.
- Subject-oriented
- 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;
- Time-variant
- The changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time;
- Non-volatile
- Data in the database is never over-written or deleted - once committed, the data is static, read-only, but retained for future reporting; and
- Integrated
- The database contains data from most or all of an organization's operational applications, and that this data is made consistent.
# posted by Kunal @ 1:29 AM 
Subscribe to Posts [Atom]
