The Time Machine in Columnar NoSQL Databases: The Case of Apache HBase

Chia Ping Tsai; Che Wei Chang; Hung Chang Hsiao; Haiying Shen

doi:10.3390/fi14030092

The Time Machine in Columnar NoSQL Databases: The Case of Apache HBase

Chia Ping Tsai, Che Wei Chang, Hung Chang Hsiao, Haiying Shen

Department of Computer Science and Information Engineering

Research output: Contribution to journal › Article › peer-review

2 Citations (Scopus)

Abstract

Not Only SQL (NoSQL) is a critical technology that is scalable and provides flexible schemas, thereby complementing existing relational database technologies. Although NoSQL is flourishing, present solutions lack the features required by enterprises for critical missions. In this paper, we explore solutions to the data recovery issue in NoSQL. Data recovery for any database table entails restoring the table to a prior state or replaying (insert/update) operations over the table given a time period in the past. Recovery of NoSQL database tables enables applications such as failure recovery, analysis for historical data, debugging, and auditing. Particularly, our study focuses on columnar NoSQL databases. We propose and evaluate two solutions to address the data recovery problem in columnar NoSQL and implement our solutions based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem widely adopted across industries. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

Original language	English
Article number	92
Journal	Future Internet
Volume	14
Issue number	3
DOIs	https://doi.org/10.3390/fi14030092
Publication status	Published - 2022 Mar

All Science Journal Classification (ASJC) codes

Computer Networks and Communications

Access to Document

10.3390/fi14030092

Cite this

@article{d7c2f2d56f554cbf9947a1e7560a3eb7,

title = "The Time Machine in Columnar NoSQL Databases: The Case of Apache HBase",

abstract = "Not Only SQL (NoSQL) is a critical technology that is scalable and provides flexible schemas, thereby complementing existing relational database technologies. Although NoSQL is flourishing, present solutions lack the features required by enterprises for critical missions. In this paper, we explore solutions to the data recovery issue in NoSQL. Data recovery for any database table entails restoring the table to a prior state or replaying (insert/update) operations over the table given a time period in the past. Recovery of NoSQL database tables enables applications such as failure recovery, analysis for historical data, debugging, and auditing. Particularly, our study focuses on columnar NoSQL databases. We propose and evaluate two solutions to address the data recovery problem in columnar NoSQL and implement our solutions based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem widely adopted across industries. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.",

author = "Tsai, {Chia Ping} and Chang, {Che Wei} and Hsiao, {Hung Chang} and Haiying Shen",

note = "Publisher Copyright: {\textcopyright} 2022 by the authors. Licensee MDPI, Basel, Switzerland.",

year = "2022",

month = mar,

doi = "10.3390/fi14030092",

language = "English",

volume = "14",

journal = "Future Internet",

issn = "1999-5903",

publisher = "Multidisciplinary Digital Publishing Institute (MDPI)",

number = "3",

}

TY - JOUR

T1 - The Time Machine in Columnar NoSQL Databases

T2 - The Case of Apache HBase

AU - Tsai, Chia Ping

AU - Chang, Che Wei

AU - Hsiao, Hung Chang

AU - Shen, Haiying

PY - 2022/3

Y1 - 2022/3

N2 - Not Only SQL (NoSQL) is a critical technology that is scalable and provides flexible schemas, thereby complementing existing relational database technologies. Although NoSQL is flourishing, present solutions lack the features required by enterprises for critical missions. In this paper, we explore solutions to the data recovery issue in NoSQL. Data recovery for any database table entails restoring the table to a prior state or replaying (insert/update) operations over the table given a time period in the past. Recovery of NoSQL database tables enables applications such as failure recovery, analysis for historical data, debugging, and auditing. Particularly, our study focuses on columnar NoSQL databases. We propose and evaluate two solutions to address the data recovery problem in columnar NoSQL and implement our solutions based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem widely adopted across industries. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

AB - Not Only SQL (NoSQL) is a critical technology that is scalable and provides flexible schemas, thereby complementing existing relational database technologies. Although NoSQL is flourishing, present solutions lack the features required by enterprises for critical missions. In this paper, we explore solutions to the data recovery issue in NoSQL. Data recovery for any database table entails restoring the table to a prior state or replaying (insert/update) operations over the table given a time period in the past. Recovery of NoSQL database tables enables applications such as failure recovery, analysis for historical data, debugging, and auditing. Particularly, our study focuses on columnar NoSQL databases. We propose and evaluate two solutions to address the data recovery problem in columnar NoSQL and implement our solutions based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem widely adopted across industries. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

UR - http://www.scopus.com/inward/record.url?scp=85127542111&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85127542111&partnerID=8YFLogxK

U2 - 10.3390/fi14030092

DO - 10.3390/fi14030092

M3 - Article

AN - SCOPUS:85127542111

SN - 1999-5903

VL - 14

JO - Future Internet

JF - Future Internet

IS - 3

M1 - 92

ER -

The Time Machine in Columnar NoSQL Databases: The Case of Apache HBase

Abstract

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this