Industrial control system database measuring point information multi-task updating scheduling method and related device

Abstract

The invention discloses an industrial control system database measuring point information multi-task updating scheduling method and a related device, and belongs to the technical field of industrial control system database measuring point updating. Firstly, a measuring point information flow is released through an equipment measuring point information release program, and before the equipment measuring point information release program executes a data table replacement operation, a request event is sent to a measuring point information automatic updating program to determine whether a request can be released or not. Generating a release mark according to the first mark variable; judging whether to execute issuing operation or not through an equipment measuring point information issuing program, and generating an execution result; finally, an execution result is fed back to the measuring point information automatic updating program, and the second mark variable is updated; and updating the measurement point information task by the measurement point information automatic updating program, and executing data table modification operation according to the second mark variable. Through strategy scheduling, when the data table replacement operation conflicts with the data table modification operation, the two operations are executed in order, and it is guaranteed that the two measuring point information updating methods are both correct and effective.

Description

Technical Field

[0001] The invention belongs to the technical field of industrial control system database measurement point update, and relates to an industrial control system database measurement point information multi-task update scheduling method and related devices. Background Art

[0002] The real-time database of the host computer of the industrial control system stores the measuring point information of the equipment (including: measuring point name, measuring point type, measuring point hardware address, measuring point threshold range, etc.). According to the different measuring point update methods supported by the equipment, there are generally two update methods, namely: manual update and automatic update. Specifically, for equipment that cannot automatically send measuring point information, it is necessary to first export the equipment measuring point information table and then manually import it into the host computer configuration data table. After verification, the host computer equipment measuring point information publishing program writes it into the real-time database by replacing the data table; for equipment that supports automatic sending of measuring point information, after the configuration in the equipment is generated, the equipment immediately sends its latest measuring point information to the host computer measuring point information automatic update program, which writes the collected equipment measuring point information into the database by modifying the data table.

[0003] As the types of devices included in industrial control systems increase, it is inevitable that there will be devices that need to manually update the point directory (referred to as: manual update devices) and devices that can automatically update the point directory (referred to as: automatic update devices) in the same system, which will face the following situations:

[0004] When engineer 1 is importing the measurement point directory data table for the manual update device, engineer 2 is completing the configuration of the automatic update device at the same time. At this time, the data table replacement operation of the upper computer device measurement point information publishing program will conflict with the data table modification operation of the measurement point information automatic update program, which will cause at least one of the tasks to fail. Summary of the invention

[0005] The purpose of the present invention is to provide a multi-task update scheduling method and related devices for industrial control system database measurement point information, so as to solve the technical problem in the prior art that when a data table replacement operation conflicts with a data table modification operation, it is easy to cause the execution failure of one of the tasks.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions:

[0007] In a first aspect, the present invention provides a method for scheduling multi-task update of measurement point information in an industrial control system database, comprising the following steps:

[0008] Initiate a measuring point information flow to the measuring point information automatic update program through the equipment measuring point information release program, and generate a release tag according to the first tag variable;

[0009] According to the release mark, the device measurement point information release program determines whether to execute the release operation and generates the execution result;

[0010] Feedback the execution result to the measuring point information automatic updating program, and update the second marking variable;

[0011] According to the second marking variable, the measuring point information task is updated through the measuring point information automatic updating program, and the data table modification operation is executed.

[0012] Furthermore, the first flag variable represents the number of automatic update devices MUDCC that are currently updating the measurement point information; the second flag variable represents whether manual update device measurement point information IAUDP is being released.

[0013] Furthermore, the step of initiating the measuring point information flow to the measuring point information automatic updating program through the equipment measuring point information publishing program and generating the publishing mark according to the first mark variable specifically includes:

[0014] Before the equipment measuring point information publishing program executes the data table replacement operation, it initiates a request event to the measuring point information automatic update program to request whether the release can be performed;

[0015] After receiving the request event, the automatic update program of the measuring point information performs analysis:

[0016] a. If the current first mark variable is 0, there is no automatic update device that is currently updating the measurement point information. The second mark variable is set to true, and then the permission to publish mark pleasePublish is generated and fed back to the device measurement point information publishing program;

[0017] b. If the current first mark variable is not 0, there is an automatic update device that is currently updating the measurement point information, and then a pause publishing mark stopPublish is generated and fed back to the device measurement point information publishing program.

[0018] Furthermore, the step of determining whether to execute the publishing operation according to the publishing mark and generating the execution result through the device measurement point information publishing program specifically includes:

[0019] If the device measurement point information publishing program receives the stopPublish mark, the publishing process will be stopped;

[0020] If the device measurement point information publishing program receives the release permission mark pleasePublish, it will continue to execute the data table replacement operation of the publishing process and generate the execution result.

