Only the fact tables will be considered for Star Database sizing purposes because they are responsible for most of the data. Of the four fact tables in Star, two of the tables (W_ACTIVITY_SPREAD_F and W_RESOURCE_ASSIGNMENT_SPREAD_F) are identical to the equivalent spread tables in ODS (see Estimating the Size of the ODS Database for details). The rows for the remaining fact tables were calculated in the previous sections. Spread and resource limit data are initially loaded into holding tables (_FS suffix), so sizes are doubled for these tables.
Data Component | Calculation | Rows | Size Example |
---|---|---|---|
W_ACTIVITYSPREAD_F | 300 bytes/row | 5,000,000 x 2 | 3.0 GB |
W_RESOURCE_ASSIGNMENT_SPREAD_F | 175 bytes/row | 5,000,000 x 2 | 1.6 GB |
W_RESOURCE_LIMIT_F | 70 bytes/row | 1,825,000 x 2 | 0.125 GB |
Dimensional and Temporary | 20% of Spread | n/a | 0.9 GB |
W_Project_History_F | 265 bytes/row | 6000 | 0.04 GB |
Total |
|
|
5.6 GB |
Note: The above sizing does not include the W_Activity_History_F and W_WBS_History_F tables, which will be the largest if the History Interval is set at Weekly and the History Level is set at Activity.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014