Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance

Abstract

Performance tuning in database management system means escalating the performance of database by reducing time. For enhancing performance, analysis is important and analysis can be performed by neural network learning to save time spent in doing repeated work. Because neural network has ability to adapt dynamically varying environment .In this paper, working on two aspects is done and named as lead and lag parameters. Lead parameter is target and lag parameters are levers that need to press for achieving the target. For identification of lead parameters; consider the criticality of the parameter (thru cardinality estimation) and lag parameters are the parameters that are associated with it and their time of processing affect lead parameter. This paper is all about analyzing the lag parameter and feeding only those lag parameters which are contributing in high share of time to automated tuning system. General Terms Lead parameter, Lag parameter, analysis.