SIGMOD '97 Industrial Session 5
TPC-C: The OLTP Benchmark
Benchmarks: What and Why
Benefits and Liabilities
Benchmarks have a Lifetime
What is the TPC?
TPC-C Overview
TPC-C's Five Transactions
TPC-C Database Schema
TPC-C Workflow
Data Skew
NURand Distribution
ACID Tests
Transparency
Transparency (cont.)
TPC-C Rules of Thumb
Typical TPC-C Configuration (Conceptual)
Competitive TPC-C Configuration Today
TPC-C Current Results
TPC-C Results (by OS)
TPC-C Results (by DBMS)
Analysis from 30,000 ft.
TPC-C Summary
Reference Material
TPC-D The Industry Standard Decision Support Benchmark
Outline
TPC-D Overview
PPT Slide
TPC-D Schema
Schema Usage
TPC-D Database Scaling and Load
TPC-D Query Set
Sample Query Definition
Sample Query Definition (cont.)
Query Variations
TPC-D Update Functions
TPC-D Execution Rules
TPC-D Execution Rules (cont.)
TPC-D Metrics
TPC-D Metrics (cont.)
Disclosure Requirements
TPC-D Current Results
Do good, Do well and TO-DO
Things we missed...
TPC-D, version 2: Overview
An extensible TPC workload?
Want to learn more about TPC-D?
Author: Charles Levine
Email: clevine@microsoft.com