Understanding Data Warehouse

Understanding Data Warehouse

• The Data Warehouse is that database which is kept separate from the organization's operational database.
• There is no frequent updation done in data warehouse.
• Data warehouse possess consolidated historical data which help the organization to analyse it's business.
• Data warehouse helps the executives to organize,understand and use their data to take strategic decision.
• Data warehouse systems available which helps in integration of diversity of application systems.
• The Data warehouse system allows analysis of consolidated historical data analysis.

Definition

Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support management's decision making process.