/awesome-database-learning

A list of learning materials to understand databases internals

Awesome Database Learning

A list of learning materials to understand databases internals, including but not limited to:

  • papers
  • blogs
  • courses
  • talks

Please submit a pull request if there is any material that you think should be included in this collection.

Table of Contents

Recommended Courses, Books and Talks

Courses

Books

Talks

SQL & Relation Algebra

Courses:

Query Optimizer

Blogs:

Planner Models

Blogs:

Papers:

Subquery Optimization

Blogs:

Papers:

Join Order Optimization

Papers:

Functional Dependency & Physical Properties

Thesis:

Papers:

Cost Model

Papers:

Statistics

Papers:

Books:

Query Execution

Execution Framework

Papers:

Vectorization vs Compilization

Blogs:

Papers:

Join

Papers:

Hash Table

Blogs:

DDL

Transaction

Isolation Levels

Blogs:

Papers:

Concurrency Control

Courses:

Papers:

Network

Courses:

Papers:

Storage

Buffer Management

Courses:

Papers:

Disk IO

Blogs:

Papers:

B-Tree

Courses:

Papers:

LSM-Tree

Papers:

Serializing & RPC

Data Partitioning

Blogs:

Papers:

Replication & Consistency

Blogs:

Papers:

Consensus

Technical report:

  • University of Cambridge Distributed consensus revised, a great paper about Consenssus especially Paxos and Paxos-Related algorithms, by Heidi Howard

Papers:

Scale & Balance

Blogs:

Benchmark & Testing

Blogs: