tpcc_current (1034761), страница 5
Текст из файла (страница 5)
Other field s, su ch as field s u sed by t he SUT,or the RTE, for com p u tations, or com m u nication w ith the term inal, bu t not stored in the d atabase, are in lowercaseitalics.2.1.3The term database transaction as u sed is this sp ecification refers to a u nit of w ork on the d atabasew ith fu ll ACID p rop erties as d escribed in Clau se 3. A business transaction is com p rised of one or m ore d atabasetransactions.
When u sed alone, the term transaction refers to a bu siness transaction.2.1.4The term [x .. y ] rep resents a closed range of valu es starting w ith x and end ing w ith y.2.1.5The term randomly selected w ithin [x .. y ] m eans ind ep end ently selected at rand om and u niform lyd istribu ted betw een x and y, inclu sively, w ith a m ean of (x+y)/ 2, and w ith the sam e nu m ber of d igits of p recision asshow n.
For exam p le, [0.01 .. 100.00] has 10,000 u niqu e valu es, w hereas [1 ..100] has only 100 u n iqu e valu es.2.1.6The term non-uniform random, u sed only for generating cu stom er nu m bers, cu stom er last nam e s,and item nu m bers, m eans an ind ep end ently selected and non -u niform ly d istribu ted rand om nu m ber over thesp ecified range of valu es [x .. y].
This nu m ber m u st be generated by u sing the fu nction N URand w hich p rod u cesp ositions w ithin the range [x .. y]. The resu lts of N URand m ight have to be converted to p rod u ce a nam e or anu m ber valid for the im p lem entation.N URand (A, x, y) = (((rand om (0, A) | rand om (x, y)) + C) % (y - x + 1)) + xw here:exp -1 | exp -2 stand s for the bitw ise logical OR op eration betw een exp -1 and exp -2exp -1 % exp -2 stand s for exp -1 m od u lo exp -2rand om (x, y) stand s for rand om ly selected w ithin [x .. y]A is a constant chosen accord ing to the size of the range [x .. y]for C_LAST, the range is [0 .. 999] and A = 255for C_ID, the range is [1 ..
3000] and A = 1023for OL_I_ID, the range is [1 .. 100000] and A = 8191C is a ru n-tim e constant rand om ly chosen w ithin [0 .. A] that can be varied w ith ou t altering p erform ance.The sam e C valu e, p er field (C_LAST, C_ID, and OL_I_ID), m u st be u sed by all em u lated term inals.2.1.6.1In ord er that the valu e of C u sed for C_LAST d oes not alter p erform ance the follow ing m u st be tru e:Let C-Load be the valu e of C u sed to generate C_LAST w hen p op u lating the d atabase.
C-Load is a valu ein the range of [0..255] inclu d ing 0 and 255.TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 21 of 130Let C-Ru n be the valu e of C u sed to generate C_LAST for the m easu rem ent ru n.Let C-Delta be the absolu te valu e of the d ifference betw een C -Load and C-Ru n. C-Delta m u st be a valu e inthe range of [65..119] inclu d ing the valu es of 65 and 119 and exclu d ing the valu e of 96 and 112.2.1.7The term application program refers to cod e that is not p art of the com m ercially available com p onentsof the system , bu t p rod u ced sp ecifically to im p lem ent the transaction p rofiles (see Clau ses 2.4.2, 2.5.2, 2.6.2, 2.7.4,and 2.8.2) of this benchm ark. For exam p le, stored p roced u res, triggers, and r eferential integrity constraints areconsid ered p art of the ap p lication p rogram w hen u sed to im p lem ent any p ortion of the transaction p rofiles, bu t arenot consid ered p art of the ap p lication p rogram w hen solely u sed to enforce integrity ru les (see Clau se 1.5) ortransp arency requ irem ents (see Clau se 1.6) ind ep end ently of any transaction p rofile.2.1.8The term terminal as u sed in this sp ecification refers to the interface d evice cap able of entering andd isp laying characters from and to a u ser w ith a m inim u m d isp lay of 24x80.
A term inal is d efined as the com p onentsthat facilitate end -u ser inp u t and the d isp lay of the ou tp u t as d efined in Clau se 2. The term inal m ay not contain anyknow led ge of the ap p lication excep t field form at, typ e, and p osition.TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 22 of 1302.2General Requirements for Terminal I/O2.2.1Input/Output Screen D efinitions2.2.1.1The layou t (p osition on the screen and size of titles an d field s) of the inp u t/ ou tp u t screens, as d efinedin Clau ses 2.4.3.1, 2.5.3.1, 2.6.3.1, 2.7.3.1, and 2.8.3.1, m u st be rep rod u ced by th e test sp onsor as closely as p ossiblegiven the featu res and lim itations of the im p lem ented system . Any d eviation from the i np u t/ ou tp u t screens m u st beexp lained .2.2.1.2Inp u t/ ou tp u t screens m ay be altered to circu m vent lim itations of the im p lem entation p rovid ing thatno p erform ance ad vantage is gained .
H ow ever, the follow ing ru les ap p ly:1. Titles can be translated into any langu age.2. The sem antic content cannot be altered .3. The nu m ber of ind ivid u al field s cannot be altered .4. The nu m ber of characters w ithin the field s (i.e., field w id th) cannot be d ecreased .5. Reord ering or rep ositioning of field s is allow ed .6. A cop y of the new screen sp ecifications and layou t m u st be inclu d ed in the Full Disclosu re Rep ort .2.2.1.3The am ou nt and p rice field s d efined in Clau se 2 are form atted for U.S. cu rrency.
These form ats can bem od ified to satisfy d ifferent cu rrency rep resentation (e.g., u se another cu rrency sign, m ove the d ecim al p ointretaining at least one d igit on its right).2.2.1.4For inp u t/ ou tp u t screens w ith u nu sed field s (or grou p s of field s), it is not requ ired to enter or d isp laythese field s. For exam p le, w hen an ord er has less than 15 item s, the grou p s of field s corresp ond ing to the rem ainingitem s on the inp u t/ ou tp u t screen are u nu sed and need not be entered or d isp layed after being cleared .
Sim ilarly,w hen selecting a cu stom er u sing its last nam e, the cu stom er nu m ber field is unu sed and need not be entered ord isp layed after being cleared .2.2.1.5All inp u t and ou tp u t field s that m ay change m u st be cleared at the beginning of each transaction evenw hen the sam e transaction typ e is consecu tively selected by a given term inal. Field s shou ld be cleared by d isp layingthem as sp aces or zeros.Comment: In Clau ses 2.2.1.4 and 2.2.1.5, if the test sp onsor d oes not p rom ote u sing sp ace or zero as a clear characterfor its im p lem entation, other clear characters can be u sed as long as a given field alw ays u ses the sam e clearcharacter.2.2.1.6A menu is u sed to select the next transaction typ e.
The m enu , co nsisting of one or m ore lines, m u st bed isp layed at the very top or at the very bottom of the inp u t/ ou tp u t screen. If an inp u t field is need ed to enter them enu selection, it m u st be located on the line(s) reserved for the m enu .Comment: The m enu is in ad d ition to the screen form ats d efined in the term inal I/ O Clau se for each transactiontyp e.2.2.1.7The m enu m u st d isp lay exp licit text (i.e., it m u st contain the fu ll nam e of each transaction and theaction to be taken by the u ser to select each transaction).
A m inim u m of 60 characters (exclu d ing sp ace s) m u st bed isp layed on the m enu .TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 23 of 1302.2.1.8Any inp u t and ou tp u t field (s), other than the m and atory field s sp ecified in the inp u t/ ou tp u t screensas d efined in Clau ses 2.4.3.1, 2.5.3.1, 2.6.3.1, 2.7.3.1, and 2.8.3.1, m u st be d isclosed , and the p u rp ose of su ch field (s)exp lained .2.2.2Entering and D isplaying Fields2.2.2.1A field is said to be entered once all the significant characters that com p ose the in p u t d ata for that fieldhave been com m u nicated to the SUT by the em u lated term inal.2.2.2.2A field is said to be d isp layed once all significant characters that com p ose the d ata for that field havebeen com m u nicated by the SUT to the em u lated term inal for d isp lay.2.2.2.3Com m u nicating inp u t and ou tp u t d ata d oes not requ ire transferring any sp ecific nu m ber of bytes.Method s for op tim izing this com m u nication, su ch as m essage com p ression and d ata caching , are allow ed .2.2.2.4The follow ing featu res m u st be p rovid ed to the em u lated u ser:1.
The inp u t characters ap pear on the inp u t/ ou tp u t screen (i.e., are echoed ) as they are keyed in. Thisrequ irem ent can be satisfied by visu al insp ection at fu ll load w he re there are no p erceivable d elays.Otherw ise, it is requ ired that the character echoing be verified by actu al m easu rem ents. For exam p le, that canbe d one u sing a p rotocol analyzer, RTE m easu rem ent, etc. to show that the echo resp onse tim e is less than 1second .
If local echo or block m od e d evices are u sed then verification is not requ ired .Comment: A w eb brow ser im p lem entation, or a term inal or PC em u lating a term inal in either local echo or blockm od e, w ill m eet the echo resp onse tim e requ irem ent of one second , so there is no need for an echo test.2. Inp u t is allow ed only in the p ositions of an inp u t field (i.e., ou tp u t -only field s, labels, and blanks sp aces onthe inp u t/ ou tp u t screen are p rotected from inp u t).3. Inp u t-cap able field s are d esignated by som e m ethod of clearly id entifying them (e.g., highlighted areas,u nd erscores, reverse vid eo, colu m n d ivid ers, etc.).4.