A Query Optimization Algorithm Based on Multiple Join Attribute
Yuan Shen
Abstract
Yuan Shen
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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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