
VLDB 2009 Tutorial Column-Oriented Database Systems 2
Re-use permitted when acknowledging the original © Stavros Harizopoulos, Daniel Abadi, Peter Boncz (2009)
What is a column-store?
VLDB 2009 Tutorial Column-Oriented Database Systems 2
row-store column-store
Date
CustomerProduct
Store
+ easy to add/modify a record
- might read in unnecessary data
+ only need to read in relevant data
- tuple writes require multiple accesses
=> suitable for read-mostly, read-intensive, large data repositories
Date Store Product Customer Price
Price
评论