tpcc_current (1034761), страница 16
Текст из файла (страница 16)
This fact m u st bed em onstrated in one of the follow ing w ays:TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 62 of 1301.row s in the WAREH OUSE table that p ertain to the inactive w arehou ses (Wi) m u st be d eleted p rior to them easu rem ent,2.show that the su m of D_N EXT_O_ID for each of the inactive w arehou ses d oes not change d u ring them easu rem ent, and that W_YTD for each of the inactive w arehou ses d oes not change d u ring the m easu rem ent.• the rep orted throu ghp u t cannot fall short of 9 tp m C p er configu red w arehou se (Wc -see Clau se 4.1.3),• the 60-d ay sp ace com p u tations m u st be com p u ted based on Wc, the num ber of w arehou ses configu red atd atabase generation.4.2.360-D ay Space ComputationThe storage sp ace requ ired for the 60-d ay p eriod m u st be d eterm ined as follow s:1.The test d atabase m u st be bu ilt inclu d ing the initial d atabase p op u lation (see Clau se 4.3) and all ind icesp resent d u ring the test.2.The test d atabase m u st be bu ilt to su stain th e rep orted throu ghp u t d u ring an eight hou r p eriod .
Thisexclu d es p erform ing on the d atabase any op eration that d oes not occu r d u ring the m easu rem ent interval(see Clau se 5.5).3.The total storage sp ace allocated for the test d atabase m u st be d ecom p osed into the follow ing:• Free-Space: any sp ace allocated to the test d atabase and w hich is available for fu tu re u se. It iscom p rised of all d atabase storage sp ace not u sed to store a d atabase entity (e.g., a row , an ind ex, am etad atu m ) or not u sed as form atting overhead by the d ata m anager.• D ynamic-Space: any sp ace u sed to store existing row s from th e d ynam ic tables (i.e., the H ISTORY,ORDER, and ORDER-LIN E tables).
It is com p rised of all d atabase storage sp ace u sed to store row s androw storage overhead for the d ynam ic tables. It inclu d es any d ata that is ad d ed to the d atabase as aresu lt of inserting a new row ind ep end ently of all ind ices. It d oes not inclu d e ind ex d ata or otheroverhead s su ch as ind ex overhead , page overhead , block overhead , and table overhead .• Static-Space: any sp ace u sed to store static inform ation and ind ices.
It is com p rised of all sp aceallocated to the test d atabase and w hich d oes not qu alify as either Free -Sp ace or Dynam ic-Sp ace.4.Given that the system m u st be configu red to su stain the rep orted throu ghp u t d u ring an eight hou r p eriod ,the d atabase m u st allow the d ynam ic tables to grow accord ingly for at least eight hou rs w ithou t im p actingp erform ance. Free-Space u sed to allow grow th of the d ynam ic tables for an eight hou r d ay at the rep ortedthrou ghp u t is called the D aily-Grow th. Given W, the nu m ber of configu red w arehou ses on the testsystem , the Daily-Grow th m u st be com p u ted as:Daily-Grow th = (d ynam ic-Sp ace / (W * 62.5)) * tp m CN ote: In the form u la above, 62.5 is u sed as a norm alizing factor since the initial d atabase p op u lation foreach w arehou se hold s the Dynam ic-Sp ace requ ired for an eight hou r d ay of activity at 62.5 tp m C.5.Any Free-Sp ace beyond 150% of the Daily-Grow th is called D aily-Spread, and m u st be ad d ed to theDynam ic-Sp ace w hen com p u ting the storage requ irem ent for the 60-d ay p eriod .
The Daily-Sp read m u st becom p u ted as:Daily-Sp read = Free-Sp ace - 1.5 * Daily-Grow thIf the com p u ted Daily-Sp read is negative, then a nu ll valu e m u st be u sed for Daily -Sp read .6.The 60-D ay-Space m u st be com p u ted as:60-Day-Sp ace = Static-Sp ace + 60 * (Daily-Grow th + Daily-Sp read )TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 63 of 1307.4.3The Dynam ic-Sp ace p resent in the test d atabase is consid ered as p art of the 60-Day-Sp ace.D atabase Population4.3.1The test d escribed in Clau se 5 requ ires that the p rop erly scaled p op u lation be p resent in the testd atabase.
Each table m u st contain the num ber of row s d efined in Clau se 4.2.2 p rior to test execu tion (e.g., the N ew Ord er table m u st contain 2,000 row s p er w arehou se).4.3.2D efinition of Terms4.3.2.1valu es.The term random m eans ind ep end ently selected and u niform ly d istribu ted over the sp ecified range ofComment: For the p u rp ose of p op u lating the initial d atabase only, rand om nu m bers can be generated by selectingentries in sequ ence from a set of at least 10,000 p regenerated rand om nu m bers.
This techniqu e cannot be u sed for thefield O_OL_CN T.4.3.2.2The notation random a-string [x .. y ] (resp ectively, n-string [x .. y ]) rep resents a string of rand omalp hanu m eric (resp ectively, nu m eric) cha racters of a rand om length of m inim u m x, m axim u m y, and m ean (y+x)/ 2.Comment: The character set u sed m u st be able to rep resent a m inim u m of 128 d ifferent characters. The character setu sed m u st inclu d e at least 26 low er case letters, 26 u p p er case letter s, and the d igits „ 0‟ to „ 9‟ .4.3.2.3The cu stom er last nam e (C_LAST) m u st be generated by the concatenation of three variable lengthsyllables selected from the follow ing list:0123456789BAROUGH TABLEPRIPRESESEAN TICALLYATIONEIN GGiven a nu m ber betw een 0 and 999, each of the three syllables is d eterm ined by the corresp ond ing d igit in the threed igit rep resentation of the nu m ber.
For exam p le, the nu m ber 371 generates the nam e PRICALLYOUGH T, and thenu m ber 40 generates the nam e BARPRESBAR.4.3.2.4The notation unique w ithin [x] rep resents any one valu e w ithin a set of x contigu ou s valu es, u niqu ew ithin the grou p of row s being p op u lated . When several grou p s of row s of the sam e typ e are p op u lat ed (e.g., thereis one grou p of cu stom er typ e row s for each d istrict typ e row ), each grou p m u st u se the sam e set of x contigu ou svalu es.4.3.2.5The notation random w ithin [x ..
y ] rep resents a rand om valu e ind ep end ently selected 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 niqu e va lu es.4.3.2.6The notation random permutation of [x .. y ] rep resents a sequ ence of nu m bers from x to y arrangedinto a rand om ord er. This is com m only know n as a p erm u tation (or selection) w ithou t rep lacem ent.4.3.2.7The w arehou se zip cod e (W_ZIP), the d istrict zip cod e (D_ZIP) and the cu stom er zip cod e (C_ZIP) m u st begenerated by the concatenation of:TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 64 of 1301.
A rand om n-string of 4 num bers, and2. The constant string '11111'.Given a rand om n-string betw een 0 and 9999, the zip cod es are d eterm ined by concatenating the n -string and theconstant '11111'. This w ill create 10,000 u niqu e zip cod es. For exam p le, the n -string 0503 concatenated w ith 11111,w ill m ake the zip cod e 050311111.Comment: With 30,000 custom ers p er w arehou se and 10,000 zip cod es available, there w ill be an average of 3cu stom ers p er w arehou se w ith the sam e zip cod e.4.3.34.3.3.1Table Population RequirementsThe initial d atabase p op u lation m u st be com p rised of:• 100,000 row s in the ITEM table w ith:I_ID u niqu e w ithin [100,000]I_IM_ID rand om w ithin [1 ..
10,000]I_N AME rand om a-string [14 .. 24]I_PRICE rand om w ithin [1.00 .. 100.00]I_DATA rand om a-string [26 .. 50]. For 10% of the row s, selected at rand om , the string "ORIGIN AL" m u stbe held by 8 consecu tive characters starting at a rand om p osition w ithin I_DATA• 1 row in the WAREH OUSE table for each configu red w arehou se w ith:W_ID u niqu e w ithin [number_of_configured_warehouses]W_N AME rand om a-string [6 .. 10]W_STREET_1 rand om a-string [10 ..
20]W_STREET_2 rand om a-string [10 .. 20]W_CITY rand om a-string [10 .. 20]W_STATE rand om a-string of 2 lettersW_ZIP generated accord ing to Clau se 4.3.2.7W_TAX rand om w ithin [0.0000 .. 0.2000]W_YTD = 300,000.00TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 65 of 130For each row in the WAREH OUSE table:o 100,000 row s in the STOCK table w ith:S_I_ID u niqu e w ithin [100,000]S_W_ID = W_IDS_QUAN TITY rand om w ithin [10 ..
100]S_DIST_01 rand om a-string of 24 lettersS_DIST_02 rand om a-string of 24 lettersS_DIST_03 rand om a-string of 24 lettersS_DIST_04 rand om a-string of 24 lettersS_DIST_05 rand om a-string of 24 lettersS_DIST_06 rand om a-string of 24 lettersS_DIST_07 rand om a-string of 24 lettersS_DIST_08 rand om a-string of 24 lettersS_DIST_09 rand om a-string of 24 lettersS_DIST_10 rand om a-string of 24 lettersS_YTD = 0S_ORDER_CN T = 0S_REMOTE_CN T = 0S_DATA rand om a-string [26 .. 50].
For 10% of the row s, selected at rand om , the string"ORIGIN AL" m u st be held by 8 consecu tive characters starting at a rand om p osition w ithinS_DATAo 10 row s in th e DISTRICT table w ith:D_ID u niqu e w ithin [10]D_W_ID = W_IDD_N AME rand om a-string [6 .. 10]D_STREET_1 rand om a-string [10 .. 20]D_STREET_2 rand om a-string [10 .. 20]D_CITY rand om a-string [10 .. 20]D_STATE rand om a-string of 2 lettersD_ZIP generated accord ing to Clau se 4.3.2.7D_TAX rand om w ithin [0.0000 .. 0.2000]D_YTD = 30,000.00D_N EXT_O_ID = 3,001TPC Benchm ark™C - Stand ard Sp ecification, Revision 5.11 - Page 66 of 130For each row in the DISTRICT table:* 3,000 row s in the CUSTOMER table w ith:C_ID u niqu e w ithin [3,000]C_D_ID = D_IDC_W_ID = D_W_IDC_LAST generated accord ing to Clau se 4.3.2.3, itera ting throu gh the range of [0 ..