Skip to main content
SpringerLink
Log in

Constraint-based query optimization and processing

  • Conference paper
  • First Online:
Constraint Databases and Application (CDB 1995)

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

Included in the following conference series:

Abstract

Constraint technology can be used to extend the functionality and performance of current database systems in a variety of ways. In this paper, we show how to use constraints for the processing of queries that contain user-defined functions. Such functions are a common feature in many extended and object-oriented database applications. By representing knowledge about the functions through constraints, the efficiency of query optimization and execution can be improved significantly. We demonstrate the potential of our technique on several examples from spatial data management.

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. K. Aberer and G. Fischer. Object-oriented query processing: The impact of methods on language, architecture and optimization. Technical Report GMD no. 763, GMD-IPSI, Darmstadt, Germany, 1993.

    Google Scholar 

  2. M. Atkinson, F. Bancilhon, D. DeWitt, K. Dittrich, D. Maier, and S. Zdonik. The object-oriented database system manifesto. In Proc. 1st Int. Conf. on Distributed and Object-Oriented Design, 1989. Reprinted in [31].

    Google Scholar 

  3. T. Atwood, J. Duhl, G. Ferran, M. Loomis, and D. Wade, editors. The Object Database Standards: ODMG-93. Morgan-Kaufmann, 1994.

    Google Scholar 

  4. F. Bancilhon. A query language for the O2 object-oriented database systems. In 2nd International Workshop on Database Programming Languages, 1989. Reprinted in [5].

    Google Scholar 

  5. F. Bancilhon, C. Delobel, and P. Kannelakis, editors. Building an Object-Oriented Database System. Morgan-Kaufmann, 1992.

    Google Scholar 

  6. E. Bertino. Method precomputation in object-oriented databases. In ACM-SIGOIS and IEEE-TC-OA International Conference on Organizational Computing Systems (COCS91), 1991.

    Google Scholar 

  7. J. A. Blakeley. Object query module. Technical report, Texas Instrument Incorporation, 1991. DARPA Open Object-Oriented Database Preliminary Module Specification.

    Google Scholar 

  8. A. Brodsky, J. Jaffar, and M. J. Maher. Toward practical constraint databases. In Proc. 19th Int. Conference on Very Large Databases (VLDB), pages 567–580, 1993.

    Google Scholar 

  9. J. Cardiff. Semantic query optimization in heterogeneous DBMSs. In Proc. 20th Hawaii Conf. on System Sciences, pages 273–282, 1994.

    Google Scholar 

  10. S. Chaudhuri and K. Shim. Query optimization in the presence of foreign functions. In Proc. 19th Int. Conference on Very Large Data Bases (VLDB), pages 529–542, 1993.

    Google Scholar 

  11. R. Elmasri and S. B. Navathe. Fundamentals of Database Systems. The Benjamin/Cummings Publishing Company, Inc, 1989.

    Google Scholar 

  12. J.C. Freytag, D. Maier, and G. Vossen, editors. Query Processing for advanced database systems. Morgan Kaufmann, 1994.

    Google Scholar 

  13. T. Frühwirth, A. Herold, V. Küchenhoff, T. Le Provost, P. Lim, E. Monfroy, and M. Wallace. Constraint logic programming: An informal introduction. Technical Report ECRC-93-5, ECRC, Munich, Germany, 1993. Available by ftp from ftp.ecrc.de.

    Google Scholar 

  14. V. Gaede and O. Günther. Efficient processing of queries containing user-defined predicates. In Proc. 4th Int. Conference on Deductive and Object-Oriented Databases (DOOD'95), 1995.

    Google Scholar 

  15. V. Gaede and O. Günther. Processing joins with user-defined functions. Technical Report 94-013, ICSI, Berkeley, California, March 1994.

    Google Scholar 

  16. V. Gaede and W.-F. Riekert. Spatial access methods and query processing in the object-oriented GIS GODOT. In Proc. of the AGDM'94 Workshop, pages 40–52, Delft, The Netherlands, 1994. Netherlands Geodetic Commission.

    Google Scholar 

  17. G. Graefe and D. Maier. Query optimization in object-oriented database system: A prospectus. In K. R. Dittrich, editor, Advances in Object-Oriented Database System, pages 358–363. Springer Verlag, September 1988. LNCS, No. 334.

    Google Scholar 

  18. O. Günther. Efficient computation of spatial joins. In Proc. IEEE 9th Int. Conference on Data Engineering, 1993.

    Google Scholar 

  19. J. M. Hellerstein. Practical predicate placement. In Proc. ACM SIGMOD Conference on Management of Data, pages 325–335, 1994.

    Google Scholar 

  20. J. M. Hellerstein and M. Stonebraker. Predicate migration: Optimizing queries with expensive predicates. In Proc. ACM SIGMOD Conference on Management of Data, pages 267–276, 1993.

    Google Scholar 

  21. P. C. Kanellakis and D. Q. Goldin. Constraint programming and database query languages. Technical Report CS-94-31, Brown University, Providence, 1994.

    Google Scholar 

  22. P. C. Kanellakis, G.M. Kuper, and P.Z. Revesz. Constraint query languages. Technical Report CS-92-50, Brown University, Providence, 1992.

    Google Scholar 

  23. P.C. Kanellakis, S. Ramaswamy, D.E. Vengroff, and J.S. Vitter. Indexing for data models with constraints and classes. In Proc. 12th ACM PODS, pages 233–243, 1993.

    Google Scholar 

  24. A. Kemper, C. Kilger, and G. Moerkotte. Function materialization in object bases. In Proc. ACM SIGMOD Conference on Management of Data, pages 258–268, 1991.

    Google Scholar 

  25. A. Kemper, G. Moerkotte, K. Peithner, and M. Steinbrunn. Optimizing disjunctive queries with expensive predicates. In Proc. ACM SIGMOD Conference on Management of Data, pages 336–347, 1994.

    Google Scholar 

  26. A. Kemper, G. Moerkotte, and M. Steinbrunn. Optimizing boolean expressions in object bases. In Proc. 18th Int. Conference on Very Large Database (VLDB), pages 79–90, 1992.

    Google Scholar 

  27. J.J. King. QUIST: A system for semantic query optimization in relational databases. In Proc. 7th International Conference on Very Large Databases (VLDB), pages 510–517, 1981.

    Google Scholar 

  28. D. Maier, S. Daniels, T. Keller, B. Vance, and G. Graefe W.J. McKenna. Challenges for query processing in object-oriented databases. In [12], pages 337–381, 1994.

    Google Scholar 

  29. P. Mishra and M. H. Eich. Join processing in relational databases. ACM Computing Surveys, 24(1):63–113, March 1992.

    Google Scholar 

  30. S. T. Shenoy and Z. M. Ozsoyoglu. A system for semantic query optimization. In Proc. ACM SIGMOD Conference on the Management of Data, pages 181–195, 1987.

    Google Scholar 

  31. M. Stonebraker, editor. Readings in Database Systems, San Mateo, 1994. Morgan Kaufmann. Second edition.

    Google Scholar 

  32. J. Ullman. Principles of Database and Knowledge Base Systems, volume 1. Computer Science Press, 1988.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institut für Wirtschaftsinformatik, Humboldt-Universität zu Berlin, Spandauer Str. l, 10178, Berlin, Germany

    Volker Gaede & Oliver Günther

Authors
  1. Volker Gaede
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Oliver Günther
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Gabriel Kuper Mark Wallace

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gaede, V., Günther, O. (1996). Constraint-based query optimization and processing. In: Kuper, G., Wallace, M. (eds) Constraint Databases and Application. CDB 1995. Lecture Notes in Computer Science, vol 1034. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-60794-3_15

Download citation

  • DOI: https://doi.org/10.1007/3-540-60794-3_15

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-60794-6

  • Online ISBN: 978-3-540-49456-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation