All Topics
OLTP vs OLAP
Why transactional (OLTP) and analytical (OLAP) databases are built so differently, from row versus column storage to how each runs queries.
Data Stores
Videos (2)
Podcasts (1)
Slide decks (1)
Infographics (1)
Sources (26)
- web page Architecture of SQLite
- web page Arrow Columnar Format — Apache Arrow v26.0.1
- web page Concepts | Parquet
- web page Distinctive Features of ClickHouse - ClickHouse Documentation
- web page PostgreSQL: Documentation: 18: 11.2. Index Types
- web page PostgreSQL: Documentation: 18: 11.9. Index-Only Scans and Covering Indexes
- web page PostgreSQL: Documentation: 18: 13.2. Transaction Isolation
- web page PostgreSQL: Documentation: 18: 14.1. Using EXPLAIN
- web page PostgreSQL: Documentation: 18: 24.1. Routine Vacuuming
- web page PostgreSQL: Documentation: 18: 28.3. Write-Ahead Logging (WAL)
- web page PostgreSQL: Documentation: 18: 5.12. Table Partitioning
- web page PostgreSQL: Documentation: 18: 65.1. B-Tree Indexes
- web page PostgreSQL: Documentation: 18: 65.4. GIN Indexes
- web page PostgreSQL: Documentation: 18: 65.5. BRIN Indexes
- web page PostgreSQL: Documentation: 18: 66.6. Database Page Layout
- web page PostgreSQL: Documentation: 18: 8.14. JSON Types
- web page PostgreSQL: Documentation: 18: Chapter 13. Concurrency Control
- web page The Balanced Search Tree (B-Tree) in SQL Databases
- web page The Leaf Nodes of an SQL Index
- web page Why DuckDB – DuckDB
- pdf P19
- web page https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/mergetree
- web page https://clickhouse.com/docs/en/optimize/sparse-primary-indexes
- web page https://www.allthingsdistributed.com/files/amazon-aurora-p1041-verbitski.pdf
- web page https://www.cs.umb.edu/~poneil/ColStore.pdf
- pdf lsmtree