As a subsystem of information integration, the drilling database is mainly used to manage the drilling construction data. The ultimate goal is:
Establish a unified and standardized drilling data dictionary;
Establishes regular data management to provide users with convenient and quick data retrieval methods;
Establish a heterogeneous data exchange and migration platform;
Generate professional reports;
Achieve professional graph drawing;
Drilling Engineering Design and computation are implemented.
The Database Management System for drilling engineering adopts the B/S structure, in ms. A set of web application systems developed based on the net technology. The web server uses Microsoft's Internet Information Server, and the data storage uses the Oracle9i database. The system architecture is shown in figure.
Drilling Engineering Database Management System is a database management system used to store and manage drilling construction data and drilling engineering design. It covers:
System Management: System Management is to configure and maintain the entire system, including: professional database configuration (access to parallel database data); dictionary maintenance, is the configuration of data tables in the system, including field unit and Chinese name, user management, role management, log management, password modification, historical logs, and Database Structure Maintenance, maintenance of the data table structure; privileged review acceptance is the review and acceptance of data that has not been reviewed and accepted.
Data entry allows you to input, modify, delete, and query data on the web.
Data review is performed on the input data through the Web.
Data acceptance is the final acceptance of the audited data through web.
Query Design: Design and save the data that needs to be frequently queried as a template.
Data Query: Use the designed query template for data query, and export the data as TXT and Excel files.
Drawing, including formation pressure and rupture pressure, Casing Strength curve, horizontal projection, vertical projection, and well body structure.
Report generation, including the basic data table of the well, the quality of the trajectory of the target well, the quality of the trajectory of the horizontal well, the data table of the inclined well, the data table of the well body structure, the amount of Drilling Fluid Materials, the bit Usage Table, the cement injection table, and the casing string structure data table and cement usage.
Drilling engineering design.