Abstract | ||
---|---|---|
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. |
Year | DOI | Venue |
---|---|---|
1990 | 10.1109/32.44361 | IEEE Trans. Software Eng. |
Keywords | Field | DocType |
index selection,total cost,exponential time,optimal set,polynomial time,cost function property,index set,cost function,function cost,secondary indexes,optimal selection,transaction model,relational databases,indexing,database,optimization,algorithm design and analysis,indexes,heuristic algorithm,testing,database management systems,indexation,transaction processing | Transaction processing,Exponential function,Relational database,Heuristic (computer science),Computer science,Index set,Algorithm,Minification,Time complexity,Total cost | Journal |
Volume | Issue | ISSN |
16 | 1 | 0098-5589 |
Citations | PageRank | References |
13 | 3.13 | 16 |
Authors | ||
3 |
Name | Order | Citations | PageRank |
---|---|---|---|
Elena Barcucci | 1 | 306 | 59.66 |
R. Pinzani | 2 | 90 | 15.91 |
Renzo Sprugnoli | 3 | 295 | 128.45 |