Abstract
Most temporal data models have concentrated on describing temporal data based on versioning of objects, tuples, or attributes. The concept of time series, which is often needed in temporal applications, does not fit well within these models. The goal of this paper is to propose a generalized temporal database model that integrates the modeling of both version-based and time-series based temporal data into a single conceptual framework. The concept of calendar is also integrated into our proposed model. We also discuss how a conceptual Extended-ER design in our model can be mapped to an object-oriented or relational database implementation.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
J. Clifford and A. Rao, “A Simple, General Structure for Temporal Domains,” Temporal Aspects in Information Systems, C. Rolland, F. Bodart, and M. Leonard (Ed.) (1988) 17–28
R. Chandra and A. Segev, “Managing Temporal Financial Data in an Extensible Database,” Proc. 19th Int'l Conf. on VLDB, (1993) 302–313
R. Chandra, A. Segev, and M. Stonebraker, “Implementing Calendars and Temporal Rules in Next Generation Databases,” Proc. 3rd Int'l Conf. on Data Engineering (1994) 264–273
W. Dreyer, A. K. Dittrich, and D. Schmidt, “An Object-Oriented Data Model for a Time Series Management System,” Proc. 7th Int'l Working Conf. on Scientific and Statistical Database Management (1994) 186–195
W. Dreyer, A. K. Dittrich, and D. Schmidt, “Research Perspectives for Time Series Management Systems,” ACM SIGMOD Record, Vol. 23, No. 1 (1994) 10–15
W. Dreyer, A. K. Dittrich, and D. Schmidt, “Using the CALANDA Time Series Management System,” Proc. ACM SIGMOD Int'l Conf. (1995) 489
C. E. Dyreson and R. T. Snodgrass, “Timestamp Semantics and Representation,” Information Systems, 18, No. 3 (1993) 143–166
R. Elmasri, V. Kouramajian, and S. Fernando, “Temporal Database Modeling: An Object-Oriented Approach,” CIKM 93, Proc. 2nd Int'l Conf. on Information and Knowledge Management (1993)
R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems” 2nd Edition, Benjamin/Cummings (1994)
R. Elmasri, G. Wuu, “A Temporal Model and Query Language for ER Database,” In IEEE Data Engineering Conference (1990)
S. Gadia, and C. Yeung, “A Generalized model for a temporal relational database,” In ACM SIGMOD Conference (1988)
V. Kourmajian and R. Elmasri, “Mapping of 2-D Temporal Extended ER Models into Temporal FNF and NFNF Relational Models,” Proc. 10th International Conference on the Entity-Relationship Approach (1991)
A. Kurt and M. Ozsoyoglu, “Modeling Periodic Time and Calendars,” Proc. Int'l Conf. on Application of Databases (1995) 221–234
C. Lecluse, P. Richard, and F. Velez, “O2, an Object Oriented Data Model,” Proc. ACM SIGMOD Conference (1988)
S. Navathe, and R. Ahmed, “A Temporal Data Model and Query Language,” In Information Sciences (1989)
E. Rose and A. Segev, “TOODM — A Temporal Object-Oriented Data Model with Temporal Constraints”, Proc. 10th International Conference on the Entity-Relationship Approach (1991)
D. Schmidt, A. K. Dittrich, W. Dreyer, and R. Marti, “Time Series, a Neglected Issue in Temporal Database Research?,” Proc. Int'l Workshop on Temporal Databases (1995) 214–232
R. Snodgrass, “The Temporal Query Language TQUEL,” In ACM TODS 12(2) (1987)
A. Segev and A. Shoshani, “Logical Modeling of Temporal Data,” Proc. ACM SIGMOD Int'l Conf. (1987)
M.D. Soo and R.T. Snodgrass, “Multiple Calendar Support for Conventional Database Management,” Technical Report TR 92-07, Dept. of Computer Science, University of Arizona, USA
A. Tansel et al., Editors “Temporal Databases: Theroy, Design, and Implementations,” Database System and Applications Series. Benjamin/Cummings (1993)
G. Wuu and U. Dayal, “A Uniform Model for Temporal Object-Oriented Databases,” Proc. 8th International Conference on Data Engineering (1992)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lee, J.Y., Elmasri, R., Won, J. (1996). Specification of calendars and time series for temporal databases. In: Thalheim, B. (eds) Conceptual Modeling — ER '96. ER 1996. Lecture Notes in Computer Science, vol 1157. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0019933
Download citation
DOI: https://doi.org/10.1007/BFb0019933
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61784-6
Online ISBN: 978-3-540-70685-4
eBook Packages: Springer Book Archive