A method for associating the management and supervision dynamics of a drilling and completion operation database

Abstract

The present invention discloses a method for associating and managing the supervision dynamics of a drilling and completion operation database. The method includes the following steps: S1, establishing a supervision dynamics database; S2, associating the drilling and completion operation database; S3, associating attendance data; S4, uniquely identifying the identity of the drilling and completion supervisor; S5, querying operation log data; S6, judging the offshore status information of the drilling and completion supervisor; S7, generating "offshore / wellsite record - log" data; S8, generating "offshore / wellsite record - attendance" data; S9, proofreading the "offshore / wellsite record - log" data; S10, obtaining the basic information data of the supervised well and the data on the handling of complex situations and accidents in the supervised well; S11, writing the data into the supervision dynamics database. The beneficial effects of the present invention are as follows: It can realize the automated and informatized management of supervision dynamics, improve the management efficiency and quality, and eliminate the fraud risks that may exist in manual management.

Description

Technical Field

[0001] The present invention relates to the technical field of petroleum, and particularly relates to a method for associating and supervising the dynamics of a well drilling and completion operation database management. Background Art

[0002] Under the daily fee system model for well drilling and completion operations, Party A (oil company) settles accounts with the contractor (drilling company) according to the operation time, and Party A (oil company) is responsible for all technical measures and costs.

[0003] Well drilling and completion supervision is the full-time representative of Party A (oil company) on the well site, comprehensively responsible for on-site production management, organizing and coordinating the work of the contracting unit according to the contract provisions, and being responsible for the safety, environmental protection, health, quality, progress, cost, well control, etc. of the well drilling and completion project. It is the main responsible person on the well drilling and completion operation site.

[0004] Under the daily fee system model, well drilling and completion supervision is even more the first responsible person for work safety and the first responsible person for well control. It is the core position in well drilling and completion operations. Its technical ability level and operation management level are the key factors affecting the quality, safety, and progress of well drilling and completion operations.

[0005] In order to ensure the quality and safety of well drilling and completion operations, it is necessary to evaluate the technical ability level and operation management level of well drilling and completion supervision. Information such as the number of wells supervised, the time at sea / on the well, the type of well being operated, the difficulty of the well being operated, the risk category of the well being operated, and various accidents and complex situations involved in the operation process, that is, the supervision dynamics, is one of the main factors that need to be evaluated.

[0006] Currently, the statistics and management of supervision dynamics are carried out manually, mainly relying on personal reporting and personal evidence collection. It is difficult to verify manually, with low efficiency and poor quality, and there is a risk of fraud, far from reaching the level of informatized scientific management.

[0007] The well drilling and completion operation database, also known as the well drilling and completion history database, well drilling and completion engineering database, etc., is a database system that records operation data during well drilling and completion (such as basic information of the well being operated, operation logs, drilling parameters, downhole tools, etc.). It is reviewed by the main responsible person for the operation (well drilling and completion supervision) and then uploaded, and an operation daily report is generated and sent to the project team (superior unit). The data will go through multiple levels of review and be locked in the database after ensuring its accuracy.

[0008] Currently, such systems all establish databases with the well being operated as the unit, focusing on wellbore data. The records of the main responsible person for the operation (well drilling and completion supervision) are simple, only including the name and position recorded in the operation log, without other specific information; there is no unique identifier that can identify an individual, and it is difficult to determine the identity of the supervisor when there are homonyms.

[0009] The offshore personnel tracking and management system is a network management system established to promptly grasp the whereabouts and work records of offshore personnel and strengthen the dynamic management of offshore operation personnel. It can standardize the application and approval process for offshore operations, ensure that safety management personnel and enterprise managers are aware of the personnel dynamics at sea and on land, and can also serve as part of the offshore emergency command system to provide effective information and data.

[0010] Currently, most such systems use radio frequency cards as offshore certificates for identity recognition. Most of the relevant information about the employee (such as: photo, name, age, validity period of various qualification certificates, and some data required in case of emergencies) will be integrated on this card. Offshore operation personnel need to swipe the card for registration when landing on and leaving offshore facilities. The system records the information of landing on and leaving the facilities, which serves as the data of the dynamics of offshore personnel, thereby realizing the dynamic management of offshore personnel.

