TPC-E vs. TPC-C
- 8 February 2011
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 39 (3), 5-10
- https://doi.org/10.1145/1942776.1942778
Abstract
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.Keywords
This publication has 5 references indexed in Scilit:
- An object placement advisor for DB2 using solid state storageProceedings of the VLDB Endowment, 2009
- FlashLoggingPublished by Association for Computing Machinery (ACM) ,2009
- Characterization of storage workload traces from production Windows ServersPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2008
- A case for flash memory ssd in enterprise database applicationsPublished by Association for Computing Machinery (ACM) ,2008
- The five-minute rule twenty years later, and how flash memory changes the rulesPublished by Association for Computing Machinery (ACM) ,2007