SIGMOD '97 Industrial Session 5

5/29/97


Click here to start


Table of Contents

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

PPT Slide

TPC-D Query Set

Sample Query Definition

Sample Query Definition (cont.)

Query Variations

TPC-D Update Functions

PPT Slide

TPC-D Execution Rules

TPC-D Execution Rules (cont.)

TPC-D Metrics

TPC-D Metrics (cont.)

PPT Slide

Disclosure Requirements

TPC-D Current Results

PPT Slide

Do good, Do well and TO-DO

Things we missed...

PPT Slide

TPC-D, version 2: Overview

An extensible TPC workload?

Want to learn more about TPC-D?

Author: Charles Levine

Email: clevine@microsoft.com