Methodology for modeling a column-oriented database with Cassandra
Keywords:Data modeling, NoSQL, column-oriented model, Cassandra, query driven model
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.
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://docs.datastax.com/en/dse/6.7/cql/cql/ddl/dataModelingApproach.html /(consulted on June 2021)
How to Cite
Copyright (c) 2021 Ahmed DOURHRI
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Copyright on any article in the International Journal of Computer Engineering and Data Science (IJCEDS) is retained by the author(s) under the Creative Commons license, which permits unrestricted use, distribution, and reproduction provided the original work is properly cited.
Authors grant IJCEDS a license to publish the article and identify IJCEDS as the original publisher.
Authors also grant any third party the right to use, distribute and reproduce the article in any medium, provided the original work is properly cited.