IDEAS home Printed from https://ideas.repec.org/a/aes/dbjour/v3y2012i4p25-32.html
   My bibliography  Save this article

A Framework for Automated Database TuningUsing Dynamic SGA Parameters and Basic Operating System Utilities

Author

Listed:
  • Hitesh KUMAR SHARMA

    (University of Petroleum & Energy Studies)

  • Aditya SHASTRI

    (Banasthali University, Rajasthan,India)

  • Ranjit BISWAS

    (CSE Dept, Jamia Hamdard (Hamdard University))

Abstract

In present scenario the manual work (Done by Human) cost more to an organization than the automatic work ( Done by Machine)and the ratio is increasing day by day as per the tremendous increment in Machine (Hardware + Software) Intelligence. We are moving towards the world where the Machines will be able to perform better than today by their own intelligence. They will adjust themselves as per the customer’s performance need. But to make this dream true, lots of human efforts (Theoretical and Practical) are needed to increase the capability of Machines to take their own decision and make the future free from manual work and reduce the working cost. Our life is covered with the different types of systems working around. The information system is one of them. All businesses are having the base by this system. So there is the most preference job of the IT researcher to make the Information system self-Manageable. The Development of well-established frameworks are needed to made them Auto-tuned is the basic need of the current business.The DBMS vendors are also providing the Auto-Tune packages with their DBMS Application. But they charge for these Auto-Tune packages. This extra cost of packages can be eliminated by using some basic Operating system utilities (e.g. VB Script, Task Scheduler, Batch Files, and Graphical Utility etc.). We have designed a working framework for Automatic Tuning of DBMS by using the Basic Utilities of Operating System (e.g. Windows) .These utilities will collect the statistics of SGA dynamic Parameters. The Framework will automatically analyze these SGA Parameter statistics and give suggestions fordiagnose the problem. In this paper we have presented that framework with practical Implementation.

Suggested Citation

  • Hitesh KUMAR SHARMA & Aditya SHASTRI & Ranjit BISWAS, 2012. "A Framework for Automated Database TuningUsing Dynamic SGA Parameters and Basic Operating System Utilities," Database Systems Journal, Academy of Economic Studies - Bucharest, Romania, vol. 3(4), pages 25-32, December.
  • Handle: RePEc:aes:dbjour:v:3:y:2012:i:4:p:25-32
    as

    Download full text from publisher

    File URL: http://dbjournal.ro/archive/10/10_3.pdf
    Download Restriction: no
    ---><---

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:aes:dbjour:v:3:y:2012:i:4:p:25-32. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Adela Bara (email available below). General contact details of provider: https://edirc.repec.org/data/aseeero.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.