Gaining the Performance Edge Using a Column-Oriented Database Management System

Gaining the Performance Edge Using a Column-Oriented Database Management System

Cover

This paper explores the data explosion phenomenon and why column-oriented database systems are able to provide the boost that is needed to gain the performance edge. The paper contrasts row-oriented systems with column-oriented systems, and then elaborates on the benefits of the columnar approach. A review of how data access latency across the different levels of the memory hierarchy can impact application performance sheds some light on why the column-oriented approach can deliver these benefits, which suggests a number of drivers for increasing analytical application performance, particularly by means of exploiting parallelism. Last, the paper suggests some factors guiding the evaluation process when considering a columnar system.

Vendor:
Sybase, an SAP company
Posted:
06 Aug 2009
Published:
01 Jul 2009
Format:
PDF
Length:
12 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!