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 This 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 The 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 Database, it may be as much as 50% of the total space.
Fact/Spread Data Spread and Fact data total size depend 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 part of the ODS and is fundamental to the dimensional schema (Star).
Other ETL Tables There is some database space usage specific to the ETL process. This space is trivial relative to the core P6 EPPM data.
ETL Process Installation This includes shell scripts, sql files, and JAR files.