TPC-E vs. TPC-C: Characterizing the New TPC-E Benchmark via an I/O Comparison Study

被引：50

作者：

Chen, Shimin ^{[1
]}

Ailamaki, Anastasia ^{[2
]}

Athanassoulis, Manos ^{[2
]}

Gibbons, Phillip B. ^{[1
]}

Johnson, Ryan ^{[3
]}

Pandis, Ippokratis ^{[3
]}

Stoica, Radu ^{[2
]}

机构：

[1] Intel Labs Pittsburgh, Pittsburgh, PA USA

[2] Ecole Polytech Fed Lausanne, CH-1015 Lausanne, Switzerland

[3] Carnegie Mellon Univ, Pittsburgh, PA 15213 USA

来源：

SIGMOD RECORD | 2010年 / 39卷 / 03期

关键词：

D O I：

10.1145/1942776.1942778

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

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 TPC-C 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.

引用

页码：5 / 10

页数：6

共 8 条

[1] An Object Placement Advisor for DB2 Using Solid State Storage
Canim, Mustafa
Mihaila, George A.
Bhattacharjee, Bishwaranjan
Ross, Kenneth A.
Lang, Christian A.
[J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2009, 2 (02): : 1318 - 1329
[2] Chen Shimin., 2009, SIGMOD
[3] Graefe G., 2007, DAMON WORKSH
[4] KAVALANEKAR S, 2008, 4 INT S WORKL CHAR I
[5] Lee Sang-Won., 2008, SIGMOD
[6] *T PROC PERF COUNC, 2007, TPC E BENCHM OV
[7] *T PROC PERF COUNC, TPC E BENCHM VERS 1
[8] Transaction Processing Performance Council, TPC C BENCHM REV 5 1

← 1 →