© 1985 by British Computer Society
Towards the Optimal Secondary Index Organisation and Secondary Index Selection

1 Department of Mathematical and Computer Sciences, Michigan Technological University, Houghton, Michigan 49931, USA, 2 National Technical University of Athens, Department of Computer Science, 9 Heroon Polytechniou Avenue, Genikes Edres, Zografou, Athens (624), Greece
The problem of organising a secondary index (e.g. inverted, multilist, B-tree, etc.) and the problem of selecting the secondary attributes to be indexed by employing a particular organisation are among the two most debated problems in database technology. Related studies try to solve the two problems by studying them separately. This paper tries to combine previous results on the two problems and develops a model which selects the optimal set of secondary attributes to be indexed by allowing various organisations and implementations of secondary indexes to be decision variables in the selection process.
* Department of Mathematical and Computer Sciences, Michigan Technological University, Houghton, Michigan 49931, U.S.A.
National Technical University of Athens, Department of Computer Science, 9 Heroon Polytechniou Avenue, Genikes Edres, Zografou, Athens (624), Greece