In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the data warehouse for reporting.
The typical data warehouse uses staging, integration, and access layers to house its key functions. The staging layer stores raw data, the integration layer integrates the data and moves it into hierarchal groups, and the access layer helps users retrieve data.
- Vannest, Jeff (11 February 2011). "Advantages of a Data Warehouse". LABVANTAGE Solutions, Inc.. http://www.labvantage.com/blog/?p=79. Retrieved 17 February 2012.
- Patil, Preeti S.; Srikantha Rao; Suryakant B. Patil (2011). "Optimization of Data Warehousing System: Simplification in Reporting and Analysis". International Journal of Computer Applications (Foundation of Computer Science) 9 (6): 33–37. http://www.ijcaonline.org/proceedings/icwet/number9/2131-db195.