Data warehouse combines various data sources into a single resource for end-user access. End-user can perform ad hoc queries, reporting, analysis, and visualisation of the warehouse information. Data warehousing typically involves combining a variety of technology vendors’ products into an integrated solution.
The purpose of a data warehouse is to establish a data repository that makes operational data accessible in a form that is readily acceptable for decision support and executive information system application.
Characteristics of Data Warehousing:
- Data are organised by detailed subject relevant for decision support
- Integrated and consistent
- Stable (not updated or changed)