Column Store Database

Column Store Database - ColumnStoreDatabase...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Column Store Database Biswa Ranjan Senapati
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Agenda Introduction to Column-Stores Definition Comparison of row store and column store Need for column store Partitioning Touple construction Column store optimization Compression Late materialization Block iteration C-store Architecture
Background image of page 2
Motivation 3 Query: Select c.name, c.address From CUSTOMERS c Where c.region=Columbia; Query process three attributes of the relation CUSTOMER. But process scan through whole table. Most of the queries do not process all attributes of a table.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Definition Column Store: all attributes of in a column stored contiguously on disk
Background image of page 4
5 Row Store 1011,10-04-2011, Joe, Whaley Street,$123; 1012,10-05-2011, Smith, Assembly Street, $25; 1031,10-06-2011, Mike, Blossom Street, $103; Column Store 1011, 1012, 1031; 10-04-2011, 10-05-2011, 10-06-2011; CustNo Date Name Address Revenue 1011 10-04-2011 Joe Whaley St. $123 1012 10-05-2011 Smith Assembly St. $25
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/13/2011 for the course CSCE 824 taught by Professor Staff during the Fall '11 term at South Carolina.

Page1 / 18

Column Store Database - ColumnStoreDatabase...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online