Data Warehouse Characteristics
Data Warehouse is designed with four characteristics. They are
- Time variant.
- Non Volatile.
- Subject Oriented.
A Data Warehouse is a time variant data base, which supports the business management in analysing the business and comparing the business with different time periods like Year, Quarter, Month, Week and Date.
Attributes of Time
It is non volatile Database, once the data entered into the database, it does not reflects to the change which takes place at operational database. Hence the data is statics in Data Warehouse.
- It generates artificially keys or surrogate keys to store the history.
- A surrogate key generated serious of numbers.
- It requires more disk space.
A DWH is a integrated database, which allows you to collect the data and integrate the data with multiple database sources.
Data warehouse is a subject oriented database, which supports the business need of individual department specific user.
Example : Sales, HR, Accounts, Marketing etc.