Keywords (1)

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

TPC-E vs. TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study,10.1145/1942776.1942778,Sigmod Record,Shimin Chen,Anastasia Ailama

TPC-E vs. TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study  
BibTex | RIS | RefWorks Download
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.
Journal: Sigmod Record , vol. 39, no. 3, pp. 5-10, 2011
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.