Fast Updates on Read-Optimized Databases Using Multi-Core CPUs

Details Fast Updates on Read-Optimized Databases Using Multi-Core CPUs Fast Updates on Read-Optimized Databases Using Multi-Core CPUs

2011-09-30

arxiv.org/abs/1109.6885v1

Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 1, pp. 61-72 (2011)

Computer Science

Databases

VLDB2012

Scientific paper

Read-optimized columnar databases use differential updates to handle writes by maintaining a separate write-optimized delta partition which is periodically merged with the read-optimized and compressed main partition. This merge process introduces significant overheads and unacceptable downtimes in update intensive systems, aspiring to combine transactional and analytical workloads into one system. In the first part of the paper, we report data analyses of 12 SAP Business Suite customer systems. In the second half, we present an optimized merge process reducing the merge overhead of current systems by a factor of 30. Our linear-time merge algorithm exploits the underlying high compute and bandwidth resources of modern multi-core CPUs with architecture-aware optimizations and efficient parallelization. This enables compressed in-memory column stores to handle the transactional update rate required by enterprise applications, while keeping properties of read-optimized databases for analytic-style queries.

Affiliated with

Also associated with

No associations

Rating

Fast Updates on Read-Optimized Databases Using Multi-Core CPUs does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Fast Updates on Read-Optimized Databases Using Multi-Core CPUs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Fast Updates on Read-Optimized Databases Using Multi-Core CPUs will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-669751