TPC BENCHMARK™ C

1 TPC BEN CHMARK C Standard Specification Revision Febru ary 2010 Tran saction Processin g Perform an ce Cou n cil (TPC) w w w .tp in fo@tp 2010 Tran saction Processin g Perform an ce Cou n cil TPC benchmark C - Stan d ard Sp ecification , Revision - Page 2 of 130 Acknow ledgments Th e TPC ackn ow led ges th e su bstan tial con tribu tion of Fran ois Raab, con su ltan t to th e TPC-C su bcom m ittee an d tech n ical ed itor of th e TPC-C ben ch m ark stan d ard . Th e TPC also ackn ow led ges th e w ork an d con tribu tion s of th e TPC-C su bcom m ittee m em ber com p an ies: Am d ah l, Bu ll, CDC, DEC, DG, Fu jitsu / ICL, H P, IBM, In form ix, Mip s, Oracle, Sequ en t, Su n , Sybase, Tan d em , an d Un isys.

2 TPC Membership (as of Febru ary 2010) Full Members Associate Members TPC benchmark C - Stan d ard Sp ecification , Revision - Page 3 of 130 D ocument History Date Version Descrip tion 22 Ju n e 1992 Draft Mail ballot version (p rop osed stan d ard ) 13 Au gu st 1992 Revision Stan d ard sp ecification released to th e p u blic 1 Ju n e 1993 Revision First m in or revision 20 October 1993 Revision First m ajor revision 15 Febru ary 1995 Revision Secon d m ajor revision 4 Ju n e 1996 Revision Min or ch an ges to rev 27 Au gu st 1996 Revision Ch an ged m ix back to valu es. 12 Sep tem ber 1996 Revision Fixed Mem ber list an d ad d ed in d ex 15 Jan u ary 1997 Revision Ad d ed w ord in g for TAB Id s #197, 221 & 224 6 Febru ary 1997 Revision Ad d ed w ord in g for TAB Id s #205, 222 & 226 8 Ap ril 1997 Revision N ew Clau ses & (TAB Id #225)

3 9 Ap ril 1997 Revision Word in g ad d ed for availability d ate in Clau se 25 Ju n e 1997 Revision Ed itorial ch an ges in Clau ses an d 16 Ap ril 1998 Revision Ed itorial ch an ges in Clau ses an d 24 Au gu st 1998 Revision N ew Clau se an d ch an ged w ord in g in Clau se 25 Au gu st 1999 Revision Mod ify w ord in g in Clau se 18 October 2000 Revision Ch an ge p ricin g, 2 H ou r Measu rem en t, 60 Day Sp ace 6 Decem ber 2000 Revision 7x24 Main ten an ce, Mail Ballot Draft 26 Febru ary 2001 Revision Official Version Sp ecification 11 Decem ber 2002 Revision Clau se , PDO Lim itation s, Clu ster Du rability, Ch eckp oin t In terval, Typ ograp h ical Errors 11 Decem ber 2003 Revision Mod ified Clau se , Clau se , Clau se , an d Clau se Rep laced Clau se , an d Clau se Mod ified Clau se (tru n cated rep orted MQTh ) 22 Ap ril 2004 Revision Clau se (9), Execu tive Su m m ary, Mod ify (5)

4 , N ew Com m en t 4 an d 5 to 21 Ap ril 2005 Revision Mod ified Clau se , Mod ified Clau se , In tegrated TPC Pricin g Sp ecification 20 October 2005 Revision Mod ified Clau ses an d , Ad d ed Com m en t to Clau se an d ad d ed Clau se 8 Decem ber 2005 Revision Mod ified Clau ses , Rep laced 21 Ap ril 2006 Revision Mod ified Clau ses an d Ad d ed Clau se 14 Decem ber 2006 Revision Mod ified Clau ses , , , , , , , an d Ad d ed Clau se 14 Ju n e 2007 Revision Mod ified Clau se , , , to ad d ress su bstitu tion ru les 17 Ap ril 2008 Revision Mod ified Clau ses , , , , , , , , , , , Ad d ed Clau se 5 Febru ary 2009 Revision Ed itorial ch an ges in Clau ses , , , , 11 Febru ary 2010 Revision Up d ated TPC Mem bersh ip , Ed itorial ch an ge in Clau se , Mod ified Clau se , Mod ified Clau se , Mod ified / Ad d ed Clau ses , , , an d to su p p ort TPC-En ergy requ irem en ts.

5 TPC benchmark C - Stan d ard Sp ecification , Revision - Page 4 of 130 TPC Ben ch m ark , TPC-C, an d tp m C are trad em arks of th e Tran saction Processin g Perform an ce Cou n cil. Perm ission to cop y w ith ou t fee all or p art of th is m aterial is gran ted p rovid ed th at th e TPC cop yrigh t n otice, th e title of th e p u blication , an d its d ate ap p ear, an d n otice is given th at cop yin g is by p erm ission of th e Tran saction Processin g Perform an ce Cou n cil. To cop y oth erw ise requ ires sp ecific p erm ission . TPC benchmark C - Stan d ard Sp ecification , Revision - Page 5 of 130 TABLE OF CON TEN TS Ackn ow led gm en ts .. 2 TPC Mem bersh ip.

