Cassandra data modeling is the process of designing tables. This could involve drawing up an entity-relationship diagram, designing tables based on queries, and finally, making optimizations based on the features supported by Cassandra. Ideally, the data model can be split into three levels of abstraction:
- Conceptual data model: A conceptual data model represents a high level view of the data. It is technology agnostic and not specific to Cassandra or any other database system. The purpose of creating a conceptual data model is to understand the data. We get a clear idea of the entities involved and the relationships between different entities. For our case, we will be using the entity relationship model as the conceptual data model.
- Logical data model: A logical data model will act as a bridge between the business case and the final table design. We will use the conceptual model and apply query-driven design rules to get a logical data model.
- Physical data model: A...