	Home	About	Events	Standards	Services	Forums	Resources	PPDM Wiki

	Contact	Join	Site Map

Go back to Community Resources

Resource Categories

Home > Community Resources > Resource Categories: Data Model

Your input about the products is welcome and encouraged. Click here if you have a submission that you would like to share with the PPDM community .

Submissions in the Data Model category include any scripts, programs, or articles/presentations that relate directly to the Data Model. This catagory includes Oracle procedures, SQL Server procedures, SQL reports, and other database related submissions.

Your input about the products is welcome and encouraged. Click here if you have a submission that you would like to share with the PPDM community . Submissions in the Data Model category include any scripts, programs, or articles/presentations that relate directly to the Data Model. This catagory includes Oracle procedures, SQL Server procedures, SQL reports, and other database related submissions.

Data Model Submissions

This set of scripts will create the PPDM table report documentation.

Submission Name	Company	Description
Audit Triggers	DataMatters Consulting	Create triggers to populate ROW_CHANGED_BY, ROW_CHANGED_DATE, ROW_CREATED_BY, ROW_CREATED_DATE.
ChkPPDM 3.6.0	Brian Marshall	ChkPPDM 3.6.0 is an implementation of ChkDB for PPDM 3.6. ChkDB is Open Source rule-based data checking software. Currently, ChkPPDM has rule-sets to check for foreign key problems. Only Oracle is supported. This is not currently a GUI application; it is a set of scripts that can be run from SQL*Plus.
Creating a PPDM MySQL Database	Brian Marshall	Creating a PPDM36 MySQL Database. The scripts used to create this MySQL istribution from the Oracle distribution are available upon request from Brian Marshall of CleanDB. MyISAM Tables or InnoDB Tables These scripts can create PPDM tables of two types: - MyISAM tables are very fast but they do not support transactions or foreign key checking. - InnoDB tables are transaction-safe and they support foreign key checking.
Horizontal PDEN_SUMMARY View	DataMatters Consulting	Creates a horizontal view of the vertical PDEN_VOL_SUMMARY table using Oracle\'s INLINE view technology.
Load of the Rings	dMCI	The Windows based program will display the load order of tables within the PPDM. With referential integrity enabled in a model like the PPDM, this load order is necessary to load the data. It is also a nice to have for developers (or people not familiar with the subject area_ because it clearly shows what tables to load when. Please beaware that this program requires the ring content for PPDM_GROUPS & PPDM_TABLE_GROUP from the PPDM to work.
Populate PPDM 3.5 Meta Model Tables	PC Connections	These scripts will populate the meta model tables in PPDM 3.5 to the extent possible automatically.
Populate PPDM 3.6 Meta Model Tables	PC Connections	These scripts will populate the meta model tables in PPDM 3.6 to the extent possible automatically.
Populate PPDM 3.7 Meta Model Tables	PC Connections	These scripts will populate the meta model tables in PPDM 3.7 to the extent possible automatically.
Sample PPDM MySQL Database	Brian Marshall	Sample data for PPDM36 MySQL Database.
Standard PPDM Metadata (MySQL)	Brian Marshall	Populate the tables whose names begin with PPDM_ with the standard PPDM data. (This is a subset of the PPDM 3.6 sample dataset.) For MySQL.
Standard PPDM Metadata (Oracle)	Brian Marshall	Populate the tables whose names begin with PPDM_ with the standard PPDM data. (This is a subset of the PPDM 3.6 sample dataset.) For Oracle.
Table reports	PPDM Association	This set of scripts will create the PPDM table report documentation. The documentation is formatted to be printed landscape on 8 1/2 x 11 paper with a fixed font of appropriate size (Courier Bold 9 does nicely). It also can be translated to a word document opened with Word select all; format font; courier_new bold 9 uncheck all the other font boxes and save as doc.