ScholarLens Back to search
2009•Journal of Dalian Jiaotong UniversityRequires access

Query Rewriting Research and Application in Query Optimization

Yaxin Liu

Open publisher page 0 citations

Abstract

Query optimization is an important technique for designing and implementation database system and a crucial factor that affects the capability of the database.Aim at the factual problem of query efficiency,the concretely executive process of SQL statement reference to the characteristic of database query is analyzed.Based on Dalian Criminal Interrogation assistance decision support system,materialized view is constructed,and the SQL statement is rewritten,which improves query efficiency.

About this research paper

What this paper is about

Query optimization is an important technique for designing and implementation database system and a crucial factor that affects the capability of the database.Aim at the factual problem of query efficiency,the concretely executive process of SQL statement reference to the characteristic of database query is analyzed.Based on Dalian Criminal Interrogation assistance decision support system,materialized view is constructed,and the SQL statement is rewritten,which improves query efficiency.

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

Query optimization is an important technique for designing and implementation database system and a crucial factor that affects the capability of the database.Aim at the factual problem of query efficiency,the concretely executive process of SQL statement reference to the characteristic of database query is analyzed.Based on Dalian Criminal Interrogation assistance decision support system,materialized view is constructed,and the SQL statement is rewritten,which improves query efficiency.

Key concepts: Query optimization, Sargable, Computer science, Query by Example, Query expansion, SQL, Statement (logic), View

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Query Rewriting Research and Application in Query Optimization — Research Paper | ScholarLens