Data warehouse

From LIMSWiki
Jump to: navigation, search

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.[1]

Further reading

References

  1. 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.