Skip to main content
SpringerLink
Log in

Efficient processing of queries containing user-defined predicates

  • Query Processing II
  • Conference paper
  • First Online:
Deductive and Object-Oriented Databases (DOOD 1995)

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

Included in the following conference series:

Abstract

Query optimizers often have difficulties with the treatment of user-defined functions. In particular, the optimization of joins involving complex, user-defined predicates rather than just simple arithmetic comparisons may lead to query plans of poor quality. In this paper, we identify a class of user-defined functions that can be included in queries in such a way that efficient query optimization is still possible. For this class of functions, a join between two sets R and S, for example, could still be computed in time significantly less than O(¦R¦ · ¦S¦). To achieve this goal we introduce the concept of the φ-function, an operator to process each set separately with respect to the user-defined function(s) being used. These φ-functions dynamically derive information to constrain subsequent processing steps. The derived information allows in particular the application of an existing index or some other traditional join strategy. After demonstrating this technique on various examples, we present the results of a practical performance evaluation.

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. 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 [21].

    Google Scholar 

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

    Google Scholar 

  3. F. Bancilhon, S. Cluet, and C. Delobel. A query language for O2 . In Building an object-oriented database system, chapter 11, pages 234–255. Morgan Kaufmann, 1992.

    Google Scholar 

  4. E. Bertino and L. Martino. Object-Oriented Database Systems. Addison-Wesley, 1993.

    Google Scholar 

  5. P. Bieganski, J. Riedl, and J. V. Carlis. Generalized suffix trees for biological sequence data: Applications and implementation. In Proc. 20th Hawaii Conf. on System Sciences, pages 35–43, 1994.

    Google Scholar 

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

    Google Scholar 

  7. R. G. G. Cattel. Object Data Management. Addison-Wesley, 1991.

    Google Scholar 

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

    Google Scholar 

  9. J. Courteau. Genome databases. Science, 254:201–207, 1991.

    PubMed  Google Scholar 

  10. K. A. Frenkel. The human genome project and informatics. CACM, 34(11):41–54, 1991.

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  13. 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 

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

    Google Scholar 

  15. 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 

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

    Google Scholar 

  17. A. Kemper and G. Moerkotte. Query optimization in object bases: Exploiting relational techniques. In [11], pages 63–98, 1994.

    Google Scholar 

  18. P. Wei-Der Li. Sequence Modelling and an extendible data model for Genomic databases. PhD thesis, University of California, San Francisco, 1991.

    Google Scholar 

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

    Google Scholar 

  20. G. M. Shaw and S. B. Zdonik. A query algebra for object-oriented databases. In Proc. IEEE 6th Int. Conference on Data Engineering, pages 154–162, February 1990.

    Google Scholar 

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

    Google Scholar 

  22. M. Stonebraker and L. Rowe. The design of POSTGRES. In Proc. ACM SIGMOD Conference on Management of Data, 1986.

    Google Scholar 

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

    Google Scholar 

  24. C. Zaniolo. The database language GEM. In Proc. ACM SIGMOD Conference on Management of Data, pages 207–218, 1983. Reprinted in [21].

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institut für Wirtschaftsinformatik, Humboldt-Universität zu Berlin, Spandauer Str. 1, 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

Tok Wang Ling Alberto O. Mendelzon Laurent Vieille

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gaede, V., Günther, O. (1995). Efficient processing of queries containing user-defined predicates. In: Ling, T.W., Mendelzon, A.O., Vieille, L. (eds) Deductive and Object-Oriented Databases. DOOD 1995. Lecture Notes in Computer Science, vol 1013. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-60608-4_46

Download citation

  • DOI: https://doi.org/10.1007/3-540-60608-4_46

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

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

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

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation