Benchmarking the join operations of relational database machines.
Crocker, Michael D.
Hsiao, David K.
MetadataShow full item record
Over the past several years benchmarking has been developed into an effective technique for performance analyses of computer systems. Relational database machines are relatively new compter systems for which a benchmarking technique does not yet exist;. The benchmarking of relational database machines involves the indent ification and design of test programs through which relevant performance data can be gathered and interpreted. All features of relational database management must be considered when designing these test programs. The join operations are an important feature of relational database management. The test programs for the join operations necessarily include the repetition of certain queries during which specific join parameters are varied. These parameters include: tuple size, relation size, disk placement, and the use cf indices. A number of join operations have been benchmarked. These operations are equality joins, inequality joins, three-way joins, and virtual joins (i.e., views) . In addition, a number of relational database machine configurations have been utilized for benchmarking the join operations. The highlights of the thesis can be found in its contribution tc a benchmarking technique for the join operations and its conclusions on the performance analyses of various relational machines in operating joins.
RightsThis publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.
Showing items related by title, author, creator and subject.
Benchmarking the selection and projection operations, and ordering capabilities of relational database machines Bogdanowicz, Robert A. (Monterey, California. Naval Postgraduate School, 1983-09);This thesis describes the performance-measurement experiments designed for a number of back-end, relational database machine configurations. An in-depth study of the tests and results of the two relational operations, ...
Das, Arijit (Monterey, California: Naval Postgraduate SchoolMonterey, California. Naval Postgraduate School, 2019-12); NPS-19-N065-AThe ExMCM is a broad program providing an innovative approach to the Mine Warfare mission area, required to operate with both U.S Navy and U.S. Marine Corps forces. The large number of sonar imagery files (from the MK18 ...
A benchmarking methodology for the centralized-database computer with expandable and parallel database processors and stores Demurjian, Steven A.; Vincent, James R.; Hsiao, David K. (Monterey, California. Naval Postgraduate School, 1985-08); NPS52-85-011In this paper a benchmarking methodology for a new kind of database computers is introduced. The emergence in the research community and in the commercial world of this kind of database computer (known as the multiple-backed ...