Affordable Access

Access to the full text

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Authors
  • Almeida, Fernando
  • Silva, Pedro
  • Araújo, Fernando
Type
Published Article
Journal
Cybernetics and Information Technologies
Publisher
Sciendo
Publication Date
Jun 01, 2019
Volume
19
Issue
2
Pages
117–132
Identifiers
DOI: 10.2478/cait-2019-0019
Source
De Gruyter
Keywords
License
Green

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.

Report this publication

Statistics

Seen <100 times