Abstract
Temporal databases provide a complete history of all changes to a database and include the times when changes occurred. This permits users to query the current status of the database as well as the past states, and even future states that are planned to occur. Traditional temporal data models concentrated on describing temporal data based on versioning of objects, tuples or attributes. However, this approach does not effectively manage time-series data that is frequently found in real-world applications, such as sales, economic, and scientific data. In this paper, we first review and formalize a conceptual model that supports time-series objects as well as the traditional version-based objects. The proposed model, called integrated temporal data model (ITDM), is based on EER. It includes in it the concept of time and provides necessary constructs for modeling all different types of objects. We then propose a temporal query language for ITDM, that treats both version-based and time-series data in a uniform manner.
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
Chandra, R., Segev, A.: Managing Temporal Financial Data in and Extensible Database. In: Proc. 19th Int’l Conf. on VLDB, pp. 302–313 (1993)
Chandra, R., Segev, A., Stonebraker, M.: Implementing Calendars and Temporal Rules in Next Generation Databases. In: Proc. 3rd Int’l Conf. on Data Engineering, pp. 264–273 (1994)
Dayal, U., Wuu, G.: A uniform Approach to Processing Temporal Queries. In: Proc. 18th VLDB Conf., pp. 407–418 (1992)
Dreyer, W., Dittrich, A.K., Schmidt, D.: An Object-Oriented Data Model for a Time Series Management System. In: Proc. 7th Int’l Working Conf. on Scientific and Statistical Database Management, pp. 186–195 (1994)
Dreyer, W., Dittrich, A.K., Schmidt, D.: Research Perspectives for Time Series Management Systems. ACM SIGMOD Record 23(1), 10–15 (1994)
Dreyer, W., Dittrich, A.K., Schmidt, D.: Using the CALANDA Time Series Management Systems. In: Proc. ACM SIGMOD Int’l Conf., pp. 489–499 (1995)
Elmasri, R., Lee, J.Y.: Implementation Options for Time-Series Data. In: Etzion, O., Jajodia, S., Sripada, S. (eds.) Dagstuhl Seminar 1997. LNCS, vol. 1399, pp. 115–127. Springer, Heidelberg (1998)
Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 2nd edn. Benjamin/Cummings (1994)
Elmasri, R., Wiederhold, J.: GORDAS: A Formal High-Level Query Language for the ER Model. In: Proc. 2nd Entity-Relationship Conference, pp. 49–72 (1981)
Elmasri, R., Wuu, G.: A Temporal Model and Query Language for ER Database. In: Proc. 6th Int’l Conf. on Data Engineering, pp. 76–83 (1990)
Gadia, S., Yeung, C.: A Generalized Model for a Relational Temporal Database. In: Proc. ACM SIGMOD Conf., pp. 251–259 (1988)
Kurt, A., Ozsoyoglu, M.: Modelling Periodic Time and Calendars. In: Proc. Int’l Conf. on Application of Databases, pp. 221–234 (1995)
Lee, J.Y.: Database Modeling and Implementation Techniques for Time-Series Data. Ph.D. Dissertation, Computer Science and Engineering Department, University of Texas at Arlington (May 1998)
Lee, J.Y., Elmasri, R., Won, J.: An Integrated Temporal Data Model Incorporating Time Series Concept. Data and Knowledge Engineering 24(3), 257–276 (1998)
Rose, E., Segev, A.: TOODM – A Temporal Object-Oriented Data Model with Temporal Constraints. In: Proc. 10th Int’l Conf. on the Entity-Relationship approach (1991)
Schmidt, D., Dittrich, A.K., Dreyer, W., Marti, R.: Time Series, a Neglected Issue in Temporal Database Research? In: Proc. Int’l Workshop on Temporal Databases, pp. 214–232 (1995)
Segev, A., Shoshani, A.: Logical Modeling of Temporal Data. In: Proc. ACM SIGMOD Int’l Conf., pp. 454–466 (1987)
Tansel, A.U.: Temporal Relational Data Model. IEEE Tans. on Knowledge and Data Engineering 9(3), 464–479 (1997)
Wuu, G., Dayal, U.: A Uniform Model for Temporal Object-Oriented Databases. In: Proc. 8th Int’l Conf. on Data Engineering, pp. 584–593 (1992)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lee, J.Y., Elmasri, R.A. (1998). An EER-Based Conceptual Model and Query Language for Time-Series Data. In: Ling, TW., Ram, S., Li Lee, M. (eds) Conceptual Modeling – ER ’98. ER 1998. Lecture Notes in Computer Science, vol 1507. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-49524-6_3
Download citation
DOI: https://doi.org/10.1007/978-3-540-49524-6_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65189-5
Online ISBN: 978-3-540-49524-6
eBook Packages: Springer Book Archive