DSM vs. NSM: CPU performance tradeoffs in block-oriented query processing

Comparisons between the merits of row-wise storage (NSM) and columnar storage (DSM) are typically made with respect to the persistent storage layer of database systems. In this paper, however, we focus on the CPU efficiency tradeoffs of tuple representations inside the query execution engine, while tuples flow through a processing pipeline. We analyze the performance in the context of query engines using so-called "block-oriented" processing

• Type: Conference
• Year: 2008
• Where: DAMON
• Authors: Marcin Zukowski, Niels Nes, Peter A. Boncz
• Keywords: CPU Efficiency, CPU Efficiency Tradeoffs, DAMON 2008, Informatics, Query Execution