[0011] This type of system relies on offshore facilities and focuses on the approval process management of landing facilities and the management of facility personnel. For well drilling and completion supervision, it only registers the information of offshore personnel landing on and leaving the facilities, without registering the well name of the operation well, the difficulty of the operation well, the risk type of the operation well, and the information on participating in handling various accidents and complex situations during the operation process, etc. This type of system includes an offshore certificate number as the unique identification number for personnel. Since the facility management mode for onshore well drilling and completion operations is different from that for offshore operations, there is currently no such system for onshore operations, but there will be similar attendance systems or attendance records. Summary of the Invention

[0012] The purpose of the present invention is to provide a method for managing and supervising the dynamics associated with the well drilling and completion operation database. By establishing a supervision dynamics database and associating it with the well drilling and completion operation database, the problem of unique identification of the supervision identity in the well drilling and completion operation database is solved, so as to realize the automated and informatized management of supervision dynamics, improve the management efficiency and quality, and eliminate the possible fraud risks in manual management.

[0013] To achieve the above purpose, the present invention adopts the following technical solutions, including the following steps:

[0014] S1. Establish a supervision dynamics database with the well drilling and completion supervision data as the object;

[0015] S2. Associate the supervision dynamics database with the well drilling and completion operation database;

[0016] S3. Associate attendance data;

[0017] S4. Conduct unique identification of the well drilling and completion supervision identity;

[0018] S5. Query the well drilling and completion operation database, read the operation log data in the well drilling and completion database, and extract the records of the well drilling and completion supervision in the operation personnel information;

[0019] S6. Judge the offshore status information of the drilling and completion supervision.

[0020] S7. Judge the start and end time information of going offshore / going to the well, and generate the data of "Offshore / Going to the Well Record - Log".

[0021] S8. Generate the data of "Offshore / Going to the Well Record - Attendance" through the attendance data in step S3.

[0022] S9. Proofread the data of "Offshore / Going to the Well Record - Log" with the data of "Offshore / Going to the Well Record - Attendance".

[0023] S10. Query the drilling and completion operation database in step S5 to obtain the basic information data of the supervised well and the data of the complex situation and accident handling of the supervised well.

[0024] S11. Summarize the data obtained in step S10 and step S9, and write them into the supervision dynamic database.

[0025] Further, in step S1, the drilling and completion supervision data in the supervision dynamic database includes personal basic information, rank information and on-site operation information; the personal basic information includes name, gender and age; the rank information includes the supervision level and the tenure of the supervision level; the on-site operation information includes name, supervision level, name of the well under operation and start and end time.

[0026] Further, in step S1, the drilling and completion supervision data in the supervision dynamic database also includes; daily status information, monthly offshore / going to the well days, annual offshore / going to the well days, annual number of wells under operation, number of wells with difficult or risky operations, number of wells with complex accidents handled, types of complex accidents handled and basic information of the wells involved in the operation; the daily status information includes whether it is in the offshore / going to the well state and the cumulative number of offshore / going to the well days this time.

[0027] Further, in step S2, the supervision dynamic database is associated with the drilling and completion operation database, and the association methods include directly connecting to the database and connecting to the database through WebAPI.

[0028] Further, in step S3, when associating the attendance data, a one-to-one correspondence is established between the supervision identity information in the supervision dynamic database and the supervision identity in the attendance data.

[0029] Further, in step S4, the method a for uniquely identifying the drilling and completion supervision identity includes the following steps:

[0030] S401a. Add the unique identification number a of the drilling and completion supervision to the drilling and completion operation database.

[0031] S402a. Add the unique identification number b of the drilling and completion supervision to the supervision dynamic database;

[0032] S403a. Establish a one-to-one correspondence between the unique identification number a and the unique identification number b of the drilling and completion supervision. During the process of querying the drilling and completion operation database, use the unique identification number a of the drilling and completion supervision as a constraint condition for data query.

[0033] Furthermore, in step S4, the method b for uniquely identifying the identity of the drilling and completion supervision includes the following steps:

[0034] S401b. Read the personal basic information, rank information, and attendance data of the supervisor in the supervision dynamic database;

[0035] S402b. Judge by name. If there is no duplicate name, the uniqueness of the identity can be determined, and then use the name as a constraint condition to query data in the drilling and completion operation database;

[0036] S403b. If there is a duplicate name, judge by name and rank information. If there is no complete coincidence, then use the name and rank information as a constraint condition to query data in the drilling and completion operation database;

[0037] S404b. If the name and rank information both coincide, and if the well name in the attendance data can be found, judge by name, rank information, and well name. If there is no complete coincidence, then use the name, rank information, and well name as a constraint condition to query data in the drilling and completion operation database;

