Data warehouse system
A data warehouse system is an information system that consists of all the components required for the data warehouse process . These are at least the data acquisition area (English staging area) , in which the data extracted from the data sources are merged and, if necessary, adjusted and transformed, and the central data warehouse database, the actual data warehouse (data warehouse). Ideally, further components are the data marts and the metadata repository , the memory for the metadata and the data warehouse manager for process control , which are required to provide area-specific or evaluation-specific views .
The data warehouse database is fed from a wide variety of internal and external data sources using the ETL process . On the basis of this integrated database, comprehensive evaluations are possible, which are usually carried out in the data marts.
The data sources and their management systems are usually not part of the data warehouse system.
literature
- A. Bauer, H. Günzel: Data warehouse systems - architecture, development, application . dpunkt, 2013, ISBN 978-3-89864-785-4 .
- WH Inmon, RD Hackethorn: Using the Data Warehouse. John Wiley & Sons, New York 1994, ISBN 0-471-05966-8 .
- W. Lehner: Database technology for data warehouse systems, concepts and methods. dpunkt, 2002, ISBN 3-89864-177-5 .
- M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis: Fundamentals of Data Warehouses. 2nd Edition. Springer, 2003, ISBN 3-540-42089-4 .
- J. Töpfer, R. Winter: Active Enterprise Intelligence. Springer, 2008, ISBN 978-3-540-78496-8 .