top of page

Record Governance is needed to automate data exchange

Record governance is the third of five principles that will allow us to create enterprise systems that have an inherent capability to exchange data and aggregate it for reporting and AI.


Record governance is necessary because the same record may appear in many different systems and we need to know which version to trust.


When a system creates a record, it automatically governs it, and if needed, governance can be transferred to another system. For example, if an oil and gas company sells a well to another company, governance for the data related to the well would transfer to the new owner.


It is important to note that Record Governance applies to a group of records. For example, with well data there would be the main record and child records and even possibly grandchild records that relate to well that the new company would govern.


It is also important to note that records within a table can be governed by different systems. Oil Well data is a good example of that.


Record governance is greatly simplified by the fact that the primary key holds information that tells the system who created the record. That means we only need to keep track of exceptions where governance was transferred to another system.


Record governance is critical to data integrity and automatically aggregating data in data warehouses.


Please check out record governance at https://www.3d-ess.com/record-governance. I welcome your comments, questions and likes. Thank you for your attention.

1 view0 comments

Recent Posts

See All

Recursive selects to rollup financial data

In this post I am going to describe the financial roll-up procedure that was developed using Postgres that is a part of an enterprise system platform that has an inherent capability to exchange data b

Need help creating an application framework

In this post, I have a #QuestionForGroup about creating an application framework to connect to the open-source platform I created using Postgres. The platform allows us to create enterprise systems th

Automatically consolidate data into a Data Warehouse

In this post I am going to describe the data warehouse generate procedure (DW procedure) that was developed using Postgres that is a part of an enterprise system platform that has an inherent capabili

Comments


bottom of page