# Introduction to Database System Architectures
## Agenda
1. Choosing the right database system
- Understanding the tradeoff: the CAP theorem
- Relational vs. non-relational
- Selection criteria

2. Database System Architecture Models
- ANSI/SPARC 3-layer model
- 5-level hierarchy
- DBMS architecture view

3. An Excursion into Enterprise Architecture Frameworks & Documentation
- Zachman Framework
- TOGAF, ArchiMate
- arc42

4. Technical Architecture of an RDBMS
- RDBMS Technical Architecture (rough cut)
- What’s important in Database System Architecture Views?

## References

### Choosing the right database system, Database System Architecture Models

- Avi Silberschatz / Henry F. Korth / S. Sudarshan: [Database System Concepts, 6. Edition](https://www.db-book.com/db6/slide-dir/index.html).
McGraw-Hill 2010, ISBN-13: 978-1259252983
- [CAP theorem (Wikipedia)](https://en.wikipedia.org/wiki/CAP_theorem)
- SE Radio #364: Peter Zaitsev on [Choosing the Right Open Source Database](https://www.se-radio.net/2019/04/364-peter-zaitsev-on-choosing-the-right-open-source-database/)
- [A critical step in starting any database project: relational vs. non-relational, CAP Theorem and more.](https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77)
- [Database Hardware Selection Guidelines](https://www.percona.com/resources/videos/database-hardware-selection-guidelines)
- [Erste Schritte mit CockroachDB - Binary, Docker und Kubernetes](https://friends.cockroachlabs.com/MzUwLVFJTi04MjcAAAGDDfaDt-Rz0uQPchBsnRypWfq2dA69irEiumKVHOL1GiZ9zjiMGVIAIz0h-1ByPebx_y8WdAg=)
- [Distributed Storage in the Cloud](https://www.brighttalk.com/webcast/18708/520456?utm_source=brighttalk-portal&utm_medium=web&utm_campaign=knowledge-feed&utm_term=channel-feed-result-11)
- [7 Database Lessons You Can Learn From Star Trek](https://www.cockroachlabs.com/blog/database-lessons-star-trek-tng/?utm_campaign=nl-email&utm_source=mkto&utm_medium=email&utm_term=february-monthly&utm_content=newsletter-2022-2&mkt_tok=MzUwLVFJTi04MjcAAAGCVagPVkkAoDJsAXBOHlxvOQIdEDq8frK7bc4JK-UkR28qoplf2-8w55Uw8FqGDkRiRPCyHdIMxAIlFpzW4Japts26ittZyjn0Tqt4tuI4)
- [RAID-Systeme im Überblick](https://www.storage-insider.de/raid-systeme-im-ueberblick-a-1091608/?cmp=nl-2&uuid=174be5f167860ff203c16a3e39c77c06)
- [Selecting the right database and database migration plan for your workloads](https://aws.amazon.com/blogs/architecture/selecting-the-right-database-and-database-migration-plan-for-your-workloads/)
- [Choosing an AWS database service](https://docs.aws.amazon.com/decision-guides/latest/databases-on-aws-how-to-choose/databases-on-aws-how-to-choose.html)
- [List of in-memory databases](https://en.wikipedia.org/wiki/List_of_in-memory_databases)

### Enterprise Architecture Frameworks

- [The Concise Definition of The Zachman Framework](https://www.zachman.com/about-the-zachman-framework)
- [TOGAF vs Zachman: What’s The Difference?](https://www.bmc.com/blogs/togaf-vs-zachman/)
- [TOGAF | The Open Group Website](https://www.opengroup.org/togaf)
- [The ArchiMate® Enterprise Architecture Modeling Language](https://www.opengroup.org/archimate-forum/archimate-overview)
- [Archi – Open Source ArchiMate Modelling](archimatetool.com)
- [arc42](https://arc42.org/)
- Stefan Zörner: [Software-Architekturen dokumentieren und kommunizieren](https://www.hanser-elibrary.com/doi/book/10.3139/9783446472464).
Hanser Verlag, 3. Auflage Dezember 2021. ISBN-13: ‎978-3446469280.