Optimization and evaluation of disjunctive queries

IEEE Transactions on Knowledge and Data Engineering

Volumn 12, Issue 2, 2000, Pages 238-260

  Claussen, Jens ^a   Kemper, Alfons ^a,e   Moerkotte, Guido ^b,e   Peithner, Klaus ^c   Steinbrunn, Michael ^d  

^a UNIVERSITY OF PASSAU   (Germany)

^b UNIVERSITY OF MANNHEIM   (Germany)

^c MicroStrategy Inc   (Germany)

^d SUN MICROSYSTEMS   (United States)

^e IEEE

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTATIONAL LINGUISTICS; DATA REDUCTION;

BYPASS PROCESSING; DISJUNCTIVE QUERIES;

QUERY LANGUAGES;

EID: 0033706071     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/69.842265     Document Type: Article

References (36)

1. A. Kemper, G. Moerkotte, K. Peithner, and M. Steinbrunn, "Optimizing Disjunctive Queries with Expensive Predicates," Proc. ACM SIGMOD Conf. Management of Data, pp. 336-347, May 1994.
2. M. Steinbrunn, K. Peithner, G. Moerkotte, and A. Kemper, "Bypassing Joins in Disjunctive Queries," Proc. Conf. Very Large Data Bases (VLDB), pp. 228-238, Sept. 1995.
3. Query Processing for Advanced Database Systems, J.C. Freytag, D. Maier, G. Vossen, eds. San Mateo, Calif.: Morgan Kaufmann, 1993.
4. J.C. Freytag, "A Rule-Based View of Query Optimization," Proc. ACM SIGMOD Conf. Management of Data, pp. 173-180, May 1987.
5. G. Graefe and D. DeWitt, "The EXODUS Optimizer Generator," Proc. ACM SIGMOD Conf. Management of Data, pp. 160-172, May 1987.
6. G. Lohman, "Grammar-Like Functional Rules for Representing Query Optimization Alternatives," Proc. ACM SIGMOD Conf. Management of Data, pp. 18-27, May 1988.
7. M.T. Özsu and D.D. Straube, "Queries and Query Processing in Object-Oriented Database Systems," ACM Trans. Office Information Systems, vol. 8, pp. 387-430, Oct. 1990.
8. A. Kemper and G. Moerkotte, "Advanced Query Processing in Object Bases Using Access Support Relations," Proc. Conf. Very Large Data Bases (VLDB), pp. 290-301, Aug. 1990.
9. S. Cluet and C. Delobel, "A General Framework for the Optimization of Object-Oriented Queries," Proc. ACM SIGMOD Conf. Management of Data, pp. 383-392. June 1992.
10. D.S. Batory, "Extensible Cost Models and Query Optimization in GENESIS," IEEE Database Eng., vol. 9, Dec. 1986.
11. J.A. Blakeley, W.J. McKenna, and G. Graefe, "Experiences Building the Open OODB Query Optimizer," Proc. ACM SIGMOD Conf. Management of Data, pp. 287-295, May 1993.
12. G. Graefe and W. McKenna, "The Volcano Optimizer Generator: Extensibility and Efficient Search," Proc. IEEE Conf. Data Eng., pp. 209-218, Apr. 1993.
13. L. Haas, J.C. Freytag, G. Lohman, and H. Pirahesh, "Extensible Query Processing in Starburst," Proc. ACM SIGMOD Conf. Management of Data, pp. 377-388, May 1989.
14. L. Becker and R.H. Güting, "Rule-Based Optimization and Query Processing in an Extensible Geometric Database System," ACM Trans. Database Systems, vol. 17, pp. 247-303, June 1992.
15. G. Mitchell, U. Dayal, and S.B. Zdonik, "Control of an Extensible Query Optimizer: A Planning-Based Approach," Proc. Conf. Very Large Databases (VLDB), pp. 517-528, Aug. 1993.
16. A. Kemper, G. Moerkotte, and K. Peithner, "A Blackboard Architecture for Query Optimization in Object Bases," Proc. Conf. Very Large Databases (VLDB), pp. 543-554, Aug. 1993.
17. A.Y. Levy, I.S. Mumick, and Y. Sagiv, "Query Optimization by Predicate Move-Around," Proc. Conf. Very Large Data Bases (VLDB), pp. 96-107, Sept. 1994.
18. J.M. Hellerstein and M. Stonebraker, "Predicate Migration: Optimizing Queries with Expensive Predicates," Proc. ACM SIGMOD Conf. Management of Data, pp. 267-276, May 1993.
19. C. Monma and J. Sidney, "Sequencing with Series-Parallel Precedence Constraints," Math. Operations Research, vol. 4, pp. 215-224, 1979.
20. S. Chaudhuri and K. Shim, "Optimization of Queries with User-Defined Predicates," Proc. Conf. Very Large Data Bases (VLDB), pp. 87-98, Sept. 1996.
21. M. Muralikrishna, "Optimization of Multiple-Disjunct Queries in a Relational Database System," Technical Report no. 750, Univ. of Wisconsin-Madison, Feb. 1988.
22. F. Bry, "Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited," Proc. ACM SIGMOD Conf. Management of Data, pp. 193-204, May 1989.
23. P. Selinger, M. Astrahan, D. Chamberlin, R. Lorie, and T. Price, "Access Path Selection in a Relational Database Management System," Proc. ACM SIGMOD Conf. Management of Data, pp. 23-34, May 1979.
24. P. Bernstein, N. Goodman, E. Wong, C. Reeve, and J. Rothnie, "Query Processing in a System for Distributed Databases (SDD-1)," ACM Trans. Database Systems, vol. 6, Dec. 1981.
25. L. Kerschberg, P.D. Ting, and S.B. Yao, "Query Optimization in a Star Computer Network," ACM Trans. Database Systems, vol. 7, pp. 678-711, Dec. 1982.
26. M. Jarke and J. Koch, "Query Optimization in Database Systems," ACM Computing Surveys, vol. 16, pp. 111-152, June 1984.
27. M. Steinbrunn, "Heuristic and Randomised Optimisation Techniques in Object-Oriented Database Systems," Ringstraße 32, 53757 St. Augustin, Germany: infix-Verlag, dissertation, Universität Passau, 1996.
28. K. Peithner, "Optimierung deklarativer Anfragen in Objektbanken," PhD thesis, Ringstr. 32, 53757 Sankt Augustin, Germany, dissertation, Universität Passau, 1996.
29. R. Cattell, D. Barry, D. Bartels, M. Berler, J. Eastman, S. Gamerman, D. Jordan, A. Springer, H. Strickland, and D. Wade, The Object Database Standard: ODMG 2. 0. San Mateo, Calif.: Morgan Kaufmann, 1997.
30. J.M. Hellerstein and J.F. Naughton, "Query Execution Strategies for Caching Expensive Methods," Proc. ACM SIGMOD Conf. Management of Data, pp. 423-434, June 1996.
31. D. Stemple and T. Sheard, "A Recursive Base for Database Programming Primitives," Proc. Kiev East/West Workshop Next Generation Database Technology, Apr. 1991.
32. M.Z. Hanani, "An Optimal Evaluation of Boolean Expressions in an Online Query System," Comm. ACM, vol. 20, pp. 344-347, May 1977.
33. G. von Bültzingsloewen, SQL-Anfragen-Optimierung für parallele Bearbeitung. New York, Berlin, etc.: FZI-Berichte Informatik, Springer-Verlag, 1991.
34. G. Graefe, "Query Evaluation Techniques for Large Databases," ACM Computing Surveys, vol. 25, pp. 73-170, June 1993.
35. B. Stroustrup, The C++ Programming Language, second ed. Reading, Mass.: Addison-Wesley, 1992.
36. C.A. Gerlhof, "Optimierung von Speicherzugriffskosten in Objektbanken: Clustering und Prefetching," PhD thesis, Universität Passau, Fakultät für Mathematik und Informatik, D-94030 Passau, dissertation, Universität Passau, 1996.