Data modeling with Cassandra

Book description

In this lesson, you’ll learn how to design data models for Cassandra, including a data modeling process and notation. To apply this knowledge, we’ll design the data model for a sample application. This will help show how all the parts fit together. Along the way, we’ll use a tool to help us manage our CQL (Cassandra Query Language) scripts.

What you’ll learn—and how you can apply it

You will learn common patterns and antipatterns for data modeling in Cassandra. This lesson will cover the concepts around data modeling and will compare a Cassandra data model with an equivalent relational database model. You’ll learn about defining queries and about logical and physical database modeling. You’ll learn how to optimize your model for performance, and finally you’ll learn how to implement your model schema using CQL.

This lesson is for you because…

  • You are an application developer or architect who wants to learn how data is stored and processed in Cassandra.
  • You are a database administrator who wants to learn about Cassandra.


  • Helpful but not essential to have a basic understanding of relational vs. distributed databases.
  • Helpful but not essential to understand Cassandra Query Language, CQL.

Materials or downloads needed in advance

  • None

Publisher resources

View/Submit Errata

Product information

  • Title: Data modeling with Cassandra
  • Author(s): Jeff Carpenter, Eben Hewitt
  • Release date: December 2016
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9781491979716