In Michael Kaminsky's third episode, we learn about the differences in row store vs column store database. This is a very important concept for understanding the difference between analytical and transactional databases, and we talk about the tradeoffs between using row and column stores for saving the data.
Michael gets into the weeds and talks about disk blocks and the different types of queries that work well for row and column stores.