Methodology for modeling a column-oriented database with Cassandra

Authors

  • Ahmed DOURHRI LTI laboratory, ENSA, Chouaib Doukkali University, El Jadida 1166, Morocco
  • Mohamed HANINE LTI laboratory, ENSA, Chouaib Doukkali University, El Jadida 1166, Morocco
  • Hassan OUAHMANE LTI laboratory, ENSA, Chouaib Doukkali University, El Jadida 1166, Morocco

Keywords:

Data modeling, NoSQL, column-oriented model, Cassandra, query driven model

Abstract

Cassandra data model is based on a dynamic schema, with a column-oriented data model. This means that, unlike a relational database, it is not necessary to model all the columns since a row potentially does not have the same set of columns. Columns and their metadata can be added by the application when needed. On the other hand, although the tables of a Cassandra database can be flexible, in practice, it is advisable to associate some kind of schema. This paper aims to explain a methodology for developing the physical model of a column-oriented database from the data circulating in an information system, a model also driven by the queries.

Downloads

Download data is not yet available.

References

Mason, R. T., ‘NoSQL databases and data modeling techniques for a document-oriented NoSQL database’. 2015, Proceedings of Informing Science & IT Education Conference (InSITE)

Mukherjee S., University of the Cumberlands Chicago, United States , The battle between NoSQL Databases and RDBMS’. 2019, Available at SSRN 3393986

Hanine M., Benderrag A., Boutkhoum O., ‘Data Migration Methodology from Relational to NoSQL Databases’. 2015, World Academy of Science, Engineering and Technology International Journal of Computer, Electrical, Automation, Control and Information Engineering, Vol:9, No:12

Chebotko A., Kashlev A., Lu S., ‘A Big Data Modeling Methodology for Apache Cassandra’. 2015, IEEE International Congress on Big Data

Sam R. Alapati, ‘Introduction to the Cassandra Query Language’, In book: Expert Apache Cassandra Administration (pp.189-247), January 2018

Lemahieu W., Vanden B. S., Baesens B., ‘Relational Databases: Structured Query Language (SQL)’, In book: Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data (pp.146-206), 2019/08/01

https://www.upsti.fr/espace-etudiants/annales-de-concours/topics/ipt-modelisation-de-la-propagation-d-une-epidemie consulted on June 2021)

https://docs.datastax.com/en/dse/6.7/cql/cql/ddl/dataModelingApproach.html /(consulted on June 2021)

Downloads

Published

2021-07-20

How to Cite

DOURHRI, A., HANINE, M., & OUAHMANE, H. . (2021). Methodology for modeling a column-oriented database with Cassandra. International Journal of Computer Engineering and Data Science (IJCEDS), 1(1), 14–21. Retrieved from http://ijceds.com/ijceds/article/view/16

Issue

Section

Articles