An EER-Based Conceptual Model and Query Language for Time-Series Data

  • Jae Young Lee
  • Ramez A. Elmasri
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1507)


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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Chandra, R., Segev, A.: Managing Temporal Financial Data in and Extensible Database. In: Proc. 19th Int’l Conf. on VLDB, pp. 302–313 (1993)Google Scholar
  2. 2.
    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)Google Scholar
  3. 3.
    Dayal, U., Wuu, G.: A uniform Approach to Processing Temporal Queries. In: Proc. 18th VLDB Conf., pp. 407–418 (1992)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    Dreyer, W., Dittrich, A.K., Schmidt, D.: Research Perspectives for Time Series Management Systems. ACM SIGMOD Record 23(1), 10–15 (1994)CrossRefGoogle Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 2nd edn. Benjamin/Cummings (1994)Google Scholar
  9. 9.
    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)Google Scholar
  10. 10.
    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)Google Scholar
  11. 11.
    Gadia, S., Yeung, C.: A Generalized Model for a Relational Temporal Database. In: Proc. ACM SIGMOD Conf., pp. 251–259 (1988)Google Scholar
  12. 12.
    Kurt, A., Ozsoyoglu, M.: Modelling Periodic Time and Calendars. In: Proc. Int’l Conf. on Application of Databases, pp. 221–234 (1995)Google Scholar
  13. 13.
    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)Google Scholar
  14. 14.
    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)zbMATHCrossRefGoogle Scholar
  15. 15.
    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)Google Scholar
  16. 16.
    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)Google Scholar
  17. 17.
    Segev, A., Shoshani, A.: Logical Modeling of Temporal Data. In: Proc. ACM SIGMOD Int’l Conf., pp. 454–466 (1987)Google Scholar
  18. 18.
    Tansel, A.U.: Temporal Relational Data Model. IEEE Tans. on Knowledge and Data Engineering 9(3), 464–479 (1997)CrossRefGoogle Scholar
  19. 19.
    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)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Jae Young Lee
    • 1
  • Ramez A. Elmasri
    • 1
  1. 1.Computer Science and Engineering DepartmentUniversity of Texas at ArlingtonArlingtonU.S.A.

Personalised recommendations