[0021] Furthermore, the step of feeding back the execution result to the measuring point information automatic updating program and updating the second marking variable specifically includes: after the measuring point information automatic updating program receives the execution publishing completion result, setting the second marking variable to false.

[0022] Furthermore, the step of updating the measuring point information task through the measuring point information automatic updating program according to the second marking variable and executing the data table modification operation specifically includes:

[0023] Determine whether the second marking variable is true. If it is true, the measuring point will not be updated in this round, and the update task will continue to be initiated after waiting for a preset time; if it is not true, the measuring point table will be modified and the first marking variable will be updated.

[0024] Further, the step of modifying the measuring point table and updating the first marking variable if it is not true specifically includes: if it is not true, executing the first marking variable +1, and then modifying the measuring point table; after the update, executing the first marking variable -1.

[0025] In a second aspect, the present invention provides a multi-task update scheduling system for measuring point information in an industrial control system database, comprising:

[0026] An event request module is used to initiate a measuring point information flow to a measuring point information automatic update program through a device measuring point information release program, and generate a release tag according to a first tag variable;

[0027] A judgment execution module is used to judge whether to execute the release operation according to the release mark through the device measurement point information release program, and generate an execution result;

[0028] A feedback update module, used for feeding back the execution result to the measuring point information automatic update program and updating the second marking variable;

[0029] The measuring point table modification module is used to update the measuring point information task according to the second marking variable through the measuring point information automatic update program and perform the data table modification operation.

[0030] In a third aspect, the present invention provides a computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above method when executing the computer program.

[0031] In a fourth aspect, the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above method are implemented.

[0032] Compared with the prior art, the present invention has the following beneficial effects:

[0033] The present invention discloses a multi-task update scheduling method for measuring point information of an industrial control system database and a related device. The measuring point information process is first released through a device measuring point information release program. Before the device measuring point information release program executes a data table replacement operation, a request event is initiated to a measuring point information automatic update program to request whether the release can be performed. A release tag is generated according to a first tag variable; then, the device measuring point information release program determines whether to execute the release operation and generates an execution result; finally, the execution result is fed back to the measuring point information automatic update program and a second tag variable is updated; the measuring point information automatic update program updates the measuring point information task and executes a data table modification operation according to the second tag variable. Through the policy scheduling of the present invention, when a data table replacement operation conflicts with a data table modification operation, the two operations can be executed in an orderly manner, thereby ensuring that both measuring point information update methods are correctly effective. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0035] Figure 1 is a flow chart of the method of the present invention;

[0036] Figure 2 is a schematic diagram of the system of the present invention;

[0037] Figure 3 It is a schematic diagram of the computer device structure of the present invention. DETAILED DESCRIPTION

[0038] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Generally, the components of the embodiments of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.

[0039] Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the invention claimed for protection, but merely represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0040] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.

[0041] In the description of the embodiments of the present invention, it should be noted that if the terms "upper", "lower", "horizontal", "inner", etc. indicate an orientation or positional relationship based on the orientation or positional relationship shown in the drawings, or the orientation or positional relationship in which the product of the invention is usually placed when in use, it is only for the convenience of describing the present invention and simplifying the description, and does not indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention. In addition, the terms "first", "second", etc. are only used to distinguish the description, and cannot be understood as indicating or implying relative importance.

[0042] In addition, if the term "horizontal" appears, it does not mean that the component must be absolutely horizontal, but can be slightly tilted. For example, "horizontal" only means that its direction is more horizontal than "vertical", which does not mean that the structure must be completely horizontal, but can be slightly tilted.

[0043] In the description of the embodiments of the present invention, it is also necessary to explain that, unless otherwise clearly specified and limited, the terms "set", "install", "connect", and "connect" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal connection of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0044] The present invention is further described in detail below in conjunction with the accompanying drawings:

[0045] See also Figure 1 The embodiment of the present invention discloses a multi-task update scheduling method for measuring point information in an industrial control system database, comprising the following steps:

[0046] S1, initiating a measuring point information flow to a measuring point information automatic updating program through a device measuring point information publishing program, and generating a publishing tag according to a first tag variable; the first tag variable represents the "manual update device changing counts" (MUDCC) of "the number of automatic updating devices currently updating measuring point information".

[0047] Before the equipment measuring point information publishing program executes the data table replacement operation, it initiates a request event to the measuring point information automatic update program to request whether the release can be performed;

[0048] After receiving the request event, the automatic update program of the measuring point information performs analysis:

[0049] a. If the current first mark variable is 0, there is no automatic update device that is currently updating the measurement point information. The second mark variable is set to true, and then the permission to publish mark pleasePublish is generated and fed back to the device measurement point information publishing program;

[0050] b. If the current first mark variable is not 0, there is an automatic update device that is currently updating the measurement point information, and then a pause publishing mark stopPublish is generated and fed back to the device measurement point information publishing program.