[0038] S405b. If the well name in the attendance data cannot be found, then find the working facility in the attendance data and determine the well name according to the working facility and the time at the facility; if there is no record of the working facility, feedback to the relevant personnel for verification and supplement the data in the attendance information and confirm the well name; after confirming the well name, judge by name, rank information, and well name. If there is no complete coincidence, then use the name, rank information, and well name as a constraint condition to query data in the drilling and completion operation database;

[0039] S406b. In the special case where supervisors with the same name and rank information participate in the operation of the same well at the same time, feedback to the relevant personnel and adopt the method of special marking and manual verification in the attendance information for judgment.

[0040] Furthermore, in step S8, the steps for generating the "Offshore / Wellsite Record - Attendance" data are as follows:

[0041] S801. According to whether there is an offshore personnel tracking system, if so, directly call the interface of the offshore personnel tracking system to obtain the supervisor's attendance information and generate the "Offshore / Wellsite Record - Attendance" data;

[0042] S802. If there is no offshore personnel tracking system, according to whether there is an attendance system, if there is, directly call the attendance data interface to obtain the supervised attendance information and generate the "offshore / onshore well record - attendance" data;

[0043] S803. If there is no attendance system, according to whether there is an attendance sheet, if there is, read the attendance data table to obtain the supervised attendance information and generate the "offshore / onshore well record - attendance" data;

[0044] S804. If there is no attendance sheet, generate the "offshore / onshore well record - attendance" data by filling in the offshore / onshore well information in the supervision dynamic system.

[0045] Further, in step S10, the supervised working well basic information data includes recording the working well difficulty and risk level and recording the working well type; the supervised working well complexity and accident handling situation data includes recording the complex accident type and the handling process.

[0046] The beneficial effect of the present invention is: by establishing a supervision dynamic database and associating it with the drilling and completion operation database, the problem of unique identification of the supervision identity in the drilling and completion operation database is solved, so as to realize the automated and informatized management of the supervision dynamic, improve the management efficiency and quality, and eliminate the fraud risk that may exist in manual management. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 is a flowchart of a method for managing the supervision dynamic by associating with the drilling and completion operation database according to the present invention.

[0048] Figure 2 is the flowchart of the method for uniquely identifying the drilling and completion supervision identity in the present invention Figure 1 .

[0049] Figure 3 is the flowchart of the method for uniquely identifying the drilling and completion supervision identity in the present invention Figure 2 .

[0050] Figure 4 is the flowchart of generating the "offshore / onshore well record - attendance" data in the present invention. DETAILED DESCRIPTION OF THE INVENTION

[0051] The following further elaborates on the invention with reference to the accompanying drawings, so that those skilled in the art can implement it according to the description in the specification.

[0052] It should be understood that the terms such as "having", "including" and "comprising" used herein do not exclude the presence or addition of one or other elements or their combinations.

[0053] Such as Figures 1-4As shown in the figure, a method for managing and supervising the dynamics of a database related to drilling and completion operations according to the present invention includes the following steps:

[0054] S1. Taking the drilling and completion supervision data as the object, a supervision dynamics database is established. As a preference, the supervision dynamics database can be established based on database management systems such as MYSQL, SQL server, Access, and MongoDB, or YAML, XML, and json structured texts can also be used as the "database" to save data. As a preference, the supervision dynamics database adopts the MYSQL database. As a further preference, in step S1, the data in the supervision dynamics database includes personal basic information, rank information, and on-site operation information; the personal basic information includes name, gender, and age; the rank information includes the supervision level and the tenure of the supervision level; the on-site operation information includes name, supervision level, the name of the operation well, and the start and end times.

[0055] S2. Associating the supervision dynamics database with the drilling and completion operation database. As a preference, the association methods include directly connecting to the database and connecting to the database through WebAPI.

[0056] S3. Associating attendance data.

