IMPLEMENTING BI-TEMPORAL PROPERTIES INTO VARIOUS NOSQL DATABASE CATEGORIES

Authors

  • Mohammed Eshtay
  • Azzam Sleit
  • Monther Aldwairi

DOI:

https://doi.org/10.47839/ijc.18.1.1272

Keywords:

NoSQL Databases, Bitemporal Properties, Cassandra, Redis, Column Oriented Stores, Key-value Stores.

Abstract

NoSQL database systems have emerged and developed at an accelerating rate in the last years. Attractive properties such as scalability and performance, which are needed by many applications today, contributed to their increasing popularity. Time is very important aspect in many applications. Many NoSQL database systems do not offer built in management for temporal properties. In this paper, we discuss how we can embed temporal properties in NoSQL databases. We review and differentiate between the most popular NoSQL stores. Moreover, we propose various solutions to modify data models for embedding bitemporal properties in two of the most popular categories of NoSQL databases (Key-value stores and Column stores). In addition, we give examples of how to represent bitemporal properties using Redis Key-value store and Cassandra column oriented store. This work can be used as basis for designing and implementing temporal operators and temporal data management in NoSQL databases.

References

M.D. Monger, R.A. Mata-Toledo, P. Gupta, "Temporal data management in NoSQL databases," Journal of Information Systems & Operations Management, vol. 6, issue 2, pp. 1-7, 2012.

K. Grolinger, W.A. Higashino, A. Tiwari, M.A.M. Capretz, "Data management in cloud environments: NoSQL and NewSQL data stores," Journal of Cloud Computing: Advances, Systems and Applications, vol. 2, issue 1, article no. 49, December 2013.

J. Bhogal, I. Choksi, "Handling big data using NoSQL," Proceedings of the 2015 IEEE 29th International Conference on Advanced Information Networking and Applications Workshops (WAINA), 24-27 March 2015, pp. 393-398.

V.N. Gudivada, D. Rao, V.V. Raghavan, "NoSQL systems for big data management," Proceedings of the 2014 IEEE World Congress on Services (SERVICES), 2014, pp. 190-197.

K. Kaur, R. Rani, "Modeling and querying data in NoSQL databases," Proceedings of the 2013 IEEE International Conference on Big Data, 6-9 October 2013, pp. 1-7.

F. Chang, J. Dean, S. Ghemawat et al., "Bigtable: A distributed storage system for structured data," ACM Transactions on Computer Systems (TOCS), vol. 26, issue 2, article no. 4, 2008.

G. DeCandia, et al., "Dynamo: amazon's highly available Key-value store," ACM SIGOPS Operating Systems Review, vol. 41, issue 6, pp. 205-220, 2007.

G. Harrison, "Sharding, Amazon, and the Birth of NoSQL," in Next Generation Databases, Springer, pp. 39-51, 2015.

P. Atzeni, F. Bugiotti, L. Rossi, "Uniform access to non-relational database systems: The SOS platform," Proceedings of the International Conference on Advanced Information Systems Engineering, 2012, pp. 160-174.

N.Q. Mehmood, R. Culmone, L. Mostarda, "Modeling temporal aspects of sensor data for MongoDB NoSQL database," Journal of Big Data, vol. 4, issue 8, pp. 1-35, 2017.

C.J. Tauro, S. Aravindh, A. Shreeharsha, "Comparative study of the new generation, agile, scalable, high performance NOSQL databases," International Journal of Computer Applications, vol. 48, issue 20, pp. 1-4, 2012.

A. Moniruzzaman, S.A. Hossain, "Nosql database: New era of databases for big data analytics-classification, characteristics and comparison," arXiv preprint arXiv:1307.0191, 2013.

J. Pokorny, "NoSQL databases: a step to database scalability in web environment," International Journal of Web Information Systems, vol. 9, issue 1, pp. 69-82, 2013.

A. Auradkar, et al., "Data infrastructure at LinkedIn," Proceedings of the IEEE 28th International Conference on Data Engineering (ICDE'2012), 2012, pp. 1370-1381.

Redis. [Online]. Available at: https://redis.io.

Riak Products. [Online]. Available at: http://basho.com/products/.

R. Hecht, S. Jablonski, "NoSQL evaluation: A use case oriented survey," Proceedings of the 2011 IEEE International Conference on Cloud and Service Computing (CSC), 12-14 December 2011, vol. 1, pp. 336-341.

Apache HBase, [Online]. Available at: https://hbase.apache.org.

G. Wang, J. Tang, "The nosql principles and basic application of cassandra model," Proceedings of the IEEE 2012 International Conference on Computer Science & Service System (CSSS), 2012, pp. 1332-1335.

Apache Accumulo, [Online]. Available at: https://accumulo.apache.org.

K. Banker, MongoDB in Action, Manning Publications Co., 2011.

J. C. Anderson, N. Slater, J. Lehnardt, CouchDB: The Definitive Guide, (1st ed.), O'Reilly Media, 2009, p. 300.

A. Cuzzocrea, "Temporal aspects of big data management: state-of-the-art analysis and future research directions," Proceedings of the 2015 22nd IEEE International Symposium on Temporal Representation and Reasoning (TIME), 23-25 September 2015, pp. 180-185.

A. Cuzzocrea, I.-Y. Song, "Big graph analytics: The state of the art and future research agenda," Proceedings of the 17th ACM International Workshop on Data Warehousing and OLAP (DOLAP'14), 7 November 2014, pp. 99-101.

F. Bugiotti, et al., "Database design for NoSQL systems," Proceedings of the International Conference on Conceptual Modeling, 2014, pp. 223-231.

Y. Hu, S. Dessloch, "Defining temporal operators for column oriented NoSQL databases," Proceedings of the East European Conference on Advances in Databases and Information Systems (ADBIS'2014), 2014, pp. 39-55.

MarkLogic, Best Database For Integrating Data From Silos. [Online]. Available at: www.marklogic.com.

J. Han, et al., "Survey on NoSQL database," Proceedings of the 6th International Conference on Pervasive Computing and Applications (ICPCA'2011), 26-28 October 2011, pp. 363-366.

Downloads

Published

2019-03-31

How to Cite

Eshtay, M., Sleit, A., & Aldwairi, M. (2019). IMPLEMENTING BI-TEMPORAL PROPERTIES INTO VARIOUS NOSQL DATABASE CATEGORIES. International Journal of Computing, 18(1), 45-52. https://doi.org/10.47839/ijc.18.1.1272

Issue

Section

Articles