Benchmarking the Join Operations of Relational Database Machines.
Abstract
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 computer systems for which a benchmarking technique does not yet exist. The benchmarking of relational database machine involves the identification 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 of 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 to a benchmarking technique for the join operations and its conclusions on the performance analyses of various relational machines in operating joins. (Author)
Document Details
- Document Type
- Technical Report
- Publication Date
- Jun 01, 1983
- Accession Number
- ADA132312
Entities
People
- Michael D. Crocker
Organizations
- Naval Postgraduate School