Abstract
The theoretical interest and the practical relevance of a systematic treatment of multiple temporal dimensions is widely recognized in the database and information system communities. Nevertheless, most relational databases have no temporal support at all. A few of them provide a limited support, in terms of temporal data types and predicates, constructors, and functions for the management of time values (borrowed from the SQL standard). One (resp., two) temporal dimensions are supported by historical and transaction-time (resp., bitemporal) databases only. In this paper, we provide a relational encoding of a conceptual model featuring four temporal dimensions, namely, the classical valid and transaction times, plus the event and availability times. We focus our attention on the distinctive technical features of the proposed temporal extension of the relation model. In the last part of the paper, we briefly show how to implement it in a standard DBMS.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
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
Ben-Zvi, J.: The time relational model. PhD thesis, University of California, Los Angeles (1982)
ChronoGeoGraph (2009), http://dbms.dimi.uniud.it/cgg/
Combi, C., Montanari, A.: Data models with multiple temporal dimensions: Completing the picture. In: Dittrich, K.R., Geppert, A., Norrie, M.C. (eds.) CAiSE 2001. LNCS, vol. 2068, pp. 187–202. Springer, Heidelberg (2001)
Combi, C., Montanari, A., Rossato, R.: A uniform algebraic characterization of temporal functional dependencies. In: Proc. of the 12th International Symposium on Temporal Representation and Reasoning (TIME), pp. 91–99. IEEE Computer Society Press, Los Alamitos (2005)
Gubiani, D., Montanari, A.: ChronoGeoGraph: an expressive spatio-temporal conceptual model. In: Ceci, M., Malerba, D., Tanca, L. (eds.) Proc. of the 15th Italian Symposium on Advanced Database Systems (SEBD), pp. 160–171 (2007)
Jensen, C.S., Snodgrass, R.T. (eds.): Temporal Database Entries for the Springer Encyclopedia of Database Systems. Technical Report TIMECENTER TR-90 (2008)
Jensen, C.S., Snodgrass, R.T.: Semantics of time-varying attributes and their use for temporal database design. In: Papazoglou, M.P. (ed.) ER 1995 and OOER 1995. LNCS, vol. 1021, pp. 366–377. Springer, Heidelberg (1995)
Jensen, C.S., et al.: The consensus glossary of temporal database concepts - February 1998 version. In: Temporal Databases, Dagstuhl (TDB), pp. 367–405 (1997)
Lorentz, D., et al.: Oracle Database SQL Reference (2005)
Navathe, S.B., Ahmed, R.: Temporal extensions to the relational model and SQL. In: Uz Tansel, A., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R. (eds.) Temporal Databases: theory, design, and implementation, pp. 92–109. The Benjamin/Cummings Publishing Company (1993)
Oracle. Oracle 10g (2007), http://www.oracle.com
Sarda, N.L.: HSQL: A historical query language. In: Uz Tansel, A., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R. (eds.) Temporal Databases: theory, design, and implementation, pp. 110–140. The Benjamin/Cummings Publishing Company (1993)
Vianu, V.: Dynamic functional dependency and database aging. Journal of the ACM 34(1), 28–59 (1987)
Wijsen, J.: Temporal FDs on complex objects. ACM Transactions on Database Systems 24(1), 127–176 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gubiani, D., Montanari, A. (2009). A Relational Encoding of a Conceptual Model with Multiple Temporal Dimensions. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2009. Lecture Notes in Computer Science, vol 5690. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03573-9_67
Download citation
DOI: https://doi.org/10.1007/978-3-642-03573-9_67
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03572-2
Online ISBN: 978-3-642-03573-9
eBook Packages: Computer ScienceComputer Science (R0)