Data Schema Fundamentals

relational data concepts our data platform is built on top of postgresql https //www postgresql org/ postgresql is a powerful, open source object relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance our data schema enforces referential integrity this affects how records are inserted, the order in which they are inserted and how they are deleted the restful apis will not accept records which will break a referential constraint (e g inserting a daily production record for a well which does not yet exist in the well header table) read more relational database concepts https //en wikipedia org/wiki/relational database data ingest from wellview® and openwells® source systems the data ingest restful apis use the original source system ids as key fields for wellview and openwells the data schema documentation provides guidance as to which table/view and which column/value to use as the source system id guidance is provided for the well header, the wellbore and all other wellbore related data sets wellview is a registered trademark of peloton computer enterprises ltd openwells is a registered trademark of halliburton landmark crud operations database crud operations are performed using the rest apis detailed api tutorials and examples are available for postman tutorial docid\ lgtlviilhglckn 0qa8mg , python tutorial docid\ zpnzzc23zo2rjpamduwzx , and c# tutorial docid 3 nzuyhj6lz8oinqvbedy data must be pushed in the correct order to maintain referential integrity the api rest based post commands perform data upserts each upsert must pass a series of data validation checks to maintain referential integrity upserts that fail the data integrity check will be rejected table specific data integrity check rules are documented at the bottom of each table specification upserts if a duplicate record exists, the previous record will be upserted (overwritten) with the new data provided by the conflicting insert request the rest based post command will upsert if a record exists deletes cascade delete functionality is enabled this means that if a parent record is deleted, all child records will delete also (e g if a well header is deleted, all data related to that well is also deleted) the rest based delete command will delete data select various datasets are available for retrieval the rest based get command will return json based data sets these datasets can be used by other applications such as microsoft power bi or can be integrated into custom workflows, data warehouses or applications