Academic Journals Database
Disseminating quality controlled scientific knowledge

Enhanced Performance of Database by Automated Self-Tuned Systems

Author(s): Ankit Verma

Journal: International Journal of Computer Science and Management Studies
ISSN 2231-5268

Volume: 11;
Issue: 01;
Start page: 22;
Date: 2011;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: Self-tuned database | automated database

Performance tuning of Database Management Systems (DBMS) is complex as well as challenging task since it involves identification and alteration of several key performance tuning parameters. The quality of tuning and the extent of performance enhancement achieved greatlydepend on the skill and experience of the Database Administrator (DBA). The ability of our automated database design to adapt to dynamically changing inputs makes them ideal candidates for employing them for tuning purpose. In this paper, a novel tuning algorithm based on new script estimated tuning parameters is presented. The key performance indicators are proactively monitored and fed as input to the proposed script and the trained networksestimates the suitable size of the buffer cache, shared pooland redo log buffer size. The tuner alters these tuning parameters using the estimated values using a rate change computing algorithm. The preliminary results show that the proposed method is effective in improving the query response time for a variety of workload types. To summarize, this paper presents a self tuned database systemor we can say, automated database system whose main focus is performance optimization.

Tango Jona
Tangokurs Rapperswil-Jona

     Affiliate Program