Row Oriented vs Column Oriented Databases | System Design
Learn when and why you should use row databases or column databases. We talk about how the two databases lay out the same data differently in disk.
Also, we go through different tradeoffs and talk about an approach where you can have both databases for the same application serving two different sets of end users.
Video Notes: [https://pdfhost.io/edit?doc=fba5ce79-...](https://pdfhost.io/edit?doc=fba5ce79-...)
0:00 Agenda
0:35 Row Databases
3:28 Column Databases
8:08 OLTP vs OLAP
9:27 Writing in Column Databases
11:20 Disk Layout Differences
17:15 Notes & References
#systemDesign #database
Visit me at: https://irtizahafiz.com
Reach me at: [email protected]