Advertisement

An object-oriented approach to a temporal query language

  • Nina Edelweiss
  • José Palazzo M. de Oliveira
  • Barbara Pernici
Temporal Databases
Part of the Lecture Notes in Computer Science book series (LNCS, volume 856)

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.

Keywords

Temporal Databases Conceptual Modeling Object-Oriented Data Model 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [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. [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. [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. [4]
    CLIFFORD, J.; CROKER, A. Objects in time. Data Engineering, v.11. n.4. p.11–18, Dec. 1988.Google Scholar
  5. [5]
    DATE, C. Introduction to standard SQL. Paris: InterEditions, 1987. 239p.Google Scholar
  6. [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. [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. [8]
    DEUX, O. et al. The O2 System. Communications of the ACM, New York, v.34, n.10. p.34–48, Oct. 1991Google Scholar
  9. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [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. [24]
    STONEBRAKER, M. et al. The Design and implementation of INGRES. Transactions on Database Systems, v.1, n.3, p. 189–222, Sept. 1976.CrossRefGoogle Scholar
  25. [25]
    STONEBRAKER, M.; ROWE, L.A. The Design of POSTGRES. ACM SIGMOD, 1986. p.340–55.Google Scholar
  26. [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. [27]
    WUDA, G.; DAYAL, U. A Uniform model for temporal object-oriented databases. Proceedings of the 8th. IEEE Data Engineering Conference, 1992.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Nina Edelweiss
    • 1
  • José Palazzo M. de Oliveira
    • 1
  • Barbara Pernici
    • 2
  1. 1.Universidade Federal do Rio Grande do SulPorto Alegre RSBrazil
  2. 2.Politecnico di MilanoMilanoItaly

Personalised recommendations