2012Journal of Changsha Telecommunications and Technology Vocational CollegeRequires access

Research on query optimization methods based on relational database

PU Hui-zhong

Open publisher page 0 citations

Abstract

Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.

About this research paper

What this paper is about

Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.

Why it matters

A significance statement is not available in the OpenAlex record.

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

Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.

Key concepts: Computer science, Query optimization, Sargable, View, Relational database, Query by Example, Relational model, Relational database management system

Related papers

Back to paper searchBrowse research topicsOriginal source
Research on query optimization methods based on relational database — Research Paper | ScholarLens