Optimization of bulk operation performances within Oracle database

Berkovic, Ivana; Ivanković, Z.; Markoski, Branko; Radosav, Dragica; Ivkovic, M.

doi:10.1109/sisy.2010.5647277

Cited by 3 publications

(6 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Several approaches in the literature [Berkovic et al 2010;Feuerstein 2007;Hall 2006;Harrison 2000] focus efforts on identifying good practices for the development of efficient stored procedures. Efficiency improvements are related to changes that can enhance the execution time or memory utilization of the procedures.…”

Section: Efficiency Improvementsmentioning

confidence: 99%

“…Several performance experiments which investigate the impact of these kind of efficiency improvements are available in the related literature [Berkovic et al 2010;Hall 2006;Harrison 2000]. In order to illustrate some of efficiency problems, Code 1 is used as an example.…”

Section: Efficiency Improvementsmentioning

confidence: 99%

“…Note that the tool is able to create suitable warnings related to all efficiency problems of Code 1 discussed in Section 2.1. According to the related literature [Berkovic et al 2010;Feuerstein 2007;Hall 2006;Harrison 2000], the appliance of these warnings can significantly improve the performance of a stored procedure.…”

Section: Pl/sql Advisor -A Static Analysis-based Toolmentioning

confidence: 99%

“…These programming languages enable programmers to develop and store part of the business logic of information systems as stored procedures (for convenience, in this paper we use the term procedure for both procedure and function). As presented by [Berkovic et al 2010, Feuerstein 2007, stored procedures can bring several benefits to the whole system functioning, such as performance improvements, security and simpler maintenance. Due to these advantages, the usage of stored procedures became an effective technique on the architecture of information systems and general database applications.…”

Section: Introductionmentioning

confidence: 99%

“…In general, stored procedures contain both SQL commands and procedural code. Although SQL optimizations provide a greater performance impact, procedural code optimizations can also bring performance gains [Feuerstein 2007;Berkovic et al 2010]. In this paper, we present PL/SQL Advivsor, a tool based on static analysis of source code, which automatically detects efficiency and quality potential improvements on stored procedures written in PL/SQL [Sheila Moore 2009], the Oracle programming language.…”

Section: Introductionmentioning

confidence: 99%

See 4 more Smart Citations

PL / SQL Advisor : a Static Analysis-based Tool to Suggest Improvements for Stored Procedures

Nascimento¹,

Pires²,

Massoni³

2013

Anais Do IX Simpósio Brasileiro De Sistemas De Informação (SBSI 2013)

View full text Add to dashboard Cite

Stored procedures are commonly used to provide access and manipulation ofdatabase data for information systems and other applications. If procedures present inefficient programming logic or data manipulation, excessive delays are provided to the client applications. Such delays can cause, among other problems, expressive financial losses to enterprises. In additon, if procedures are developed using bad programming practices, they may become complex to maintain and evolve. In general, attempts to minimize these problems using manual analysis of source code are labor- and time-consuming. In this work, we present PL/SQL Advisor, a static analysis-based tool, which automatically detects potential improvements on database stored procedures written in PL/SQL. The results ofa case study, using real open source projects, show that our tool is able to suggest a reasonable amount ofcode improvements with low cost.

show abstract

Section: Efficiency Improvementsmentioning

confidence: 99%

Section: Efficiency Improvementsmentioning

confidence: 99%

Section: Pl/sql Advisor -A Static Analysis-based Toolmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 3 more Smart Citations