An approach towards an event-fed solution for slowly changing dimensions in data warehouses with a detailed case study

Data and Knowledge Engineering

Volumn 63, Issue 1, 2007, Pages 26-43

  Manh Nguyen, Tho ^a   Min Tjoa, A ^a   Nemec, Jaromir ^b   Windisch, Martin ^b  

^a VIENNA UNIVERSITY OF TECHNOLOGY   (Austria)

^b T Mobile Austria   (Austria)

Author keywords

Active data warehousing; Data refresh; Event based data integration; Slowly changing dimension

Indexed keywords

DATA TRANSFER; INFORMATION RETRIEVAL; INFORMATION SYSTEMS; MESSAGE PASSING; QUERY PROCESSING; SOFTWARE PROTOTYPING;

ACTIVE DATA WAREHOUSING; DATA INTEGRATION; DATA REFRESH; SLOWLY CHANGING DIMENSION;

DATA WAREHOUSES;

EID: 34250185031     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2006.10.004     Document Type: Article

References (23)

1. Kopetz H., and Bauer G. The time-triggered architecture. Proceedings of the IEEE Special Issue on Modeling and Design of Embedded Software vol. 91 (2003), Springer-Verlag LNCS 2114 112-126 (No. 1)
2. Brobst S. Enterprise application integration and active data warehousing. Proceedings of Data Warehousing 2002 (2002), Physica-Verlag 15-22
3. B. Rieger, K. Brodmann, Mastering time variances of dimension tables in the data warehouse, Osnabrueck University. http://andromeda.oec.uni-osnabrueck.de/uwdstift/DMOS-Res.pdf, 1999.
4. R. Bliujute, S. Saltenis, G. Slivinskas, C.S.Jensen, Systematic change management in dimensional data warehousing, in: Proceedings of the Third International Baltic Workshop on Databases and Information Systems, Riga, Latvia, 1998, pp. 27-41.
5. Jensen C.S., and Dyreson C.E. The consensus glossary of temporal database concepts. Proceedings of Temporal Databases: Research and Practice (1998), Springer LNCS 1399 367-405
6. Koncilia C., and Eder J. Changes of dimension data in temporal data warehouses. Proceedings of Data Warehousing and Knowledge Discovery, DaWaK 2001 (2001), Springer-Verlag LNCS 2114 284-293
7. TIBCO Software Inc. Tibco. http://www.tibco.com, 2002.
8. Inmon W.H. Building the Data Warehouse. second ed. (1996), Wiley Inc
9. W. Rjaibi, K. Dittrich, D. Jaepel, Event matching in symmetric subscription systems, in: Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research, 2002, pp. 9-10.
10. Kimball R. The Data Warehouse Toolkit (1996), Wiley Inc
11. Kimball R. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. second ed. (2002), Wiley Inc
12. Kimball R. Realtime partitions. Intelligent Enterprise Magazine 5 3 (2002)
13. Kimball R. Tricky time spans. Intelligent Enterprise Magazine 5 10 (2002)
14. MOF, Meta object facility (MOF) specification. http://www.omg.org/docs/formal/00-04-03.pdf, 2003.
15. A. Karakasidis, P. Vassiliadis, E. Pitoura, Etl queues for active data warehousing, in: Proceedings of the Second International Workshop on Information Quality in Information Systems IQIS 2005, 2005, pp. 28-39.
16. Hohpe G., Woolf B., Brown K., D'Cruz C., Fowler M., Neville S., Rettig M.J., and Simon J. Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Systems (2004), Pearson Education
17. Jensen C.S., and Snodgrass R.T. Semantics of time-varying information. Information Systems 21 4 (1996) 311-352
18. Gao D., Jensen S., Snodgrass T., and Soo D. Join operations in temporal databases. The VLDB Journal The International Journal on Very Large Data Bases 14 1 (2006) 2-29
19. R. Rocha, F. Cardoso, M. Souza, Performance tests in data warehousing ETLM process for detection of changes in data origin, in: Proceedings of Data Warehousing and Knowledge Discovery, DaWaK 2003, LNCS 2737, pp. 129-139, 2003.
20. Bruckner R., and Tjoa A. Managing time consistency for active data warehouse environments. Proceedings of Data Warehousing and Knowledge Discovery, DaWaK 2001 (2001), Springer-Verlag LNCS 2114 254-263
21. J. Vandermay, Considerations for building a real-time oracle data warehouse, datamirror corporation white paper. http://datawarehouse.ittoolbox.com/white-papers/considerations-for- building- a-realtime-data-warehouse-1188, 2000.
22. Eder J., Kappel G., Tjoa A., and Wagner R. Bier - the behaviour integrated entity relationship approach. Proceedings of the Fifth International Conference on Entity-Relationship Approach (1996), Dijon, North-Holland 147-166
23. B. Babel, J. Eder, C. Koncilia, T. Morzy, R. Wrembel, Creation and management of versions in multiversion data warehouse. in: Proceedings of the 2004 ACM symposium on Applied computingm, 2004, pp. 717-723.