How deeply does ScyllaDB in Action cover composite key?

Explains key order, partition selection, query consequences, and a CQL definition, but does not detail internal hashing.

Composite key

As explained in ScyllaDB in Action

A composite primary key is a primary key formed from multiple columns whose combined values identify a row.

A composite primary key combines multiple columns to identify a row. In ScyllaDB, its first component becomes the partition key, while additional components help organize rows within that partition. section 3.3.2

Choose the columns by tracing the queries the table must support:

Put the query’s grouping value first so related rows share a partition instead of forcing a cross-partition query. section 3.3.2

Restaurant reviews

A review table can define PRIMARY KEY (restaurant, ordered_at, food). This groups reviews by restaurant and orders them by timestamp and food within each restaurant partition.

How ScyllaDB in Action covers it

liveBook manning.com

Read ScyllaDB in Action on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

100 SQL Server Mistakes and How to Avoid ThemA composite key is a key whose identity is formed from multiple columns.
liveBook manning.com

The Well-Grounded Data AnalystA composite primary key is a record key whose uniqueness is determined by a combination of multiple columns.
liveBook manning.com

Kafka Streams in Action, Second EditionA composite key is a record or row identifier formed from multiple fields.
liveBook manning.com

Java Persistence with Spring Data and Hibernate epubA key formed from multiple attributes or columns that jointly identify a persistent entity or relational row.
liveBook manning.com

The Art of CodeA composite key is a key formed from multiple values that together identify an item or entry.
liveBook manning.com

Building Web APIs with ASP.NET CoreA composite primary key is a primary key formed from multiple columns whose combined values uniquely identify a record.
liveBook manning.com

PostgreSQL Mistakes and How to Avoid ThemA composite unique key is a uniqueness rule defined over multiple columns whose combined values identify a row combination.

Compare how 8 books explain composite key →

Related concepts

primary keykind of · A primary key is a designated column or attribute, or combination of them, that uniquely identifies each row or item in a table or data store.
dependent entityused by · A dependent entity is an entity whose identification or existence depends on a related owner entity and cannot be fully determined independently.
surrogate keyalternative to · A surrogate key is an artificially assigned, domain-independent identifier used to uniquely identify a database record independently of its business attributes.
keykind of · A key is an identifier or value used to locate or access an associated entry or property in a keyed data structure.
database tablepart of · A database table is a relational database structure that organizes records into rows and defined columns.
k-d treeused by · A k-d tree is a binary space-partitioning tree that organizes points in multidimensional space by recursively comparing coordinate dimensions.

This explainer was generated by Manning's knowledge graph from the text of ScyllaDB in Action. The section links point to the parts of the book it draws on.