[0057] S4. Uniquely identify the identity of the drilling and completion supervisor. As an optimization, in step S4, the method a for uniquely identifying the identity of the drilling and completion supervisor includes the following steps: S401a. Add the unique identification number a of the drilling and completion supervisor to the drilling and completion operation database; S402a. Add the unique identification number b of the drilling and completion supervisor to the supervision dynamic database; S403a. Establish a one-to-one correspondence between the unique identification number a of the drilling and completion supervisor and the unique identification number b of the drilling and completion supervisor. During the process of querying the drilling and completion operation database, use the unique identification number a of the drilling and completion supervisor as a constraint condition for data query. As a further optimization, in step S4, the method b for uniquely identifying the identity of the drilling and completion supervisor includes the following steps: S401b. Read the personal basic information, rank information, and attendance data of the supervisor in the supervision dynamic database; S402b. Judge by name. If there is no duplicate name, the uniqueness of the identity can be determined, and then use the name as a constraint condition to query the data in the drilling and completion operation database; S403b. If there is a duplicate name, judge by name and rank information. If there is no exact match, then use the name and rank information as a constraint condition to query the data in the drilling and completion operation database; S404b. If the name and rank information are both the same, if the well name in the attendance data can be found, judge by name, rank information, and well name. If there is no exact match, then use the name, rank information, and well name as a constraint condition to query the data in the drilling and completion operation database; S405b. If the well name in the attendance data cannot be found, then find the working facility in the attendance data, and determine the well name according to the working facility and the time at the facility; if there is no record of the working facility, feedback to the relevant personnel for verification and supplement the data in the attendance information and confirm the well name; after confirming the well name, judge by name, rank information, and well name. If there is no exact match, then use the name, rank information, and well name as a constraint condition to query the data in the drilling and completion operation database; S406b. In the special case where supervisors with the same name and rank information participate in the operation of the same well at the same time, feedback to the relevant personnel and adopt the method of special marking and manual verification in the attendance information for judgment.

[0058] S5. Query the drilling and completion operation database, read the operation log data in the drilling and completion database, and extract the records of the drilling and completion supervisor in the operation personnel information.

[0059] S6. Judge the offshore status information of the drilling and completion supervisor.

[0060] S7. Judge the start and end time information of going offshore / going to the well, and generate the data of "offshore / going to the well record - log".

[0061] S8. Generate the "Offshore / Wellsite Record - Attendance" data based on the attendance data in step S3. As an optimization, in step S8, the steps for generating the "Offshore / Wellsite Record - Attendance" data are as follows: S801. According to whether there is an offshore personnel tracking system, if so, directly call the interface of the offshore personnel tracking system to obtain the supervised attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S802. If there is no offshore personnel tracking system, according to whether there is an attendance system, if so, directly call the attendance data interface to obtain the supervised attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S803. If there is no attendance system, check whether there is an attendance sheet. If so, read the attendance data sheet to obtain the supervised attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S804. If there is no attendance sheet, generate the "Offshore / Wellsite Record - Attendance" data by filling in the offshore / wellsite information in the supervised dynamic system.

[0062] S9. Proofread the "Offshore / Wellsite Record - Log" data with the "Offshore / Wellsite Record - Attendance" data.

[0063] S10. Query the drilling and completion operation database in step S5 to obtain the basic information data of the supervised work well and the data on the complex situation and accident handling of the supervised work well. As an optimization, the basic information data of the supervised work well includes recording the difficulty and risk level of the work well and the well type of the work well; the data on the complex situation and accident handling of the supervised work well includes recording the complex accident type and the handling process.

[0064] S11. Summarize the data obtained in steps S10 and S9 and write them into the supervised dynamic database.

[0065] In another embodiment, in step S1, the data in the supervised dynamic database includes personal basic information, rank information, and on-site operation information; the personal basic information includes name, gender, and age; the rank information includes the supervision level and the tenure of the supervision level; the on-site operation information includes name, supervision level, the name of the operation well, and the start and end times.

[0066] In another embodiment, in step S1, the drilling and completion supervision data in the supervised dynamic database further includes: daily status information, monthly offshore / wellsite days, annual offshore / wellsite days, annual number of operation wells, number of operation wells for difficult or risky wells, number of wells for handling complex accidents, types of complex accidents handled, and basic information of the wells involved in the operation; the daily status information includes whether it is in the offshore / wellsite status and the cumulative number of offshore / wellsite days for this time.

[0067] In another embodiment, in step S2, associate the supervised dynamic database with the drilling and completion operation database, and the association methods include directly connecting to the database and connecting to the database through WebAPI.

[0068] In another embodiment, when associating attendance data, a one-to-one correspondence is established between the supervision identity information in the supervision dynamic database and the supervision identity in the attendance data.

[0069] In another embodiment, in step S4, the method a for uniquely identifying the drilling and well completion supervision identity includes the following steps: S401a. Add the unique identification number a of the drilling and well completion supervisor to the drilling and well completion operation database;

