A graphical query language for temporal databases

  • Vram Kouramajian
  • Michael Gertz
Temporal Data Modeling
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1021)

Abstract

This paper addresses the issue of visual query formulation for temporal databases. We introduce a number of visual constructs that allow users to build queries in a modular fashion based on a temporal Extended Entity-Relationship Model. These constructs are: Temporal projection, temporal selection, time links, filtering and set operators, and temporal aggregates.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    A. Auddino, E. Amiel, Y. Dennebouy, Y. Dupont, E. Fontana, S. Spaccapietra, Z. Tari: SUPER — Visual Interaction with an Object-based ER Model. In G. Pernul, A.M. Tjoa (Eds.), Eleventh International Conference on the Entity-Relationship Approach, LNCS 645, Springer-Verlag, Berlin, 1992, pp.340–356.Google Scholar
  2. 2.
    J. F. Allen: Maintaining Knowledge about Temporal Intervals. Communications of the ACM 26:11 (1983), 832–843.Google Scholar
  3. 3.
    K. K. Al-Taha, R. T. Snodgrass, M. D. Soo: Bibliography on Spatiotemporal Databases. SIGMOD Record 22:1 (1993), 59–67.Google Scholar
  4. 4.
    C. Batini, T. Catarci, M. F. Costabile, S. Levialdi: On Visual Representations for Database Query Systems In Proceedings of the Interface to Real and Virtual Worlds Conference, Montpellier, France, 1993, pp273–283.Google Scholar
  5. 5.
    B. Czejdo, R. Elmasri, M. Rusinkiewicz, D. W. Embley: A Graphical Data Manipulation Language for an Extended Entity-Relationship Model. IEEE Computer 23:3 (1990), 26–36.Google Scholar
  6. 6.
    T. Catarci, G. Santucci: Query by Diagram: A Graphic Query System. In F. Lochovsky (ed.), Eight International Conference on the Entity-Relationship Approach, North-Holland, Amsterdam, 1989, 291–308.Google Scholar
  7. 7.
    R. Elmasri, J. Larson: A Graphical Query facility for ER Databases. In J. Liu (ed.), Proc. 4th International Conference on the Entity-Relationship Approach, 1985, 236–245.Google Scholar
  8. 8.
    R. Elmasri, S. B. Navathe: Fundamentals of Database Systems (Second Edition). Addison-Wesley, Amsterdam, 1994.Google Scholar
  9. 9.
    R. Elmasri, G. Wiederhold: GORDAS: A Formal High-Level Query Language for the ER Model. In P. Chen (ed.), Entity-Relationship Approach to Information Modeling and Analysis, Elsevier Science, 1981.Google Scholar
  10. 10.
    R. Elmasri, G. T. Wuu, V. Kouramajian: A Temporal Model and Query Language for EER Databases. In A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R. Snodgrass (eds.): Temporal Databases: Theory, Design, and Implementation, Database Systems and Applications Series, Benjamin/Cummings, 1993, 212–229.Google Scholar
  11. 11.
    S. K. Gadia, C.-S. Yeung: A Generalized Model for a Relational Temporal Database. In H. Boral, P.-A. Larson (eds.), Proc. ACM SIGMOD Int. Conf. on Management of Data 1988, Chicago, ACM Press, New York, 1988, 251–259.Google Scholar
  12. 12.
    V. Kouramajian, M. Gertz: A Visual Query Language for Temporal Databases. Informatik-Berichte 02/95, Institut für Informatik, Universität Hannover, 1995.Google Scholar
  13. 13.
    S. B. Navathe, R. Ahmed: A Temporal Relational Model and a Query Language. Information Sciences 49:2 (1989), 147–175.Google Scholar
  14. 14.
    A. Oberweis, V. Sänger: GTL — A Graphical Language for Temporal Data. In H. Hinterberger, J. French (eds.), Proc. of the Seventh Int. Working Conf. on Scientific and Statistical Database Management, IEEE Computer Press, 1994.Google Scholar
  15. 15.
    E. Rose, A. Segev: TOODM — A Temporal Object-Oriented Data Model with Temporal Constraints. In T. Teorey (ed.), Entity-Relationship Approach: The Core of Conceptual Modelling, Elsevier Science, Amsterdam, 1991, 205–229.Google Scholar
  16. 16.
    R. Snodgrass: The Temporal Query Language TQuel. ACM Transactions on Database Systems 12:2 (1987), 247–298.Google Scholar
  17. 17.
    G. Wuu, U. Dayal: A Uniform Model for Temporal Object-Oriented Databases. In F. Golshani (ed.), Eighth International Conference on Data Engineering, IEEE Computer Society Press, 1992, 584–593.Google Scholar

Copyright information

© Springer-Verlag 1995

Authors and Affiliations

  • Vram Kouramajian
    • 1
  • Michael Gertz
    • 2
  1. 1.Knight-Ridder Information, Inc.Mountain View
  2. 2.Institut für InformatikUniversität HannoverHannoverGermany

Personalised recommendations