Analysis of Dynamic Programming and its Future Expectations
Rupesh Sendre · Zenodo (CERN European Organization for Nuclear Research) · 2023
The success of distributed database depends on the query optimization techniques used. The users pose a query and the query optimizer’s work is to find a best plan to execute that query, for example, it determines what operations like joins and selects must be applied on a query. My research addresses the difficulties being faced in current distributed environment and the how the tedious process of selecting a Query Execution Plan (QEP) from a large space of QEP can be resolved so that the cost of network communication can be reduced. It also addresses how the dynamic programming can be implemented for a large query set. In this research, we have a technique to improve the response time of complex query by using temporary table to store results.