Review best practices, including denormalizing, modeling based on queries, understanding replication strategies, planning for sort order, and understanding consistency policies.
- [Tutor] Let's summarize this overview…of Cassandra data modeling by reviewing five best practices…for designing for Cassandra.…First, your model is driven by queries.…We should focus on the queries that our application needs…and then design tables around those queries.…Now this may lead to a number of tables…that are specialized for a small number of queries -…that's not a problem.…De-normalizing is a common design technique in Cassandra…and other NoSQL databases.…It helps to compensate for not having joins…and improves overall read and write performance.…
Be sure to consider the sort order of data.…The CQL SELECT statement does not have…an ORDER BY CLAUSE,…so your data is returned in the order…that it is stored in the table.…An ORDER BY CLAUSE can be specified when you create a table,…but not when you query one.…If you're using Cassandra 3,…you may want to use materialized views…to maintain multiple tables with common data…but different sort orders.…Remember, there is some performance penalty…for using materialized views.…
- Cassandra architecture
- Keyspaces, tables, and columns
- Installing Java and Cassandra
- CQL data types
- Designing Cassandra tables
- Tuning tables to optimize queries
- When to use secondary indexes and materialized views
- Physical data modeling and distributing data
- Cassandra architecture and its impact on data modeling
Skill Level Intermediate
1. Cassandra Architecture
2. Cassandra Query Language Data Types
3. Designing Cassandra Tables
4. Physical Data Modeling and Distributing Data
Replication in Cassandra2m 1s
5. Cassandra Architecture and Its Impact on Data Modeling
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.