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
Authors: SANA SHAFIQUE, ATIF AZIZ
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: diamond
OpenAlex ID: W2594169755