[0051] S2, judging whether to execute the release operation according to the release mark through the device measurement point information release program, and generating the execution result;

[0052] If the device measurement point information publishing program receives the stopPublish mark, the publishing process will be stopped;

[0053] If the device measurement point information publishing program receives the release permission mark pleasePublish, it will continue to execute the data table replacement operation of the publishing process and generate the execution result.

[0054] S3, feeding back the execution result to the measuring point information automatic updating program, and updating the second marking variable; the second marking variable represents "whether the manual updating device measuring point information is being published" IAUDP (Is Auto Update Device Publishing).

[0055] After receiving the execution release completion result, the measuring point information automatic update program sets the second flag variable to false.

[0056] S4, according to the second marking variable, updating the measuring point information task through the measuring point information automatic updating program, and executing the data table modification operation.

[0057] Determine whether the second flag variable is true. If it is true, the measuring point will not be updated in this round, and the update task will continue to be initiated after waiting for the preset time; if it is not true, execute MUDCC=MUDCC+1, that is, the number of automatic update devices currently updating the measuring point information increases by 1, and then modify the measuring point table. After the update, execute MUDCC=MUDCC-1, that is, the number of automatic update devices currently updating the measuring point information decreases by 1.

[0058] See also Figure 2 The embodiment of the present invention discloses a multi-task update scheduling system for measuring point information of an industrial control system database, including an event request module, a judgment execution module, a feedback update module and a measuring point table modification module.

[0059] Among them, the event request module is used to initiate the measurement point information process to the measurement point information automatic update program through the equipment measurement point information release program, and generate a release mark according to the first mark variable; the judgment execution module is used to judge whether to execute the release operation according to the release mark through the equipment measurement point information release program, and generate an execution result; the feedback update module is used to feed back the execution result to the measurement point information automatic update program, and update the second mark variable; the measurement point table modification module is used to update the measurement point information task according to the second mark variable through the measurement point information automatic update program, and execute the data table modification operation.

[0060] Example:

[0061] This embodiment discloses a multi-task update scheduling method for measuring point information in an industrial control system database, comprising the following steps:

[0062] 1. For automatic update devices, the automatic update program of measuring point information changes the measuring point information in real time through data table modification operations. This task maintains two marking variables: MUDCC (Manual Update Device Changing Counts) and IAUDP (Is Auto Update Device Publishing), which respectively represent "the number of automatic update devices currently updating measuring point information" and "whether the manual update device measuring point information is being published".

[0063] 2. Equipment measurement point information release procedure Release measurement point information process:

[0064] 2.1 Before the equipment measuring point information publishing program executes the data table replacement operation, it initiates a request event to the measuring point information automatic update program to request whether it can be published.

[0065] 2.2 The automatic update program of measuring point information receives the event and performs the following analysis:

[0066] 1) If the current MUDCC is 0, that is, there is no automatic update device that is currently updating the measurement point information, then set IAUDP to true, and then return the "allow publishing mark" pleasePublish to the device measurement point information publishing program through the event;

[0067] 2) If the current MUDCC is 0, that is, the measuring point information of the automatic updating device is currently being updated, the "stopPublish mark" is returned to the device measuring point information publishing program through the event.

[0068] 2.3 The device measurement point information publishing program receives the return event sent by the measurement point information automatic update program and parses the event:

[0069] 1) If the "allow publishing mark" pleasePublish is received, the data table replacement operation of the publishing process will continue;

[0070] 2) If the "stopPublish mark" is received, the publishing process will be stopped.

[0071] 2.4 After the equipment measuring point information publishing program completes the publishing operation, it sends a publishing completion event to the measuring point information automatic updating program.

[0072] 2.5 After the measuring point information automatic update program receives the publishing completion event, it sets IAUDP to false.

[0073] 3. The automatic update program of measuring point information updates the measuring point information task. Before executing the data table modification operation, determine whether IAUDP is true:

[0074] 1) If yes, return, do not update the measurement points in this round, and continue to initiate the update task after waiting for a certain period of time;

[0075] 2) If not, execute MUDCC=MUDCC+1, that is, the number of automatic update devices currently updating the measuring point information increases by 1, and then modify the measuring point table. After the update, execute MUDCC=MUDCC-1, that is, the number of automatic update devices currently updating the measuring point information decreases by 1.

[0076] In one embodiment of the present invention, see Figure 3 , a computer device is provided, the computer device includes a processor and a memory, the memory is used to store a computer program, the computer program includes program instructions, and the processor is used to execute the program instructions stored in the computer storage medium. The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. It is the computing core and control core of the terminal, which is suitable for implementing one or more instructions, and is specifically suitable for loading and executing one or more instructions in the computer storage medium to implement the corresponding method flow or corresponding function; the processor described in the embodiment of the present invention can be used for the operation of the multi-task update scheduling method of the industrial control system database measurement point information.

