Modeling and Maintaining Histories in Data Warehouses

The topic of data warehousing [2,4] comprises architectures, algorithms, models, tools, organizational and management issues for integrating data from several operational systems in order to provide information for decision support, e.g., using data mining techniques or OLAP (on-line analytical processing) tools. Thus, in contrast to operational systems which contain detailed, atomic and current data accessed by OLTP (on-line transactional processing) applications, data warehousing technology aims at providing integrated, consolidated and historical data stored in a separate database, the data warehouse (DWH). A data warehouse system (DWS) includes the data warehouse and all components responsible for building, accessing and maintaining the DWH. 6 References