Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
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.
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.
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.
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.
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.
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.
Kline, N.: “Bibliography on Temporal Databases”, SIGMOD Record, Vol.22, No.4, 1993.
01-Pliroforiki: “Specification of System Requirements”, ORES Deliverable C2, Athens, Greece, 1993.
van der Lans, R. F.: “The SQL Standard. A Complete Reference”, Prentice Hall, 1988.
van der Lans, R. F.: “Introduction to SQL”, Addison-Wesley, 1988.
Date, C. J.: “A Guide to the SQL Standard”, 2nd Edition, Addison-Wesley, 1982.
Relational Technology Inc.: “INGRES/SQL Reference Manual”, Release 6.4, 1991.
CPH: “User Requirements”, ORES Deliverable B2, Madrid, Spain, 1993.
01-Pliroforiki: “Implementation of Valid Time Relational Algebra”, ORES Deliverable C4, Athens, Greece, 1993.
01-Pliroforiki: “Specification of Valid Time SQL”, ORES Deliverable D2, Athens, Greece, 1993.
01-Pliroforiki: “Design of Valid Time SQL”, ORES Deliverable D3, Athens, Greece, 1993.
01-Pliroforiki: “Specification of Valid Time Formalism”, ORES Deliverable C3, Athens, Greece, 1993.
RIT: “Conceptual Design Formalisms of ORES”, Technical Report no. P7224/ORES/RIT/WPE/T5/R2/v1, Stockholm, Sweden, 1993.
UMIST: “The ORES Metamodel”, Technical Report no. P7224/ORES/UMIST/WPE/3/v3, Manchester, UK, 1993.
Theodoulidis, C. et al: “A Conceptual Modelling Formalism for Temporal Database Applications”, Information Systems, Vol. 16, No 4, pp 401–416, 1991.
RIT: “Specification of Validation Tool of ORES”, Technical Report, Stockhohn, Sweden, 1993.
UMIST: “The Design Document”, Technical Report no. P7224/ORES/UMIST/WPE/5/v2, Manchester, UK, 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Theodoulidis, B., Ait-Braham, A., Karvelis, G. (1994). The ORES Temporal DBMS and the ERT-SQL query language. In: Karagiannis, D. (eds) Database and Expert Systems Applications. DEXA 1994. Lecture Notes in Computer Science, vol 856. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58435-8_191
Download citation
DOI: https://doi.org/10.1007/3-540-58435-8_191
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58435-3
Online ISBN: 978-3-540-48796-8
eBook Packages: Springer Book Archive