.png){kind=icon}
返回
A technique for parallel query optimization using MapReduce framework and a semantic-based clustering method
.png){kind=icon}
OA
AI
DOI：10.7717/peerj-cs.580.png)
.png){kind=icon}
.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
Query optimization is the process of identifying the best Query Execution Plan (QEP). The query optimizer produces a close to optimal QEP for the given queries based on the minimum resource usage. The problem is that for a given query, there are plenty of different equivalent execution plans, each with a corresponding execution cost. To produce an effective query plan thus requires examining a large number of alternative plans. Access plan recommendation is an alternative technique to database query optimization, which reuses the previously-generated QEPs to execute new queries. In this technique, the query optimizer uses clustering methods to identify groups of similar queries. However, clustering such large datasets is challenging for traditional clustering algorithms due to huge processing time. Numerous cloud-based platforms have been introduced that offer low-cost solutions for the processing of distributed queries such as Hadoop, Hive, Pig, etc. This paper has applied and tested a model for clustering variant sizes of large query datasets parallelly using MapReduce. The results demonstrate the effectiveness of the parallel implementation of query workloads clustering to achieve good scalability.
Keyword:
Query optimization
Access plan recommendation
Cluster computing
Parallel Processing
MapReduce
DBSCAN Algorithm
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
2.5
论文数:
3.4K
被引数:
6.9K
机构
引用论文
.png){kind=icon}
Mechanism of Development of Arterial Hypertension Associated with the Exchange of Level Vitamin D
OAAI
OAAI分享收藏分享收藏A New Preventive Routing Method Based on Clustering and Location Prediction in the Mobile Internet of Things移动物联网中一种新的基于聚类和位置预测的预防路由方法
PREAI
分享收藏
查看更多内容