Fast Updates on Read-Optimized Databases Using MultiCore CPUs

Download Now
Provided by: VLD Digital
Topic: Hardware
Format: PDF
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, the authors report data analyses of 12 SAP business suite customer systems. In the second half, they present an optimized merge process reducing the merge overhead of current systems by a factor of 30.
Download Now

Find By Topic