Welcome to the InfoSci Platform
Reference Hub12
Temporal Data Management and Processing with Column Oriented NoSQL Databases

Temporal Data Management and Processing with Column Oriented NoSQL Databases

Yong Hu, Stefan Dessloch
Copyright: © 2015 |Volume: 26 |Issue: 3 |Pages: 30
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781466675513|DOI: 10.4018/JDM.2015070103
Cite Article Cite Article

MLA

Hu, Yong, and Stefan Dessloch. "Temporal Data Management and Processing with Column Oriented NoSQL Databases." JDM vol.26, no.3 2015: pp.41-70. http://doi.org/10.4018/JDM.2015070103

APA

Hu, Y. & Dessloch, S. (2015). Temporal Data Management and Processing with Column Oriented NoSQL Databases. Journal of Database Management (JDM), 26(3), 41-70. http://doi.org/10.4018/JDM.2015070103

Chicago

Hu, Yong, and Stefan Dessloch. "Temporal Data Management and Processing with Column Oriented NoSQL Databases," Journal of Database Management (JDM) 26, no.3: 41-70. http://doi.org/10.4018/JDM.2015070103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This article introduces how temporal data can be maintained and processed by utilizing Column-oriented NoSQL databases (CoNoSQLDBs). Although each column in a CoNoSQLDB can store multiple data versions with their corresponded timestamps, its implicit temporal interval representation can cause wrong or misleading results during temporal query processing. In consequence, the original table representation supported by CoNoSQLDBs is not suitable for storing temporal data. To maintain the temporal data in the CoNoSQLDB tables, two alternative table representations can be adopted, namely, explicit history representation (EHR) and tuple time-stamping representation (TTR) in which each tuple (data version) has an explicit temporal interval. For processing TTR, the temporal relational algebra is extended to TTRO operator model with minor modifications. For processing EHR, a novel temporal operator model called CTO is proposed. Both TTRO and CTO contain eight temporal data operators, namely, Union, Difference, Intersection, Project, Filter, Cartesian product, Theta-Join and Group by with a set of aggregation functions, such as SUM, AVG, MAX and etc. Moreover, the authors implement each temporal operator by utilizing MapReduce framework to indicate which temporal operator model is more suitable for temporal data processing in the context of CoNoSQLDBs.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.