TPC-E vs. TPC-C: Characterizing the new TPC-E benchmark via an I/O comparison study

S Chen, A Ailamaki, M Athanassoulis, PB Gibbons… - ACM Sigmod …, 2011 - dl.acm.org
ACM Sigmod Record, 2011dl.acm.org
TPC-E is a new OLTP benchmark recently approved by the Transaction Processing
Performance Council (TPC). In this paper, we compare TPC-E with the familiar TPCC
benchmark in order to understand the behavior of the new TPC-E benchmark. In particular,
we compare the I/O access patterns of the two benchmarks by analyzing two OLTP disk
traces. We find that (i) TPC-E is more read intensive with a 9.7: 1 I/O read to write ratio, while
TPC-C sees a 1.9: 1 read-to-write ratio; and (ii) although TPC-E uses pseudo-realistic data …
TPC-E is a new OLTP benchmark recently approved by the Transaction Processing Performance Council (TPC). In this paper, we compare TPC-E with the familiar TPCC benchmark in order to understand the behavior of the new TPC-E benchmark. In particular, we compare the I/O access patterns of the two benchmarks by analyzing two OLTP disk traces. We find that (i) TPC-E is more read intensive with a 9.7:1 I/O read to write ratio, while TPC-C sees a 1.9:1 read-to-write ratio; and (ii) although TPC-E uses pseudo-realistic data, TPC-E's I/O access pattern is as random as TPC-C. The latter suggests that like TPC-C, TPC-E can benefit from SSDs, which have superior random I/O support. To verify this, we replay both disk traces on an Intel X25-E SSD and see dramatic improvements for both TPC-C and TPC-E.
ACM Digital Library