0%

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.

Prerequisites

  • 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

Table of Contents

  1. Data Modeling
    1. Conceptual Data Modeling
    2. RDBMS Design
      1. Design Differences Between RDBMS and Cassandra
    3. Defining Application Queries
    4. Logical Data Modeling
      1. Hotel Logical Data Model
      2. Reservation Logical Data Model
    5. Physical Data Modeling
      1. Hotel Physical Data Model
      2. Reservation Physical Data Model
      3. Materialized Views
    6. Evaluating and Refining
      1. Calculating Partition Size
      2. Calculating Size on Disk
      3. Breaking Up Large Partitions
    7. Defining Database Schema
      1. DataStax DevCenter
    8. Summary
3.22.249.158