Indexing Techniques of Distributed Ordered Tables: A Survey and Analysis

doi:10.1007/s11390-018-1813-8

	Indexing Techniques of Distributed Ordered Tables: A Survey and Analysis
	Feng, Chen 1,2; Li, Chun-Dian 1,2; Li, Rui 3
	2018
发表期刊	JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY
ISSN	1000-9000
卷号	33 期号:1 页码:169-189
摘要	Many NoSQL (Not Only SQL) databases were proposed to store and query on a huge amount of data. Some of them like BigTable, PNUTS, and HBase, can be modeled as distributed ordered tables (DOTs). Many additional indexing techniques have been presented to support queries on non-key columns for DOTs. However, there was no comprehensive analysis or comparison of these techniques, which brings troubles to users in selecting or proposing a proper indexing technique for a certain workload. This paper proposes a taxonomy based on six indexing issues to classify indexing techniques on DOTs and provides a comprehensive review of the state-of-the-art techniques. Based on the taxonomy, we propose a performance model named QSModel to estimate the query time and storage cost of these techniques and run experiments on a practical workload from Tencent to evaluate this model. The results show that the maximum error rates of the query time and storage cost are 24.2% and 9.8%, respectively. Furthermore, we propose IndexComparator, an open source project that implements representative indexing techniques. Therefore, users can select the best-fit indexing technique based on both theoretical analysis and practical experiments.
关键词	database Not Only SQL (NoSQL) range query indexing
DOI	10.1007/s11390-018-1813-8
收录类别	SCI
语种	英语
资助项目	Strategic Priority Program of Chinese Academy of Sciences[XDB02040009] ; Key Program of the National Natural Science Foundation of China[61532016] ; Key Program of Cloud Computing and Big Data of the Ministry of the Science and Technology of China[2016YFB1000200] ; Tencent Inc.
WOS研究方向	Computer Science
WOS类目	Computer Science, Hardware & Architecture ; Computer Science, Software Engineering
WOS记录号	WOS:000423587100011
出版者	SCIENCE PRESS
引用统计	被引频次：2[WOS] [WOS记录] [WOS相关记录]
文献类型	期刊论文
条目标识符	http://119.78.100.204/handle/2XEOYT63/5584
专题	中国科学院计算技术研究所期刊论文_英文
通讯作者	Feng, Chen
作者单位	1.Chinese Acad Sci, Inst Comp Technol, State Key Lab Comp Architecture, Beijing 100190, Peoples R China 2.Univ Chinese Acad Sci, Beijing 100049, Peoples R China 3.Tencent Inc, Beijing 100080, Peoples R China
推荐引用方式 GB/T 7714	Feng, Chen,Li, Chun-Dian,Li, Rui. Indexing Techniques of Distributed Ordered Tables: A Survey and Analysis[J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY,2018,33(1):169-189.
APA	Feng, Chen,Li, Chun-Dian,&Li, Rui.(2018).Indexing Techniques of Distributed Ordered Tables: A Survey and Analysis.JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY,33(1),169-189.
MLA	Feng, Chen,et al."Indexing Techniques of Distributed Ordered Tables: A Survey and Analysis".JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY 33.1(2018):169-189.