Call for Paper - May 2023 Edition
IJCA solicits original research papers for the May 2023 Edition. Last date of manuscript submission is April 20, 2023. Read More

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

Print
PDF
 
Download Full Text
International Journal of Computer Applications
© 2014 by IJCA Journal
Volume 96 - Number 2
Year of Publication: 2014
Authors:
Bindu Sharma
Mahesh Singh
10.5120/16763-6323

Bindu Sharma and Mahesh Singh. Article: Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance. International Journal of Computer Applications 96(2):1-3, June 2014. Full text available. BibTeX

@article{key:article,
	author = {Bindu Sharma and Mahesh Singh},
	title = {Article: Analytical Approach in Terms of Lead and Lag Parameter to Tune Database Performance},
	journal = {International Journal of Computer Applications},
	year = {2014},
	volume = {96},
	number = {2},
	pages = {1-3},
	month = {June},
	note = {Full text available}
}

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

  • 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
  • David J. Montana and Lawrence Davis, Training Feedforward Neural Networks Using Genetic Algorithms.
  • Hitesh Kumar Sharma, Aditya Shastri , Ranjit Biswas , 2012, Architecture of Automated Database Tuning Using SGA parameter.
  • S. F. Rodd, Dr, U. P. Kulkarni , 2010, Adaptive Tuning Algorithm for performance Tuning of database Management System
  • Gaozheng Zhang, Mengdong Chen , Lianzhong Liu, A model for Application –oriented Database performance Tuning
  • 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.
  • Sanjay Agarwal, Nicolas Bruno, Surajit Chaudhari, AutoAdmin: Self Tuning Database System Technology, IEEE Data Engineering Bulletin, 2006.
  • Chaudhuri, S. ; Weikum G, Foundations of Automated Database Tuning, Data Engineering, April 2006.
  • Michael L. Rupley, 2008. Jr. Introduction to Query Processing and Optimization. Indiana University at South Bend. .
  • Surjit Choudhuri, Vivek Narasayya, Self Tuning Database Systems: A Decade progress, Microsoft Research. 2007.
  • 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.
  • Gennadi Rabinovitch, David Wiese, Non-linear Optimization of Performance functions Autonomic Database Performance Tuning, IEEE Conference, 2007.
  • 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.