Architecture of Automated Database Tuning Using SGA Parameters

Hitesh KUMAR Sharma (), Aditya Shastri () and Ranjit Biswas ()
Additional contact information
Hitesh KUMAR Sharma: ITM University
Aditya Shastri: Banasthali University,Rajasthan-304022, India
Ranjit Biswas: Jamia Hamdard (Hamdard University)

Database Systems Journal, 2012, vol. 3, issue 1, 3-10

Abstract: Business Data always growth from kilo byte, mega byte, giga byte, tera byte, peta byte, and so far. There is no way to avoid this increasing rate of data till business still running. Because of this issue, database tuning be critical part of a information system. Tuning a database in a cost-effective manner is a growing challenge. The total cost of ownership (TCO) of information technology needs to be significantly reduced by minimizing people costs. In fact, mistakes in operations and administration of information systems are the single most reasons for system outage and unacceptable performance [3]. One way of addressing the challenge of total cost of ownership is by making information systems more self-managing. A particularly difficult piece of the ambitious vision of making database systems self-managing is the automation of database performance tuning. In this paper, we will explain the progress made thus far on this important problem. Specifically, we will propose the architecture and Algorithm for this problem. Key Words: Database Tuning, DBA, SGA, SGA Parameters, Automated Tuning, TOC.

Date: 2012
References: View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://dbjournal.ro/archive/7/7_1.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:3:y:2012:i:1:p:3-10

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().