The ORES Temporal DBMS and the ERT-SQL query language

  • Babis Theodoulidis
  • Aziz Ait-Braham
  • George Karvelis
Temporal Databases
Part of the Lecture Notes in Computer Science book series (LNCS, volume 856)


Up to date there exists no commercially available Temporal Database Management System (TDBMS). Current information server technology addresses ‘time’ only to a limited extent, in the form of special purpose application programs. The ORES TDBMS, an ESPRIT project currently under development, is a system in which the success and adequacy of management of time related information is paramount. A major step towards achieving such an objective is the provision of a query language powerful enough to express queries, no matter how complex, and yet easy to use. ERT-SQL is such a language.

This paper, which is mainly devoted to this language, first presents an overview of the ORES project, followed by a brief description of the conceptual data model aspects. Then, the capabilities of the query language ERT-SQL are illustrated with a number of examples. There follows a summary and concluding remarks.


Temporal (Historical) Databases Temporal DBMS Database Design Design Tools ORES Conceptual Modelling Entity-Relationship Time (ERT) Model ERT-SQL 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Pissinou, N., Snodgrass, R.T., Elmasri, R., Mumick, I.S., Ozsu, M.T., Pernici, B., Segev, A. and Theodoulidis, B.: “Towards an Infrastructure for Temporal Databases: Report of an Invitational ARPA/NSF Workshop”, TR 94-01, Department of Computer Science, University of Arizona, January,1994.Google Scholar
  2. [2]
    Klopprogge, M.R. and Lockmann, A.C.: “Modelling Information Preserving Databases: Consequences of the Concept of Time”, in Proceedings of the 9th International Conference on VLDB, Florence, Italy, pp. 399–416, 1983.Google Scholar
  3. [3]
    Elmasri, R., Wuu, G. and Kouramajian, V.: “A Temporal Model and Query Language for EER Databases”, Chapter 9, Temporal Databases: Theory, Design and Implementation, Benjamin/Cummings, pp. 212–229, 1993.Google Scholar
  4. [4]
    Rose, E. and Segev, A.: “TOODM — A Temporal Object-Oriented Data Model with Temporal Constraints”, in Proceedings of the 10th International Conference on the Entity-Relationship Approach, San Mateo, California, pp. 205–229, 1991.Google Scholar
  5. [5]
    Rose, E. and Segev, A.: “TOOSQL: A Temporal Object-Oriented Query Language”, in Proceedings of the 12th International Conference on the Entity-Relationship Approach, Dallas, Texas, 1993.Google Scholar
  6. [6]
    Cheng, T.S. and Gadia, S.K.: “An Object-Oriented Model for Temporal Databases”, in Proceedings of the International Workshop on an Infrastructure for Temporal Databases, Arlington, Texas, 1993.Google Scholar
  7. [7]
    Kline, N.: “Bibliography on Temporal Databases”, SIGMOD Record, Vol.22, No.4, 1993.Google Scholar
  8. [8]
    01-Pliroforiki: “Specification of System Requirements”, ORES Deliverable C2, Athens, Greece, 1993.Google Scholar
  9. [9]
    van der Lans, R. F.: “The SQL Standard. A Complete Reference”, Prentice Hall, 1988.Google Scholar
  10. [10]
    van der Lans, R. F.: “Introduction to SQL”, Addison-Wesley, 1988.Google Scholar
  11. [11]
    Date, C. J.: “A Guide to the SQL Standard”, 2nd Edition, Addison-Wesley, 1982.Google Scholar
  12. [12]
    Relational Technology Inc.: “INGRES/SQL Reference Manual”, Release 6.4, 1991.Google Scholar
  13. [13]
    CPH: “User Requirements”, ORES Deliverable B2, Madrid, Spain, 1993.Google Scholar
  14. [14]
    01-Pliroforiki: “Implementation of Valid Time Relational Algebra”, ORES Deliverable C4, Athens, Greece, 1993.Google Scholar
  15. [15]
    01-Pliroforiki: “Specification of Valid Time SQL”, ORES Deliverable D2, Athens, Greece, 1993.Google Scholar
  16. [16]
    01-Pliroforiki: “Design of Valid Time SQL”, ORES Deliverable D3, Athens, Greece, 1993.Google Scholar
  17. [17]
    01-Pliroforiki: “Specification of Valid Time Formalism”, ORES Deliverable C3, Athens, Greece, 1993.Google Scholar
  18. [18]
    RIT: “Conceptual Design Formalisms of ORES”, Technical Report no. P7224/ORES/RIT/WPE/T5/R2/v1, Stockholm, Sweden, 1993.Google Scholar
  19. [19]
    UMIST: “The ORES Metamodel”, Technical Report no. P7224/ORES/UMIST/WPE/3/v3, Manchester, UK, 1993.Google Scholar
  20. [28]
    Theodoulidis, C. et al: “A Conceptual Modelling Formalism for Temporal Database Applications”, Information Systems, Vol. 16, No 4, pp 401–416, 1991.Google Scholar
  21. [21]
    RIT: “Specification of Validation Tool of ORES”, Technical Report, Stockhohn, Sweden, 1993.Google Scholar
  22. [22]
    UMIST: “The Design Document”, Technical Report no. P7224/ORES/UMIST/WPE/5/v2, Manchester, UK, 1993.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Babis Theodoulidis
    • 1
  • Aziz Ait-Braham
    • 1
  • George Karvelis
    • 1
  1. 1.Department of ComputationUMISTManchesterUK

Personalised recommendations