tpcc_current (Дополнительные методические материалы), страница 22
Описание файла
Файл "tpcc_current" внутри архива находится в следующих папках: Дополнительные методические материалы, TPC-C. PDF-файл из архива "Дополнительные методические материалы", который расположен в категории "". Всё это находится в предмете "структурное проектирование автоматизированных систем обработки информации и управления" из 10 семестр (2 семестр магистратуры), которые можно найти в файловом архиве МГТУ им. Н.Э.Баумана. Не смотря на прямую связь этого архива с МГТУ им. Н.Э.Баумана, его также можно найти и в других разделах. Архив можно найти в разделе "остальное", в предмете "структурное проектирование автоматизированных систем обработки информации и управления" в общих файлах.
Просмотр PDF-файла онлайн
Текст 22 страницы из PDF
When the op tional TPC-Energy stand ard is u sed , the ad d itionalrequ irem ents and form atting of TPC-Energy related item s in the execu tive su m m ary m u st be rep orted and u sed . Inad d ition, the requ irem ents of the TPC-Energy Sp ecification, located at w w w .tp c.org, m u st be m et.Comment 1: The p rocessor inform ation to be inclu d ed is as follow s:N od e cou nt if ap p licableFor each p rocessor typ e, total enabled p rocessor cou nt, total enabled p rocessor core cou nt, total enabledp rocessor thread cou nt and p rocessor m od el and sp eed in H z. If m ore than one proces sor typ e is u sed , theym u st be d escribed on sep arate linesThe nu m ber rep orted in the "Database Processors" box in the Execu tive Su m m ary m u st sp ecify the totalp rocessor/ core/ thread inform ation for all the enabled p rocessors in the d atabase server(s).Processor inform ation for all servers in the SUT is rep orted in the "System Com p onents" box and not in the“ Processors” boxComment 2: If a p ackage is p riced bu t all of its com p onents are not u sed in the p riced benchm ark configu ration, thep ackage m u st be listed in the p ricing sp read sheet, inclu d ing any p u rchased com p onents not u sed in running thebenchm ark.
H ow ever, only the com p onents actu ally need ed to p rod u ce the rep orted p erform ance m etric shou ldap p ear in the Execu tive Su m m ary configu ration inform ation.TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 89 of 1308.1.1.3rep ort:The num erical qu antities listed below m u st be su m m arized near the beginning of the Full Disclosu re• com p u ted Maxim u m Qu alified Throu ghp u t in tp m C,• ninetieth p ercentile, average and m axim u m resp onse tim es for the N ew -Ord er, Paym ent, Ord er-Statu s, StockLevel, Delivery (d eferred and interactive) and Menu transactions,• tim e in second s ad d ed to resp onse tim e to com p ensate for d elays associated w ith em u lated com p onents,• p ercentage of transaction m ix for each transaction typ e,• m inim u m , average, and m axim u m key and think tim es for the N ew -Ord er, Paym ent, Ord er-Statu s, StockLevel, and Delivery (interactive),• ram p -u p tim e in m inu tes,• m easu rem ent interval in m inu tes,• nu m ber of checkp oints in the m easu rem ent interval,• checkp oint interval in m inutes,• nu m ber of transactions (all typ es) com p leted w ithin the m easu rem ent interval,Comment: Ap p end ix C contains an exam p le of su ch a su m m ary.
The intent is for d ata to be conveniently and easilyaccessible in a fam iliar arrangem ent and style. It is not requ ired to p recisely m im ic the layou t show n in Ap p end ix C.8.1.1.4The ap p lication p rogram (as d efined in Clau se 2.1.7) m u st be d isclosed . This inclu d es, bu t is notlim ited to, the cod e im p lem enting the five transactions and the term inal inp u t and ou tp u t fu nctions.8.1.1.5p rovid ed .A statem ent id entifying the benchm ark sp onsor(s) and other p articip ating com p anies m u st be8.1.1.6Settings m u st be p rovid ed for all cu stom er -tu nable p aram eters and op tions w hich have been chang edfrom the d efau lts fou nd in actu al p rod u cts, inclu d ing bu t not lim ited to:• Database tu ning op tions.• Recovery/ com m it op tions.• Consistency/ locking op tions.• Op erating system and ap p lication configu ration p aram eters.• Com p ilation and linkage op tions and ru n -tim e op tim izations u sed to create/ install ap p lication s, OS, and / ord atabases.Comment 1: This requ irem ent can be satisfied by p rovid ing a fu ll list of all p aram eters and op tions.Comment 2: The intent of the above clau se is that anyone attem p ting to recreate the benchm ark environm ent hassu fficient inform ation to com p ile, link, op tim ize, and execu te all softw are u sed to p rod u ce the d isclosed benchm arkresu lt.TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 90 of 1308.1.1.7Diagram s of both m easu red and p riced configu rations m u st be p rovid ed , accom p anied by ad escrip tion of the d ifferences.
This inclu d es, bu t is not lim ited to:• N u m ber and typ e of p rocessors/ cores/ thread s.• Size of allocated m em ory, and any sp ecific m ap p ing/ p artitioning of m em ory u niqu e to the test.• N u m ber and typ e of d isk u nits (and controllers, if ap p licable).• N u m ber of channels or bu s connections to d isk u nits, inclu d ing their p rotocol typ e.• N u m ber of LAN (e.g., Ethernet) connections, inclu d ing rou ters, w orkstations, term inals, etc., that w erep hysically u sed in the test or are incorp orated into the p ricing stru ctu re (see Clau se 8.1.8).• Typ e and the ru n -tim e execu tion location of softw are com p onents (e.g., DBMS, client p rocesses, transactionm onitors, softw are d rivers, etc.).Comment: Detailed d iagram s for system configu rations and architectu res can wid ely vary, an d it is im p ossible top rovid e exact gu id elines su itable for all im p lem entations.
The intent here is to d escribe the system com p on ents andconnections in su fficient d etail to allow ind ep end ent reconstru ction of the m easu rem ent environm ent.The follow ing sam p le d iagram illu strates a w orkstation/ rou ter/ server benchm ark (m easu red ) configu ration u singEthernet and a single p rocessor. N ote that this d iagram d oes not d ep ict or im p ly any op tim al configu ration for theTPC-C benchm ark m easu rem ent.ConcentratorConcentratorConcentratorConcentrators:LAN :CPU:Disk:16 1.2 Gby te Disk UnitsModel xxxCPU128Mby tes4 I/O cards1 EthernetadapterSystem _WW w ith 10 d iskless w orkstations eachEthernet u sing N ET_XX rou tersMod el_YY w ith 128 Mbytes of m ain m em ory, 4 I/ O card s w ith SCSI II p rotocol su p p ortVend or_ZZ 1.2 Gbyte d rivesTPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 91 of 1308.1.2Logical D atabase D esign Related Items:8.1.2.1Listings m u st be p rovid ed for all table d efinition statem ents and all other statem ents u sed to set -u pthe d atabase.8.1.2.2The p hysical organization of tables and ind ices, w ithin the d atabase, m u st be d isclosed .Comment: The concep t of p hysical organization inclu d es, bu t is not lim ited to: record clu stering (i.e., row s fromd ifferent logical tables are co-located on the sam e p hysical d ata p age), ind ex clu stering (i.e., row s and leaf nod es ofan ind ex to these row s are co-located on the sam e p hysical d ata p age), and p artial fill-factors (i.e., p hysical d atap ages are left p artially em p ty even thou gh ad d itional row s are available to fill them ).8.1.2.3It m u st be ascertained that insert and / or d elete op erations to any of the tables can occu r concu rrentlyw ith the TPC-C transaction m ix.
Fu rtherm ore, any restriction in the SUT d atabase im p lem entation that p reclu d esinserts beyond the lim its d efined in Clau se 1.4.11 m ust be d isclosed . This inclu d es the m axim u m nu m ber of row sthat can be inserted and the m axim u m key valu e for these new row s.8.1.2.4While there are a few restrictions p laced u p on horizontal or vertical p artitioning of tables and row s inthe TPC-C benchm ark (see Clau se 1.6), any su ch p artitioning m u st be d isclosed . Using the CUSTOMER table as anexam p le, su ch p artitioning cou ld be d enoted as:C_p art_1C_IDC_D_IDC_W_ID------------------------ vertical p artition ---------------C_p art_2C_FIRSTC_MIDDLEC_LASTC_STREET_1C_STREET_2C_CITYC_STATEC_ZIPC_PH ON EC_SIN CE------------------------ vertical p artition ---------------C_p art_3C_CREDITC_CREDIT_LIMC_DISCOUN TC_BALAN CEC_YTD_PAYMEN TC_PAYMEN T_CN TC_DELIVERY_CN T------------------------ vertical p artition ---------------C_p art_4C_DATAOnce the p artitioned d atabase elem ents have been so id entified , they can be referred to by, for exam p le, theirT_part_N notation w hen d escribing the p hysical allocation of d atabase files (see Clau se 8.1.5), w here T ind icates thetable nam e and N ind icates the p artition segm ent nu m ber.8.1.2.5Rep lication of tables, if u sed , m u st be d isclosed (see Clau se 1.4.6).TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 92 of 1308.1.2.6Ad d itional and / or d u p licated attribu tes in any table m u st be d isclosed along w ith a statem ent on theim p act on p erform ance (see Clau se 1.4.7).8.1.3Transaction and Terminal Profiles Related Items8.1.3.1The m ethod of verification for the rand om nu m ber generation m u st be d escribed .8.1.3.2The actu al layou ts of the term inal inp u t/ ou tp u t screens m u st be d isclosed .8.1.3.3The m ethod u sed to verify that the em u lated term inals p rovid e all the featu res d escribed in Clau se2.2.2.4 m u st be exp lained .
Althou gh not sp ecifically p riced , the typ e and m od el of the term inals u sed for thed em onstration in 8.1.3.3 m u st be d isclosed and com m ercially available (inclu d ing su p p orting softw are andm aintenance).8.1.3.4Any u sage of p resentation m anagers or intelligent term inals m u st be exp lained .Comment 1: The intent of this clau se is to d escribe any sp ecial m anip u lations p erform ed by a local term inal orw orkstation to off-load w ork from the SUT.
This inclu d es, bu t is not lim ited to: screen p resentations, m essagebu nd ling, and local storage of TPC-C row s.Comment 2: This d isclosu re also requ ires that all d ata m anip u lation fu nctions p erform ed by the local term inal top rovid e navigational aid s for transaction(s) m u st also be d escribed . Within this d isclosu re, the p u rp ose of su chad d itional fu nction(s) m u st be exp lained .8.1.3.5The p ercentage of hom e and rem ote ord er -lines in the N ew -Ord er transaction s m u st be d isclosed .8.1.3.6The p ercentage of N ew -Ord er transaction s that w ere rolled back as a resu lt of an u nu sed item nu m berm u st be d isclosed .8.1.3.7The nu m ber of item s p er ord ers entered by N ew -Ord er transaction s m u st be d isclosed .8.1.3.8The p ercentage of hom e and rem ote Paym ent transaction s m u st be d isclosed .8.1.3.9The p ercentage of Paym ent and Ord er -Statu s transaction s that u sed non -p rim ary key (C_LAST) accessto the d atabase m u st be d isclosed .8.1.3.10The p ercentage of Delivery transaction s that w ere skip p ed as a resu lt of an insu fficient nu m ber ofrow s in the N EW-ORDER table m u st be d isclosed .8.1.3.11The m ix (i.e., p ercentages) of transaction typ es seen by the SUT m u st be d isclosed .8.1.3.12The qu eu ing m echanism u sed to d efer the execu tion of the Delivery transaction m u st be d isclosed .8.1.4Transaction and System Properties Related Items8.1.4.1The resu lts of the ACID tests m u st be d isclosed along w ith a d escrip tion of how the ACIDrequ irem ents w ere m et.