Abstract
In order to reduce the disk access time, a database can be stored on several simultaneously accessible disks. In this paper, we are concerned with the dynamicd-attribute database allocation problem for range queries. An allocation method, called coordinate modulo allocation method, is proposed to allocate data in ad-attribute database among disks so that the maximum disk accessing concurrency can be achieved for range queries. Our analysis and experiments show that the method achieves the optimum or near-optimum parallelism for range queries. The paper offers the conditions under which the method is optimal. The worst case bounds of the performance of the method are also given. In addition, the parallel algorithm of processing range queries is described at the end of the paper. The method has been used in the statistic and scientific database management system which is being designed by us.
Article PDF
Similar content being viewed by others
References
Du, H. C. and Sobolewski, J. S., Disk allocation for Cartesian product files on multiple disk systems.ACM Trans. Database Systems 1982, 7, 82–101.
Chen, M. Y., Multidisk file design: An analysis of folding buckets to disks.BIT, 1984, 24, 262–268.
Chen, M. Y., A note on redundant disk modulo allocation.Information Processing Letters, 1985, 20, 121–123.
Chang, C. C. and Chen, M. Y., Lower Bounds of Using Disk Modulo Allocation Method to Allocate Cartesian Product Files in Two-disk System. In the Proceedings of International Computer Symposium, Tainan, Taiwan, Dec. 1986, 770–774.
Chan, C. C. and Lian, L. S., On Strict Optimality Property of Allocating Binary Cartesian Product Files on Multiple Disk Systems. In the Proceedings of International Conference on Foundation of Data Organization, Kyoto, Japan, May 1985, 104–112.
Du, H. C., Disk allocation methods for binary Cartesian product filesBIT, 1986, 26, 138–147.
Wu, C. T. and Burkhard, W. A., Associative searching in multiple storage units.ACM. Trans. Database Systems 1987, 12 (1), 38–64.
Nievergelt, J., Ninterberger, H. and Sevcik, K. C., The grid file: An adaptable, symmetric multikey file structure.ACM Trans. Database Systems, 1984, 9, (1), 38–71.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Li, J. Range query processing in multidisk systems. J. of Comput. Sci. & Technol. 7, 316–327 (1992). https://doi.org/10.1007/BF02943548
Received:
Revised:
Issue Date:
DOI: https://doi.org/10.1007/BF02943548