Abstract
Based on a systematic study of the semantics of temporal attributes of entities, this paper provides new guidelines for the design of temporal relational databases. The notions of observation and update patterns of an attribute capture when the attribute changes value and when the changes are recorded in the database. A lifespan describes when an attribute has a value. And derivation functions describe how the values of an attribute for all times within its lifespan are computed from stored values. The implications for temporal database design of the semantics that may be captured using these concepts are formulated as schema decomposition rules.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
J. Clifford and A. Croker. The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans. In Proceedings of ICDE, pp. 528–537, February 1987.
J. Clifford and A. U. Tansel. On an Algebra for Historical Relational Databases: Two Views. In Proceedings of ACM SIGMOD, pp. 247–265, May 1985.
R. Elmasri, G. Wuu, and V. Kouramajian. A Temporal Model and Query Language for EER Databases. In [17], pp. 212–229.
S. K. Gadia. A Homogeneous Relational Model and Query Languages for Temporal Databases. ACM TODS, 13(4):418–448, December 1988.
S. K. Gadia and J. H. Vaishnav. A Query Language for a Homogeneous Temporal Database. In Proceedings of ACM PODS, pp. 51–56, March 1985.
C. S. Jensen, J. Clifford, R. Elmasri, S. K. Gadia, P. Hayes, and S. Jajodia (eds). A Glossary of Temporal Database Concepts. SIGMOD Record, 23(1):52–64, March 1994.
C. S. Jensen, R. T. Snodgrass, and M. D. Soo. Extending Normal Forms to Temporal Relations. Technical Report TR-92-17, Department of Computer Science, University of Arizona, Tucson, AZ, July 1992.
C. S. Jensen and R. T. Snodgrass. Semantics of Time-Varying Attributes and Their Use for Temporal Database Design. Technical Report R-95-2012, Department of Math. and Computer Science, Aalborg University, Denmark, May 1995.
C. S. Jensen, M. D. Soo, and R. T. Snodgrass. Unifying Temporal Models via a Conceptual Model. Information Systems, 19(7):513–547, 1994.
M. R. Klopprogge and P. C. Lockemann. Modelling Information Preserving Databases: Consequences of the Concept of Time. In Proceedings of VLDB, pp. 399–416, 1983.
N. A. Lorentzos. Management of Intervals and Temporal Data in the Relational Model. Technical Report 49, Agricultural University of Athens, 1991.
S. B. Navathe and R. Ahmed. A Temporal Relational Model and a Query Language. Information Sciences, 49:147–175, 1989.
R. T. Snodgrass (ed). The TSQL2 Temporal Query Language. Kluwer Academic Publishers, 1995, 674+xxiv pages.
M. D. Soo, C. S. Jensen, and R. T. Snodgrass. An Algebra for TSQL2. In [13], chapter 27, pp. 505–546.
R. T. Snodgrass. The Temporal Query Language TQuel. ACM TODS, 12(2):247–298, June 1987.
A. Segev and A. Shoshani. A Temporal Data Model based on Time Sequences. In [17], pp. 248–270.
A.U. Tansel, J. Clifford, S.K. Gadia, A. Segev, and R.T. Snodgrass (eds). Temporal Databases: Theory, Design, and Implementation. Benjamin/Cummings, 1993.
J. Wijsen. Extending Dependency Theory for Temporal Databases. Ph.D. Thesis. Department Computerwetenschappen, Katholieke Universiteit Leuven, 1995.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jensen, C.S., Snodgrass, R.T. (1995). Semantics of time-varying attributes and their use for temporal database design. In: Papazoglou, M.P. (eds) OOER '95: Object-Oriented and Entity-Relationship Modeling. ER 1995. Lecture Notes in Computer Science, vol 1021. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0020547
Download citation
DOI: https://doi.org/10.1007/BFb0020547
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60672-7
Online ISBN: 978-3-540-48527-8
eBook Packages: Springer Book Archive