# Database Systems

- Page: https://shared.btbytes.com/p/database-systems
- Date: 2022-10-12
- Tags: database

## Learning

[CMU 15-445/645 :: Intro to Database Systems (Fall 2021)](https://15445.courses.cs.cmu.edu/fall2021/)


[Database Fundamentals](https://tontinton.com/posts/database-fundementals/)

> 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](https://github.com/tontinton/dbeel). (**in bash**)

[tontinton/dbeel: A distributed thread-per-core document database](https://github.com/tontinton/dbeel) --  _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](https://cs.stanford.edu/people/widom/) - (March 2020) Stanford's MOOC offering in Databases is now hosted by [Stanford's EdX site](https://www.edx.org/school/stanfordonline) and consists of five courses:

 1. [Relational Databases and SQL](https://www.edx.org/course/databases-5-sql)
2. [Advanced Topics in SQL](https://www.edx.org/course/advanced-topics-in-sql)
3. [OLAP and Recursion](https://www.edx.org/course/olap-and-recursion)
4. [Modeling and Theory](https://www.edx.org/course/modeling-and-theory)
 5. [Semistructured Data](https://www.edx.org/course/semistructured-data)


## AI Database systems

[georgia-tech-db/eva: AI-Relational Database System | SQL meets Deep Learning](https://github.com/georgia-tech-db/eva)


## Longer Reads

- [How Query Engines Work](https://howqueryengineswork.com/) by **Andy Grove**.
- [A shallow survey of OLAP and HTAP query engines](https://www.scattered-thoughts.net/writing/a-shallow-survey-of-olap-and-htap-query-engines/)

## Blogs

- [transactional.blog](https://transactional.blog/) via [Phil Eaton](https://x.com/eatonphil/status/1818009357382037958)

## Books

[Database Internals](https://www.databass.dev/) 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](https://github.com/auxten/go-sqldb/issues/7)