2001Acta Scientiarum Naturalium Universitatis SunyatseniRequires access

A Research on Optimization of Multi-join Queries

Peng Jian

Open publisher page 0 citations

Abstract

On the basis of the given condition,it is shown that the global optimization algorithm can apply to equi_join or nonequi_join and has nothing to do with the estimation model of the join_later size in muti_join queries,and that for star queries, the algorithm can produce join sequences with the following global optimization property.In the join sequence, arbitrary subsequence formed by three neighboring joins is optimum.

About this research paper

What this paper is about

On the basis of the given condition,it is shown that the global optimization algorithm can apply to equi_join or nonequi_join and has nothing to do with the estimation model of the join_later size in muti_join queries,and that for star queries, the algorithm can produce join sequences with the following global optimization property.In the join sequence, arbitrary subsequence formed by three neighboring joins is optimum.

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

On the basis of the given condition,it is shown that the global optimization algorithm can apply to equi_join or nonequi_join and has nothing to do with the estimation model of the join_later size in muti_join queries,and that for star queries, the algorithm can produce join sequences with the following global optimization property.In the join sequence, arbitrary subsequence formed by three neighboring joins is optimum.

Key concepts: Join (topology), Joins, Subsequence, Computer science, Hash join, Sort-merge join, Sequence (biology), Theoretical computer science

Related papers

Back to paper searchBrowse research topicsOriginal source
A Research on Optimization of Multi-join Queries — Research Paper | ScholarLens