awesome-database-learning
github.com/pingcap/awesome-database-learning ↗A list of learning materials to understand databases internals
11k
GitHub Stars
191
Curated Resources
17
Categories
15 hours ago
Last Refreshed
Recommended Courses, Books and TalksSQL & Relation AlgebraQuery OptimizerQuery ExecutionDDLRelational ModelTransactionNetworkStorageSerializing & RPCData PartitioningReplication & ConsistencyConsensusSchedulingBenchmark & TestingHTAPTLA+
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me planner models resources from awesome-database-learning"
Installation instructions →What's inside
Network
Query Optimizer
- Access Path Selection in a Relational Database Management SystemPlanner Models
- Accurate Estimation of the Number of Tuples Satisfying a ConditionStatistics
- Adaptive Optimization of Very Large Join QueriesJoin Order Optimization
- Adaptive Statistics in Oracle 12cStatistics
- Analysis of Two Existing and One New Dynamic Programming Algorithm for the Generation of Optimal Bushy Join Trees without Cross ProductsJoin Order Optimization
- An Efficient Framework for Order OptimizationFunctional Dependency & Physical Properties
Storage
- A Comparison of Fractal Trees to Log-Structured Merge (LSM) TreesLSM-Tree
- Advanced Database Systems (15-721)B-Tree
- Bigtable: A Distributed Storage System for Structured DataNoSQL Systems
- Buffer PoolsBuffer Management
- B树、B+树索引算法原理（上）B-Tree
- B树、B+树索引算法原理（下）B-Tree
Transaction
- A Critique of ANSI SQL Isolation LevelsIsolation Levels
- An Empirical Evaluation of In-Memory Multi-Version Concurrency ControlConcurrency Control
- An Evaluation of Distributed Concurrency ControlConcurrency Control
- An Evaluation of the Advantages and Disadvantages of Deterministic Database SystemsConcurrency Control
- Calvin: Fast Distributed Transactions for Partitioned Database SystemsConcurrency Control
- Concurrency Control in Distributed Database SystemsConcurrency Control
Query Execution
- Adaptive Execution of Compiled QueriesVectorization vs Compilization
- All hash table sizes you will ever needHash Table
Thomas Neumann
- Efficiently Compiling Efficient Query Plans for Modern HardwareVectorization vs Compilization
- Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to AskVectorization vs Compilization
- Fibonacci Hashing: The Optimization that the World Forgot (or: a Better Alternative to Integer Modulo)Hash Table
- Hash TablesHash Table
Scheduling
- Adaptive HTAP through Elastic Resource Scheduling
- Automated Demand-driven Resource Scaling in Relational Database-as-a-Service
- Autoscaling Tiered Cloud Storage in Anna
- Building a Large-scale Distributed Storage System Based on Raft
- MorphoSys: Automatic Physical Design Metamorphosis for Distributed Database Systems
SQL & Relation Algebra
Recommended Courses, Books and Talks
Showing a sample of 191 resources. View the full list on GitHub →