HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 29

DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers Appendix A Appendix A: TPC-D Schema Note: SF = Scale Factor of TPC-D database (i.e. For a 100G database, SF=100) PART Table Layout Column Name Datatype Requirements Comment P_PARTKEY identifier SF*200,000 are populated P_NAME variable text, size 55 P_MFGR fixed text, size 25 P_BRAND fixed text, size 10 P_TYPE variable text, size 25 P_SIZE integer P_CONTAINER fixed text, size 10 P_RETAILPRICE decimal P_COMMENT variable text, size 23 Primary Key: P_PARTKEY SUPPLIER Table Layout Column Name S_SUPPKEY S_NAME S_ADDRESS S_NATIONKEY Datatype Requirements identifier fixed text, size 25 variable text, size 40 identifier S_PHONE fixed text, size 15 S_ACCTBAL decimal S_COMMENT variable text, size 101 Primary Key: S_SUPPKEY Comment SF*10,000 are populated Foreign key reference to N_NATIONKEY PARTSUPP Table Layout Column Name Datatype Requirements Comment PS_PARTKEY PS_SUPPKEY PS_AVAILQTY identifier identifier integer Foreign key reference to P_PARTKEY Foreign key reference to S_SUPPKEY PS_SUPPLYCOST decimal PS_COMMENT variable text, size 199 Compound Primary Key: PS_PARTKEY, PS_SUPPKEY © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398