A Database Scale-Out Solution for Emerging Write-Intensive Commercial Workloads

Copyright © (2008) by Association for Computing Machinery, Inc. Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distrubuted for profit or commericial advantage. To copy otherwise, to republish, to post on servers, or to redistribute to lists, requires prior specific permission and/or a fee.

Among the increasing number of online businesses, a series of write-intensive commercial workloads are emerging recently on the Internet. These workloads generate many more write transactions on the backend database than read transactions. Most of such workloads require the database to handle high-volume write transactions in real-time. Based on the observation on the workloads, this paper proposes a multi-tier database scale-out architecture with the write caching technology. Our preliminary result shows that the database scale-out architecture can handle extremely high-volume write transactions with excellent scalability.

By: Yi Ge; Chen Wang; Xiaowei Shen; Honesty Young

Published in: Operating Systems Review, volume 42, (no 1), pages 102-3 in 2008

LIMITED DISTRIBUTION NOTICE:

This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.

rc24412.pdf

Questions about this service can be mailed to reports@us.ibm.com .