The difficulty of optimum index selection
暂无分享,去创建一个
Given a file on a secondary store in which each record has several attributes, it is usually advantageous to build an index mechanism to decrease the cost of conducting transactions to the file. The problem of selecting attributes over which to index has been studied in the context of various storage structures and access assumptions. One algorithm to make an optimum index selection requires 2k steps in the worst case, where k is the number of attributes in the file. We examine the question of whether a more efficient algorithm might exist and show that even under a simple cost criterion the problem is computationally difficult in a precise sense. Our results extend directly to other related problems where the cost of the index depends on fixed values which are assigned to each attribute. Some practical implications are discussed.
[1] Vincent Y. Lum,et al. Multi-attribute retrieval with combined indexes , 1970, Commun. ACM.
[2] Alfred V. Aho,et al. The Design and Analysis of Computer Algorithms , 1974 .
[3] Mario Schkolnick,et al. The Optimal Selection of Secondary Indices for Files , 1975, Inf. Syst..
[4] Vincent Y. Lum,et al. An optimization problem on the selection of secondary keys , 1971, ACM '71.
[5] Richard G. Casey. Design of tree structures for efficient querying , 1973, CACM.