Work

Query Optimization by Using Checkpoints with Plan Reduction Algorithm having Hybrid Architecture

Year: 2017
Type: article
Abstract: In any database system query Optimization is an important component. Optimizer designing that takes less time for searching and provides the most optimal query execution plan has been a challenge for DBMS research community in the last decade. The cost of executing a plan depends heavily on selectivity which keeps changing frequently and thusstatic compilation provides an inconsistent performance. Adaptive query optimization is an excellent method of generating optimal plans quite consistently. This paper proposes new hybrid architecture for query optimization which combine features of adaptive query processing and also reduces the search space for re optimization using reduced plan diagrams and cost diagrams. This hybrid architecture is bound to give more efficient performance as compared to any other optimization technique along with increased robustness and a substantial increase in consistency the selection of the most optimal execution plan
Language: English
Open Access status: diamond
OpenAlex ID: W2594169755
FWCI:
Cites:
Cited by:
Related to: 10