Estimating the Size of the Star Database

Previous TopicNext TopicContents

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