Please use this identifier to cite or link to this item:
Title: Adaptive techniques for performance tuning of database systems
Researcher: Rodd, Sunil F
Guide(s): Kulkarni, U P
Keywords: Computer Science
Upload Date: 25-Jun-2014
University: Graphic Era University
Completed Date: 22/03/2014
Abstract: Self-tuning of Database Management Systems(DBMS) offers important advantages newlinesuch as improved performance, reduced Total Cost of Ownership(TCO), eliminating the need newlinefor an exert Database Administrator(DBA) and improved business prospects. Several newlinetechniques have been proposed by researchers and the database vendors to self-tune the DBMS. newlineHowever, the research focus was confined to physical tuning techniques and the algorithms newlineused in existing methods for self-tuning of memory need analysis of large statistical data. As newlineresult, these approaches are not only computationally expensive but also do not adapt well to newlinedynamically changing workload types and user-load patterns. Hence, in this research, the newlineimpact of tuning parameters on the response-time and workload characterization has been newlinecarried out in order to build a knowledgebase that can effectively be used for self-tuning the newlineDBMS. The proposed self-tuning techniques are dynamic, adaptive and also provide the newlinenecessary performance-improvement in terms of query-response-time.To develop a self-tuning system that is adaptive to changing workloads, it is important newlineto identify the current workload type. Hence, to identify the current workload type, a series of newlineexperiments were carried out to relate BHR to the workload type. It is observed that the BHR newlinealone canand#146;t be used to identify the workload type as the BHR value of different workloads newlineoverlap with each other. However, it was found that using BHR in conjunction with the size of newlinethe database, it is possible to accurately identify the workload of a particular type. This newlineexperimental finding forms the basis for inclusion of these two parameters as inputs in the newlineproposed self-tuning techniques.In the second phase of the research, an analytical method was attempted to establish a newlinerelationship between the Response-time of end user queries, user-load and tuning parameters,
Pagination: 137p.
Appears in Departments:Department of Computer Science and Engineering

Files in This Item:
File Description SizeFormat 
01_title.pdfAttached File82.44 kBAdobe PDFView/Open
02_certificate.pdf48.35 kBAdobe PDFView/Open
03_acknowledgements.pdf26.38 kBAdobe PDFView/Open
04_contents.pdf37.54 kBAdobe PDFView/Open
05_preface.pdf29.63 kBAdobe PDFView/Open
06_list_of_tables_figures.pdf30.48 kBAdobe PDFView/Open
07_chapter 1.pdf192.49 kBAdobe PDFView/Open
08_chapter 2.pdf571.63 kBAdobe PDFView/Open
09_chapter 3.pdf292.8 kBAdobe PDFView/Open
10_chapter 4.pdf422.27 kBAdobe PDFView/Open
11_chapter 5.pdf382.23 kBAdobe PDFView/Open
12_chapter 6.pdf629.32 kBAdobe PDFView/Open
13_chapter 7.pdf45.99 kBAdobe PDFView/Open
14_references.pdf128.76 kBAdobe PDFView/Open

Items in Shodhganga are protected by copyright, with all rights reserved, unless otherwise indicated.