Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!ucsd!dog.ee.lbl.gov!ucbvax!hplabs!hpda!hpcuhc!dhepner
From: dhepner@hpcuhc.cup.hp.com (Dan Hepner)
Newsgroups: comp.databases
Subject: Re: sql benchmarking environment (maybe tpc-b?)?
Message-ID: <2060014@hpcuhc.cup.hp.com>
Date: 22 Apr 91 21:32:18 GMT
References: <3632@dagobah.UUCP>
Organization: Hewlett Packard, Cupertino
Lines: 29

From: mis@Seiden.com (Mark Seiden)

>i have so far been unsuccessful in persuading sun or sybase to part with
>their tpc-b implementation, though they seem very happy to quote numbers
>in press releases and semi-technical quasi-marketing literature.
>
>pity it isn't currently possible to replicate the benchmarks on other
>configurations than they ran it on.  (or am i misstating the case?)

Released TPC-B numbers are required to be accompanied by a "full disclosure 
statement".  All of the ones I've seen have included a source listing.
The TPC standard itself contains a sample 1/2 page of SQL statements
which implements:
  /*
  **  DoOne - Exceutes a single TPC BM transaction
  */
  void DoOne()
  {
   ....

It should be noted that the code is an example of what needs
to be done, not the benchmark itself. 

You can expect however that any vendor who has released such numbers has
probably brought more resources to bear on tuning the test than you are
likely to, and it may be difficult to actually reproduce the number without
the assistance of the vendor.

Dan Hepner