The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.01 - January (1990 vol.16)
pp: 32-38
ABSTRACT
<p>When planning a database, the problem of index selection is of particular interest. The authors examine a transaction model that includes queries, updates, insertions, and deletions, and they define a function that calculates the transaction's total cost when an index set is used. Their aim is to minimize the function cost in order to identify the optimal set. The algorithms proposed in other studies require an exponential time in the number of attributes in order to solve the problem. The authors propose a heuristic algorithm based on some properties of the cost function that produces an almost optimal set in polynomial time. In many cases, the cost function properties make it possible to prove that the solution obtained is the optimal one.</p>
INDEX TERMS
optimal selection; secondary indexes; database; transaction model; queries; updates; insertions; deletions; heuristic algorithm; polynomial time; cost function properties; database management systems; heuristic programming; indexing; transaction processing.
CITATION
E. Barcucci, O. Pinzani, "Optimal Selection of Secondary Indexes", IEEE Transactions on Software Engineering, vol.16, no. 1, pp. 32-38, January 1990, doi:10.1109/32.44361
17 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool