Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
Semantics of time-varying information
Information Systems
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Event matching in symmetric subscription systems
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Creation and management of versions in multiversion data warehouse
Proceedings of the 2004 ACM symposium on Applied computing
Join operations in temporal databases
The VLDB Journal — The International Journal on Very Large Data Bases
ETL queues for active data warehousing
Proceedings of the 2nd international workshop on Information quality in information systems
Evaluation model of business intelligence for enterprise systems using fuzzy TOPSIS
Expert Systems with Applications: An International Journal
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
From the point of view of a data warehouse system, collecting and receiving information from source systems is crucial for all subsequent business intelligence applications. Incoming information can generally be classified into two types: (1) the state-oriented data and (2) event-oriented data or transactional data, which contains information about the change performed by processes on the instances of information objects. On the way towards achieving the goal of a full-fledged active data warehouse it becomes more and more important to provide data with minimal latency. In this paper we focus on dimensional data which is provided by general data warehouse applications. The information transfer is performed via messages containing the change of information on the dimension instances. The proposed approach is able to validate the event-messages, reconstruct the complete history of the dimension and provide a well applicable ''comprehensive slowly changing dimension'' (cSCD) interface for queries on the historical and current state of the dimension. A description of the prototype implementation for this kind of an ''active integration'' in a data warehouse and a case study at T-Mobile conclude the paper.