理解MonetDB about column-oriented database

• Overview

  MonetDB is designed from scratch focusing on handling analytical workloads efficiently on modern hardware.

• Column-at-a-time

  MonetDB stores data one column-at-a-time both in memory and on disk and exploits bulk processing and late materialization.

• MMP

  It solely relies on memory mapped files avoiding the overhead and complexity of managing a buffer pool.

  理解buffer pool in computer

• Differ from traditional RDBMS architecture

  • Execution engine, which uses a column at-a-time-algebra

    Traditional query execution uses a tuple-at-a-time, pull-based, iterator approach in which each operator gets the next input tuple by calling t