论文信息 - A Genetic Algorithm for the Index Selection Problem

A Genetic Algorithm for the Index Selection Problem

This paper considers the problem of minimizing the response time for a given database workload by a proper choice of indexes. This problem is NP-hard and known in the literature as the Index Selection Problem (ISP). We propose a genetic algorithm (GA) for solving the ISP. Computational results of the GA on standard ISP instances are compared to branch-and-cut method and its initialisation heuristics and two state of the art MIP solvers: CPLEX and OSL. These results indicate good performance, reliability and efficiency of the proposed approach.

Jozef Kratica | Ivana Ljubic | Dusan Tosic

[1] Y. A. Kochetov,et al. Probabilistic Tabu Search Algorithm for the Multi-Stage Uncapacitated Facility Location Problem , 2001 .

[2] Vijay V. Raghavan,et al. On the Selection of an Optimal Set of Indexes , 1983, IEEE Transactions on Software Engineering.

[3] J. Krarup,et al. The simple plant location problem: Survey and synthesis , 1983 .

[4] J. Kratica,et al. Fine Grained Tournament Selection for the Simple Plant Location Problem , 2002 .

[5] Gilbert Syswerda,et al. Uniform Crossover in Genetic Algorithms , 1989, ICGA.

[6] Jozef Kratica,et al. Improving Performances of the Genetic Algorithm by Caching , 1999, Comput. Artif. Intell..

[7] D. Tcha,et al. A branch-and-bound algorithm for the multi-level uncapacitated facility location problem , 1984 .

[8] Juan José Salazar González,et al. A branch-and-cut algorithm for a generalization of the Uncapacitated Facility Location Problem , 1996 .

[9] Juan José Salazar González,et al. Separating Lifted Odd-hole Inequalities to Solve the Index Selection Problem , 1999, Discret. Appl. Math..

[10] Renzo Sprugnoli,et al. Optimal Selection of Secondary Indexes , 1990, IEEE Trans. Software Eng..

[11] Matteo Fischetti,et al. Exact and Approximate Algorithms for the Index Selection Problem in Physical Database Design , 1995, IEEE Trans. Knowl. Data Eng..

[12] Erick Cantú-Paz,et al. Efficient and Accurate Parallel Genetic Algorithms , 2000, Genetic Algorithms and Evolutionary Computation.