Join query optimization in the distributed database system using an artificial bee colony algorithm and genetic operators

V Panahi, NJ Navimipour - Concurrency and Computation …, 2019 - Wiley Online Library
As the main factor in the distributed database systems, query optimization is aimed at finding
an optimal execution plan to reduce the runtime. In such systems, because of the repeated …

Join query optimisation in the distributed databases using a hybrid harmony search and artificial bee colony algorithm

M Yazdani, NJ Navimipour - International Journal of Bio …, 2021 - inderscienceonline.com
The query optimiser is a vital part of any distributed database mechanism. Reducing the
execution period of the query depends on reaching an ideal query execution plan. Due to …

Evaluation of sub query performance in SQL server

T Oktavia, S Sujarwo - EPJ Web of Conferences, 2014 - epj-conferences.org
The paper explores several sub query methods used in a query and their impact on the
query performance. The study uses experimental approach to evaluate the performance of …

Why Bee colony is the most suitable with multi-query optimization?

S AbdelGaber, MA Abdel-Fattah… - 2022 5th International …, 2022 - ieeexplore.ieee.org
This paper presents the comparison results on the performance of the swarm algorithms with
Multi-Query Optimization (MQO). First the paper discusses query optimization process and …

[PDF][PDF] Check Evaluation Subduery

A Sundjaja - core.ac.uk
Frequently user compiles a query to satisfy business process needs, whether directly using
DBMS or connecting into application system. There are many methods that can be used to …

[PDF][PDF] EVALUATION SUBQUERY METHODS IN MICROSOFT SQL SERVER 2008.

T Oktavia - Journal of Theoretical & Applied Information …, 2014 - researchgate.net
Frequently user compiles a query to satisfy business process needs, whether directly using
DBMS or connecting into application system. There are many methods that can be used to …

[PDF][PDF] Check Evaluation of sub query performance in SOL server. pdf

A Sundjaja - EPJ Web of Conferences, 2014 - core.ac.uk
The paper explores several sub query methods used in a query and their impact on the
query performance. The study uses experimental approach to evaluate the performance of …