This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
On the Selection of an Optimal Set of Indexes
March 1983 (vol. 9 no. 2)
pp. 135-143
M.Y.L. Ip, Datatron Processing & Systems Ltd.
A problem of considerable interest in the design of a database is the selection of indexes. In this paper, we present a probabilistic model of transactions (queries, updates, insertions, and deletions) to a file. An evaluation function, which is based on the cost saving (in terms of the number of page accesses) attributable to the use of an index set, is then developed. The maximization of this function would yield an optimal set of indexes. Unfortunately, algorithms known to solve this maximization problem require an order of time exponential in the total number of attributes in the file. Consequently, we develop the theoretical basis which leads to an algorithm that obtains a near optimal solution to the index selection problem in polynomial time. The theoretical result consists of showing that the index selection problem can be solved by solving a properly chosen instance of the knapsack problem. A theoretical bound for the amount by which the solution obtained by this algorithm deviates from the true optimum is provided. This result is then interpreted in the light of evidence gathered through experiments.
Index Terms:
secondary index, Approximation algorithm, attribute selection, complexity, knapsack problem, index selection
Citation:
M.Y.L. Ip, L.V. Saxton, V.V. Raghavan, "On the Selection of an Optimal Set of Indexes," IEEE Transactions on Software Engineering, vol. 9, no. 2, pp. 135-143, March 1983, doi:10.1109/TSE.1983.236458
Usage of this product signifies your acceptance of the Terms of Use.