Abstract
Temporal Data Warehouses (TDWs) allow to manage time-varying multidimensional data by joining the research of Temporal Databases and Data Warehouses. TDWs raise different issues such as temporal aggregations, multidimensional schema versioning, etc. However, very little attention from the research community has been drawn to conceptual modeling for TDWs and its subsequent logical representation. In this paper, we present a mapping transforming our conceptual model for TDW design into the conventional ER and an object-relational models. For the latter, we show some examples using the SQL:2003 standard. We include the mapping for time-varying levels, hierarchies, and measures. We also discuss the inconveniences of a pure relational representation.
The work of E. Malinowski was funded by a scholarship of the Cooperation Department of the Université Libre de Bruxelles.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Bliujute, R., Slatenis, S., Slivinskas, G., Jensen, C.: Systematic change mangement in dimensional data warehousing. Technical report, Time Center, TR-23 (1998)
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)
Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 4th edn. Addison-Wesley, Reading (2003)
Gregersen, H., Mark, L., Jensen, C.: Mapping temporal ER diagrams to relational schemas. Technical report, Time Center, TR-39 (1998)
Jensen, C., Snodgrass, R.: Temporally enhanced database design. In: Papazoglou, M., Spaccapietra, S., Tari, Z. (eds.) Advances in Object-Oriented Data Modeling, pp. 163–193. MIT Press, Cambridge (2000)
Malinowski, E., Zimányi, E.: A conceptual solution for representing time in data warehouse dimensions. In: Proc. of the 3rd Asia-Pacific Conf. on Conceptual Modelling, pp. 45–54 (2006)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: from conceptual modeling to logical representation. Data & Knowledge Engineering (to appear, 2006)
Malinowski, E., Zimányi, E.: Inclusion of time-varying measures in temporal data warehouses. In: Proc. of the 8th Int. Conf. on Enterprise Information Systems (to appear, 2006)
Martín, C., Abelló, A.: A temporal study of data sources to load a corporate data warehouse. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737, pp. 109–118. Springer, Heidelberg (2003)
Melton, J.: Advanced SQL: 1999. Understanding Object-Relational and Other Advanced Features. Morgan Kaufman Publisher, San Francisco (2003)
Mendelzon, A., Vaisman, A.: Temporal queries in OLAP. In: Proc. of the 26th Very Large Database Conference, pp. 243–253 (2000)
Pedersen, T., Jensen, C., Dyreson, C.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)
Wang, X., Bettini, C., Brodsky, A., Jajodia, S.: Logical design for temporal databases with multiple granularities. ACM Transactions on Database Systems 22(2), 115–170 (1997)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Malinowski, E., Zimányi, E. (2006). Object-Relational Representation of a Conceptual Model for Temporal Data Warehouses. In: Dubois, E., Pohl, K. (eds) Advanced Information Systems Engineering. CAiSE 2006. Lecture Notes in Computer Science, vol 4001. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11767138_8
Download citation
DOI: https://doi.org/10.1007/11767138_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-34652-4
Online ISBN: 978-3-540-34653-1
eBook Packages: Computer ScienceComputer Science (R0)