[Back]

M. Nguyen, M. Martin Windisch, J. Jaromir Nemec:
"Event-Feeded Dimension Solution";
Talk: 7th International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2005, Copenhagen, Denmark; 2005-08-22 - 2005-08-26; in: "Data Warehousing and Knowledge Discovery, 7th International Conference, DaWaK 2005", Lecture Notes in Computer Science 3589 Springer 2005, Data Warehousing and Knowledge Discovery, 7th International Conference, Copenhagen, Denmark (2005), ISBN: 3-540-28558-x; 22 - 31.

From the point of view of a data warehouse system its part of collect-ing and receiving information from other systems is crucial for all subsequent business intelligence applications. The incoming information can be classified generally in two types, the state-snapshot data and the state-change or event data usually called transactional data, which contains information about the change processes applied on the instances of information objects. On the way towards active data warehouses it becomes more important to provide complete data with minimal latency. We focus in this paper on dimensional data provided by any data-master application. The information transfer is done via messages containing the change-information of the dimension instances. The receiving data warehouse system is able to validate the event-messages, reconstruct the complete history of the dimension and provide a well applicable "comprehen-sive slowly changing dimension" (cSCD) interface for well-performing queries on the historical and current state of the dimension. A prototype implementa-tion of "active integration" of a data warehouse is proposed.

http://aleph.ub.tuwien.ac.at/F?base=tuw01&func=find-c&ccl_term=AC05936252

http://publik.tuwien.ac.at/files/pub-inf_2953.pdf