Spatial Data Models for the E&P Industry
The PPDM data model is robust and comprehensive data model for effectively managing data and processes in transactional systems, or for use as a corporate master data store. Fully enabling such a voluminous corporate Data model was a daunting task and may not return value in proportion to the efforts applied. So the next project intended to simplify the data model that will focus on high level spatial data that will be used for GIS browsing applications and for Geological and Geophysical (G&G) users.
The resulting light weight model, released publicly, is PPDM Lite 1.0. In some implementations, PPDM Lite may be thought of as a simple warehouse or data mart model. If desired, PPDM Lite 1.0 may be spatially enabled using a GIS system. For most implementations, PPDM Lite will be maintained through automated processes from PPDM 3.7. Also the project thought of considering additional data types intended by the E&P industry to include in to PPDM in the coming days.
The phase V of the project that started in January 2005 started on working on adding new areas to PPDM Lite, extending its usefulness to the energy sector.
The deliverables of the project were:
- Methodology to create subset of PPDM
- DDL to create database according to business requirements. (DDL stands for Data Definition Language and is part of the SQL language responsible for defining and managing all objects in a database.)
- Reference Material
The PPDM Lite 1.0 Architectural principle guide has been revised and released in February 2005. This document contains the rules and guidelines that govern the development of the PPDM Lite data model.
Modules in PPDM Lite
Sometimes users may need to access more information out of the master data in PPDM Lite. In this case, users can join master database and the required databases.
There are around 20 modules in the PPDM Lite 1.0 which the user can use in their projects .
Creating PPDM Lite
The PPDM Lite reference guide is freely available for download from the PPDM website. The reference guide is to help- managers, analysts, database administrators, programmers and data managers understand how to implement PPDM Lite 1.0. This guide also provides a Step-by-Step implementation of PPDM Lite. The implementation can be done in a different number of ways. As a stand-alone database, a GIS enabled database, GIS from-end to PPDM 3.1 or an integrated section within PPDM 3.7.
| Modules in PPDM Lite | |
| Business Associates | Licenses |
| Contracts | Production |
| Entitlements | Records Management |
| Facility | Reserves |
| Financial | Seismic |
| Field/Pool | Spatial |
| Interest Sets | Stratigraphy |
| Land Rights | Licenses |
| Meta Model | Support Facility |
| Projects | |
ArcGIS Pipeline Data Model - APDM
The ArcGIS Pipeline Data Model (APDM) is a geodatabase model which is intended to meet the needs of gas and liquid transmission pipelines. The APDM was developed by members of the ESRI Pipeline Interest Group steering and technical committees that includes representatives from pipeline and pipeline vendor companies, under the guidance of ESRI. The purpose of APDM is to capture the ‘behavior’ of pipeline events, features and objects within a geodatabase object model. The development of the model started up in 2002 and as on June 2006 version 4 has been released. The APDM is designed to be a template, not a standard.
The APDM was derived in part from established pipeline data models: Integrated Spatial Analysis Technology (ISAT), Pipeline Open Data Standard (PODS), and Industry Standard Pipeline Data Management (ISPDM). These three models are designed for industry-standard relational database management systems. The APDM is designed to fully exploit ESRI geodatabase technology. The feature classes in the APDM were derived from the tables contained in the ISPDM, ISAT, and PODS models. The salient attributes found in the feature classes of the APDM can be found in the attributes of the tables in the PODS, ISAT, and ISPDM models.
The model was designed to include a sampling of standard features typically by the used pipeline companies but was tailored to include items such as Integrity, Pipe Inspection, high-consequence areas, and risk analysis. The APDM was designed to be a template from which a pipeline company would start with the core elements of the model and modify the model by adding features or refining existing features.
A primary objective of the model was to account for linear referencing of features (stationing). Most transmission pipeline companies refer to the location of features or events that occur along the pipeline system as events occurring along a route (station series) at a certain distance (measure). Stationing was handled in the model using out-of-the-box technology referred to as routes and measures.