THE OPTIMIZATION OF QUERIES IN ECONOMIC APPLICATIONS THAT USE RDBMS’S

PhD. Danut - Octavian Simion ()
Additional contact information
PhD. Danut - Octavian Simion: “Athenaeum” University of Bucharest, Romania

Internal Auditing and Risk Management, 2015, vol. 37, issue 1, 55-64

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.

Keywords: SQL Tuning; Economic applications; RDBMS; PL/SQL; optimization hints; indexes; UML diagram. (search for similar items in EconPapers)
Date: 2015
References: Add references at CitEc
Citations:

Downloads: (external link)
http://aimr.univath.ro/download/1003_aimr_37_60_69.pdf
http://aimr.univath.ro/en/article/THE-OPTIMIZATION ... E-RDBMS--S~1003.html (text/html)

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:ath:journl:v:37:y:2015:i:1:p:55-64

Access Statistics for this article

Internal Auditing and Risk Management is currently edited by Emilia Vasile

More articles in Internal Auditing and Risk Management from Athenaeum University of Bucharest Contact information at EDIRC.
Bibliographic data for series maintained by Cosmin Catalin Olteanu and Emilia Vasile ().