Architecture of Automated Database Tuning Using SGA Parameters
Journal Title: Database Systems Journal - Year 2012, Vol 3, Issue 1
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.
Authors and Affiliations
Hitesh KUMAR SHARMA, Aditya SHASTRI, Ranjit BISWAS
Keywords
Related Articles
- EP ID EP146055
- DOI -
- Views 93
- Downloads 0
New e-learning method using databases
The objective of this paper is to present a new e-learning method that use databases. The solution could pe implemented for any typeof e-learning system in any domain. The article will purpose a solution to improve the l...
PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases
Modern data analysis applications are driven by the Network databases. They are pushing traditional database and data warehousing technologies beyond their limits due to their massively increasing data volumes and...
Oracle Exalytics: Engineered for Speed-of-Thought Analytics
One of the biggest product announcements at 2011's Oracle OpenWorld user conference was Oracle Exalytics In-Memory Machine, the latest addition to the "Exa"-branded suite of Oracle-Sun engineered software-hardware...
Integrating XML Technology with Object-Relational Databases into Decision Support Systems
This paper presents some informatics technologies, like XML and object-relational databases, and the main motivations for implementing them in Decision Support Systems (DSS). Also, it is proposed and analyzed a con...
A Framework for Semi-Automated Implementation of Multidimensional Data Models
Data warehousing solution development represents a challenging task which requires the employment of considerable resources on behalf of enterprises and sustained commitment from the stakeholders. Costs derive mostly fro...