6 2 TABLE OF CON TEN TS .. 5 Clau se 0: PREAMBLE .. 7 In trod u ction .. 7 Gen eral Im p lem en tation Gu id elin es .. 8 Gen eral Measu rem en t Gu id elin es .. 9 Clau se 1: LOGICAL DATABASE DESIGN .. 10 Bu sin ess an d Ap p lication En viron m en t .. 10 Database En tities, Relation sh ip s, an d Ch aracteristics .. 11 Table Layou ts .. 11 Im p lem en tation Ru les .. 18 In tegrity Ru les .. 19 Data Access Tran sp aren cy Requ irem en ts .. 20 Clau se 2: TRAN SACTION an d TERMIN AL 21 Defin ition of Term s .. 21 Gen eral Requ irem en ts for Term in al I/ O .. 23 Gen eral Requ irem en ts for Tran saction Profiles .. 26 Th e N ew-Ord er Tran saction .. 28 Th e Paym en t Tran saction.

7 33 Th e Ord er-Statu s Tran saction .. 37 Th e Delivery Tran saction .. 40 Th e Stock-Level Tran saction .. 44 Clau se 3: TRAN SACTION an d SYSTEM PROPERTIES .. 47 Th e ACID Prop erties .. 47 Atom icity Requ irem en ts .. 47 Con sisten cy Requ irem en ts .. 48 Isolation Requ irem en ts .. 51 Du rability Requ irem en ts .. 57 Clau se 4: SCALIN G an d DATABASE POPULATION .. 61 Gen eral Scalin g 61 Scalin g Requ irem en ts .. 61 Database Pop u lation .. 64 Clau se 5: PERFORMAN CE METRICS an d RESPON SE TIME .. 69 Defin ition of Term s .. 69 Pacin g of Tran saction s by Em u lated Users .. 69 Resp on se Tim e Defin ition .. 73 Com p u tation of Th rou gh p u t Ratin g.

8 73 Measu rem en t In terval Requ iremen ts .. 74 Requ ired Rep ortin g .. 76 Prim ary Metrics .. 78 Clau se 6: SUT, DRIVER, an d COMMUN ICATION S DEFIN ITION .. 79 Mod els of th e Target System .. 79 Test Con figu ration .. 80 System Un d er Test (SUT) Defin ition .. 80 Driver Defin ition .. 80 TPC benchmark C - Stan d ard Sp ecification , Revision - Page 6 of 130 Com m u n ication s In terface Defin ition s .. 81 Fu rth er Requ irem en ts on th e SUT an d Driver System .. 81 Clau se 7: PRICIN G .. 85 Pricin g Meth od 85 Priced System .. 85 Requ ired Rep ortin g .. 88 Clau se 8: FULL DISCLOSURE .. 89 Fu ll Disclosu re Rep ort Req u irem en ts .. 89 Revision s to th e Fu ll Disclosu re Rep ort.

9 98 Clau se 9: AUDIT .. 100 Gen eral Ru les .. 100 Au d itor's ch eck list .. 100 In d ex 105 Ap p en d ix A: SAMPLE PROGRAMS .. 108 Th e N ew-Ord er Tran saction .. 108 Th e Paym en t Tran saction .. 110 Th e Ord er-Statu s Tran saction .. 112 Th e Delivery Tran saction .. 114 Th e Stock-Level Tran saction .. 116 Sam p le Load Program .. 117 Ap p en d ix B: EXECUTIVE SUMMARY STATEMEN T .. 130 Ap p en d ix C: N UMERICAL QUAN TITIES SUMMARY .. 132 TPC benchmark C - Stan d ard Sp ecification , Revision - Page 7 of 130 Clause 0: PREAMBLE Introduction TPC benchmark C (TPC-C) is an OLTP w orkload . It is a m ixtu re of read-on ly an d u p d ate in ten sive tran saction s th at sim u late th e activities fou n d in com p lex OLTP ap p lication en viron m en ts.

10 It d oes so by exercisin g a br ead th of system com p on en ts associated w ith su ch en viron m en ts, w h ich are ch aracterized by: Th e simu ltan eou s execu tion of m u ltip le tran saction typ es th at sp an a bread th of com p lexity On-lin e an d d eferred tran saction execu tion m od es Mu ltip le on-lin e term in al session s Mod erate system an d ap p lication execu tion time Sign ifican t d isk in p u t/ ou tp u t Tran saction in tegrity (ACID p rop erties) N on-u n iform d istribu tion of d ata access th rou gh p rim ary an d secon d ary keys Databases con sistin g of m an y tables w ith a w id e variety of sizes, attribu tes, an d relation sh ip s Con ten tion on d ata access an d u p d ate Th e p erform an ce m etric rep orted by TPC-C is a "bu sin ess th rou gh p u t" m easu rin g th e n u m ber of ord ers p r ocessed p er m in u te.