ScholarLens Back to search
2010•Unpublished venueRequires access

Research and Practice of SQL Optimization in ORACLE

Jiyuan Shi

Open publisher page 4 citations

Abstract

Adjustment and optimization of applications is an important stage throughout the software life cycle. Based on the database system coming into running applications, SQL statements on the optimization algorithms and improving the application efficiency have become an important goal. In this paper, based on the ORACLE database management system and the optimization goals, the methods and techniques for analyzing, and the basis principle, are combined together with an instance of SQL statements which outlines the implementation of SQL optimization methods and the performance. The work can make an effective support for the application of database system.

About this research paper

What this paper is about

Adjustment and optimization of applications is an important stage throughout the software life cycle. Based on the database system coming into running applications, SQL statements on the optimization algorithms and improving the application efficiency have become an important goal. In this paper, based on the ORACLE database management system and the optimization goals, the methods and techniques for analyzing, and the basis principle, are combined together with an instance of SQL statements which outlines the implementation of SQL optimization methods and the performance. The work can make an effective support for the application of database system.

Why it matters

OpenAlex reports 4 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Adjustment and optimization of applications is an important stage throughout the software life cycle. Based on the database system coming into running applications, SQL statements on the optimization algorithms and improving the application efficiency have become an important goal. In this paper, based on the ORACLE database management system and the optimization goals, the methods and techniques for analyzing, and the basis principle, are combined together with an instance of SQL statements which outlines the implementation of SQL optimization methods and the performance. The work can make an effective support for the application of database system.

Key concepts: Computer science, SQL, PL/SQL, Oracle, Stored procedure, Oracle Unified Method, Database, Oracle database

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Research and Practice of SQL Optimization in ORACLE — Research Paper | ScholarLens