CN109492010B - Statistical method, device, equipment and storage medium for work records - Google Patents

Statistical method, device, equipment and storage medium for work records Download PDF

Info

Publication number
CN109492010B
CN109492010B CN201811435780.7A CN201811435780A CN109492010B CN 109492010 B CN109492010 B CN 109492010B CN 201811435780 A CN201811435780 A CN 201811435780A CN 109492010 B CN109492010 B CN 109492010B
Authority
CN
China
Prior art keywords
business activity
record
current
working
work
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
CN201811435780.7A
Other languages
Chinese (zh)
Other versions
CN109492010A (en
Inventor
李伟
胡元凌
周世恒
杨海滨
陈梦蛟
车永辉
郑凯洲
曾小明
唐成功
谷金鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China National Offshore Oil Corp CNOOC
Original Assignee
China National Offshore Oil Corp CNOOC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China National Offshore Oil Corp CNOOC filed Critical China National Offshore Oil Corp CNOOC
Priority to CN201811435780.7A priority Critical patent/CN109492010B/en
Publication of CN109492010A publication Critical patent/CN109492010A/en
Application granted granted Critical
Publication of CN109492010B publication Critical patent/CN109492010B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/103—Workflow collaboration or project management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/02—Agriculture; Fishing; Forestry; Mining

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Agronomy & Crop Science (AREA)
  • Animal Husbandry (AREA)
  • Marine Sciences & Fisheries (AREA)
  • Mining & Mineral Resources (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses a statistical method, a device, equipment and a storage medium of a working record, which are characterized in that the current working record is firstly obtained, then the business activity associated with the current working record is determined, then a working record index corresponding to the associated business activity is determined according to data generation logic, and then a working record obtaining request is sent to a recorder according to the working record index; and finally, determining the work record index to be acquired according to the current work record, the work record fed back by the recorder to the record acquisition request and the work record index. Therefore, the technical scheme provided by the embodiment determines the work record index through the service logic based on the service logic, and then obtains the work record according to the work record index and determines the work record to be obtained, so that the statistical efficiency of the work record is improved, and the real situation of the enterprise work record is accurately reflected.

Description

Statistical method, device, equipment and storage medium for work records
Technical Field
The embodiment of the invention relates to the technical field of data statistics, in particular to a statistical method, a statistical device and a storage medium for work records.
Background
The oil field enterprise is different from other industries and is an enterprise with complex and intensive technology, organization mechanisms are relatively independent, the business connection is close, the organization mechanisms are mutually supported, the data types are multiple, the sharing timeliness requirement is high, software and tools applied in the business process are numerous, the result types are various, the management modes of the results are also various, besides part of the results are managed in a relational database, and a large amount of result data are scattered in a report document or file. Besides partial filing and arrangement of the document data into a data center, a plurality of results are scattered in the hands of business personnel, on one hand, the documents cannot be shared and applied, and on the other hand, the documents have serious potential safety hazards.
In order to change the current situation, oil field enterprises develop data integration and data center construction work, develop data standards by integrally combing exploration and development services, and provide standard support for data resource construction. However, since no effective data resource completeness statistical method exists, data resource construction work is not improved obviously for a long time.
The previous statistics on the completeness of data resources only remain on the result analysis of Structured Query Language (SQL) statement Query statistics under various conditions set for a certain data table, and most of them can only be used for tables that periodically generate data, such as: daily production data, monthly production data, log records and the like are scanned table by table for service objects, on one hand, the scanning efficiency is low, ten hours of time are often needed for completing one-time scanning by an oil field enterprise with a medium data scale, and on the other hand, the statistical result is not satisfactory and the current situation of data resources cannot be truly reflected.
Disclosure of Invention
The invention provides a statistical method, a statistical device, equipment and a storage medium of a work record, which are used for improving the statistical efficiency of the work record and accurately reflecting the real situation of the work record of an enterprise.
In a first aspect, an embodiment of the present invention provides a statistical method for a work record, where the method includes:
acquiring a current working record;
determining business activities related to the current working record;
determining a working record index corresponding to the associated business activity according to the data generation logic;
sending a work record acquisition request to a recorder according to the work record index;
and determining a working record index to be acquired according to the current working record, the working record fed back to the record acquisition request by the recorder and the working record index.
In a second aspect, an embodiment of the present invention further provides a device for counting work records, where the device includes:
the current record acquisition module is used for acquiring a current working record;
the business activity determining module is used for determining the business activity related to the current working record;
the record index determining module is used for determining a work record index corresponding to the associated business activity according to the data generating logic;
the recording request acquisition module is used for sending a working record acquisition request to a recorder according to the index of the working record;
and the to-be-acquired record determining module is used for determining the to-be-acquired work record index according to the current work record, the work record fed back to the record acquisition request by the recorder and the work record index.
In a third aspect, an embodiment of the present invention further provides an apparatus, where the apparatus includes:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the statistical method of work records as described in the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, which when executed by a processing apparatus, implements the statistical method for work records as described in the first aspect.
According to the statistical method, the statistical device, the statistical equipment and the statistical storage medium for the working records, the current working record is obtained firstly, then the business activity associated with the current working record is determined, then the working record index corresponding to the associated business activity is determined according to the data generation logic, and then the working record obtaining request is sent to the recording party according to the working record index; and finally, determining the work record index to be acquired according to the current work record, the work record fed back by the recorder to the record acquisition request and the work record index. Therefore, the technical scheme provided by the embodiment determines the work record index through the service logic based on the service logic, and then obtains the work record according to the work record index and determines the work record to be obtained, so that the statistical efficiency of the work record is improved, and the real situation of the enterprise work record is accurately reflected.
Drawings
FIG. 1 is a flow chart of a statistical method of work records according to a first embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a work record statistics system according to a first embodiment of the present invention;
FIG. 3 is a flow chart of a statistical method of work records according to a second embodiment of the present invention;
FIG. 3a is a diagram of an activity table according to a second embodiment of the present invention;
FIG. 3b is a diagram illustrating monthly completed workload in the second embodiment of the present invention
FIG. 4 is a schematic structural diagram of a statistical apparatus for working records according to a third embodiment of the present invention;
fig. 5 is a schematic structural diagram of a terminal device in the fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a statistical method of a work record according to a first embodiment of the present invention. The present embodiment is applicable to the situation of counting the work records of each place, and the statistical method for the work records provided by the present embodiment may be executed by a statistical device for the work records, and the statistical device for the work records may be implemented by software and/or hardware. The statistical means for setting the work records are integrated in the terminal device, i.e. the statistical method for the work records is performed by the terminal device. The terminal device is a device having a function of inputting a program and data to a computer or receiving a processing result output from the computer. The terminal device includes, but is not limited to, mobile terminals such as notebook computers, smart phones, tablet computers, and portable multimedia playing devices, and fixed terminals such as digital TVs and desktop computers.
In this embodiment, the oilfield enterprise is an enterprise with complex and intensive operations, and relates to a plurality of operations such as physical exploration, shaft engineering, analysis and assay, comprehensive research, development and production, and operation management, and the organizations are relatively independent and have close business connection and support each other. Therefore, the working records of each organization need to be counted and summarized, and the defects need to be checked and repaired, so as to query the working conditions of each organization, grasp the working conditions of each organization more macroscopically, and provide a favorable reference for making a later working plan.
Specifically, as shown in fig. 1, the statistical method for work records provided in the embodiment of the present invention mainly includes the following steps:
and S110, acquiring the current working record.
In this embodiment, the work record refers to a corresponding record of a business, organization or individual after completing a work. The current work record is the work plan that can be seen in the staff's field of view. Further, current working records include, but are not limited to: current work data, current object instance, current object type, and current completed workload, etc.
Further, the current working data refers to data already existing in the activity table, and the current object instance is an object instance already existing in the working index. For example, an object instance may be a well in an oilfield enterprise. The current object type refers to the type corresponding to the object instance in the data set. For example, in an oilfield enterprise, a well is present in the type "already present". The current completed workload refers to the completed workload within a time period that has been counted. Further, currently completed workloads include, but are not limited to: daily completed workload, monthly completed workload, quarterly completed workload, annual monthly completed workload, etc.
Further, the trigger mode for acquiring the current working record can be set according to the actual situation. For example, the setting trigger key may be a virtual key located on a touch screen of the terminal device. Illustratively, the counted activity table is displayed on a touch screen, and if an operation that a user clicks or touches a work record in the activity table is obtained, a current work record corresponding to the clicking or touching operation is obtained. For another example, after the terminal device executes the set function or instruction, the current working record is automatically generated and acquired.
And S120, determining the business activity associated with the current working record.
In this embodiment, the business activities refer to activities of the enterprise when the enterprise operates. Different associated business activities may be determined based on the nature of the enterprise and the association between businesses. Exemplary, oilfield enterprise business activities include, but are not limited to: physical exploration, shaft engineering, analysis and test, comprehensive research, development and production, management and the like.
Determining the business activity associated with the current work record refers to determining the associated business activity that has occurred according to the existing work record. Further, the present embodiment provides 4 cases of determining the associated business activity from the current working record.
In this embodiment, if the current working record is the current working data, the business activity associated with the current working data is determined according to the current working data. In practical applications, the current working data must be generated by its corresponding business activity. Therefore, after the current working data is acquired, the associated business activity can be determined according to the corresponding relation between the current working data and the business activity. For example, when the current working data is "200 meters deep in the activity list," it may be determined that the "well construction" business activity has been completed. Namely, the well building business activity is the business activity related to the current working data of the well depth of 200 meters.
In this embodiment, if the current working record is the current working data, the business activity associated with the current object instance is determined according to the current object instance and the business activity relationship. Business activity relationships refer to the relationships between activities that complete a task. Illustratively, the object instance is "well XX", and the business activities associated with well XX may include "physical exploration", "comprehensive research", and other related business activities. It should be noted that, the embodiment only describes the business activity relationship, but is not limited thereto. The business activity relationship can be set and modified according to the actual situation.
In this embodiment, if the current work record is the current object type, the business activity associated with the current object type is determined according to the current object type and the business type relationship. Business type relationships refer to relationships between types of individual business activities. For example, in an oilfield enterprise, if a well exists in the type "already exists", this indicates that the well has been completed, and then the necessary business activities in the well construction stages, such as drilling, logging, etc., must have occurred, and then "drilling" and "logging" are the associated business activities determined according to the current object type.
In this embodiment, if the current work record is the current completed workload, the service activity associated with the current completed workload is determined according to the current completed workload. Further, currently completed workloads include, but are not limited to: daily completed workload, monthly completed workload, quarterly completed workload, annual monthly completed workload, etc. For example, by exploring the monthly workload table, the workload that has been completed in this month can be obtained, i.e., the number of wells drilled and the well name or number can be obtained in this month, so that the business activity corresponding to the well name or number is completed.
S130, determining a working record index corresponding to the associated business activity according to the data generation logic.
In this embodiment, the data generation logic refers to the logical relationship between business activities and work records. The working record index refers to that all working records needing statistics are made into an index structure. The work record index comprises all the work record data needing statistics. Preferably, the work record index is tree-structured.
Further, the data generation logic comprises: logic for generating corresponding work records after the business activity occurs; after the business activity occurs, the specific object instance generates the logic of the corresponding work record. Further, the logic of generating the corresponding work record after the business activity occurs means that the work record is necessarily generated after the business activity occurs. Illustratively, the business activity is well building, and then after the business activity of well building is completed, the data of working record well depth is generated.
Further, the data generation logic further comprises: after the business activity occurs, the specific object instance generates the logic of the corresponding work record. Further, after the business activity occurs, some data can be generated and some data can not be generated according to different object instances. For example, when a well is a "vertical well", a work record of "well depth" is generated, and data of "well deviation" is not available. When a well is a "directional well," well deviation data exists while the working record of "well depth" is generated.
And S140, sending a work record acquisition request to the recorder according to the work record index.
In this embodiment, the recording side refers to an organization structure or individuals distributed to record business activity data everywhere. Determining the working record required to be acquired according to the working record index, generating a working record acquisition request according to the working record required to be acquired, and sending the working record acquisition request to a recorder. Further, the number of the recording sides is at least one. Fig. 2 is a schematic structural diagram of a work record statistics system according to a first embodiment of the present invention. As shown in fig. 2, the work record statistical system mainly includes a statistical party 210 and a recording party 220, and the recording party 220 includes N recording parties. The statistical party 210 sends the work record acquisition request to the corresponding recording party 220, and the recording party 220 uploads the corresponding work record according to the work record acquisition request. Further, the logger 220 may determine the work record uploading mode according to the actual situation. For example: the work records can be uploaded by the staff in a mode of inputting in a fixed input box. For another example: the working record can be uploaded in a mode of character recognition after the camera of the recording party is used for scanning. The camera can be a built-in camera of the terminal equipment, and can also be an external camera for point connection. For another example: the camera of the recorder can be used for shooting the photos of the bills or the paper work records and directly uploading the photos. In this embodiment, only the job record uploading method is described, but not limited. And a proper work record uploading mode can be selected according to actual conditions.
S150, determining a work record index to be acquired according to the current work record, the work record fed back by the recorder to the work record acquisition request and the work record index.
In this embodiment, the working record fed back by the recorder to the working record obtaining request refers to the working record uploaded to the system by the recorder according to the working record obtaining request.
And screening out the work records and the work record indexes fed back by the recorder to the work record acquisition request according to the current work record, and determining the work record index to be acquired for the work record which is not acquired.
Further, the work records to be acquired are determined according to the work record indexes to be acquired, and a work record acquisition request is generated, so that a recording party uploads the work records according to the work record acquisition request. Further, the work record index to be acquired can be determined continuously according to the requirement until the work record index to be acquired does not exist, that is, no work record to be acquired exists. Therefore, completeness of data can be guaranteed, and omission or missing of working records in enterprises is avoided.
The statistical method for the work records provided by this embodiment includes obtaining a current work record, determining a business activity associated with the current work record, determining a work record index corresponding to the associated business activity according to a data generation logic, and sending a work record obtaining request to a recording party according to the work record index; and finally, determining the work record index to be acquired according to the current work record, the work record fed back by the recorder to the record acquisition request and the work record index. Therefore, the technical scheme provided by the embodiment determines the work record index through the service logic based on the service logic, and then obtains the work record according to the work record index and determines the work record to be obtained, so that the statistical efficiency of the work record is improved, and the real situation of the enterprise work record is accurately reflected.
Example two
FIG. 3 is a flow chart of a statistical method of work records according to a second embodiment of the present invention; on the basis of the foregoing embodiment, the present embodiment further optimizes a statistical method of the work records, as shown in fig. 3, the optimized statistical method of the work records mainly includes the following steps:
and S310, acquiring the current working record.
In this embodiment, the current work plan includes, but is not limited to: current work data, current object instance, current object type, and current completed workload, etc.
Further, the current working data refers to data already existing in the activity table. For example, fig. 3a is a schematic diagram of an activity table in the second embodiment of the present invention. As shown in fig. 3a, data 1, data 2, and data 3 are the current working data described in this embodiment. It should be noted that the working record may be provided by a recording party or a statistical party.
Further, the current object instance is an object instance already existing in the working index. For example, an object instance may be a well in an oilfield enterprise. The current object type refers to the type corresponding to the object instance in the data set. For example, in an oilfield enterprise, a well is present in the type "already present".
The current completed workload refers to the completed workload within a time period that has been counted. Further, currently completed workloads include, but are not limited to: daily completed workload, monthly completed workload, quarterly completed workload, annual monthly completed workload, etc. FIG. 3b is a diagram illustrating monthly completed workloads in accordance with the second embodiment of the present invention. As shown in fig. 3b, the completed workload may be represented in the form of a table. The completed work volume includes at least the number of completed works and the name of the corresponding completed work.
S320, determining business activities related to the current working data according to the current working data; or determining the business activity associated with the current object instance according to the current object instance and the business activity relationship; or determining the business activity related to the current object type according to the current object type and the business type relation; or determining the business activity related to the current completed workload according to the current completed workload.
In this embodiment, the business activity associated with the current working data is determined according to the current working data. In practical applications, the current working data must be generated by its corresponding business activity. Therefore, after the current working data is acquired, the associated business activity can be determined according to the corresponding relation between the current working data and the business activity. As shown in fig. 3a, if data 1 data exists in the activity table, it can be determined that service B is a service activity associated with data 1 data. If data 2 data exists, then it may be determined that "service C service is a service activity associated with" data 2 data. If data 3 data exists, then service E may be determined to be the service activity associated with data 3 data.
In this embodiment, if the current working record is the current working data, the business activity associated with the current object instance is determined according to the current object instance and the business activity relationship. Business activity relationships refer to the relationships between activities that complete a task. Illustratively, the object instance is "well XX", and the business activities associated with well XX may include "physical exploration", "comprehensive research", and other related business activities. It should be noted that, the embodiment only describes the business activity relationship, but is not limited thereto. The business activity relationship can be set and modified according to the actual situation.
In this embodiment, if the current work record is the current object type, the business activity associated with the current object type is determined according to the current object type and the business type relationship. Business type relationships refer to relationships between types of individual business activities. For example, in an oilfield enterprise, if a well exists in the type "already exists", this indicates that the well has been completed, and then the necessary business activities in the well construction stages, such as drilling, logging, etc., must have occurred, and then "drilling" and "logging" are the associated business activities determined according to the current object type.
In this embodiment, if the current work record is the current completed workload, the service activity associated with the current completed workload is determined according to the current completed workload. Further, currently completed workloads include, but are not limited to: daily completed workload, monthly completed workload, quarterly completed workload, annual monthly completed workload, etc. Illustratively, as shown in fig. 3b, in the monthly worksheet, it can be seen that the workload of completing the month is "well building 3", which are "well 1", "well 2" and "well 3", respectively. Then the business activities "well construction" of "well 1", "well 2" and "well 3" have been completed, and further, the associated business activities that can be determined from the monthly worksheet are the "well construction" business of "well 1", "well 2" and "well 3".
Further, the associated business activities are determined according to the current working record, and different working records may have the same associated business activities. Therefore, the associated business activities obtained in the above four cases can be normalized. That is, different work records have the same associated business activity, and only one associated business activity is reserved. Therefore, the workload of acquiring the work records in the later period can be reduced, and the workload of repeatedly acquiring the same business activity is avoided. Illustratively, the presence type of well 01 is "already present" and the associated business activities determined from the current object type are "drilling" and "logging" of well 01. Meanwhile, if the associated business activity is determined to be the 'well drilling' and 'well logging' of the No. 01 well according to the current completed workload, different work records are subjected to the 'well drilling' and 'well logging' of the same associated business activity No. 01 well, and are combined into one associated business activity. The present embodiment is only an explanation of the normalization process, and is not limited thereto.
S330, determining the preposed business activity of the business activity corresponding to the current working data, the preposed business activity of the business activity associated with the current object instance, the preposed business activity of the business activity associated with the current object type or the preposed business activity of the business activity associated with the current completed workload according to the business activity preposed relation.
In this embodiment, the business activity pre-relation means that when business activity a is completed, then business activity B must have been completed. For example, in an oilfield enterprise, when the business activity of "rock fragment observation" has been completed, then the business activity of "rock fragment logging" must have been completed.
Further, according to the business activity prepositive relation, respectively determining the prepositive business activity of the business activity corresponding to the current working data, the prepositive business activity of the business activity associated with the current object instance, the prepositive business activity of the business activity associated with the current object type, or the prepositive business activity of the business activity associated with the current completed workload. I.e., each business activity has its corresponding pre-business activity in addition to the initial business activity. The initial business activity refers to the first business activity in a project. For example, if "rock chip watch" is the associated business activity, then it may be determined that "rock chip admission" is the leading business activity of "rock chip watch".
S340, according to the business activity postposition relation, determining the postposition business activity of the business activity corresponding to the current working data, the postposition business activity of the business activity related to the current object instance, the postposition business activity of the business activity related to the current object type, or the postposition business activity of the business activity related to the current completed workload.
In this embodiment, the business activity post-relation means that when the business activity C is completed, the business activity D will be completed within a preset time. For example, in an oil field enterprise, a drilling engineering design is completed 15 days after the drilling geological design is completed. It should be noted that the preset time may be determined according to the type of the service activity C, and the preset time is not limited in this embodiment.
Further, according to the business activity postposition relationship, determining the postposition business activity of the business activity corresponding to the current working data, the postposition business activity of the business activity associated with the current object instance, the postposition business activity of the business activity associated with the current object type, or the postposition business activity of the business activity associated with the currently completed workload. I.e., each business activity has its corresponding post-business activity, except for terminating the business activity. Terminating a business activity refers to the last business activity in a project. For example, if "drilling geological design" is the associated business activity, then it may be determined that "drilling engineering design" is a post-business activity of "drilling geological design".
And S350, determining a working record index corresponding to the associated business activity according to the data generation logic.
The data generation logic includes: logic for generating corresponding work records after the business activity occurs; after the business activity occurs, the specific object instance generates the logic of the corresponding work record. Further, the logic of generating the corresponding work record after the business activity occurs means that the work record is necessarily generated after the business activity occurs. Illustratively, the business activity is well building, and then after the business activity of well building is completed, the data of working record well depth is generated.
Further, the data generation logic further comprises: after the business activity occurs, the specific object instance generates the logic of the corresponding work record. Further, after the business activity occurs, some data can be generated and some data can not be generated according to different object instances. For example, when a well is a "vertical well", a work record of "well depth" is generated, and data of "well deviation" is not available. When a well is a "directional well," well deviation data exists while the working record of "well depth" is generated.
Further, for multiple occurrences of business activity, the working record of the missing single activity is derived through the object instance and data generation logic.
Further, according to a periodicity rule, counting the periodic working records, and determining missing periodic working records and a working record index. Illustratively, the work record index includes a start time, an end time, and an acquisition policy. Illustratively, well # 06 daily production data begins at the commissioning business activity until the present or obsolete time a work record is made each day.
And S360, sending a work record acquisition request to a recorder according to the work record index.
And S370, determining a working record index to be acquired according to the current working record, the working record fed back by the recorder to the record acquisition request and the working record index.
S380, calculating the completeness rate of the working record according to the number of the object instances in the actual working record and the number of the object instances in the working record index; wherein the actual job record comprises: and the current working record and the working record fed back by the recorder to the record acquisition request.
In this embodiment, the completeness table represents the amount of completeness of an organization or business activity work record,
it should be noted that in an oil field enterprise, not all of the recording parties can upload all the work records on time or completely, and then the completeness of the work records needs to be calculated according to the number of the object instances in the actual work records and the number of the object instances in the work record index; the actual working record comprises: and the current working record and the working record fed back by the recorder to the record acquisition request. The full rate is equal to the number of object instances in the actual work record divided by the number of object instances in the work record index.
In practical applications, the completion rate needs to be performed according to different situations. The implementation simply introduces the situation that the homothetic rate needs to be performed.
In this embodiment, a method for performing a full-scale statistics on enterprise global data is provided. The overall enterprise completeness statistical formula is as follows:
Figure BDA0001883756370000151
it should be noted that the sum of the numbers of the corresponding object instances of each work record index is the sum of the numbers of the corresponding service object instances of each work record index, and mainly includes two cases: summing the working record indexes which can judge that the business object must generate the working record according to the data generation logic according to the number of the corresponding object instances in each working record index; and summing the work record indexes which can generate the work records according to the actually existing object instances of each work record index. And finally, solving the sum of the two conditions to obtain the sum of the number of the due object instances of each working record index.
The sum of the actual object instance numbers of the work record indexes is the sum of the object instance numbers existing in each work record index, and mainly comprises two conditions: summing the work record indexes which can possibly generate the work records and the work record indexes which must generate the work records but do not have the specific number according to the actual existing object instance number of each work record index; for the work record index which must generate the work record and can know that the specific number of the work record indexes should be generated, the sum of the ratio of the number of the existing data pieces of each object instance in the single work record index to the number of the due data pieces is calculated, then the sum of the ratio of each work record index is calculated, and finally the sum of the two conditions is calculated. It should be noted that the ratio of the number of existing data pieces to the number of due data pieces of each object instance in the single-job record index is between 0 and 1.
In this embodiment, a single-object instance whole-full-rate statistical method is provided. The single object instance integral full rate statistical formula is as follows:
Figure BDA0001883756370000161
it should be noted that the number of data sets that an object instance should have is the number of data sets that can determine the working record that the object instance should generate and the number of data sets that may generate the working record according to the data generation logic;
the number of the actual data sets of the object instance refers to the number of the data sets of the working records in which the object instance actually exists. There are three main cases: for a data set which can determine the number of due working records, the number of the data set is calculated according to the ratio of the number of actual existing data of the object instance to the number of due working records, for a data set which cannot determine the specific number but can determine the number of the object instances, the number of the data set is calculated according to the ratio of the number of existing object instances of the object instance to the number of due object instances, other data sets which cannot determine the number of the object instances exist, the object instances are calculated according to 1, and the object instances do not exist and are calculated according to 0. It should be noted that the above ratios are all between 0 and 1.
In this embodiment, a method for counting the complete rate of an object instance of a certain class is provided. The statistical formula of the complete rate of a certain class of object instances is as follows:
Figure BDA0001883756370000162
it should be noted that, taking a development well as an example, all object instances in the class of objects (development wells) refer to all development well instances. The accumulated quantity of the number of the data sets of all the object instances in the object category is the sum of the number of the object instances of the category in each data set, and mainly comprises two conditions, namely, for the data sets which can judge that the business object instances need to generate the working records according to the data generation logic, the sum is carried out according to the number of the object instances of each data set; and summing the data sets which can generate the working records according to the actually existing object examples of each data set, and finally summing the two conditions.
The accumulated quantity of the actual data set numbers of all object instances in the object category refers to the sum of the existing object instance numbers of the object instances in each data set, statistics is carried out in two cases, and the data sets which are possibly provided with work records and the data sets which are necessary to be provided with the work records but not provided with the actual object instance numbers of all the data sets are summed according to the actual existing object instance numbers of all the data sets; for the data set which must generate the working records and can know the specific number of the working records to be generated, the sum of the ratios of the existing working records to the due working records of each object instance in the single data set is calculated, then the sum of the ratios of the data sets is calculated, and finally the sum of the two conditions is calculated.
In the embodiment, a method for counting the complete data set rate of a single object instance is provided. Table 1 is a formula table of the data set full rate of the single object instance in this embodiment, and according to different scenes, a calculation formula of the data set full rate of the single object instance is shown in table 1:
TABLE 1
Figure BDA0001883756370000171
In this embodiment, a method for performing per-service domain unity-total-rate statistics is provided. According to a statistical formula of the integral full rate of the service domain:
Figure BDA0001883756370000181
it should be noted that the total number of the object instances that each data set should have in the business domain refers to the total number of the business object instances that each data set should have in the business domain. The method mainly comprises two cases, namely summing the data sets which can judge that the business object instances must generate the working records according to the data generation logic according to the number of the corresponding object instances of each data set; summing the data sets which can generate data according to the actual existing object examples of each data set, and finally solving the sum of the two conditions;
the sum of the actual object instances of each data set in the service domain is the sum of the existing service object instances of each data set in the service domain, and the statistics is carried out under two conditions, namely, the data sets which possibly generate the working records and the data sets which must generate the working records but do not have the actual object instances of each data set are summed according to the actual existing object instances of each data set; for the data set which must generate the working records and can know that the specific number of the working records should be generated, the sum of the ratio of the actual working record number of each object instance in the single data set to the due working record number is calculated, then the sum of the ratio of each data set is calculated, and finally the sum of the two conditions is calculated.
In this embodiment, a statistical method for overall organization percentage is provided. According to the statistical formula of the integral full rate of the organization mechanism:
Figure BDA0001883756370000182
the total number of object instances that should be present in each data set in the organization means the total number of object instances that should be present in each data set in the organization. The data sets which can judge that the business object must generate the working record according to the business rule are divided into two cases, and the sum is carried out according to the number of the due object instances of each data set; summing up data sets which can possibly generate working records according to actual existing object instances of the data sets, and finally solving the sum of the two conditions;
the total number of actual object instances of each data set in the organization is the total number of the object instances existing in each data set in the organization. Counting is carried out under two conditions, and the data sets which are possible to generate the working records and the data sets which must generate the working records but do not know the specific number of the working records are summed according to the number of the actual existing object instances of each data set; for the data set which must generate data and can know the specific number of the working records to be generated, the sum of the ratios of the existing working records to the due working records of each object instance in the single data set is calculated, then the sum of the ratios of the data sets is calculated, and finally the sum of the two conditions is calculated.
In this embodiment, a statistical method of organization overall rate in an evaluation period is provided. The organization complete rate statistical formula in the evaluation period is as follows:
Figure BDA0001883756370000191
it should be noted that the period is from the examination start time to the examination end time; the data volume to be reported in the period refers to the object instance volume to be reported by the organization according to the reporting time (assessment starting time) and the assessment ending time specified by the acquisition specification;
the actual reported data volume in the period refers to the object instance volume of the object instance which is actually existed in each data set and satisfies the reporting time in the data set, namely the assessment starting time and the assessment ending time.
In this embodiment, a method for calculating different total rates is provided, and in practical applications, total rates of other cases may also be calculated.
According to the statistical method, the statistical device, the statistical equipment and the statistical storage medium for the working records, the current working record is obtained firstly, then the business activity associated with the current working record is determined, then the working record index corresponding to the associated business activity is determined according to the data generation logic, and then the working record obtaining request is sent to the recording party according to the working record index; and finally, determining the work record index to be acquired according to the current work record, the work record fed back by the recorder to the record acquisition request and the work record index. Therefore, the technical scheme provided by the embodiment determines the work record index through the service logic based on the service logic, and then obtains the work record according to the work record index and determines the work record to be obtained, so that the statistical efficiency of the work record is improved, and the real situation of the enterprise work record is accurately reflected.
EXAMPLE III
Fig. 4 is a schematic structural diagram of a device for counting work records in a third embodiment of the present invention, which is applicable to counting the work records in various places, and the device for counting the work records may be implemented in a software and/or hardware manner. The statistical device for setting the working record is integrated in the terminal equipment, and the specific structure of the statistical device for the working record is as follows:
a current record obtaining module 410, configured to obtain a current working record;
a business activity determining module 420, configured to determine a business activity associated with the current working record;
a record index determining module 430, configured to determine, according to the data generation logic, a work record index corresponding to the associated business activity;
the record request acquisition module 440 sends a work record acquisition request to the recorder according to the work record index;
the record to be acquired determining module 450 is configured to determine a work record index to be acquired according to the current work record, the work record fed back to the record acquisition request by the recording party, and the work record index.
The device for counting the work records provided by this embodiment first obtains a current work record, then determines a business activity associated with the current work record, then determines a work record index corresponding to the associated business activity according to a data generation logic, and then sends a work record obtaining request to a recorder according to the work record index; and finally, determining the work record index to be acquired according to the current work record, the work record fed back by the recorder to the record acquisition request and the work record index. Therefore, the technical scheme provided by the embodiment determines the work record index through the service logic based on the service logic, and then obtains the work record according to the work record index and determines the work record to be obtained, so that the statistical efficiency of the work record is improved, and the real situation of the enterprise work record is accurately reflected.
Specifically, the current working record at least includes:
current work data, current object instance, current object type, and current completed workload.
Further, the business activity determination module 420 includes:
the first business activity determining unit is used for determining the business activity related to the current working data according to the current working data; alternatively, the first and second electrodes may be,
the second business activity determining unit is used for determining the business activity related to the current object instance according to the current object instance and the business activity relationship; alternatively, the first and second electrodes may be,
a third service activity determining unit, configured to determine, according to the current object type and the service type relationship, a service activity associated with the current object type; alternatively, the first and second electrodes may be,
and the fourth service activity determining unit is used for determining the service activity related to the currently completed workload according to the currently completed workload.
Further, the business activity determining module 420 further includes:
and a fifth business activity determining unit, configured to determine, according to the business activity pre-processing relationship, a pre-processing business activity of the business activity corresponding to the current working data, a pre-processing business activity of the business activity associated with the current object instance, a pre-processing business activity of the business activity associated with the current object type, or a pre-processing business activity of the business activity associated with the currently completed workload.
Further, the business activity determining module 420 further includes:
and a sixth business activity determining unit, configured to determine, according to the business activity postposition relationship, a postposition business activity of a business activity corresponding to the current working data, a postposition business activity of a business activity associated with the current object instance, a postposition business activity of a business activity associated with the current object type, or a postposition business activity of a business activity that has currently completed workload association.
Specifically, the data generation logic at least includes:
logic for generating corresponding work records after the business activity occurs; and
after the business activity occurs, the specific object instance generates the logic of the corresponding work record.
Further, the work record statistic device further includes: the system comprises a full rate calculation module, a full rate calculation module and a full rate calculation module, wherein the full rate calculation module is used for calculating the full rate of a working record according to the number of object instances in an actual working record and the number of object instances in a working record index; wherein the actual job record comprises: and the current working record and the working record fed back by the recorder to the record acquisition request.
The product can execute the statistical method of the working record provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
Example four
Fig. 5 is a schematic structural diagram of a terminal device according to a fourth embodiment of the present invention, as shown in fig. 5, the terminal device includes a processor 510, a memory 520, an input device 530, and an output device 540; the number of the processors 510 in the terminal may be one or more, and one processor 510 is taken as an example in fig. 5; the processor 510, the memory 520, the input device 530 and the output device 540 in the terminal may be connected by a bus or other means, which is exemplified in fig. 5.
The memory 520 is a computer-readable storage medium, and can be used for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the statistical method of the work records in the embodiment of the present invention (for example, the current record obtaining module 410, the business activity determining module 420, the record index determining module 430, the record request obtaining module 440, and the record to be obtained determining module 450 in the statistical apparatus of the work records). The processor 510 executes various functional applications of the terminal and data processing, i.e., implements the statistical method of the work records described above, by executing software programs, instructions, and modules stored in the memory 520.
The memory 520 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 520 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory 520 may further include memory located remotely from the processor 510, which may be connected to the terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 530 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the terminal. The output device 540 may include a display device such as a display screen.
EXAMPLE five
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processing apparatus, implements a statistical method for a work record, where the statistical method for the work record includes:
acquiring a current working record;
determining business activities related to the current working record;
determining a working record index corresponding to the associated business activity according to the data generation logic;
sending a work record acquisition request to a recorder according to the work record index;
and determining a working record index to be acquired according to the current working record, the working record fed back to the record acquisition request by the recorder and the working record index.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in the statistical method of the work records provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to perform the statistical method of the work records according to the embodiments of the present invention.
It should be noted that, in the embodiment of the statistical apparatus for the work records, the included units and modules are only divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims (4)

1. A statistical method of work records, comprising:
acquiring a current working record;
determining business activities associated with the current working record;
determining a working record index corresponding to the associated business activity according to the data generation logic;
sending a work record acquisition request to a recorder according to the work record index;
determining a working record index to be acquired according to the current working record, the working record fed back by the recorder to the record acquisition request and the working record index;
calculating the completeness rate of the working record according to the number of the object instances in the actual working record and the number of the object instances in the working record index; wherein the actual job record comprises: the current working record and the working record fed back by the recorder to the record acquisition request;
the current working record at least comprises:
current working data, a current object instance, a current object type, and a current completed workload;
the determining the business activity associated with the current working record comprises:
determining business activities related to the current working data according to the current working data; alternatively, the first and second electrodes may be,
determining the business activity associated with the current object instance according to the current object instance and the business activity relationship; alternatively, the first and second electrodes may be,
determining the business activity associated with the current object type according to the current object type and the business type relation; alternatively, the first and second electrodes may be,
determining the business activity related to the current completed workload according to the current completed workload;
determining the business activity associated with the current working record, further comprising:
determining a pre-business activity of a business activity corresponding to the current working data, a pre-business activity of a business activity associated with the current object instance, a pre-business activity of a business activity associated with the current object type, or a pre-business activity of a business activity associated with the currently completed workload according to a business activity pre-relation; determining the business activity associated with the current working record, further comprising:
determining the post-business activity of the business activity corresponding to the current working data, the post-business activity of the business activity associated with the current object instance, the post-business activity of the business activity associated with the current object type, or the post-business activity of the business activity associated with the currently completed workload according to the post-relation of the business activities; the data generation logic includes at least:
logic for generating corresponding work records after the business activity occurs; and
after the business activity occurs, the specific object instance generates the logic of the corresponding work record.
2. A statistical device for work records, comprising:
the current record acquisition module is used for acquiring a current working record;
a business activity determining module, configured to determine a business activity associated with the current working record;
the record index determining module is used for determining a work record index corresponding to the associated business activity according to the data generating logic;
the record request acquisition module is used for sending a work record acquisition request to a recorder according to the work record index;
the to-be-acquired record determining module is used for determining a to-be-acquired work record index according to the current work record, the work record fed back to the record acquisition request by the recorder and the work record index;
the system comprises a full rate calculation module, a full rate calculation module and a full rate calculation module, wherein the full rate calculation module is used for calculating the full rate of a working record according to the number of object examples in an actual working record and the number of object examples in a working record index; wherein the actual job record comprises: the current working record and the working record fed back by the recorder to the record acquisition request;
the current working record at least comprises:
current working data, a current object instance, a current object type, and a current completed workload;
the business activity determination module comprises:
the first business activity determining unit is used for determining the business activity related to the current working data according to the current working data;
the second business activity determining unit is used for determining the business activity related to the current object instance according to the current object instance and the business activity relationship;
a third service activity determining unit, configured to determine, according to the current object type and the service type relationship, a service activity associated with the current object type;
a fourth service activity determination unit, configured to determine, according to the currently completed workload, a service activity associated with the currently completed workload;
the business activity determination module further comprises:
a fifth business activity determining unit, configured to determine, according to the business activity pre-processing relationship, a pre-processing business activity of a business activity corresponding to the current working data, a pre-processing business activity of a business activity associated with the current object instance, a pre-processing business activity of a business activity associated with the current object type, or a pre-processing business activity of a business activity associated with the current completed workload;
the business activity determination module further comprises:
a sixth business activity determining unit, configured to determine, according to the business activity postposition relationship, a postposition business activity of a business activity corresponding to the current working data, a postposition business activity of a business activity associated with the current object instance, a postposition business activity of a business activity associated with the current object type, or a postposition business activity of a business activity for which workload association has been currently completed;
the data generation logic includes at least:
logic for generating corresponding work records after the business activity occurs; and
after the business activity occurs, the specific object instance generates the logic of the corresponding work record.
3. An apparatus, characterized in that the apparatus comprises:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the statistical method of work records of claim 1.
4. A computer-readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processing device, implements the statistical method of work records according to claim 1.
CN201811435780.7A 2018-11-28 2018-11-28 Statistical method, device, equipment and storage medium for work records Expired - Fee Related CN109492010B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811435780.7A CN109492010B (en) 2018-11-28 2018-11-28 Statistical method, device, equipment and storage medium for work records

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811435780.7A CN109492010B (en) 2018-11-28 2018-11-28 Statistical method, device, equipment and storage medium for work records

Publications (2)

Publication Number Publication Date
CN109492010A CN109492010A (en) 2019-03-19
CN109492010B true CN109492010B (en) 2022-04-29

Family

ID=65698107

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811435780.7A Expired - Fee Related CN109492010B (en) 2018-11-28 2018-11-28 Statistical method, device, equipment and storage medium for work records

Country Status (1)

Country Link
CN (1) CN109492010B (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102236685A (en) * 2010-05-07 2011-11-09 盛乐信息技术（上海）有限公司 Method for recovering local music information based on audio fingerprinting technology
CN106227880A (en) * 2016-08-01 2016-12-14 挂号网（杭州）科技有限公司 Doctor searches for the implementation method of recommendation
CN106251213A (en) * 2016-07-20 2016-12-21 太仓安顺财务服务有限公司 Financial sffairs paper method of sending and receiving in a kind of financial liquidation

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102236685A (en) * 2010-05-07 2011-11-09 盛乐信息技术（上海）有限公司 Method for recovering local music information based on audio fingerprinting technology
CN106251213A (en) * 2016-07-20 2016-12-21 太仓安顺财务服务有限公司 Financial sffairs paper method of sending and receiving in a kind of financial liquidation
CN106227880A (en) * 2016-08-01 2016-12-14 挂号网（杭州）科技有限公司 Doctor searches for the implementation method of recommendation

Also Published As

Publication number Publication date
CN109492010A (en) 2019-03-19

Similar Documents

Publication Publication Date Title
US10706377B2 (en) Communication data analysis and processing system and method
US20230032882A1 (en) Systems and methods for database investigation tool
US10198515B1 (en) System and method for aggregating data from a plurality of data sources
US9590880B2 (en) Dynamic collection analysis and reporting of telemetry data
US9619531B2 (en) Device, method and user interface for determining a correlation between a received sequence of numbers and data that corresponds to metrics
US20090222552A1 (en) Human-computer productivity management system and method
US20210319070A1 (en) Organization of database search results
US10719799B1 (en) Virtual management systems and methods
CA2927580C (en) Method and system for document data extraction template management
US20100050079A1 (en) Context driven help function
EP3051475A1 (en) Data analysis system and method to enable integrated view of customer information
CN105740311A (en) System and method of data wrangling
US11281568B2 (en) Automation of enterprise software inventory and testing
AU2014343044A1 (en) Method and system for document data extraction template management
US9298780B1 (en) Method and system for managing user contributed data extraction templates using weighted ranking score analysis
CN110990445A (en) Data processing method, device, equipment and medium
CN111078695A (en) Method and device for calculating metadata association relation in enterprise
US11061755B1 (en) Application health monitoring and reporting
US20110082839A1 (en) Generating intellectual property intelligence using a patent search engine
CN109492010B (en) Statistical method, device, equipment and storage medium for work records
Indriyanto THE ROLE OF INFORMATION TECHNOLOGY IN INCREASING AUDIT PROCESS EFFICIENCY
US10552455B2 (en) Analytics enablement for engineering records
US10057108B2 (en) Systems, devices, and methods for exchanging and processing data measures and objects
CN110347992B (en) Data analysis method and system based on electronic report
CN113128981A (en) Project management method and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20220429

CF01 Termination of patent right due to non-payment of annual fee