Thursday, October 16, 2014

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.

No comments: