IDEAS home Printed from https://ideas.repec.org/a/ath/journl/v37y2015i1p55-64.html
   My bibliography  Save this article

The Optimization Of Queries In Economic Applications That Use Rdbms’S

Author

Listed:
  • PhD. Danut - Octavian SIMION

    (“Athenaeum” University of Bucharest, Romania)

Abstract

The paper presents the advantages of the optimization of queries in economic applications that use RDBMS’s. The economic applications that are based on a relational database management system (RDBMS) often require fast responses at the queries made by users. Fast responses mean a good design of the database and saves time and money for the end users and for companies that use these types of applications. Sometimes a good design doesn’t always ensure fast responses of queries so other methods of optimization may improve time and enables users to obtain more from their economic applications. There are methods o optimize queries such as transforming the queries using algebraic rules, modifying the initiation parameters of RDBMS, using hints for optimization, using instruments such as Automatic SQL Tuning. This optimization needs to analyze queries and to make an optimization plan by using explain plan command to calculate statistics and the most important task is to create the appropriate indexes for one or more columns. These methods helps the users to get fast responses for their queries and to improve the design and rules for the database that they use in specific economic applications.

Suggested Citation

  • PhD. Danut - Octavian SIMION, 2015. "The Optimization Of Queries In Economic Applications That Use Rdbms’S," Internal Auditing and Risk Management, Athenaeum University of Bucharest, vol. 37(1), pages 55-64, March.
    • Handle: RePEc:ath:journl:v:37:y:2015:i:1:p:55-64
    as

    Download full text from publisher

    File URL: http://aimr.univath.ro/download/1003_aimr_37_60_69.pdf
    Download Restriction: no
    File URL: http://aimr.univath.ro/en/article/THE-OPTIMIZATION-OF-QUERIES-IN-ECONOMIC-APPLICATIONS-THAT-USE-RDBMS--S~1003.html
    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:ath:journl:v:37:y:2015:i:1:p:55-64. 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: Cosmin Catalin Olteanu and Emilia Vasile (email available below). General contact details of provider: https://edirc.repec.org/data/feathro.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.