TPC-E vs. TPC-C
Shimin Chen, Anastasia Ailamaki, Manos Athanassoulis et al. · ACM SIGMOD Record · 2011
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.
Cited by 72 works. doi:10.1145/1942776.1942778
Authors
- Shimin Chen
- Anastasia Ailamaki
- Manos Athanassoulis
- Phillip B. Gibbons
- Ryan Johnson
- Ippokratis Pandis
- Radu Stoica
References
- Transaction Processing Performance Council
- A case for flash memory ssd in enterprise database applications
- Characterization of storage workload traces from production Windows Servers
- The five-minute rule twenty years later, and how flash memory changes the rules
- FlashLogging
- An object placement advisor for DB2 using solid state storage