loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
11th International Database Engineering and Applications Symposium (IDEAS 2007)
Kruskal's Algorithm for Query Tree Optimization
Banff, Alberta, Canada
September 06-September 08
ISBN: 0-7695-2947-X
Pryscila Barvik Guttoski, Universidade Federal do Parana, Brazil
Marcos Sfair Sunye, Universidade Federal do Parana, Brazil
Fabiano Silva, Universidade Federal do Parana, Brazil
This paper describes an implementation of Kruskal's algorithm in query optimization process for generation of a near optimal execution query tree. The open source PostgreSQL DBMS was used in the experiments since its query optimization is performed by Dynamic Programming and Genetic algorithm, which allows a concrete comparison with our approach. Kruskal's algorithm presents some advantages like its simplified code, its polynomial-time execution and the reduced search space to generate only one query tree, that will be the optimal tree. In most experiments, Kruskal's algorithm got the expected results in almost the same time as the results achieved by default PostgreSQL's optimization algorithms. The results confirm that Kruskal's algorithm is a feasible method for query optimization.
Citation:
Pryscila Barvik Guttoski, Marcos Sfair Sunye, Fabiano Silva, "Kruskal's Algorithm for Query Tree Optimization," ideas, pp.296-302, 11th International Database Engineering and Applications Symposium (IDEAS 2007), 2007
Usage of this product signifies your acceptance of the Terms of Use.