Sign in
Author
|
Conference
|
Journal
|
Organization
|
Year
|
DOI
Look for results that meet for the following criteria:
since
equal to
before
between
and
Search in all fields of study
Limit my searches in the following fields of study
Agriculture Science
Arts & Humanities
Biology
Chemistry
Computer Science
Economics & Business
Engineering
Environmental Sciences
Geosciences
Material Science
Mathematics
Medicine
Physics
Social Science
Multidisciplinary
Keywords
(1)
Transaction Processing
Subscribe
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
Edit
TPC-E vs. TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study
BibTex
|
RIS
|
RefWorks
Download
Shimin Chen
,
Anastasia Ailamaki
,
Manos Athanassoulis
,
Phillip B. Gibbons
,
Ryan Johnson
,
Ippokratis Pandis
,
Radu Stoica
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
DOI:
10.1145/1942776.1942778
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.
(
portal.acm.org
)
(
portal.acm.org
)
(
www.informatik.uni-trier.de
)
(
doi.acm.org
)
More »
References
(4)
An Object Placement Advisor for DB2 Using Solid State Storage
(
Citations: 2
)
Mustafa Canim
,
Bishwaranjan Bhattacharjee
,
George A. Mihaila
,
Christian A. Lang
,
Kenneth A. Ross
Journal:
Proceedings of The Vldb Endowment - PVLDB
, vol. 2, no. 2, pp. 1318-1329, 2009
FlashLogging: exploiting flash devices for synchronous logging performance
(
Citations: 13
)
Shimin Chen
Conference:
International Conference on Management of Data - SIGMOD
, pp. 73-86, 2009
Characterization of storage workload traces from production Windows Servers
(
Citations: 20
)
Swaroop Kavalanekar
,
Bruce L. Worthington
,
Qi Zhang
,
Vishal Sharda
Conference:
IEEE International Symposium on Workload Characterization - IISWC
, pp. 119-128, 2008
A case for flash memory ssd in enterprise database applications
(
Citations: 70
)
Sang-won Lee
,
Bongki Moon
,
Chanik Park
,
Jae-Myung KimSang-Woo Kim
,
Sang-woo Kim
Conference:
International Conference on Management of Data - SIGMOD
, pp. 1075-1086, 2008