Abstract
The overall aim of this paper is to briefly introduce our approach to temporal data modelling described as the ORES methodology. The ORES Temporal Database Management System (TDBMS), which consists of the methodology together the supporting software tools, will provide the efficient and user friendly representation and manipulation of temporal knowledge. More specifically, this paper is concerned with the definition and manipulation of temporal data at the conceptual level. It therefore concentrates on describing such a tool, namely the query language ERT-SQL, with the help of some illustrative examples.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Cannan, S. and Otten G.: “SQL the Standard Handbook”, McGRAW-HILL Book Company Europe, England, 1993.
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.
UMIST: “Conceptual Temporal Data Modelling: A Comparative Survey”, Technical Report no. P7224/ORES/UMIST/WPE/11/v1, Manchester, UK, 1994.
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/vl, Stockholm, Sweden, 1993.
UMIST: “The ORES Metamodel”, Technical Report no. P7224/ORES/UMIST/WPE/3/v3, Manchester, UK, 1993.
RIT: “Specification of Validation Tool of ORES”, Technical Report, Stockholm, Sweden, 1993.
UMIST, ‘An Algebra for a Entity-Relationship Time Model', Technical Report No P7224/ORES/UMIST/WPE2/R2, 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ait-Braham, A., Theodoulidis, B., Karvelis, G. (1994). Conceptual modelling and manipulation of temporal databases. In: Loucopoulos, P. (eds) Entity-Relationship Approach — ER '94 Business Modelling and Re-Engineering. ER 1994. Lecture Notes in Computer Science, vol 881. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58786-1_86
Download citation
DOI: https://doi.org/10.1007/3-540-58786-1_86
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58786-6
Online ISBN: 978-3-540-49100-2
eBook Packages: Springer Book Archive