Skip to main content
SpringerLink
Log in

An object-oriented approach to a temporal query language

  • Temporal Databases
  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1994)

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

Included in the following conference series:

Abstract

Time constraints and the temporal dimension are an essential aspect in many real world systems, like cooperative work and industrial production systems. Traditional database systems support these features only through application programs. The recent tendency consists of representing the temporal aspects in the database schema and in the corresponding query language and supporting them directly in the DBMS. In this paper the different aspects of adding the temporal dimension in an object-oriented data model are analyzed and a classification scheme is proposed for the types of possible queries. Based on this classification, a query language for the object-oriented TF-ORM data model is presented and discussed in detail. In TF-ORM. both transaction and valid times are associated to data, and the query language is used to retrieve information about the database current valid information, about past valid values, and about past histories.

This work was partially supported by the Italian National Research Council, project “Temporal data and knowledge bases”, and by the Brazilian Conselho Nacional de Desenvolvimento Científico e Tecnológico - CNPq.

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. ARAPIS, C. Specifying object life-cycles. D.TSICHRITZIS (ed.) Object Management. Genève: Universitè de Genève, 1990. p.197–225.

    Google Scholar 

  2. CAREY, M.J.; DEWITT, D.J.; VANDENBERG, S.L. A Data Model and Query Language for EXODUS. ACM SIGMOD Record, v.17. n.3. p.413–23, Sept. 1988.

    Google Scholar 

  3. CHENG, T.S.; GADIA, Shashi K. An Object-oriented model for temporal databases. Proceedings of the International Workshop on an Infrastructure for Temporal Databases. Arlington, Texas, June 14–16, 1993. p.N-1–N-19.

    Google Scholar 

  4. CLIFFORD, J.; CROKER, A. Objects in time. Data Engineering, v.11. n.4. p.11–18, Dec. 1988.

    Google Scholar 

  5. DATE, C. Introduction to standard SQL. Paris: InterEditions, 1987. 239p.

    Google Scholar 

  6. DAYAL, U.; WUU, G.T.J. Extending existing DBMSs to manage temporal data: an object-oriented approach. Proceedings of the International Workshop on an Infrastructure for Temporal Databases. Arlington, Texas, June 14–16, 1993. p.J-1–J-8.

    Google Scholar 

  7. De ANTONELLIS, V.; PERNICI, B., SAMARATI, P. F-ORM Method: a F-ORM Methodology for reusing specifications. In: F.V. Assche; B. Moulin; C. Rolland (eds.) Object Oriented Approach in Information Systems. Amsterdam: North-Holland, 1991. p.117–35.

    Google Scholar 

  8. DEUX, O. et al. The O2 System. Communications of the ACM, New York, v.34, n.10. p.34–48, Oct. 1991

    Google Scholar 

  9. EDELWEISS, N.; OLIVEIRA, J.P.M. de; PERNICI, B. An Object-Oriented Temporal Model. Proceedings of the 5th International Conference on Advanced Information Systems Engineering (CAISE'93), Paris, 8–11 June, 1993, p.397–415. (Lecture Notes in Computer Science, n.685).

    Google Scholar 

  10. EDELWEISS, N.; OLIVEIRA, J.P.M.de: CASTILHO, J.M.V.de. A Temporal Logic Language for Temporal Conditions Definition. Proceedings of the 13th. International Conference of the Chilean Computer Science Society. La Serena, Chile, Oct. 14–16, 1993, p.163–178.

    Google Scholar 

  11. GABBAY, D.; McBRIEN, P. Temporal logic and historical databases. Proceedings of the 17th. International Conference on Very Large Databases. Barcelona, Sept. 1991. p.423–430.

    Google Scholar 

  12. GREENSPAN, S.J.; BORGIDA, A.; MYLOPOULOS, J. A Requirements modeling language and its logic. In: M.L.BRODIE; J.MYLOPOULOS (eds.) On Knowledge Base Systems. New York: Springer-Verlag, 1986. p.471–502.

    Google Scholar 

  13. JESEN, C.S. et al. (eds.) The TSQL Benchmark. Proceedings of the International Workshop on an Infrastructure for Temporal Databases, Arlington, Texas, June 14–16, 1993. p.QQ-1–QQ-18.

    Google Scholar 

  14. KÄFER, W.; SCHÖNING. H. Realizing a temporal complex-object data model. Proceedings of the ACM SIGMOD International Conference on Management of Data, San Diego, June 2–5, 1992. p.266–275.

    Google Scholar 

  15. LOUCOPOULOS, P.: THEODOULIDIS, B.; PANTAZIS, D. Business rules modelling: conceptual modelling and object-oriented specifications. In: F.V.ASSCHE; B.MOULIN; C.ROLLAND (eds.) Object Oriented Approach in Information Systems. Amsterdam: North-Holland. 1991. p.323–342.

    Google Scholar 

  16. MYLOPOULOS, J. et al. Telos: representing knowledge about Information Systems. ACM Transactions on Information Systems, v.8. n.4. p.325–62, Oct. 1990.

    Google Scholar 

  17. NAVATHE, S.B.; AHMED, R. TSQL: A Language interface for history databases. In: C.ROLLAND; F.BODART; M.LEONARD (eds.) Temporal Aspects in Information Systems. Amsterdam: North-Holland, 1988. p. 109–122.

    Google Scholar 

  18. PISSINOU, N.; MAKKI, K.; YESHA, Y. Research perspectives on time in object databases. Proceedings of the International Workshop on an Infrastructure for Temporal Databases. Arlington, Texas, June 14–16, 1993. p.Y-1–Y-9.

    Google Scholar 

  19. ROSE, E.; SEGEV, A. TOOSQL — A Temporal object-oriented query language. Berkeley: The University of California and Information and Computing Science Division, Mar. 1993. (Tech. Rep. LBL-33855).

    Google Scholar 

  20. SARDA, N.L. Extensions to SQL for historical databases. IEEE Transaction on Knowledge and Data Engineering, v.2, n.2. p. 220–230, June 1990.

    Google Scholar 

  21. SERNADAS, C. et al. In-the-large object-oriented design of information systems. In: F.V.ASSCHE; B.MOULIN; C.ROLLAND (eds.) Object Oriented Approach in Information Systems. Amsterdam: North-Holland. 1991, p.209–232.

    Google Scholar 

  22. SNODGRASS, R.; AHN, I. A Taxonomy of time in databases. Proceedings of the ACM SIGMOD International Conference on Management of Data. Texas, May 28–31, 1985. p.236–46.

    Google Scholar 

  23. SNODGRASS, R. The Temporal query language TQuel. ACM Transactions on Database Systems, v.12. n.2. p.247–298, June 1987.

    Google Scholar 

  24. STONEBRAKER, M. et al. The Design and implementation of INGRES. Transactions on Database Systems, v.1, n.3, p. 189–222, Sept. 1976.

    Article  Google Scholar 

  25. STONEBRAKER, M.; ROWE, L.A. The Design of POSTGRES. ACM SIGMOD, 1986. p.340–55.

    Google Scholar 

  26. SU, S.Y.W.; CHEN, H.-H.M. Modeling and management of temporal data in object-oriented knowledge bases. Proceedings of the International Workshop on an Infrastructure for Temporal Databases, Arlington, Texas, June 14–16, 1993. p.HH-1–HH-18.

    Google Scholar 

  27. WUDA, G.; DAYAL, U. A Uniform model for temporal object-oriented databases. Proceedings of the 8th. IEEE Data Engineering Conference, 1992.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Universidade Federal do Rio Grande do Sul, Porto Alegre RS, Brazil

    Nina Edelweiss & José Palazzo M. de Oliveira

  2. Politecnico di Milano, Milano, Italy

    Barbara Pernici

Authors
  1. Nina Edelweiss
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. José Palazzo M. de Oliveira
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Barbara Pernici
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Dimitris Karagiannis

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Edelweiss, N., de Oliveira, J.P.M., Pernici, B. (1994). An object-oriented approach to a temporal 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_187

Download citation

  • DOI: https://doi.org/10.1007/3-540-58435-8_187

  • 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

Publish with us

Policies and ethics

Search

Navigation