Abstract
This paper proposes a temporal, object-oriented query language called TOOSQL which has an SQL-like syntax and compares it with other recent developments in the area. TOOSQL was designed to satisfy the criteria for temporal languages developed in previous work on temporal relational models and to extend this criteria to a language for an object-oriented model which has several inherent features that make it a more attractive basis for a temporal data model. TOOSQL differs from previous work and concurrent efforts in its support for corrections, schema updates, tune-sequence operations and user-defined operations. A grammar is developed as a means of formalizing TOOSQL. Finally, we conclude with a discussion of open issues.
This work was supported by the Applied Mathematical Sciences Research Program of the Office of Energy Research, U.S. Department of Energy under Contract DE-AC03-76SF00098.
Preview
Unable to display preview. Download preview PDF.
References
A.M. Alashqur, S.Y.W. Su and H. Lam, OQL: A Query Language for Manipulating Object-Oriented Databases, Proceedings of the 5th International Conference on Very Large Data Bases, Amsterdam, The Netherlands, 1989, pp. 433–442.
D. Beech and B. Mahbod, Generalized Version Control in an Object-Oriented Database, IEEE, February 1988, pp. 14–22.
M. Caruso and E. Sciore, Meta-Functions and Contexts in an Object-Oriented Database Language, Proceedings of the ACM SIGMOD International Conference on the Management of Data, Chicago, IL, June 1988, pp. 56–65.
R. Elmasri and G.T.J. Wuu, A Temporal Model and Query Language for ER Databases, Proceedings of the 6th International Conference on Data Engineering, May 1990, pp. 76–83.
O. Etzion and A. Gal, Temporal Support in Active Databases, Proceedings of the Second Workshop on Information Technologies and Systems (WITS), Dallas, Texas, December, 1992.
[Gadia 88] S.K. Gadia, The Role of Temporal Elements in Temporal Databases, Database Engineering, V 7, 1988, pp. 197–203.
S.K. Gadia, Parametric Databases: seamless integration of spatial, temporal, belief and ordinary data, SIGMOD RECORD V. 22, N. 1, March 1993, pp. 15–20.
M. Guo, S.Y.W. Su and H. Lam, An Association-Algebra for Processing Object-Oriented Databases, Proceedings of the 7th International Conference on Data Engineering, Kobe, Japan, April 1991, pp. 23–32.
C. Jensen, J. Clifford, S.K. Gadia, A. Segev and R.T. Snodgrass, A Glossary of Temporal Database Concepts, SIGMOD Record V. 21, N. 3, September 1992
W. Kafer and and H. Schoning, Realizing a Temporal Complex-Object Data Model, to appear in Proceedings of the ACM SIGMOD International Conference on the Management of Data, San Diego, California, June 1992.
W. Kim, J.F. Garza, N. Ballou and D. Woelk, Architecture of the ORION Next Generation Database System, IEEE Transactions on Knowledge and Data Engineering, V2, N1, March 1990, pp. 109–124.
E. McKenzie and R. Snodgrass, Evaluation of Relational Algebras Incorporating the Time Dimension in Databases, ACM Computing Surveys, V. 23, N. 4, December 1991, pp. 421–500.
S.B. Navathe and R. Ahmed, A Temporal Relational Model and Query Language, Information Sciences, V. 49, 1989, pp. 147–175.
E. Rose and A. Segev, TOODM — A Temporal, Object-Oriented Data Model with Temporal Constraints, Proceedings of the 10th International Conference on the Entity-Relationship Approach, San Mateo, California, 1991, pp. 205–229.
E. Rose and A. Segev, TOOA — A Temporal, Object-Oriented Algebra, Proceedings of the European Conference on Object-Oriented Programming, Kaiserlautem, Germany, July 1993. (An extended version is available as Lawrence Berkeley Lab Technical Report LBL-32013, June 1992)
E. Rose and A. Segev, Schema Updates and Data Definition in TOODM, LBL Technical Report (forthcoming) October 1993.
E. Rose and A. Segev, TOOSQL: A Temporal Object-Oriented Query Language and Calculus Lawrence Berkeley Lab Technical Report LBL-33333, March 1993.
E. Sciore, Using Annotations to Support Multiple Kinds of Versioning in an Object-Oriented Database System, ACM Transactions on Database Systems, V. 16, N. 3, September 1991, pp. 417–438.
E. Sciore, Versioning and Configuration Management in an Object-Oriented Data Model, Technical Report BCCS 91-12 revised, Computer Science Department, Boston College, 1991.
E. Sciore, Multi-Dimensional Versioning for Object-Oriented Databases, Proceedings of the 2nd International Conference on Deductive and Object-Oriented Databases, December 1991.
A. Segev and A. Shoshani, Logical Modeling of Temporal Databases, proceedings of ACM SIGMOD International Conference on the Management of Data, May 1987, pp. 454–466.
R. Snodgrass, The Temporal Query Language TQUEL, ACM Transactions on Database Systems, V. 12, N. 2, June 1987, pp. 247–298.
R. Snodgrass, Temporal Object-Oriented Databases: A Critical Comparison, chapter to appear in Database Challenges in the 1990's, edited by W. Kim, March 1993.
M. Stonebraker, L. Rowe and M. Hirohama, The Implementation of POSTGRES, IEEE Transactions on Knowledge and Data Engineering, V. 2, N. 1, March 1990, pp. 125–142.
S.Y.W. Su and H.M. Chen, A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T, Proceedings of the 17th International Conference on Very Large Data Bases, Barcelona, Spain, September 1991, pp. 431–442.
G. Wuu and U. Dayal, A Uniform Model for Temporal Object-Oriented Databases, Proceedings of the 8th International Conference on Data Engineering February 1992, pp. 584–593.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Rose, E., Segev, A. (1994). TOOSQL- a temporal object-oriented query language. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024362
Download citation
DOI: https://doi.org/10.1007/BFb0024362
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58217-5
Online ISBN: 978-3-540-48575-9
eBook Packages: Springer Book Archive