The time machine in NoSQL

Chia Ping Tsai, Hung-Chang Hsiao, Yu Chang Chao, Cheng Lung Chu, Yeh Ching Chung

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Not Only SQL (NoSQL) is a recent 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. In this paper, we firstly present two solutions to address the data recovery problem in NoSQL; each solution has its pros and cons. We implement our proposals based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

Original languageEnglish
Title of host publicationIntelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014
EditorsWilliam Cheng-Chung Chu, Stephen Jenn-Hwa Yang, Han-Chieh Chao
PublisherIOS Press
Pages1317-1326
Number of pages10
ISBN (Electronic)9781614994831
DOIs
Publication statusPublished - 2015 Jan 1
EventInternational Computer Symposium, ICS 2014 - Taichung, Taiwan
Duration: 2014 Dec 122014 Dec 14

Publication series

NameFrontiers in Artificial Intelligence and Applications
Volume274
ISSN (Print)0922-6389

Other

OtherInternational Computer Symposium, ICS 2014
CountryTaiwan
CityTaichung
Period14-12-1214-12-14

Fingerprint

Recovery
Ecosystems
Industry

All Science Journal Classification (ASJC) codes

  • Artificial Intelligence

Cite this

Tsai, C. P., Hsiao, H-C., Chao, Y. C., Chu, C. L., & Chung, Y. C. (2015). The time machine in NoSQL. In W. C-C. Chu, S. J-H. Yang, & H-C. Chao (Eds.), Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014 (pp. 1317-1326). (Frontiers in Artificial Intelligence and Applications; Vol. 274). IOS Press. https://doi.org/10.3233/978-1-61499-484-8-1317
Tsai, Chia Ping ; Hsiao, Hung-Chang ; Chao, Yu Chang ; Chu, Cheng Lung ; Chung, Yeh Ching. / The time machine in NoSQL. Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014. editor / William Cheng-Chung Chu ; Stephen Jenn-Hwa Yang ; Han-Chieh Chao. IOS Press, 2015. pp. 1317-1326 (Frontiers in Artificial Intelligence and Applications).
@inproceedings{c6ba93763587455d897c02545107c224,
title = "The time machine in NoSQL",
abstract = "Not Only SQL (NoSQL) is a recent 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. In this paper, we firstly present two solutions to address the data recovery problem in NoSQL; each solution has its pros and cons. We implement our proposals based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.",
author = "Tsai, {Chia Ping} and Hung-Chang Hsiao and Chao, {Yu Chang} and Chu, {Cheng Lung} and Chung, {Yeh Ching}",
year = "2015",
month = "1",
day = "1",
doi = "10.3233/978-1-61499-484-8-1317",
language = "English",
series = "Frontiers in Artificial Intelligence and Applications",
publisher = "IOS Press",
pages = "1317--1326",
editor = "Chu, {William Cheng-Chung} and Yang, {Stephen Jenn-Hwa} and Han-Chieh Chao",
booktitle = "Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014",
address = "Netherlands",

}

Tsai, CP, Hsiao, H-C, Chao, YC, Chu, CL & Chung, YC 2015, The time machine in NoSQL. in WC-C Chu, SJ-H Yang & H-C Chao (eds), Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014. Frontiers in Artificial Intelligence and Applications, vol. 274, IOS Press, pp. 1317-1326, International Computer Symposium, ICS 2014, Taichung, Taiwan, 14-12-12. https://doi.org/10.3233/978-1-61499-484-8-1317

The time machine in NoSQL. / Tsai, Chia Ping; Hsiao, Hung-Chang; Chao, Yu Chang; Chu, Cheng Lung; Chung, Yeh Ching.

Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014. ed. / William Cheng-Chung Chu; Stephen Jenn-Hwa Yang; Han-Chieh Chao. IOS Press, 2015. p. 1317-1326 (Frontiers in Artificial Intelligence and Applications; Vol. 274).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - The time machine in NoSQL

AU - Tsai, Chia Ping

AU - Hsiao, Hung-Chang

AU - Chao, Yu Chang

AU - Chu, Cheng Lung

AU - Chung, Yeh Ching

PY - 2015/1/1

Y1 - 2015/1/1

N2 - Not Only SQL (NoSQL) is a recent 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. In this paper, we firstly present two solutions to address the data recovery problem in NoSQL; each solution has its pros and cons. We implement our proposals based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

AB - Not Only SQL (NoSQL) is a recent 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. In this paper, we firstly present two solutions to address the data recovery problem in NoSQL; each solution has its pros and cons. We implement our proposals based on Apache HBase, a popular NoSQL database in the Hadoop ecosystem. Our implementations are extensively benchmarked with an industrial NoSQL benchmark under real environments.

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

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

U2 - 10.3233/978-1-61499-484-8-1317

DO - 10.3233/978-1-61499-484-8-1317

M3 - Conference contribution

T3 - Frontiers in Artificial Intelligence and Applications

SP - 1317

EP - 1326

BT - Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014

A2 - Chu, William Cheng-Chung

A2 - Yang, Stephen Jenn-Hwa

A2 - Chao, Han-Chieh

PB - IOS Press

ER -

Tsai CP, Hsiao H-C, Chao YC, Chu CL, Chung YC. The time machine in NoSQL. In Chu WC-C, Yang SJ-H, Chao H-C, editors, Intelligent Systems and Applications - Proceedings of the International Computer Symposium, ICS 2014. IOS Press. 2015. p. 1317-1326. (Frontiers in Artificial Intelligence and Applications). https://doi.org/10.3233/978-1-61499-484-8-1317