CFP last date
20 June 2024
Reseach Article

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

by Bindu Sharma, Mahesh Singh
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 96 - Number 2
Year of Publication: 2014
Authors: Bindu Sharma, Mahesh Singh
10.5120/16763-6323

Bindu Sharma, Mahesh Singh . Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance. International Journal of Computer Applications. 96, 2 ( June 2014), 1-3. DOI=10.5120/16763-6323

@article{ 10.5120/16763-6323,
author = { Bindu Sharma, Mahesh Singh },
title = { Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance },
journal = { International Journal of Computer Applications },
issue_date = { June 2014 },
volume = { 96 },
number = { 2 },
month = { June },
year = { 2014 },
issn = { 0975-8887 },
pages = { 1-3 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume96/number2/16763-6323/ },
doi = { 10.5120/16763-6323 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:20:41.833613+05:30
%A Bindu Sharma
%A Mahesh Singh
%T Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance
%J International Journal of Computer Applications
%@ 0975-8887
%V 96
%N 2
%P 1-3
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
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.

References
  1. Sreekumar Vobugari, D. V. L. N. Somayajulu, and B. M. Subraya ,2012, A model for building dynamic indexes & storage and Re-use of optimal query plans Generated thru progressive Optimization
  2. David J. Montana and Lawrence Davis, Training Feedforward Neural Networks Using Genetic Algorithms.
  3. Hitesh Kumar Sharma, Aditya Shastri , Ranjit Biswas , 2012, Architecture of Automated Database Tuning Using SGA parameter.
  4. S. F. Rodd, Dr, U. P. Kulkarni , 2010, Adaptive Tuning Algorithm for performance Tuning of database Management System
  5. Gaozheng Zhang, Mengdong Chen , Lianzhong Liu, A model for Application –oriented Database performance Tuning
  6. Debnath, B. K. ; Lilja, D. J. ; Mokbel, M. F. , SARD: A Statistical Approach for Ranking database Tuning parameters, Data Engineering Workshop, 2008. ICDEW 2008. IEEE 24th International Conference, April 2008.
  7. Sanjay Agarwal, Nicolas Bruno, Surajit Chaudhari, AutoAdmin: Self Tuning Database System Technology, IEEE Data Engineering Bulletin, 2006.
  8. Chaudhuri, S. ; Weikum G, Foundations of Automated Database Tuning, Data Engineering, April 2006.
  9. Michael L. Rupley, 2008. Jr. Introduction to Query Processing and Optimization. Indiana University at South Bend. .
  10. Surjit Choudhuri, Vivek Narasayya, Self Tuning Database Systems: A Decade progress, Microsoft Research. 2007.
  11. Gerhar Weikum, Axel Moenkerngerg et. al. , Self-tuning Database Technology and Information Services :From wishful thing to viable Engineering, Parallel and Distributed Information System 1993.
  12. Gennadi Rabinovitch, David Wiese, Non-linear Optimization of Performance functions Autonomic Database Performance Tuning, IEEE Conference, 2007.
  13. Satish, S. K. ; Saraswatipura, M. K. ; Shastry, S. C, DB2 Performance Enhancements using Materialized Query Table for LUW Systems, 2007. ICONS '07. Second International Conference, April 2007.
Index Terms

Computer Science
Information Sciences

Keywords

Performance tuning in database management system Analysis of time parameters for tuning database performance. .