The estimated size of the ODS Database is derived from two primary components: the estimated size of PMDB project data and the estimated size of the spread data. The majority of Oracle ODS Database data is simply a copy of the P6 EPPM Database tables. The remaining space usage comes mostly from the ActivitySpread and ResourceAssignmentSpread tables. Any remaining data will be estimated as a percentage of the spread data (including aggregate spread tables and hierarchies).
Data Component | Calculation | Rows | Size Example |
---|---|---|---|
ActivitySpread | 300 bytes/row | 5,000,000 x 2* | 3.0 GB |
ResourceSpread | 175 bytes/row | 5,000,000 x 2* | 1.6 GB |
Other | 30% of Spreads | n/a | 0.4 GB |
Total |
|
| 45 GB |
* Temporary data stored during loading process results in copies of spread data during initial ETL.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014