[0070] S402a. Add the unique identification number b of the drilling and well completion supervisor to the supervision dynamic database;

[0071] S403a. Establish a one-to-one correspondence between the unique identification number a of the drilling and well completion supervisor and the unique identification number b of the drilling and well completion supervisor. During the process of querying the drilling and well completion operation database, use the unique identification number a of the drilling and well completion supervisor as a constraint condition for data query.

[0072] In another embodiment, in step S4, the method b for uniquely identifying the drilling and well completion supervision identity includes the following steps: S401b. Read the basic personal information, rank information, and attendance data of the supervisor in the supervision dynamic database; S402b. Judge by name. If there is no duplicate name, the uniqueness of the identity can be determined, and then use the name as a constraint condition to query the data in the drilling and well completion operation database; S403b. If there is a duplicate name, judge by name and rank information. If there is no complete coincidence, then use the name and rank information as a constraint condition to query the data in the drilling and well completion operation database; S404b. If the name and rank information are both coincident, and if the well name in the attendance data can be found, judge by name, rank information, and well name. If there is no complete coincidence, then use the name, rank information, and well name as a constraint condition to query the data in the drilling and well completion operation database; S405b. If the well name in the attendance data cannot be found, then find the working facility in the attendance data, and determine the well name according to the working facility and the time at the facility; if there is no record of the working facility, feedback to the relevant personnel for verification and supplement the data in the attendance information and confirm the well name; after confirming the well name, judge by name, rank information, and well name. If there is no complete coincidence, then use the name, rank information, and well name as a constraint condition to query the data in the drilling and well completion operation database; S406b. In the special case where supervisors with the same name and rank information participate in the operation of the same well at the same time, feedback to the relevant personnel and adopt the method of special marking in the attendance information and manual verification for judgment.

[0073] In another embodiment, in step S8, the steps for generating the "Offshore / Wellsite Record - Attendance" data are as follows:

[0074] S801. Check if there is an offshore personnel tracking system. If so, directly call the interface of the offshore personnel tracking system to obtain supervision attendance information and generate "Offshore / Wellsite Record - Attendance" data.

[0075] S802. If there is no offshore personnel tracking system, check if there is an attendance system. If so, directly call the attendance data interface to obtain supervision attendance information and generate "Offshore / Wellsite Record - Attendance" data.

[0076] S803. If there is no attendance system, check if there is an attendance sheet. If so, read the attendance data sheet to obtain supervision attendance information and generate "Offshore / Wellsite Record - Attendance" data.

[0077] S804. If there is no attendance sheet, generate "Offshore / Wellsite Record - Attendance" data by filling in offshore / wellsite information in the supervision dynamic system.

[0078] In another embodiment, in step S10, the supervision work well basic information data includes recording the work well difficulty and risk level, and recording the work well type; the supervision work well complexity and accident handling situation data includes recording the complex accident type and the handling process.

[0079] The beneficial effects of the present invention are as follows: By establishing a supervision dynamic database and associating it with the drilling and completion operation database, the problem of unique identification of the supervision identity in the drilling and completion operation database is solved, so as to realize the automated and informatized management of supervision dynamics, improve the management efficiency and quality, and eliminate the fraud risks that may exist in manual management.

[0080] Although the embodiments of the present invention have been disclosed as above, it is not limited to the applications listed in the specification and embodiments. It can be fully applied to various fields suitable for the present invention. For those familiar with the field, additional modifications can be easily made. Therefore, without departing from the general concept defined by the claims and the equivalent scope, the present invention is not limited to the specific details and the illustrated and described examples here.

Claims

1. A method for associating the management and supervision dynamics of a drilling and completion operation database, characterized in that It includes the following steps: S1. Take the drilling and completion supervision data as the object and establish a supervision dynamic database; S2. Associate the supervision dynamic database with the drilling and completion operation database; S3. Associate the attendance data; S4. Uniquely identify the drilling and completion supervision identity; S5. Query the drilling and completion operation database, read the operation log data in the drilling and completion database, and extract the records of the drilling and completion supervision in the operator information; S6. Judge the offshore status information of the drilling and completion supervision; S7. Judge the start and end time information of going offshore / going to the well, and generate the data of "offshore / going to the well record - log"; S8. Generate the data of "offshore / going to the well record - attendance" through the attendance data in step S3; S9. Proofread the data of "offshore / going to the well record - log" through the data of "offshore / going to the well record - attendance"; S10. Obtain the basic information data of the supervised working well and the data of the complex situation and accident handling of the supervised working well by querying the drilling and completion operation database in step S5; S11. Summarize the data obtained in steps S10 and S9 and write them into the supervision dynamic database.

2. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 1, wherein: In step S1, the drilling and completion supervision data in the supervision dynamic database includes personal basic information, rank information, and on-site operation information; the personal basic information includes name, gender, and age; the rank information includes the supervision level and the tenure of the supervision level; the on-site operation information includes name, supervision level, well name of the operation well, and start and end time.

3. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 2, wherein In step S1, the drilling and completion supervision data in the supervision dynamic database also includes; daily status information, monthly offshore / going to the well days, annual offshore / going to the well days, annual operation well times, operation well times of difficult wells or risky wells, complex accident handling well times, complex accident handling types, and basic information of the participating operation wells; The daily status information includes whether it is in the offshore / going to the well status and the cumulative offshore / going to the well days this time.

4. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 1 or 2, characterized in that, In step S2, when associating the supervision dynamic database with the drilling and completion operation database, the association methods include directly connecting the databases and connecting the databases through WebAPI.

5. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 1 or 2, characterized in that, In step S3, when associating the attendance data, establish a one-to-one correspondence between the supervision identity information in the supervision dynamic database and the supervision identity in the attendance data.

6. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 2, wherein In step S4, the method a for uniquely identifying the drilling and completion supervision identity includes the following steps: S401a. Add the unique identification number a of the drilling and completion supervision to the drilling and completion operation database; S402a. Add the unique identification number b of the drilling and completion supervision to the supervision dynamic database; S403a. Establish a one-to-one correspondence between the unique identification number a of the drilling and completion supervision and the unique identification number b of the drilling and completion supervision, and use the unique identification number a of the drilling and completion supervision as a constraint condition for data query during the process of querying the drilling and completion operation database.

7. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 2, wherein In step S4, the method b for uniquely identifying the drilling and completion supervision identity includes the following steps: S401b. Read the supervision personal basic information, rank information, and attendance data in the supervision dynamic database; S402b. Determine by name. If there are no duplicate names, the uniqueness of the identity can be determined, and then use the name as a constraint condition to query data in the drilling and completion operation database; S403b. If there are duplicate names, determine by name and rank information. If there is no exact match, then use the name and rank information as constraint conditions to query data in the drilling and completion operation database; S404b. If the name and rank information both match, and if the well name in the attendance data can be found, determine by name, rank information, and well name. If there is no exact match, then use the name, rank information, and well name as constraint conditions to query data in the drilling and completion operation database; S405b. If the well name in the attendance data cannot be found, then find the working facility in the attendance data, and determine the well name based on the working facility and the time at the facility; if there is no record of the working facility, feedback to the relevant personnel for verification and supplement the data in the attendance information and confirm the well name; after confirming the well name, determine by name, rank information, and well name. If there is no exact match, then use the name, rank information, and well name as constraint conditions to query data in the drilling and completion operation database; S406b. In the special case where supervisors with the same name and rank information participate in the operation of the same well at the same time, feedback to the relevant personnel and adopt the method of special marking and manual verification in the attendance information for judgment.

8. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 1 or 2, characterized in that In step S8, the steps to generate the "Offshore / Wellsite Record - Attendance" data are as follows: S801. According to whether there is an offshore personnel tracking system, if so, directly call the interface of the offshore personnel tracking system to obtain the supervisor attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S802. If there is no offshore personnel tracking system, according to whether there is an attendance system, if so, directly call the attendance data interface to obtain the supervisor attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S803. If there is no attendance system, according to whether there is an attendance sheet, if so, read the attendance data sheet to obtain the supervisor attendance information and generate the "Offshore / Wellsite Record - Attendance" data; S804. If there is no attendance sheet, generate the "Offshore / Wellsite Record - Attendance" data by filling in the offshore / wellsite information in the supervisor dynamic system.

9. The method for managing and supervising the dynamics of the associated drilling and completion operation database according to claim 1 or 2, characterized in that: In step S10, the basic information data of the supervisor's working well includes recording the difficulty and risk level of the working well and the well type of the working well; the data on the complexity and accident handling situation of the supervisor's working well includes recording the types of complex accidents and the handling process.

Images