Learn about the need to plan for sorting data in Cassandra; unlike relational databases, Cassandra does not provide an ORDER BY clause or a functional equivalent.
- [Instructor] In this lesson,…let's walk through an example…of estimating the size of a table…using column storage,…row storage…and index storage formulas.…We'll start with a simple table.…We'll assume that it has four columns,…an ID, which is a uuid,…a device name,…which is a text data type,…an installation year,…which is an integer,…and a serial number,…which is a text data type.…First thing we want to do…is estimate column sizes.…The size of a uuid is 16 bytes.…
The size of an integer is four bytes.…And text can vary.…But we'll assume the average length…of device name is 16 bytes…and the average serial number is 10 bytes.…Next, we want to estimate the column usage.…What percent of rows will actually use that column?…We'll assume that the ID and device name…are in every row.…So their percentage is 100 percent.…We may be missing some installation years,…so let's assume 80 percent there…and serial numbers are often missing…so we'll assume just a 50 percent usage rate.…
Now let's calculate the expected column storage.…This is simply…
- 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.