18th IEEE International Conference on Tools with Artificial Intelligence (ICTAI'06)
Use of AI in Query Optimization of Relational Databases
Arlington, Virginia
November 13-November 15
ISBN: 0-7695-2728-0
Exponential growth in number of possible strategies with the increase in number of relations in a query has been identified as a major problem in the field of query optimization of relational databases. Present database systems use exhaustive search to find the best possible strategy. But as the size of a query grows, exhaustive search method itself becomes quite expensive. Other AI algorithms like A* algorithm, Simulated Annealing etc. have been suggested as a solution. However, all these algorithms fail to produce the best strategy; necessarily required for query execution. We did some modifications to the A* algorithm to produce a randomized form of the algorithm and compared it with the original A* algorithm and exhaustive search. The comparison results have shown improved A* algorithm to be almost equivalent in output quality along with a colossal decrease in search space in comparison to exhaustive search method.
Citation:
Amit Goyal, Laurentiu Vasiliu, Brahmananda Sapkota, "Use of AI in Query Optimization of Relational Databases," ictai, pp.591-598, 18th IEEE International Conference on Tools with Artificial Intelligence (ICTAI'06), 2006
Usage of this product signifies your acceptance of the
Terms of Use.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||