Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Disk allocation methods for binary Cartesian product files
Du H. BIT26 (2):138-147,1986.Type:Article
Date Reviewed: Aug 1 1987

In response to a query, a database system must search the index for suitable records and fetch them from the disk. When the database occupies more than one disk, the response can be faster if the records are on different disks so the fetches can be overlapped.

This paper examines the problem of distributing records among disks to maximize fetch overlap. The problem is idealized by considering a system where each attribute has value one or zero and every possible combination of attribute values occurs among the records. For this case, a distribution scheme is presented and proven to be superior to prior known schemes, and close to optimal in a carefully defined sense. The disk chosen for a record is given by the weighted sum of the values of its attributes. In the old scheme, the weights were uniform; but in the new scheme, the weights are systematically chosen from 1,2,4, . . . 2k−1, where there are 2k disks.

Although a well-done piece of mathematics, this paper by itself is of little practical value. Few databases satisfy the highly abstract conditions of the problem solved and the paper gives no consideration to extending its results for less stringent assumptions.

Reviewer:  Wilfred J. Hansen Review #: CR111327
Bookmark and Share
 
Allocation/ Deallocation Strategies (D.4.2 ... )
 
 
Organization/ Structure (E.5 ... )
 
 
File Systems Management (D.4.3 )
 
 
Information Search And Retrieval (H.3.3 )
 
 
Performance (D.4.8 )
 
Would you recommend this review?
yes
no
Other reviews under "Allocation/Deallocation Strategies": Date
Optimal prepaging and font caching
Fuchs D., Knuth D. ACM Transactions on Programming Languages and Systems 7(1): 62-79, 1985. Type: Article
Feb 1 1986
Managing stored voice in the Etherphone system
Terry D., Swinehart D. ACM Transactions on Computer Systems 6(1): 3-27, 1988. Type: Article
Apr 1 1989
Analysis of a cyclic placement scheme
Page I. The Computer Journal 27(1): 18-25, 1984. Type: Article
Sep 1 1985
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy