Estimating the Size of the ODS Database

Previous TopicNext TopicContents

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