While data partitioning significantly improves the scalability of multithreaded and clustered transaction processing (TP) systems, selecting a correct and effective partitioning criterion (i.e. how to partition data) requires deep insight into the target TP systems. In this paper, we propose a novel analysis method to find even non-intuitive partitioning criteria for TP systems using our tracing tool that generates dynamic data dependence graphs (dynamic DDGs). Analyzing the exact behavior of a TP system from its dynamic DDG, our method can also generate a routing function of transaction requests for each partitioning criterion. We have demonstrated that our method could find the candidates of partitioning criteria and their routing functions, with a non-trivial TP system scenario.
By: Mikio Takeuchi; Ryoh Neyama
Published in: RT0709 in 2007
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.
Questions about this service can be mailed to reports@us.ibm.com .