This is the first Data Modeling lesson in a two-part series. Data modeling is the process of identifying the entities in our domain, the relationships between these entities and how they will be stored in the database.
The main steps of data modeling in Scylla are:
The focus of this lesson is the parts of data modeling that are unique to Scylla (and Apache Cassandra) and not general data modeling. It is assumed that you have some prior data modeling experience.
After this lesson you will be able to:
- Describe the Scylla data model
- Understand what a Keyspace, Table, Column, and Row are
- Explain the differences between a Primary Key, Partition Key, Compound Key, and Clustering Key
- Run a cqlsh and perform basic queries