The Preliminary Specification Part CCXCV (PLM Part XXXIV)
Before we forget we need to pick up an important piece of technology that will work with all of the technologies in the Preliminary Specification. It's important to mention it here in the Petroleum Lease Marketplace as so many of the unique oil and gas attributes are stored within this module. The technology of course is the data model. And the data model that we are including in the Preliminary Specification is the industry standard PPDM (Professional Petroleum Data Management Association). This will provide a solid foundation for the innovative producer to base their ERP, engineering and geotechnical applications upon.
The PPDM Association defines and creates standards to help oil and gas companies manage exploration and production data. Included within the scope of their data model is the following data; general well header information, digital well log data, seismic location information, seismic data, land parcel information, reservoir field / pool information, faults and formations, geographical information, and surface grids. Although many of these data elements may seem outside of the ERP scope only seismic location information, seismic data, and faults and formations are outside. Particularly the land information, since we are in the Petroleum Lease Marketplace module, will be of significant value within an industry wide collaborative application.
The data model is currently quite large in the last upgrade PPDM suggest that just the upgrade is an addition of 500 tables. I am not a member of the association and am therefore not able to download the model and can’t tell what level of normalization the data model conforms to. Looking in the wiki however I see a number of tables with similar first names that have different second names. It would appear to me that the first name should be the table and the second name should be an attribute within that table. Therefore instead of 10 or 15 tables they would only need one table. However data models being data models it is difficult to understand them without a comprehensive look into them.
Many of the innovative oil and gas producers will already be using applications that access the PPDM data model. These would be for earth science and engineering applications primarily, and as a result we are building on the producers current infrastructure of technologies. In addition we are adding to the scope of applications that the technical staff are able to access and use their data for. Having well header information for engineering information that also references the accounting information provides real value for the engineer. I would suggest it is also something that is necessary as we get into some of the more complex accounting that we do in the Material Balance Report of the Accounting Voucher.
Data models are sophisticated architectures that reside within the Oracle database and provide a structure for the data to be stored and retrieved. The database ensures that the rules and requirements of the data are enforced so that elements of the database remain in balance and harmony. Database technology provides this value through the Oracle database and the data models that are developed. We will use the PPDM data model. Oracle will have developed their own data models for their Oracle Fusion Middleware Applications. And we will be developing our own data models for the data that is unique to the needs of the People, Ideas & Objects application modules. All of these data models will be employed by the same RDBMS (Relational Database Management System) that being the Oracle database. The size of these databases will be enormous.
For the industry to successfully provide for the consumers energy demands, it’s necessary to build the systems that identify and support the Joint Operating Committee. Building the Preliminary Specification is the focus of People, Ideas & Objects. Producers are encouraged to contact me in order to support our Revenue Model and begin their participation in these communities. Those individuals that are interested in joining People, Ideas & Objects can join me here and begin building the software necessary for the successful and innovative oil and gas industry.
Please note what Google+ provides us is the opportunity to prove that People, Ideas & Objects are committed to developing this community. That this is user developed software, not change that is driven from the top down. Join me on the People, Ideas & Objects Google+ Circle (private circle, accessible by members only) and begin building the community for the development of the Preliminary Specification.
The Preliminary Specification is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for People, Ideas & Objects products remains at the sole discretion of People, Ideas & Objects.