Issue No. 02 - February (1992 vol. 18)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/32.121758
<p>M. Y. L. Ip et al. solved the index selection problem for a relational database by reducing it to a classical knapsack problem and then applying an approximation algorithm. It is shown that this reduction process does not work in general by providing a counterexample, and its practical significance is discussed. It turns out that the main idea of Ip et al. need not be discarded. In particular, the approximation algorithm used can be adapted fairly easily to take care of the problems which were raised by the counterexample. In spite of its simplicity, this modification can lead to a reduced number of indices, which is rather attractive from a practical point of view.</p>
index selection problem; relational database; classical knapsack problem; approximation algorithm; reduction process; approximation theory; database theory; optimisation; relational databases
B. Falkowski, "Comments on an Optimal Set of Indices for a Relational Database," in IEEE Transactions on Software Engineering, vol. 18, no. , pp. 168-171, 1992.