Performance Measurement of a Relational Database System Using Monitoring and Modeling Techniques

摘要

An investigation was conducted to provide a productive means of measuring the effectiveness of a collection of untested relational algebra query optimization techniques which are integrated within an existing microprocessor resident relational database. As a result of this research, two methods of performance measurement were proposed. A software monitor was designed, coded, and tested specifically to determine if the employed optimization methods actually descrease the amount of processing time required to execute a given query. Additionally, a baseline simulation model was designed and presented as an alternative means of analyzing the performance of this optimization logic.