2012•Computer and ModernizationRequires access

A Query Optimization Algorithm Based on Multiple Join Attribute

Yuan Shen

Open publisher page 0 citations

Abstract

Database query operation is the most common operation.Because the data in a distributed database is distributed and redundant,query optimization study of a distributed database is one of the core issues.In order to improve the efficiency of distributed database queries,the paper analyzes and discusses the common implementation strategy based on the direct-join,and presents an improved direct-join query optimization strategy for the distributed database applications for multi-table joins when there are multiple connection properties.Improved algorithm improves query execution parallelism,reduces the query processing time and improves the query efficiency.

About this research paper

What this paper is about

Database query operation is the most common operation.Because the data in a distributed database is distributed and redundant,query optimization study of a distributed database is one of the core issues.In order to improve the efficiency of distributed database queries,the paper analyzes and discusses the common implementation strategy based on the direct-join,and presents an improved direct-join query optimization strategy for the distributed database applications for multi-table joins when there are multiple connection properties.Improved algorithm improves query execution parallelism,reduces the query processing time and improves the 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

Database query operation is the most common operation.Because the data in a distributed database is distributed and redundant,query optimization study of a distributed database is one of the core issues.In order to improve the efficiency of distributed database queries,the paper analyzes and discusses the common implementation strategy based on the direct-join,and presents an improved direct-join query optimization strategy for the distributed database applications for multi-table joins when there are multiple connection properties.Improved algorithm improves query execution parallelism,reduces the query processing time and improves the query efficiency.

Key concepts: Computer science, Query optimization, Joins, Sargable, Online aggregation, Database, View, Query expansion

Related papers

Back to paper searchBrowse research topicsOriginal source
A Query Optimization Algorithm Based on Multiple Join Attribute — Research Paper | ScholarLens