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: irtizahafiz9@gmail.com
On this page of the site you can watch the video online Row Oriented vs Column Oriented Databases | System Design with a duration of hours minute second in good quality, which was uploaded by the user Code with Irtiza 25 April 2022, share the link with friends and acquaintances, this video has already been watched 2,754 times on youtube and it was liked by 74 viewers. Enjoy your viewing!