This paper concerns the following problem: given a set of multi-attribute records, a fixed number of buckets and a two-disk system, arrange the records into the buckets and then store the buckets between the disks in such a way that, over all possible orthogonal range queries (ORQs), the disk access concurrency is maximized. We shall adopt the multiple key hashing (MKH) method for arranging records into buckets and use the disk modulo (DM) allocation method for storing buckets onto disks. Since the DM allocation method has been shown to be superior to any other allocation methods for allocating an MKH file onto a two-disk system for answering ORQs, the real issue is knowing how to determine an optimal way for organizing the records into buckets based upon the MKH concept.
A performance formula that can be used to evaluate the average response time, over all possible ORQs, of an MKH file in a two-disk system using the DM allocation method is first presented. Based upon this formula, it is shown that our design problem is related to a notoriously difficult problem, namely the Prime Number Problem. Then a performance lower bound and an efficient algorithm for designing optimal MKH files in certain cases are presented. It is pointed out that in some cases the optimal MKH file for ORQs in a two-disk system using the DM allocation method is identical to the optimal MKH file for ORQs in a single-disk system and the optimal average response time in a two-disk system is slightly greater than one half of that in a single-disk system. 相似文献
The reaction of [Cu(sac)2(H2O)4] · 2H2O with 2-methylpyrazine (mpyz) leads two complexes, concomitant crystallization of a mononuclear complex [Cu(sac)2(mpyz)(H2O)2] (1) and a polymeric complex [Cu(sac)2(μ-mpyz)]n (2). Both complexes have been characterized by elemental analyses, magnetic measurements, FT-IR and ESR, TG-DTA and single-crystal
X-ray diffraction analyses. Single-crystal X-ray analyses show that complex 1 consists of discrete molecules in which the copper(II) ions exhibits a square-pyramidal coordination geometry. The individual
molecules of 1 are connected into a hydrogen-bonded chain structure, which is further assembled to form a three-dimensional network by π–π stacking interactions.
Complex 2 is an 1D coordination polymer in which copper(II) centers are bridged by the mpyz ligand. The chains are further assembled
to form two-dimensional frameworks by π–π and C–H···π stacking interactions. 相似文献