The following rules are used by VGenLoader to calculate the cardinalities of the Scaling Tables and Growing Tables. The VGen package uses random number generators to set the number of rows for relationships such as securities per account and, as a result, the cardinality of some TPCxV tables can only be approximated. Variable Used Rule 60% have just the customer as the executor 38% have the customer and 1 other executor ACCOUNT_PERMISSION accounts 2% have the customer and 2 other executors Avg. is ~1.42 * accounts ADDRESS customers companies(5,000) + EXCHANGE(4) + customers BROKER customers 0.01 * customers (or 1 broker per 100 customers) CASH_TRANSACTION settled ~0.92 * settled (84% of buys and 100% of sells are cash) COMPANY companies 1 * companies COMPANY_COMPETITOR companies 3 * companies CUSTOMER_ACCOUNT customers 5 * customers CUSTOMER_TAXRATE customers 2 * customers securities * 1,305 (5 years of 5-day work weeks with two DAILY_MARKET securities leap years) FINANCIAL companies companies * 20 quarters (5 years) HOLDING settled ~0.07955 * settled (assumes ITD = 125 and SF = 500) HOLDING_HISTORY settled ~1.3331 * settled (assumes ITD = 125 and SF = 500) HOLDING_SUMMARY accounts ~ 9.9234 * accounts (assumes ITD = 125 and SF = 500) LAST_TRADE securities 1 * securities NEWS_ITEM companies 2 * companies NEWS_XREF companies 2 * companies SECURITY customers 1 * Securities SETTLEMENT settled 1 * settled TRADE customers 7200 * customers = ((ITD * 8 * 3600) / SF) * customers ~((2 rows per market trade) * 0.6) + TRADE_HISTORY settled ((3 rows per limit trade) * 0.4) Average is (2.4 * settled) TRADE_REQUEST 0 WATCH_LIST customers Each customer has one watch list (1 * customers) WATCH_ITEM customers Average=100 items per watch list * customers The following list contains the cardinality of Fixed Tables. Fixed Tables Cardinality Cardinality Formula CHARGE 15 5 trade types * 3 customer tiers COMMISSION_RATE 240 4 rates * 4 exchanges * 5 trade types * 3 customer tiers COMPANY 5,000 5,000 companies
The following rules are used by VGenLoader to calculate the cardinalities of the Scaling Tables and Growing Tables. The VGen package uses random number generators to set the number of rows for relationships such as securities per account and, as a result, the cardinality of some TPCxV tables can only be approximated. Variable Used Rule ACCOUNT_PERMISSION accounts 60% have just the customer as the executor 38% have the customer and 1 other executor 2% have the customer and 2 other executors Avg. is ~1.42 * accounts ADDRESS customers companies(5,000) + EXCHANGE(4) + customers BROKER customers 0.01 * customers (or 1 broker per 100 customers) CASH_TRANSACTION settled ~0.92 * settled (84% of buys and 100% of sells are cash) COMPANY companies 1 * companies COMPANY_COMPETITOR companies 3 * companies CUSTOMER_ACCOUNT customers 5 * customers CUSTOMER_TAXRATE customers 2 * customers DAILY_MARKET securities securities * 1,305 (5 years of 5-day work weeks with two leap years) FINANCIAL companies companies * 20 quarters (5 years) HOLDING settled ~0.07955 * settled (assumes ITD = 125 and SF = 500) HOLDING_HISTORY settled ~1.3331 * settled (assumes ITD = 125 and SF = 500) HOLDING_SUMMARY accounts ~ 9.9234 * accounts (assumes ITD = 125 and SF = 500) LAST_TRADE securities 1 * securities NEWS_ITEM companies 2 * companies NEWS_XREF companies 2 * companies SECURITY customers 1 * Securities SETTLEMENT settled 1 * settled TRADE customers 7200 * customers = ((ITD * 8 * 3600) / SF) * customers TRADE_HISTORY settled ~((2 rows per market trade) * 0.6) + ((3 rows per limit trade) * 0.4) Average is (2.4 * settled) TRADE_REQUEST 0 WATCH_LIST customers Each customer has one watch list (1 * customers) WATCH_ITEM customers Average=100 items per watch list * customers The following list contains the cardinality of Fixed Tables. Fixed Tables Cardinality Cardinality Formula CHARGE 15 5 trade types * 3 customer tiers COMMISSION_RATE 240 4 rates * 4 exchanges * 5 trade types * 3 customer tiers COMPANY 5,000 5,000 companies
tpcx-v_v2.1.0.docx