Introduction to data warehousing, ETL process, star and snowflake schemas, column-oriented storage, compression, sort order, and trade-offs in writing to column-oriented storage.
This chapter discusses log-structured and page-oriented storage engines, their advantages, trade-offs, and considerations when choosing a storage engine.