Title

10Th Anniversary Of Attosecond Pulses

Keywords

ACID; log; RAID; transaction processing system

Abstract

In the past few years, more storage system applications have employed transaction processing techniques to ensure data integrity and consistency. Logging is one of the key requirements to ensure transaction Atomicity, Consistency, Isolation, Durability (ACID) properties and data recoverability in transaction processing systems (TPS). Recently, emerging complex I/O bound transactions have resulted in substantially more log content and higher log flushing latency. The latency will delay transaction commit and decrease the overall throughput of the TPS. On the other hand, RAID is widely used as the underlying storage system for Databases to guarantee system reliability and availability with high I/O performance. In this paper, we observe the overlap between the redundancies in the underlying RAID storage system and database logging system, and propose a novel reliable storage architecture called Transactional RAID (TRAID). TRAID deduplicates this overlap by only logging one compact version (XOR results) of recovery references for the updating data. It minimizes the amount of log content and thereby boosts the overall transaction processing performance. At the same time, TRAID guarantees the same RAID reliability, as well as recovery correctness and ACID semantics as current TPS setups. We experiment on two open-source database systems: Berkeley DB and PostgreSQL, with three different workloads: standard OLTP benchmark TPC-C, customized TPC-C with strong access locality, and customized TPC-C with writeintensive property. Then we test TRAID performance with “Group Commit” enabled. Finally, we evaluate the recovery efficiency of TRAID. Our extensive results demonstrate that for throughput, TRAID outperforms RAID by 43.24-69.5 percent for various workloads; it also saves on log space by 28.57-35.48 percent, and outperforms RAID by about 20 percent in throughput with “Group Commit” enabled. At last, we show that TRAID outperforms RAID from 28.7 to 35.7 percent during the recovery. © 2012, IEEE

Publication Date

4-14-2012

Publication Title

Journal of Physics B: Atomic, Molecular and Optical Physics

Volume

45

Issue

4

Number of Pages

-

Document Type

Editorial Material

Personal Identifier

scopus

DOI Link

https://doi.org/10.1088/0953-4075/45/7/070201

Socpus ID

84858697403 (Scopus)

Source API URL

https://api.elsevier.com/content/abstract/scopus_id/84858697403

This document is currently not available here.

Share

COinS