Advertisement

TOOSQL- a temporal object-oriented query language

  • Ellen Rose
  • Arie Segev
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 823)

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.

Keywords

Time Sequence Query Language Object Instance Valid Time Path Expression 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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. 2.
    D. Beech and B. Mahbod, Generalized Version Control in an Object-Oriented Database, IEEE, February 1988, pp. 14–22.Google Scholar
  3. 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. 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. 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. 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. 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. 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. 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 1992Google Scholar
  10. 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. 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.CrossRefGoogle Scholar
  12. 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.CrossRefGoogle Scholar
  13. 13.
    S.B. Navathe and R. Ahmed, A Temporal Relational Model and Query Language, Information Sciences, V. 49, 1989, pp. 147–175.CrossRefGoogle Scholar
  14. 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. 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. 16.
    E. Rose and A. Segev, Schema Updates and Data Definition in TOODM, LBL Technical Report (forthcoming) October 1993.Google Scholar
  17. 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. 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.CrossRefGoogle Scholar
  19. 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. 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. 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. 22.
    R. Snodgrass, The Temporal Query Language TQUEL, ACM Transactions on Database Systems, V. 12, N. 2, June 1987, pp. 247–298.CrossRefGoogle Scholar
  23. 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. 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.CrossRefGoogle Scholar
  25. 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. 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

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Ellen Rose
    • 1
    • 2
  • Arie Segev
    • 3
    • 2
  1. 1.The University of ToledoToledo
  2. 2.Information and Computing Sciences DivisionLawrence Berkeley Laboratory Berkeley
  3. 3.Walter A. Haas School of BusinessUniversity of CaliforniaUSA

Personalised recommendations