Heuristic and randomized optimization for the join ordering problem

VLDB Journal

Volumn 6, Issue 3, 1997, Pages 191-208

  Steinbrunn, Michael ^a   Moerkotte, Guido ^b   Kemper, Alfons ^a  

^a UNIVERSITY OF PASSAU   (Germany)

^b UNIVERSITY OF MANNHEIM   (Germany)

Author keywords

Genetic algorithms; Heuristic algorithms; Join ordering; Query optimization; Randomized algorithms

Indexed keywords

EID: 0001443955     PISSN: 10668888     EISSN: None     Source Type: Journal    
DOI: 10.1007/s007780050040     Document Type: Article

References (25)

1. Bennet K, Ferris MC, Ioannidis YE (1991) A genetic algorithm for database query optimization. In: Proc 4th Int Conf Genetic Algorithms, San Diego, Calif, pp 400-407
2. Elmasri E, Navathe SB (1994) Fundamentals of database systems, 2nd edn. Benjamin/Cummings, Redwood City, Calif
3. Galindo-Legaria C, Pellenkoft A, Kersten M (1994) Fast, randomized join-order selectoin - why use transformations? In: Proc Conf Very Large Data Bases (VLDB), Santiago, Chile, September, pp 85-95
4. Goldberg DE (1989) Genetic algorithms in search, optimization & machine learning. Addison-Wesley, Reading, Mass
5. Ibaraki T, Kameda T (1984) Optimal nesting for computing N-relational joins. ACM Trans Database Syst 9:482-502
6. Ioannidis YE, Kang YC (1990) Randomized algorithms for optimizing large join queries. In: Proc ACM SIGMOD Conf Management of Data, Atlantic City, NJ, April, pp 312-321
7. Ioannidis YE, Kang YC (1991) Left-deep vs. bushy trees: an analysis of strategy spaces and its implications for query optimization. In: Proc ACM SIGMOD Conf Management of Data, Denver, Colo, May, pp 168-177
8. Ioannidis YE, Wong E (1987) Query optimization by simulated annealing. In: Proc ACM SIGMOD Conf Management of Data, San Francisco, Calif, pp 9-22
9. Krishnamurthy R, Boral H, Zaniolo C (1986) Optimization of non-recursive queries. In: Proc Cof Very Large Data Bases (VLDB), Kyoto, Japan, pp 128-137
10. Kemper A, Moerkotte G (1992) Access support relations: an indexing method for object bases. Inf Syst 17:117-146
11. Kemper A, Moerkotte G (1994) Object-oriented database management: applications in engineering and computer science. Prentice-Hall, Englewood Cliffs, NJ
12. Kruskal JB (1956) On the shortest spanning subtree of a graph and the travelling salesman problem. Proc Am Math Soc 7:48-50
13. Lawler E (1978) Sequencing jobs to minimize total weighted completion time subject to precedence constraits. Ann Discrete Math 2:75-90
14. Lanzelotte R, Valduriez P, Zaït M (1993) On the effectiveness of optimization search strategies for parallel execution spaces. In: Proc Conf Very Large Data Bases (VLDB), Dublin, Ireland, pp 493-504
15. Mishra P, Eich MH (1992) Join processing in relational databases. ACM Comput Surv 24:63-113
16. Monma C, Sidney J (1979) Sequencing with series-parallel precedence constraints. Math Oper Res 4:215-224
17. Ono K, Lohman GM (1990) Measuring the complexity of join enumeration in query optimization. In: Proc Conf Very Large Data Base (VLDB), Brisbane, Australia, pp 314-325
18. Selinger PG, Astrahan MM, Chamberli DD, Lorie RA, Price TG (1979) Access path selection in a relational database management system. In: Proc ACM SIGMOD Conf Management of Data, Boston, USA, May, pp 23-24
19. Swami A, Gupta A (1988) Optimization of large join queries. In: Proc ACM SIGMOD Conf Management of Data, Chicago, Ill, May, pp 8-17
20. Shapiro LD (1986l Join processing in database systems with large main memories. ACM Trans Database Syst 11:239-264
21. Swami A, Iyer B (1993) A polynomial time algorithm for optimizing join queries. In: Proc IEEE Conf Data Eng, Vienna, Austria, April, pp 345-354
22. Swami A (1989) Optimization of large join queries: combining heuristics and combinatorial techniques. In: Proc ACM SIGMOD Conf Management of Data, Portland, Ore, May, pp 367-376
23. Vance B, Maier D (1996) Rapid bushy join-order optimization with cartesian product. In: Proc ACM SIGMOD Conf Management of Data, Montreal, June, pp 35-46
24. Wong E, Youssefi K (1976) Decomposition - a strategy for query processing. ACM Trans Database Syst 1:223-241
25. Youssefi K, Wong E (1979) Query processing in a relational database management system. In: Proc Conf Very Large Data Bases (VLDB), Rio de Janeiro, Brazil, pp 409-417