Database Systems

Learning

CMU 15-445/645 :: Intro to Database Systems (Fall 2021)

Database Fundamentals

This is when I decided to read the excellent books Database Internals by Alex Petrov and Designing Data-Intensive Applications by Martin Kleppmann. The books piqued my curiosity enough to write my own little database I called dbeel. (in bash)

tontinton/dbeel: A distributed thread-per-core document database —  A distributed thread-per-core document database written in rust. So basically it has a document API like in MongoDB with leaderless replication like in Cassandra and thread-per-core architecture like in ScyllaDB.

Jennifer Widom’s Home Page - (March 2020) Stanford’s MOOC offering in Databases is now hosted by Stanford’s EdX site and consists of five courses:

1. Relational Databases and SQL
2. Advanced Topics in SQL
3. OLAP and Recursion
4. Modeling and Theory
5. Semistructured Data

AI Database systems

georgia-tech-db/eva: AI-Relational Database System | SQL meets Deep Learning

Longer Reads

• How Query Engines Work by Andy Grove.
• A shallow survey of OLAP and HTAP query engines

Blogs

• transactional.blog via Phil Eaton

Books

Database Internals by Alex Petrov.

The book consists of two parts: Storage Engines and Distributed Systems since that’s where most of the differences between the vast majority of databases is coming from.

Papers

Database Papers that I like · Issue #7 · auxten/go-sqldb