arrow
返回

Smart Intra-query Fault Tolerance for Massive Parallel Processing Databases

delete2019-12-19
delete13
delete
OA
AI
Y
Yunhong Ji *
柴云鹏 封面图
柴云鹏 (Yunpeng Chai)
X
Xuan Zhou
L
Lipeng Ren
Y
Yajie Qin
DOI:10.1007/s41019-019-00114-zdelete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
Intra-query fault tolerance has increasingly been a concern for online analytical processing, as more and more enterprises migrate data analytical systems from mainframes to commodity computers. Most massive parallel processing (MPP) databases do not support intra-query fault tolerance. They may suffer from prolonged query latency when running on unreliable commodity clusters. While SQL-on-Hadoop systems can utilize the fault tolerance support of low-level frameworks, such as MapReduce and Spark, their cost-effectiveness is not always acceptable. In this paper, we propose a smart intra-query fault tolerance (SIFT) mechanism for MPP databases. SIFT achieves fault tolerance by performing checkpointing, i.e., materializing intermediate results of selected operators. Different from existing approaches, SIFT aims at promoting query success rate within a given time. To achieve its goal, it needs to: (1) minimize query rerunning time after encountering failures and (2) introduce as less checkpointing overhead as possible. To evaluate SIFT in real-world MPP database systems, we implemented it in Greenplum. The experimental results indicate that it can improve success rate of query processing effectively, especially when working with unreliable hardware.
Keyword:
Intra-query fault tolerance
Fault tolerance
Pipeline
Massive parallel processing databases
AI总结

AI总结

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

期刊

D
Data Science and Engineering
IF:
4.6
论文数:
249
被引数:
665

机构

E
east china normal university
学者数:
3.1W
论文数: 2.1W
被引数: 25
R
Renmin University of China
学者数:
8.1K
论文数: 7.7K
被引数: 1.1W
引用论文

引用论文

err分享
err收藏
New software for comparing the color gamuts generated by printing technologies
err2022-07-01
err0
errOAAI
errAna Belén López-Baldomero; Manuel Rubiño; Carolina Ortiz; Carlos Salas
err分享
err收藏
err
IF0
err
err0
PREAI
err
err分享
err收藏
Preliminary Development of the Climate and Racial Justice Scale
err2024-10-01
err0
PREAI
errRegina M. Musicaro; McKenna Parnes; Sarah R. Lowe; Susan Clayton; Cheryl Holder; Sarah E. O. Schwartz
err分享
err收藏
Regulation of Exosomes in the Pathogenesis of Breast Cancer
err2021-12-22
err0
errOAAI
errCongjian Shi; Hongqin Yang; Zhengchao Wang; Zhenghong Zhang
err分享
err收藏
Prenatally detected double trisomy: Klinefelter and Down syndrome
err2006-09-07
err0
PREAI
errM. Sanz-Cortés; F. Raga; A. Cuesta; R. Claramunt; F. Bonilla-Musoles
err分享
err收藏
学者 查看更多内容