Architecture of a database system

What Hacker News says

1. oxffSep 2022
   The first two CMU courses are goated. I recommend reading at least some of the papers Pavlo says to, but if I'd have to recommend a particular one it'd be "Architecture of a Database System": https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf
   thread
2. dmitrykovalApr 2021
   Architecture of a Database System – Hellerstein, Stonebraker & Hamilton, 2007. Is a great paper focused on DBs design and architecture. From 2007 but still rocks. http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf
   thread
3. pg314Jun 2018
   "Architecture of a Database System" by Hellerstein, Stonebraker and Hamilton [1], gives a good overview. The source code and documentation of PostgreSQL is excellent if you want to dive deeper.

   [1] http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf

   thread
4. lbruckOct 2017
   I like "Architecture of a Database System" by Stonebraker, Hamilton, and Hellerstein (http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf) for an overview and then "Transaction Processing: Concepts and Techniques" by Gray and Reuter (https://www.amazon.com/Transaction-Processing-Concepts-Techn...) for the storage-side of things. Granted these are a little old (especially G&R) so extra thought must be given for modern hardware (memory, CPU performance, processor counts, network, disks, etc) as well as distributed processing, replication, and consensus.
   Show morethread
5. tedyoungJun 2016
   The Red Book [1] (recently updated) is a good overview and has lots of useful references. Some might be too high-level, but this paper (really a short book!) is a good start at what makes up a database: "Architecture of a Database System"[2].

   Keep in mind that the scope of a "database" can be huge, so you might want to start really small, e.g., writing a basic key-value store that can support things concurrent reads & write, isolation, etc. It all depends on what interests you.

   --

   [1] http://www.redbook.io/

   [2] http://www.electricmonk.nl/data/freeitebooks/fntdb07-archite...

   Show morethread
6. why-elAug 2015
   Good write up. Another excellent resource straight out of the UC Berkeley Database Group that I keep close by is "Architecture of a Database System"[1] by three researchers in the field. It is very readable.

   [1] http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf

   thread