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!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy