Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation

Data and Knowledge Engineering

Volumn 59, Issue 2, 2006, Pages 435-459

  Golfarelli, Matteo ^a   Lechtenbörger, Jens ^b   Rizzi, Stefano ^a   Vossen, Gottfried ^b  

^a UNIVERSITY OF BOLOGNA   (Italy)

^b UNIVERSITY OF MÜNSTER   (Germany)

Author keywords

Cross version querying; Data warehousing; Schema augmentation; Schema versioning

Indexed keywords

DATA REDUCTION; DATABASE SYSTEMS; GRAPH THEORY; QUERY LANGUAGES;

CROSS VERSION QUERYING; SCHEMA AUGMENTATION; SCHEMA VERSIONING;

DATA WAREHOUSES;

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

References (38)

1. Oracle Change Management Pack. Technical report, Oracle Technical White Paper, 2000.
2. KALIDO dynamic information warehouse-a technical overview. Technical report, KALIDO White Paper, 2004.
3. Aho A.V., Garey M.R., and Ullman J.D. The transitive reduction of a directed graph. SIAM Journal on Computing 1 2 (1972) 131-137
4. Ausiello G., D'Atri A., and Saccà D. Graph algorithms for functional dependency manipulation. Journal of the ACM 30 4 (1983) 752-766
5. B. Be ̧bel, J. Eder, C. Koncilia, T. Morzy, R. Wrembel, Creation and management of versions in multiversion data warehouse, in: Proc. SAC, Nicosia, Cyprus, 2004, pp. 717-723.
6. M. Blaschka, FIESTA-a framework for schema evolution in multidimensional databases, Ph.D. thesis, Technische Universitat Munchen, Germany, 2000.
7. M. Blaschka, C. Sapia, G. Höfling, On schema evolution in multidimensional databases, in: Proc. DaWaK, 1999, pp. 153-164.
8. Cormen T.H., Stein C., Rivest R.L., and Leiserson C.E. Introduction to Algorithms (2001), McGraw-Hill
9. S.S. Cosmadakis, P.C. Kanellakis, Functional and inclusion dependencies: a graph theoretic approach, in: Proc. 3rd PODS, 1984, pp. 29-37.
10. C. De Castro, F. Grandi, M.R. Scalas, On schema versioning in temporal databases, in: S. Clifford, A. Tuzhilin (Eds.), Recent Advances in Temporal Databases, Zurich, Switzerland, 1995, pp. 272-294.
11. J. Eder, C. Koncilia, Changes of dimension data in temporal data warehouses, in: Proc. DaWaK, 2001, pp. 284-293.
12. J. Eder, C. Koncilia, T. Morzy, The COMET metamodel for temporal data warehouses, in: Proc. CAiSE, 2002, pp. 83-99.
13. Golfarelli M., Maio D., and Rizzi S. The Dimensional Fact Model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems 7 2-3 (1998) 215-247
14. M. Golfarelli, S. Rizzi, A methodological framework for data warehouse design, in: Proc. 1st DOLAP Workshop, Washington, 1998, pp. 3-9.
15. F. Grandi. A relational multi-schema data model and query language for full support of schema versioning, in: Proc. 10th SEBD, Isola d'Elba, Italy, 2002.
16. Gray J., Chaudhuri S., Bosworth A., Layman A., Reichart D., Venkatrao M., Pellow F., and Pirahesh H. Data Cube: a relational aggregation operator generalizing group-by, cross-tab, and sub totals. Data Mining and Knowledge Discovery 1 1 (1997) 29-53
17. H. Gupta, V. Harinarayan, A. Rajaraman, J.D. Ullman, Index selection for OLAP, in: Proc. ICDE, 1997, pp. 208-219.
18. Inmon W.H. Building the Data Warehouse. third ed. (2002), John Wiley & Sons
19. Jensen C., Clifford J., Elmasri R., Gadia S.K., Hayes P.J., and Jajodia S. A consensus glossary of temporal database concept. ACM SIGMOD Record 23 1 (1994) 52-64
20. Jensen C., et al. The consensus glossary of temporal database concepts. In: Etzion O., Jajodia S., and Sripada S. (Eds). Temporal Databases: Research and Practice (1998), Springer 367-405
21. Kimball R., Reeves L., Ross M., and Thornthwaite W. The Data Warehouse Lifecycle Toolkit (1998), John Wiley & Sons
22. Lechtenbörger J. Computing unique canonical covers for simple FDS via transitive reduction. Information Processing Letters 92 4 (2004) 169-174
23. Lechtenbörger J., and Vossen G. Multidimensional normal forms for data warehouse design. Information Systems 28 5 (2003) 415-434
24. H. Lenz, A. Shoshani, Summarizability in OLAP and statistical databases, in: Proc. 9th SSDBM, 1997, pp. 132-143.
25. C. Letz, E. Henn, G. Vossen, Consistency in data warehouse dimensions, in: Proc. IDEAS, 2002, pp. 224-232.
26. Maier D. The Theory of Relational Databases (1983), Computer Science Press
27. McKenzie E., and Snodgrass R. Schema evolution and the relational algebra. Information Systems 15 2 (1990) 207-232
28. E. Pourabbas, A. Shoshani, Answering joint queries from multiple aggregate OLAP databases, in: Proc. 5th DaWaK, Prague, 2003.
29. C. Quix, Repository support for data warehouse evolution, in: Proc. DMDW, 1999.
30. Red-Gate Software, Compare and synchronize SQL database structures, 2004.
31. Roddick J. A survey of schema versioning issues for database systems. Information and Software Technology 37 7 (1995) 383-393
32. SAP. Multi-dimensional modeling with BW: ASAP for BW accelerator, Technical report, SAP America Inc. and SAP AG, 2000.
33. D. Theodoratos, M. Bouzeghoub, A general framework for the view selection problem for data warehouse design and evolution, in: Proc. DOLAP, McLean, 2000.
34. Theodoratos D., and Bouzeghoub M. Data currency quality satisfaction in the design of a data warehouse. International Journal of Cooperative Information Systems 10 3 (2001) 299-326
35. TSQL2 Language Design Committee. The TSQL2 Temporal Query Language (1995), Kluwer Academic Publishers
36. Ullman J.D. Database and Knowledge-Base Systems vol. 1 (1988), Computer Science Press
37. A. Vaisman, A. Mendelzon, W. Ruaro, S. Cymerman, Supporting dimension updates in an OLAP server, in: Proc. CAiSE, 2002, pp. 67-82.
38. J. Yang, Temporal data warehousing, Ph.D. thesis, Stanford University, 2001.