Genetic programming in database query optimization

Database query optimization is a hard research problem. Exhaustive techniques are adequate for trivial instances only, while combinatorial optimization techniques are vulnerable to the peculiarities of specific instances. We propose a model based on genetic programming to address this problem, motivated by its robustness and efficiency in a wide area of search problems. We adapt the genetic programming paradigm to the requirements of the query optimization problem, showing that the nature of the problem makes genetic programming a particularly attractive approach to it.

[1]  Michael C. Ferris,et al.  A Genetic Algorithm for Database Query Optimization , 1991, ICGA.

[2]  Goetz Graefe,et al.  Query evaluation techniques for large databases , 1993, CSUR.

[3]  Vidroha Debroy,et al.  Genetic Programming , 1998, Lecture Notes in Computer Science.

[4]  Costas Vassilakis,et al.  PARALLEL OPTIMISATION OF JOIN QUERIES USING A TECHNIQUE OF EXHAUSTIVE NATURE 1 , 1993 .

[5]  Yannis E. Ioannidis,et al.  Left-deep vs. bushy trees: an analysis of strategy spaces and its implications for query optimization , 1991, SIGMOD '91.

[6]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[7]  Arun N. Swami,et al.  Optimization of large join queries , 1988, SIGMOD '88.

[8]  Patrick Valduriez,et al.  On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces , 1993, VLDB.

[9]  John H. Holland,et al.  Adaptation in Natural and Artificial Systems: An Introductory Analysis with Applications to Biology, Control, and Artificial Intelligence , 1992 .

[10]  Yannis E. Ioannidis,et al.  Randomized algorithms for optimizing large join queries , 1990, SIGMOD '90.

[11]  Edward Omiecinski,et al.  Large Join Optimization on a Hypercube Multiprocessor , 1994, IEEE Trans. Knowl. Data Eng..

[12]  Timos K. Sellis,et al.  Parametric query optimization , 1992, The VLDB Journal.

[13]  Myra Spiliopoulou,et al.  Parallel Optimization of Large Join Queries with Set Operators and Aggregates in a Parallel Environment Supporting Pipeline , 1996, IEEE Trans. Knowl. Data Eng..

[14]  David E. Goldberg,et al.  Genetic Algorithms in Search Optimization and Machine Learning , 1988 .

[15]  John R. Koza,et al.  Genetic programming (videotape): the movie , 1992 .