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

[1]
A. DOURHRI, M. HANINE, and H. . OUAHMANE, “Methodology for modeling a column-oriented database with Cassandra”, IJCEDS, vol. 1, no. 1, pp. 14–21, Jul. 2021.

Issue

Vol. 1 No. 1 (2021): Volume 1. Issue 1

Section

Articles

ARK

https://n2t.net/ark:/32155/IJCEDS.v1i1.16

License

Copyright (c) 2021 Ahmed DOURHRI

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Copyright on any article published in the International Journal of Computer Engineering and Data Science (IJCEDS) is retained by the author(s). All articles are published under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (CC BY-NC 4.0), which permits any non-commercial use, distribution, and reproduction in any medium, provided that the original work is properly cited.

License Agreement

By submitting and publishing their work in IJCEDS, the authors:

  • Grant IJCEDS the non-exclusive right to publish the article and to identify IJCEDS as the original publisher.

  • Authorize any third party to use, share, and reproduce the article for non-commercial purposes, provided that appropriate credit is given to the original authors and source, and a link to the license is included.