Architectural Principles Constraints in PPDM
Referential Integrity refers to the development of enforced (mandatory or optional) relationships between parent and child tables. In a relational database, the concept of Referential Integrity is critical in order to maintain the value of the information contained within the database. It ensures that database information is associated in a consistent and meaningful fashion.
For example, Referential Integrity prevents a Well Test from being loaded unless the loader can determine which Well the test belongs to. It also forces data loaders to validate entries where needed, so that variations or typographic errors in names (Ex. Alberta, Ablerta, Alta, Ab) do not create data retrieval problems later on.
For a detailed discussion of constraints in PPDM, refer to the PPDM Reference Guide on constraints, available on the PPDM web site.
