Abstract
As several mature implementations of data warehousing systems are fully operational, a crucial role in preserving their up-to-dateness is played by the ability to manage the changes that the data warehouse (DW) schema undergoes over time in response to evolving business requirements. In this paper we propose an approach to schema versioning in DWs, where the designer may decide to undertake some actions on old data aimed at increasing the flexibility in formulating cross-version queries, i.e., queries spanning multiple schema versions. After introducing an algebra of DW schema operations, we define a history of versions for data warehouse schemata and discuss the relationship between the temporal horizon spanned by a query and the schema on which it can consistently be formulated.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Eder, J., Koncilia, C.: Changes of dimension data in temporal data warehouses. In: Proc. DaWaK, pp. 284–293 (2001)
Yang, J.: Temporal data warehousing. PhD thesis, Stanford University (2001)
Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. IJCIS 7, 215–247 (1998)
Maier, D.: The theory of relational databases. Computer Science Press, Rockville (1983)
Lechtenbörger, J.: Computing Unique Canonical Covers for Simple FDs via Transitive Reduction. Technical report, Angewandte Mathematik und Informatik, University of Muenster, Germany. To appear on Information Processing Letters (2004)
Aho, A.V., Garey, M.R., Ullman, J.D.: The transitive reduction of a directed graph. SIAM Journal on Computing 1, 131–137 (1972)
Lechtenbörger, J., Vossen, G.: Multidimensional normal forms for data warehouse design. Information Systems 28, 415–434 (2003)
Pourabbas, E., Shoshani, A.: Answering Joint Queries from Multiple Aggregate OLAP Databases. In: Proc. 5th DaWaK, Prague (2003)
McKenzie, E., Snodgrass, R.: Schema evolution and the relational algebra. Information Systems 15, 207–232 (1990)
Roddick, J., Snodgrass, R.: Schema versioning. In: The TSQL2 Temporal Query Language, pp. 425–446. Kluwer Academic Publishers, Dordrecht (1995)
Jensen, C.S., Clifford, J., Elmasri, R., Gadia, S.K., Hayes, P.J., Jajodia, S.: A consensus glossary of temporal database concepts. ACM SIGMOD Record 23, 52–64 (1994)
Roddick, J.: A survey of schema versioning issues for database systems. Information and Software Technology 37, 383–393 (1995)
Quix, C.: Repository Support for Data Warehouse Evolution. In: Proc. DMDW (1999)
Vaisman, A., Mendelzon, A., Ruaro, W., Cymerman, S.: Supporting dimension updates in an OLAP server. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 67–82. Springer, Heidelberg (2002)
Blaschka, M.: FIESTA - A framework for schema evolution in multidimensional databases. PhD thesis, Technische Universitat Munchen, Germany (2000)
Eder, J., Koncilia, C., Morzy, T.: The COMET Metamodel for temporal data warehouses. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 83–99. Springer, Heidelberg (2002)
Oracle: Oracle change management pack. Oracle Technical White Paper (2000)
Kalido: Kalido dynamic information warehouse - a technical overview. KALIDO White Paper (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G. (2004). Schema Versioning in Data Warehouses. In: Wang, S., et al. Conceptual Modeling for Advanced Application Domains. ER 2004. Lecture Notes in Computer Science, vol 3289. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30466-1_38
Download citation
DOI: https://doi.org/10.1007/978-3-540-30466-1_38
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23722-8
Online ISBN: 978-3-540-30466-1
eBook Packages: Springer Book Archive