A methodology for database system performance evaluation

  • Authors:
  • Haran Boral;David J DeWitt

  • Affiliations:
  • Microelectronics and Computer Technology Corporation, Austin, Texas;University of Wisconsin --- Madison

  • Venue:
  • SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
  • Year:
  • 1984

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper presents a methodology for evaluating the performance of database management systems and database machines in a multiuser environment. Three main factors that affect transaction throughput in a multiuser environment are identified: multiprogramming level, degree of data sharing among simultaneously executing transactions, and transaction mix. We demonstrate that only four basic query types are needed to construct a benchmark that will evaluate the performance of a system under a wide variety of workloads. Finally, we present the results of applying our techniques to the Britton-Lee IDM 500 database machine