Skip to main content
SpringerLink
Log in

TOOSQL- a temporal object-oriented query language

  • Conference paper
  • First Online:
Entity-Relationship Approach — ER '93 (ER 1993)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 823))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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.

    Google Scholar 

  2. D. Beech and B. Mahbod, Generalized Version Control in an Object-Oriented Database, IEEE, February 1988, pp. 14–22.

    Google Scholar 

  3. 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.

    Google Scholar 

  4. 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.

    Google Scholar 

  5. 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.

    Google Scholar 

  6. [Gadia 88] S.K. Gadia, The Role of Temporal Elements in Temporal Databases, Database Engineering, V 7, 1988, pp. 197–203.

    Google Scholar 

  7. 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.

    Google Scholar 

  8. 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.

    Google Scholar 

  9. 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

    Google Scholar 

  10. 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.

    Google Scholar 

  11. 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.

    Article  Google Scholar 

  12. 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.

    Article  Google Scholar 

  13. S.B. Navathe and R. Ahmed, A Temporal Relational Model and Query Language, Information Sciences, V. 49, 1989, pp. 147–175.

    Article  Google Scholar 

  14. 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.

    Google Scholar 

  15. 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)

    Google Scholar 

  16. E. Rose and A. Segev, Schema Updates and Data Definition in TOODM, LBL Technical Report (forthcoming) October 1993.

    Google Scholar 

  17. E. Rose and A. Segev, TOOSQL: A Temporal Object-Oriented Query Language and Calculus Lawrence Berkeley Lab Technical Report LBL-33333, March 1993.

    Google Scholar 

  18. 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.

    Article  Google Scholar 

  19. E. Sciore, Versioning and Configuration Management in an Object-Oriented Data Model, Technical Report BCCS 91-12 revised, Computer Science Department, Boston College, 1991.

    Google Scholar 

  20. E. Sciore, Multi-Dimensional Versioning for Object-Oriented Databases, Proceedings of the 2nd International Conference on Deductive and Object-Oriented Databases, December 1991.

    Google Scholar 

  21. 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.

    Google Scholar 

  22. R. Snodgrass, The Temporal Query Language TQUEL, ACM Transactions on Database Systems, V. 12, N. 2, June 1987, pp. 247–298.

    Article  Google Scholar 

  23. 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.

    Google Scholar 

  24. 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.

    Article  Google Scholar 

  25. 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.

    Google Scholar 

  26. 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.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. The University of Toledo, 43606, Toledo, OH

    Ellen Rose

  2. Information and Computing Sciences Division, Lawrence Berkeley Laboratory Berkeley, 94720, California

    Ellen Rose & Arie Segev

  3. Walter A. Haas School of Business, University of California, USA

    Arie Segev

Authors
  1. Ellen Rose
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Arie Segev
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Ramez A. Elmasri Vram Kouramajian Bernhard Thalheim

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation