Skip to main content

A graphical query language for temporal databases

  • Temporal Data Modeling
  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((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.

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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. J. F. Allen: Maintaining Knowledge about Temporal Intervals. Communications of the ACM 26:11 (1983), 832–843.

    Google Scholar 

  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. 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. 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. 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. 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. R. Elmasri, S. B. Navathe: Fundamentals of Database Systems (Second Edition). Addison-Wesley, Amsterdam, 1994.

    Google Scholar 

  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. 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. 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. 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. S. B. Navathe, R. Ahmed: A Temporal Relational Model and a Query Language. Information Sciences 49:2 (1989), 147–175.

    Google Scholar 

  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. 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. R. Snodgrass: The Temporal Query Language TQuel. ACM Transactions on Database Systems 12:2 (1987), 247–298.

    Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Michael P. Papazoglou

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kouramajian, V., Gertz, M. (1995). A graphical query language for temporal databases. In: Papazoglou, M.P. (eds) OOER '95: Object-Oriented and Entity-Relationship Modeling. ER 1995. Lecture Notes in Computer Science, vol 1021. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0020549

Download citation

  • DOI: https://doi.org/10.1007/BFb0020549

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-60672-7

  • Online ISBN: 978-3-540-48527-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics