MonetDB/X100: a (very) fast column-store

Google Tech Talks January, 15 2008 ABSTRACT MonetDB/X100 is a second-generation column-store prototyped at CWI, targeted at analysis-heavy data management tasks such as data warehousing and information retrieval. In this overview talk I will outline the research challenges, novel techniques and results from this project. The ideal is to close the existing performance gap between hand-coded applicationas and database systems using architecture-conscious techniques, and by carefully exploiting the bandwith strengs of modern hardware (and avoiding its latency weaknesses). The novel techniques presented encompass expressing relational operators as vector operations, lightweight compression on the border between CPU cache and RAM, sequential-access optimized database design and I/O bandwidth sharing. Speaker: Peter Boncz