The Community for Technology Leaders
Green Image
<p>Consider the problem of maintaining large indices (or secondary memory indices) in a multiprocessor multidisk environment in which each processor has a dedicated secondary memory (one disk or more). The processors either reside in the same site and communicate via shared memory, or reside in different sites and communicate via a local broadcast network. The straightforward method (SFM) for maintaining such an index, which is commonly called declustering, is to partition the index records equally among the processors, each of which maintains its part of the index in a local B/sup tree. In prior work (Inform. Processing Lett., vol. 34, pp. 313-321, May 1990), we have presented another method, called the "totally distributed B/sup tree" (TDB) method, in which all processors together implement a "wide" B/sup tree. There are settings in which the second method is better than the first method, and vice versa. In this paper, we present a new method, called the combined distribution method (CDM), that combines the ideas underlying SFM and TDB. In tightly coupled environments, CDM outperforms both SFM and TDB in almost all practical settings (in many settings by more than 30%). This is shown by an approximate analysis and verified by simulations. Note that CDM's approach can improve performance in database systems that use a RAID (redundant array of inexpensive disks).</p>
multiprocessing systems; indexing; tree data structures; magnetic disc storage; performance evaluation; distributed databases; large index maintenance; multiprocessor multidisk environments; secondary memory indices; dedicated secondary memory; shared memory; local broadcast network; straightforward method; declustering; index record partitioning; local B/sup tree; totally distributed B/sup tree method; combined distribution method; tightly coupled environments; performance; approximate analysis; simulation; database systems; RAID; redundant array of inexpensive disks; data structures; distributed file systems; distributed indices

G. Matsliach and O. Shmueli, "A Combined Method for Maintaining Large Indices in Multiprocessor Multidisk Environments," in IEEE Transactions on Knowledge & Data Engineering, vol. 6, no. , pp. 479-496, 1994.
754 ms
(Ver 3.3 (11022016))