ACM SIGMOD Record · 2011 · 71 citations · 5 references
ComputingComputer ScienceComputer SystemsComputer ArchitectureDatabasesStorage SystemsMemory Hierarchy OptimizationSolid-state Drive ArchitectureAccess Pattern AnalysisDisk I/o AnalysisDisk I/o PerformanceI/o EfficiencyMemory Access PatternsRandom Access PerformanceStorage Access PatternsTransaction Processing
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.
5
A case for flash memory ssd in enterprise database applications
Sang-Won Lee, Bongki Moon, Chanik Park et al. · 2008 · 299 citations
Characterization of storage workload traces from production Windows Servers
Swaroop Kavalanekar, Bruce Worthington, Qi Zhang et al. · 2008 · 259 citations