The physical space requirements of the data warehouse consist of more than just copies of the project management data. Space requirements will vary with the amount of data processed from the P6 EPPM database. The system uses space for the following types of data:
- Core Project Management Data includes all the physical fields that exist in the P6 EPPM database. This is approximately all the data in the P6 EPPM database.
- Logical Fields become physically stored as part of the P6 EPPM database in the Extended Schema (Px) tablespace. While this is less than the size of the P6 EPPM DatabaseP6 EPPM database, it may be as much as 50% of the total space.
- Fact/Spread Data total size depends on the number of activities and resource assignments, the average length of activities, and the total window (date range) of the data warehouse. Because of this, it will be treated as a distinct group. It is fundamental to the dimensional schema (Primavera Data Warehouse).
- Other ETL Tables use database space specific to the ETL process. This space is trivial relative to the core P6 EPPM data.
- ETL Process Installation includes shell scripts, SQL files, and JAR files.