A tool for performance evaluation of database systems for small computer systems

Abstract

This paper proposes a tool that provides a comparative evaluation of the performance of database systems. The tool has four components, the input component, the database-queries components, the statistical computation component and the report component. The input includes small, medium and large files as well as parameters relating to the database management systems being evaluated, the computers used for evaluation and ,the computer access normalization factor. The database-queries component incIudes several prepared sets of queries that test access paths, range retrievals, joins, query optimization and updates. The database management systems under evaluation executes the queries on small, medium and large files. The statistical computation component accrues the performance timings and executes statistical functions on these data. Finally, the report component provides the resulting evaluation in a tabular form. The tool has a user friendly interface. It provides reliable and accurate results even when the database management systems are running on different computers.