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