Performance Tuning in Database Management System based on Analysis of Combination of Time and Cost Parameter through Neural Network Learning

Abstract

Performance tuning in database management system means enhancing the performance of database, i.e. minimizing the response time at a very optimum cost. Query optimization is one of the important aspects of performance tuning. Lots of research work has been done in this field but it is still ongoing process. To achieve high performance at a very low cost identification of KPIs (Key performance indicators) is necessary, so that by altering these parameters dynamically minimum response time with optimum value can be achieved. This paper proposes how to filter cost and time parameters, to prioritize these parameters to get minimum response time. The approach proposes in this paper will be implemented by using neural network learning rules.