Learn about the role of primary keys and partitions to the physical layout of data. Learn about the limitations of secondary indexes.
- [Instructor] An important consideration in data modeling…is selecting the appropriate primary key.…The key will uniquely identify a row,…but it will also limit how we can retrieve rows.…We'll need to carefully consider the implications…of our primary key choice.…For example, we'll assume that the process ID and host ID…uniquely identify an application instance.…In this example, we list three text attributes…followed by three int, or integer attributes.…The text attributes are application name,…process ID, and host ID.…
The integer attributes store data…on operating system priority, CPU time,…and the number of IO operations.…You'll notice the first attribute…in the primary key is host ID.…This is because the first attribute specified…in the primary key list is used as the partition key,…which determines which node the row is stored on.…The rest of the primary key is used as the clustering key,…which determines how data is ordered on the disk.…
We need to choose our primary keys carefully…because they are used to retrieve data…
- 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.