Not logged in. Log in.

Go back to Data Model

PPDM 3.7.1

• Download PPDM 3.7.1
• Online Documentation

Production Release of PPDM Version 3.7.1

Full Model Definition

Model definition products can be used to create a PPDM version 3.7.1 database at your site.

• Script to upgrade your version of PPDM 3.7 to PPDM 3.7.1 (revised June 8, 2005).
• DDL in Oracle SQL format (ZIP, 808K; revised Oct 26, 2006)
• DDL in MS SQL Server format (ZIP, 295K; revised Dec 6, 2005)
• DDL in PostreSQL format (ZIP,876K; posted June 17, 2005)
• DDL in mySQL format (ZIP, 320K; posted June 20, 2005)

Subset Model Definition

The PPDM DDL Generator creates a subset of the PPDM data 3.7.1 model based the modules you want to implement. Choose your database format below:

• Oracle
• PostgreSQL
• mySQL

Documentation

• PPDM 3.7.1 Upgrade Reference Guide. Summary of model changes for the correction release.
• Online documentation: Online access to table and column information and the sample data
• Model Documentation: A full description of the PPDM 3.7.1 Model with diagrams
• Reference Guides: Module by module technical information for anyone implementing PPDM 3.7.1
• Architectural Principles 3.7: A description of the methods and design strategies used to develop the model Minor revision May 2006 (PDF, 1.19 MB)
• Constraint Issues in PPDM 3.5: A description of the issues with implementing complex constraints in PPDM. Written for PPDM 3.5. (PDF, 170K)

Diagrams

• Data diagrams in powerpoint. This version provides best printer quality. (PPT; 1.6 MB)
• Roadmaps (PDF, 1.23MB)

Other Support Products

Sample Data

• PPDM371_Insert.zip: A set of SQL Insert statements that may be used to populate your PPDM 3.7.1 database. Last Updated Feb 6, 2006.
• PPDM371_OracleDMP.zip: An Oracle .dmp file for direct import into your PPDM 3.7.1 Oracle user account. Last Updated Feb 6, 2006.

Load of the Rings

• PPDM Load of the Rings Reference Guide
• PPDM Load Order (by table and by column)

Data Quality

The quality of the sample data is indicated in the column ROW_QUALITY for every table.

• Where ROW_QUALITY = 'SYNTHETIC', the data was artificially generated by the work groups as examples of usage.
• Where ROW_QUALITY = 'REAL', the data was derived from an open or public data source.
• Where ROW_QUALITY = 'REFERENCE'. the data may be considered to be reference data suitable for implementation. This data should only be used after thorough review and analysis by your company; the PPDM Association does not assert the data to be complete or error free. It can be considered a good start on your implementation, however.

PPDM Mapping Database

• Version Mappings: Click here to see mappings between PPDM versions since PPDM 3.2.
• Due to the sponsorship of Talisman Energy, PPDM Association can now offer a mapping between PPDM 3.2 and PPDM 3.7 (XLS). The mapping is in excel format (contact PPDM if you require a different format).