In this lecture, we will discuss column-oriented databases, which represent a different way of building a relational database that is optimized for large-scale read-intensive operations rather than transaction processing. In preparation, read:

• Daniel J. Abadi, Samuel R. Madden, Nabil Hachem. "Column-Stores vs. Row-Stores: How Different Are They Really?" SIGMOD, 2008. [PDF]

Optional Reading: If you are curious you may also wish to read the original C-Store paper, which gives a bit more background about the features of C-Store, focusing less on the storage system and executor.

• Mike Stonebraker, Daniel Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Sam Madden, Elizabeth O'Neil, Pat O'Neil, Alex Rasin, Nga Tran and Stan Zdonik. "C-Store: A Column Oriented DBMS". VLDB, pages 553-564, 2005. [PDF]