Performance of a two-headed disk system when serving database queries under the scan policy
- 1 September 1989
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 14 (3) , 425-442
- https://doi.org/10.1145/68012.68017
Abstract
Disk drives with movable two-headed arms are now commercially available. The two heads are separated by a fixed number of cylinders. A major problem for optimizing disk head movement, when answering database requests, is the specification of the optimum number of cylinders separating the two heads. An earlier analytical study assumed a FCFS model and concluded that the optimum separation distance should be equal to 0.44657 of the number of cylinders N of the disk. This paper considers that the SCAN scheduling policy is used in file access, and it applies combinatorial analysis to derive exact formulas for the expected head movement. Furthermore, it is proven that the optimum separation distance is N/2 - 1 (⌈ N /2 - 1⌉ and ⌊ N /2 - 1⌋) if N is even (odd). In addition, a comparison with a single-headed disk system operating under the same scheduling policy shows that if the two heads are optimally spaced, then the mean seek distance is less than one-half of the value obtained with one head. In fact that the SCAN policy is used for many database applications (for example,batching and secondary key retrieval) demonstrates the potential of two-headed disk systems for improving the performance of database systems.Keywords
This publication has 21 references indexed in Scilit:
- Optimal directory placement on disk storage devicesJournal of the ACM, 1988
- Analysis of retrieval performance for records and objects using optical disk technologyACM Transactions on Database Systems, 1987
- Optimum Head Separation in a Disk System with Two Read/Write HeadsJournal of the ACM, 1984
- Implications of certain assumptions in database performance evauationACM Transactions on Database Systems, 1984
- Estimating block transfers and join sizesPublished by Association for Computing Machinery (ACM) ,1983
- Estimating block accesses and number of records in file managementCommunications of the ACM, 1982
- The Determination of the Optimum Database Maintenance PointsThe Computer Journal, 1982
- Computers and the construction of economic modelsThe Computer Journal, 1979
- Minimum cost selection of secondary indexes for formatted filesACM Transactions on Database Systems, 1977
- Analysis and performance of inverted data base structuresCommunications of the ACM, 1975