Abstract
Data warehouses are oftentimes in charge of supporting the decision finding processes in companies and public administration. To fulfil these tasks the systems model parts of real world regarding the respective application domain. But the world is changing and in such an evolving environment data warehouses can only cope with their tasks if they can be kept consistent with the real world. For that purpose they have to be able to deal with modifications in the data schema and their influence on the data values. This paper focusses on the modeling of the data transformation. We identified six different types of transformation operations. Based on the semantic analysis of these operations we present a matrix based representation for data transformation which enables us to specify the transformation results and a more efficient graph based representation, which furthermore offers potential for optimization.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Statistical Office of the European Communities, http://ec.europa.eu/eurostat/
Eder, J., Wiggisser, K.: Data Warehouse Maintenance, Evolution and Versioning. In: Liu, L., Özsu, T. (eds.) Encyclopedia of Database Systems. LNCS. Springer, Heidelberg (2009)
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)
Eder, J., Wiggisser, K.: A DAG Comparison Algorithm and its Application to Temporal Data Warehousing. In: ER 2006, pp. 217–226. Springer, Heidelberg (2006)
Kimball, R.: Slowly Changing Dimensions. DBMS Magazine 9(4), 14 (1996)
Quix, C.: Repository Support for Data Warehouse Evolution. In: Proc. of the 1st Int’l. WS on Design and Management of Data Warehouses, p. 4 (1999)
Vaisman, A., Mendelzon, A.: A Temporal Query Language for OLAP: Implementation and a Case Study. In: Proc. of the Int’l. WS on Database Programming Languages, pp. 78–96 (2001)
Body, M., Miquel, M., Bédard, Y., Tchounikine, A.: Handling Evolutions in Multidimensional Structures. In: Proc. of the 19th ICDE, pp. 581–591 (2003)
Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G.: Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation. Data- and Knowledge Engineering 59(2), 435–459 (2006)
Malinowski, E., Zimányi, E.: A conceptual solution for representing time in data warehouse dimensions. In: Proc. of the 3rd Asia-Pacific Conference on Conceptual Modelling, pp. 45–54 (2006)
Kaas, C., Pedersen, T., Rasmussen, B.: Schema Evolution for Stars and Snowflakes. In: Proc. of the 6th ICEIS, pp. 425–433 (2004)
SAP Inc.: Multi-Dimensional Modeling with BW: ASAP for BW Accelerator. Technical report, SAP Inc. (2000)
Kalido: KALIDO Dynamic Information Warehouse: A Technical Overview. Technical report, Kalido (2004)
Ehrig, H., Ehrig, K., Prange, U., Taentzer, G.: Fundamentals of Algebraic Graph Transformation. Monographs in Theoret. Comp. Science (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Eder, J., Wiggisser, K. (2008). Modeling Transformations between Versions of a Temporal Data Warehouse. In: Song, IY., et al. Advances in Conceptual Modeling – Challenges and Opportunities. ER 2008. Lecture Notes in Computer Science, vol 5232. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-87991-6_10
Download citation
DOI: https://doi.org/10.1007/978-3-540-87991-6_10
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-87990-9
Online ISBN: 978-3-540-87991-6
eBook Packages: Computer ScienceComputer Science (R0)