© 1979 by British Computer Society
| ||||||||||||||||||||||||||||||||||||||||||||||||||||
Optimising disc head movements in secondary key retrievals

1 School of Computing Studies, University of East Anglia, Norwich, UK, 2 Dimitriou Ralli 46, Amarousion, Athens, Greece
Schneiderman and Goodman (1976) considered queries based on primary key values and they argued that the process of batching may reduce their response time. This study considers the effect of batching queries based on secondary key values and proposes some means of scheduling the queries which substantially reduces the required disc head movements. The method is a variation of the SCAN disc scheduling policy and it can be applied to online retrieval systems because it works even for very small batch sizes and because it does not impose prohibitive overheads in evaluating/implementing it.
Received January 1978.
* now at School of Computing Studies, University of East Anglia, Norwich NR4 7TJ.
Dimitriou Ralli 46, Amarousion, Athens, Greece.