arrow
返回

Join queries optimization in the distributed databases using a hybrid multi-objective algorithm

delete2021-11-02
delete6
PRE
AI
E
Elham Azhir
N
Nima Jafari Navimipour *
M
Mehdi Hosseinzadeh *
A
Arash Sharifi
M
Mehmet Ünal
A
Aso Mohammad Darwesh
DOI:10.1007/s10586-021-03451-9delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
In the distributed database systems, the relations needed by a query can be kept in several locations. This process significantly increases potential corresponding Query Execution Plans (QEP's); a user query. Hence; th, in addition to the expense of local computing, the charge of transferring data between different cloud sites should also be considered. It does not sound logical to investigate all potential query plans in a high setting like this. The best query plan (regarding cost) must be generated; processing a given query. A new hybrid multi-objective genetic and bat algorithm, a Multi-Objective Genetic Algorithm with BAT (MOGABAT), is used in the present article to produce the best query plans. The functionality comparison is made on different join graph structures, among MOGABAT, Multi-Objective BAT (MOBAT), and Non-dominated Sorting Genetic Algorithm II (NSGA-II). The obtained results have shown that the quality of generated query plans is enhanced; the join graph structures. Nevertheless, more execution time is needed.
Keyword:
Distributed Query
Multi-Objective Optimization
MOBAT
Genetic Algorithm
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

C
Cluster Computing-The Journal of Networks Software Tools and Applications
IF:
4.1
论文数:
5.0K
被引数:
7.5K

机构

I
Islamic Azad University
学者数:
4.0W
论文数: 3.3W
被引数: 9.8K
N
national yunlin university science & technology
学者数:
3.2K
论文数: 3.3K
被引数: 1
I
istanbul nisantasi university
学者数:
422
论文数: 510
被引数: 3
G
Gachon University
学者数:
8.2K
论文数: 9.3K
被引数: 8.6K
学者 查看更多机构
引用论文

引用论文

Double adaptive weights for stabilization of moth flame optimizer: Balance analysis, engineering cases, and medical diagnosis
err2021-02-01
err179
PREAI
errShan, Weifeng; Qiao, Zenglin; Heidari, Ali Asghar; Chen, Huiling; Turabieh, Hamza; Teng, Yuntian
err分享
err收藏
The association between rheumatoid arthritis and periodontal disease in a population-based cross-sectional case-control study
err2020-07-20
err0
errOAAI
errStefan Renvert; Johan Sanmartin Berglund; G. Rutger Persson; Maria K. Söderlin
err分享
err收藏
SGOA: annealing-behaved grasshopper optimizer for global tasks
err2021-01-03
err111
PREAI
errYu, Caiyang; Chen, Mengxiang; Cheng, Kai; Zhao, Xuehua; Ma, Chao; Kuang, Fangjun; Chen, Huiling
err分享
err收藏
Flow boiling critical heat flux enhancement in ZrSi2 accident-tolerant fuel cladding with porous structures
err2022-05-01
err0
PREAI
errMinrak Kim; Hyunwoo Noh; Gi Cheol Lee; Hwasung Yeom; Tong Kyun Kim; Jin Man Kim; Tae Ho Kim; HangJin Jo; Hyun Sun Park; Kumar Sridharan; Moo Hwan Kim
err分享
err收藏
学者 查看更多内容