Skip to main content
SpringerLink
Log in

Query by example for nested tables

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1998)

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

Included in the following conference series:

Abstract

QBEN, a Query By Example language for Nested tables, is described. QBEN is user-friendly and allows for the easy formulation of complex queries. At the same time, optimization techniques can be incorporated that enable the global optimization of a series of queries. QBEN is addressed both to non-experts and experts. Comparison with other approaches is also made.

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. E. F. Codd, A Relational Model of Data for Large Shared Data Banks, Communications of the ACM 13(6), 377–387, 1970.

    Article  MATH  Google Scholar 

  2. ISO (1992), The International Organization for Standardization, Database Language SQL, ISO 9075:1992(E).

    Google Scholar 

  3. ISO (1996), Database Language SQL/Foundation (SQL3), ISO/ DBL MCI-004C and ANSI X3H2 96-059C (ISO/ANSI Working Draft), March 1996.

    Google Scholar 

  4. B. E. Jacobs, C. A. Walczak, A Generalized Query-by-Example Data Manipulation Language Based on Database Logic, IEEE Transactions. on Software Engineering SE-9(1), 40–56, 1983.

    Google Scholar 

  5. G. Jaeschke, H.-J Schek, Remarks on the Algebra of Non First Normal Form Relations, Proc. ACM SIGACT/SIGMOD Symposium on Principles of Database Systems, 124–138, 1982.

    Google Scholar 

  6. A. Klug, Abe-A Query Language for Constructing Aggregates-by-Example, Proc. 1st Int. Workshop on Statistical Database Management, 190–205, 1981.

    Google Scholar 

  7. H.-C. Liu, K. Ramamohanarao, Algebraic Equivalences among Nested Relational Expressions, Proc. 3rd Int. Conference on Information and Knowledge Management, 234–243, 1994.

    Google Scholar 

  8. N. A. Lorentzos, K. A. Dondis, A Query Language for Nested Tables, Technical Report, Informatics Laboratory, Agricultural University of Athens, 1997 (in Greek).

    Google Scholar 

  9. G. Ozsoyoglu, V. Mattos, Z. M. Ozsoyoglu, Query-Processing Techniques in the summary-Table-by-Example Database Query Languages, ACM Transactions on Database ystems 14(4), 526–573, 1989.

    Article  Google Scholar 

  10. M. A. Roth, H. F. Korth, A. Silberschatz, Extended Algebra and Calculus for Nested Relational Databases, ACM Transactions on Database Systems 13(4), 389–417, 1988.

    Article  MATH  MathSciNet  Google Scholar 

  11. H.-J. Schek, M. H. Scholl, The Relational Model with Relation-Valued Attributes, Information Systems 11(2), 137–147, 1986.

    Article  MATH  Google Scholar 

  12. L. Wegner, S. Thelemann, S. Wilke, QBE-like Queries and Multimedia Extensions in a Nested Relational DBMS, Proc. Int. Conference on Visual Information Systems, 1996.

    Google Scholar 

  13. S. B. Yao et al., Formanager: An Office Forms Management System, ACM Transactions on Office Information Systems 2(3), 235–262, 1984.

    Article  Google Scholar 

  14. M. M. Zloof, Query-by-Example: A data base Language, IBM Systems Journal 4, 324–343, 1977.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Informatics Laboratory, Agricultural University of Athens, Iera Odos 75, GR 118 55, Athens, Greece

    Nikos A. Lorentzos & Konstantinos A. Dondis

Authors
  1. Nikos A. Lorentzos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Konstantinos A. Dondis
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Gerald Quirchmayr Erich Schweighofer Trevor J.M. Bench-Capon

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Lorentzos, N.A., Dondis, K.A. (1998). Query by example for nested tables. In: Quirchmayr, G., Schweighofer, E., Bench-Capon, T.J. (eds) Database and Expert Systems Applications. DEXA 1998. Lecture Notes in Computer Science, vol 1460. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0054527

Download citation

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

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64950-2

  • Online ISBN: 978-3-540-68060-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation