NoSQL’s biggest secret SQL never went away
summary
Covers how non-relational databases are reintroducing SQL-like query languages to balance scale, speed and availability with rich querying. Traces the evolution from key-value stores through JSON-focused languages like Jsoniq, academic proposals such as SQL++, and practical implementations in projects including Cassandra and Couchbase.
AI-written summary · about
chapters (23)
- 0:00Start
- 1:47A cruster of toasters
- 3:221960: the first commercial database
- 3:55Hierarchical
- 5:26Network
- 6:00Relational (with SOL)
- 6:55Object oriented databases
- 8:29Key value
- 10:38Column and graph
- 11:34There's always a trade-off
- 13:20Manual 21
- 14:56Map/Reduce
- 16:07MongoDB query
- 20:10Cassandra's COL
- 26:25SELECT
- 27:07ARRAY ELEMENTS
- 27:43REMOVE MISSING ITEMS
- 28:44Updating and deleting
- 29:27TRAVEL SAMPLE DATA
- 30:38A SIMPLE JOIN
- 33:23Query Types
- 34:24Simple Query
- 36:32Coordinated Fallback
related talks
56mNewSQL: SQL Is Here to Stay
44mNonrelational SQL
45mDemystifying NoSQL: The SQL developer's guide
31mSQL to NoSQL to NewSQL and the rise of polyglot persistence Paul Dix
45mMore Than a Query Language: SQL in the 21st Century
58mThe Mother of All Query Languages: SQL in the 21st Century
46mMore Than a Query Language: SQL in the 21st Century
43mThe State of NoSQL in 2021