Well Reporting System - Database Design

Data storage

The foundation of the Well Reporting System is a well defined relational database.  Data is stored in tables that are logically related.  Because of these relations, data can be collected in a manner that is logical in the context of a well.  When a report or data summary is required, the data is consolidated on the basis of the logical data relations without any user actions being required.

The top level structure of the database, forming the primary data relation is defined as shown in the diagram.  A database may contain any number of wells and each well may contain any number of wellpaths, BHA runs and Daily Drilling Reports.

To understand the secondary data relation, consider the Daily Operations log.  Each activity, in addition to the usual data, is labeled with a BHA number (if applicable to that operation).  Various BHA run summary data – such as depth in/out, drilling hours, etc. – can be calculated by the program.  Directional survey data is stored under the Wellpath so that on the basis of a Wellpath reference (input on the BHA) and the calculated depth in/out, directional survey data relevant for the BHA run can be retrieved from the database.  All it takes to complete this process is to ensure all data input is correct and click the Calculate button.  It’s as easy as that!!

Fully scalable database

The Well Reporting System uses the Advantage Database Server.  Advantage may be installed on the same computer as the Well Reporting System but can also be installed centrally on a server.  Whichever version is installed, it requires little to no maintenance.  A dedicated database administrator is not required.

The Advantage Database Server is available in two editions:

The free LOCAL version is installed with the Well Reporting System and is used to connect to a database on a computer or network location.  Technically it is allowed to connect 5 simultaneous users to the same database, but this is not recommended.

The CLIENT/SERVER edition is the best solution for an environment where multiple users simultaneously connect to the same database on a centralized server.  The Client/Server edition is better suited for these environments because it provides transaction control.  Transaction control allows writing multiple changes to the database in an “all or nothing” manner.  This is especially important in a multi-user environment where several interdependent records (for example survey records, where each record is calculated from the previous record) must be stored in the database without the risk of data corruption due to two or more users attempting to store the same data.  The Client/Server is an additional purchase available in 2- to 100-user editions.  Please contact us for further information.

The Well Reporting System can connect to both versions.  This makes the database fully scalable, allowing it to grow with your operations and company.

Consistent units of measurement

Through the Softdrill NL proprietary framework that handles units of measurement, it is possible to store all data in the database in consistent units.; i.e. for all wells in the database all lengths are stored in feet, all weights in pounds and so on. On-screen and printed data is converted to the user’s preferred units and converted back when storing in the database.

Storing all data in consistent units makes it possible to effectively query the database across all wells in a single operation.