View source for CSC/ECE 506 Fall 2007/wiki1 3 as1506

'''Commercial computers''', since long, have been using parallel architectures for its high end applications. However unlike the requirements of scientific or engineering computing where majority of the work done depends on the computing ability, commercial applications require that the system supports maximum number of transactions at any given time so that it can support large databases and service large number of customers. The class of such systems is referred to on-line transaction processing. 



== TPC benchmarks ==

The goal of TPC benchmarks is to define a set of functional requirements that can be run on any transaction processing system, regardless of hardware or operating system. This methodology allows any vendor, using "proprietary" or "open" systems, to implement the TPC benchmark and guarantees to end-users that they will see an apples-to-apples comparison. 

One of the OLTP system benchmark in this suite, the TPC-C, simulates a complete environment where a population of terminal operators executes transactions against a database. The benchmark is centered around the principal activities (transactions) of an order-entry environment. These transactions include entering and delivering orders, recording payments, checking the status of orders, and monitoring the level of stock at the warehouses.

The throughput of TPC-C is a direct result of the level of activity at the terminals. Each system has ten terminals and all five transactions are available at each terminal. A remote terminal emulator (RTE) is used to maintain the required mix of transactions over the performance measurement period. This mix represents the complete business processing of an order as it is entered, paid for, checked, and delivered. More specifically, the required mix is defined to produce an equal number of New-Order and Payment transactions and to produce one Delivery transaction, one Order-Status transaction, and one Stock-Level transaction for every ten New-Order transactions.

The tpm-C metric is the number of New-Order transactions executed per minute. Given the required mix and the wide range of complexity and types among the transactions, this metric more closely simulates a complete business activity, not just one or two transactions or computer operations. For this reason, the tpm-C metric is considered to be a measure of business throughput. The tpm-C, does not just measure a few basic computer or database transactions, but measures how many complete business operations can be processed per minute. This new benchmark should give users a more extensive, more complex yardstick for measuring OLTP system performance.

The current version of TPC-C benchmark is Version 5.9. Compared to the version mentioned in the text, pricing changes included reducing maintenance support pricing to 3 years down from 5 years, 24x7 maintenance up from 8x5, removing terminal network pricing (hubs, switches), and allowing pricing quotes from web pages and print materials. Runtime changes included reducing the disk space requirements to 60 days from 180 days, increasing the measurement interval to 2 hours up from 20 minutes, reporting checkpoint durations, and reporting the number of lost connections of users during the measurement interval.

=== Top 10 TPC-C (according to performance) ===

<table class=3DMsoNormalTable border=3D1 cellspacing=3D0 cellpadding=3D0
 style=3D'border-collapse:collapse;border:none;mso-border-alt:solid black .=
5pt;
 mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insid=
eh:
 .5pt solid black;mso-border-insidev:.5pt solid black'>
 <tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'>Company</b></p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border:solid black 1.=
0pt;
  border-left:none;mso-border-left-alt:solid black .5pt;mso-border-alt:soli=
d black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'>Name</b></p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border:solid black 1=
.0pt;
  border-left:none;mso-border-left-alt:solid black .5pt;mso-border-alt:soli=
d black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal><span class=3DSpellE><b style=3D'mso-bidi-font-weigh=
t:normal'>tpmC</b></span><b
  style=3D'mso-bidi-font-weight:normal'></b></p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border:solid black 1.=
0pt;
  border-left:none;mso-border-left-alt:solid black .5pt;mso-border-alt:soli=
d black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'>Price/<span
  class=3DSpellE>tpmC</span></b></p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:1'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>HP</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>HP Integrity Superdome- Itanium2/1.6Ghz/24MB iL3</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>4,092,799</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>2.93</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:2'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM System p5 595</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>4,033,378</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>2.97</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:3'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM <span class=3DSpellE>eServer</span> p5 595</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>3,210,540</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>5.07</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:4'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM System p 570</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>1,616,162</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>3.54</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:5'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>IBM <span class=3DSpellE>eServer</span> p5 595</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>1,601,784</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>5.05</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:6'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>FUJITSU</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>PRIMEQUEST 540 16p/32c</p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>1,238,579</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>3.94</p>
  </td>
 </tr>
 <tr style=3D'mso-yfti-irow:7;mso-yfti-lastrow:yes'>
  <td width=3D140 valign=3Dtop style=3D'width:105.15pt;border:solid black 1=
.0pt;
  border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid =
black .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>HP</p>
  </td>
  <td width=3D169 valign=3Dtop style=3D'width:126.5pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>HP Integrity Superdome </p>
  </td>
  <td width=3D140 valign=3Dtop style=3D'width:104.95pt;border-top:none;bord=
er-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>1,231,433</p>
  </td>
  <td width=3D142 valign=3Dtop style=3D'width:106.2pt;border-top:none;borde=
r-left:
  none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
  mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;
  mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=3DMsoNormal>4.82</p>
  </td>
 </tr>
</table>