Learn how to diagram physical models in Cassandra.
- [Narrator] We designed Cassandra…Tables to answer specific queries.…Now, ideally, our tables can be…used to answer multiple queries.…Sometimes this falls out naturally.…For example, using this devices table we…can answer queries about devices and their…I.P addresses, as well as queries about…devices and their installation date.…Now lets modify this table to include…the name of the server manufacturer.…Now we have a table that has information about…devices, location, installation date, and manufacturer.…
The tables uses installation year as a partition key,…so that determines which node stores the data.…It uses installation date and ID as a clustering key.…We can look up rows in the table using the primary key.…If we want to select results by manufacturer name,…we can't do it with this table definition.…We could create another table and cluster the…manufacturer with this command.…This solution solves the selecting problem,…but duplicates the data that we had in the devices table.…
Now this kind of data duplication is a common…
- 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.