ScholarLens Back to search
2009•Computer Programming Skills & MaintenanceRequires access

Query Rewriting Relational Database Query Optimization Technology

Qi-Cai Chen

Open publisher page 0 citations

Abstract

With the data warehouse technology more and more extensive,data warehouse query is also getting higher and higher frequency of use,based on the query rewriting relational database query optimization technology,through the view rewritten subquery merging predicate equivalent replacement,the use of temporary tables,as well as a set to replace UNION operator OR logic operations such as the use of technology,this article discussed in detail the database query optimizer query rewrite module design and implementation of XML,SQL statements,such as query rewriting method.

About this research paper

What this paper is about

With the data warehouse technology more and more extensive,data warehouse query is also getting higher and higher frequency of use,based on the query rewriting relational database query optimization technology,through the view rewritten subquery merging predicate equivalent replacement,the use of temporary tables,as well as a set to replace UNION operator OR logic operations such as the use of technology,this article discussed in detail the database query optimizer query rewrite module design and implementation of XML,SQL statements,such as query rewriting method.

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

With the data warehouse technology more and more extensive,data warehouse query is also getting higher and higher frequency of use,based on the query rewriting relational database query optimization technology,through the view rewritten subquery merging predicate equivalent replacement,the use of temporary tables,as well as a set to replace UNION operator OR logic operations such as the use of technology,this article discussed in detail the database query optimizer query rewrite module design and implementation of XML,SQL statements,such as query rewriting method.

Key concepts: Computer science, Query optimization, Sargable, Query language, Materialized view, View, Query expansion, Query by Example

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Query Rewriting Relational Database Query Optimization Technology — Research Paper | ScholarLens