<abstract xmlns="http://www.w3.org/1999/xhtml"><p>Databases provide an efficient way to store, retrieve and analyze data. Oracle relational database is one of the most popular database management systems that is widely used in a different variety of industries and businesses. Therefore, it is important to guarantee that the database access and data manipulation is optimized for reducing database system response time. This paper intends to analyze the performance and the main optimization techniques (Forall, Returning, and Bulk Collect) that can be adopted for Oracle Relational Databases. The results have shown that the adoption of Forall and Bulk Collect approaches bring significant benefits in terms of execution time. Furthermore, the growth rate of the average execution time is lower for Bulk Collect than Forall. However, adoption of Returning approach doesn’t bring significant statistical benefits.</p></abstract>

Databases provide an efficient way to store, retrieve and analyze data. Oracle relational database is one of the most popular database management systems that is widely used in a different variety of industries and businesses. Therefore, it is important to guarantee that the database access and data manipulation is optimized for reducing database system response time. This paper intends to analyze the performance and the main optimization techniques (Forall, Returning, and Bulk Collect) that can be adopted for Oracle Relational Databases. The results have shown that the adoption of Forall and Bulk Collect approaches bring significant benefits in terms of execution time. Furthermore, the growth rate of the average execution time is lower for Bulk Collect than Forall. However, adoption of Returning approach doesn’t bring significant statistical benefits.

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Cybernetics and Information Technologies

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

{"article-title":"Performance Analysis and Optimization Techniques for Oracle Relational Databases"}

Databases provide an efficient way to store, retrieve and analyze data. Oracle relational database is one of the most popular database management systems that...

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Published Online: Jun 18, 2019

Page range: 117 - 132

Received: Apr 04, 2019

Accepted: May 14, 2019

DOI: https://doi.org/10.2478/cait-2019-0019

Keywords
Databases, performance analysis, optimization techniques, Oracle, information systems

© 2019 Fernando Almeida et al., published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Published Online: Jun 18, 2019

Page range: 117 - 132

Received: Apr 04, 2019

Accepted: May 14, 2019

DOI: https://doi.org/10.2478/cait-2019-0019

KeywordsDatabases, performance analysis, optimization techniques, Oracle, information systems

© 2019 Fernando Almeida et al., published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Keywords
Databases, performance analysis, optimization techniques, Oracle, information systems