[0077] The present invention also provides a storage medium, specifically a computer-readable storage medium (Memory), which is a memory device in a computer device for storing programs and data. It is understandable that the computer-readable storage medium here can include both built-in storage media in the computer device and, of course, extended storage media supported by the computer device. The computer-readable storage medium provides a storage space, which stores the operating system of the terminal. In addition, one or more instructions suitable for being loaded and executed by a processor are also stored in the storage space, and these instructions can be one or more computer programs (including program codes). It should be noted that the computer-readable storage medium here can be a high-speed RAM memory or a non-volatile memory (non-volatile memory), such as at least one disk memory. The processor can load and execute one or more instructions stored in the computer-readable storage medium to implement the corresponding steps of the multi-task update scheduling method for measuring point information in the industrial control system database in the above embodiment.

[0078] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0079] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0080] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1A function specified in one or more boxes.

[0081] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0082] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A multi-task update scheduling method for measuring point information in an industrial control system database, characterized in that: The following steps are involved: Initiate a measuring point information flow to the measuring point information automatic update program through the equipment measuring point information release program, and generate a release tag according to the first tag variable; According to the release mark, the device measurement point information release program determines whether to execute the release operation and generates the execution result; Feedback the execution result to the measuring point information automatic updating program, and update the second marking variable; According to the second marking variable, the measuring point information task is updated through the measuring point information automatic updating program, and the data table modification operation is executed.

2. The method for multi-task updating and scheduling of measuring point information in an industrial control system database according to claim 1 is characterized in that: The first flag variable represents the number of automatic update devices MUDCC that are currently updating the measurement point information; the second flag variable represents whether the manual update device measurement point information IAUDP is being released.

3. The method for multi-task updating and scheduling of measuring point information in an industrial control system database according to claim 1, characterized in that: The step of initiating the measuring point information process to the measuring point information automatic updating program through the equipment measuring point information publishing program and generating the publishing mark according to the first mark variable specifically includes: Before the equipment measuring point information publishing program executes the data table replacement operation, it initiates a request event to the measuring point information automatic update program to request whether the release can be performed; After receiving the request event, the automatic update program of the measuring point information performs analysis: a. If the current first mark variable is 0, there is no automatic update device that is currently updating the measurement point information. The second mark variable is set to true, and then the permission to publish mark pleasePublish is generated and fed back to the device measurement point information publishing program; b. If the current first mark variable is not 0, there is an automatic update device that is currently updating the measurement point information, and then a pause publishing mark stopPublish is generated and fed back to the device measurement point information publishing program.

4. The method for multi-task update scheduling of measurement point information in an industrial control system database according to claim 1, characterized in that: The step of determining whether to execute the publishing operation according to the publishing mark and generating the execution result through the device measurement point information publishing program specifically includes: If the device measurement point information publishing program receives the stopPublish mark, the publishing process will be stopped; If the device measurement point information publishing program receives the release permission mark pleasePublish, it will continue to execute the data table replacement operation of the publishing process and generate the execution result.

5. The method for multi-task updating and scheduling of measuring point information in an industrial control system database according to claim 1, characterized in that: The step of feeding back the execution result to the measuring point information automatic updating program and updating the second marking variable specifically includes: after the measuring point information automatic updating program receives the execution publishing completion result, setting the second marking variable to false.

6. The method for multi-task update scheduling of measurement point information in an industrial control system database according to claim 1, characterized in that: The step of updating the measuring point information task through the measuring point information automatic updating program according to the second marking variable and executing the data table modification operation specifically includes: Determine whether the second marking variable is true. If it is true, the measuring point will not be updated in this round, and the update task will continue to be initiated after waiting for a preset time; if it is not true, the measuring point table will be modified and the first marking variable will be updated.

7. A method for multi-task update scheduling of measurement point information in an industrial control system database according to claim 6, characterized in that: The step of modifying the measuring point table and updating the first marking variable if it is not true specifically includes: if it is not true, executing the first marking variable +1, and then modifying the measuring point table; after the update, executing the first marking variable -1.

8. A multi-task update scheduling system for measuring point information in an industrial control system database, characterized in that: include: An event request module is used to initiate a measuring point information flow to a measuring point information automatic update program through a device measuring point information release program, and generate a release tag according to a first tag variable; A judgment execution module is used to judge whether to execute the release operation according to the release mark through the device measurement point information release program, and generate an execution result; A feedback update module, used for feeding back the execution result to the measuring point information automatic update program and updating the second marking variable; The measuring point table modification module is used to update the measuring point information task according to the second marking variable through the measuring point information automatic update program and perform the data table modification operation.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images