Dallas, TX: Apache Cassandra — Data Modeling
Date(s) - June 26, 2014 - June 27, 2014
Time -
All Day

1. Introducing the Cassandra Data Modeling Framework

1.1. Introductions

1.2. Understand the data modeling framework

Exercise 1. Setting up the lab environment

2. Review of the Cassandra Data Model and CQL

2.1. Review column families and tables

2.2. Review CQL Data Definition Language

2.3. Review CQL querying capabilities

Exercise 2. Creating, populating, and querying a database

3. Conceptual Data Modeling

3.1. Overview conceptual data modeling techniques

3.2. Understand entity-relationship model

Exercise 3. Designing and documenting a conceptual data model with ERDs

4. Logical Data Modeling

4.1. Introduce Column Family Diagrams

4.2. Understand Cassandra data modeling principles

4.3. Introduce query-driven data modeling methodology

4.4. Master mapping rules

4.5. Master mapping patterns

Exercise 4. Designing and documenting a logical data model with CFDs

5. Analysis and Validation of Logical Design

5.1. Overview a logical design analysis

5.2. Understand partition size limitations

5.3. Understand the cost of data redundancy and data consistency

5.4. Understand the cost of application-side joins and referential integrity constraints

5.5. Describe considerations for transactions and data aggregates

Exercise 5. Analyzing a logical data model

6. Physical Data Modeling and Optimization Techniques

6.1. Describe key design techniques

6.2. Describe table design optimizations

6.3. Understand secondary index use cases

6.4. Understand techniques for concurrent access to data

Exercise 6. Designing and documenting a physical data model with CFDs

7. Selected Use Cases

7.1. Describe Cassandra use cases

7.2. Model sensor data

7.3. Model messaging data

Exercise 7. Defining and exploring your use case