THE OPTIMIZATION OF QUERIES IN ECONOMIC APPLICATIONS THAT USE RDBMS’S
-
Authors:
• PhD. Danut - Octavian SIMION, email: danut_so@yahoo.com, Afiliation: “Athenaeum” University of Bucharest, RomaniaPages:
• 55|64 -
Keywords: SQL Tuning, Economic applications, RDBMS, PL/SQL, optimization hints, indexes, UML diagram.
-
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.
