JP6661488B2 - Monitoring and control equipment - Google Patents

Description

  The present invention relates to a monitoring and control device, and more particularly to a monitoring and control device capable of accumulating monitoring control data in a time series and reproducing a system in a past state.

  In the operation and maintenance of plants such as conventional water treatment facilities, sewage treatment facilities, and pump facilities, in order to investigate past plant abnormalities and accident conditions, it is necessary to reproduce those conditions on the system. . As a means for doing this, for example, there is a method in which operation data of a plant is stored in a system, when a reproduction request is received, necessary data is extracted from the stored data, and the system state is reproduced on each screen (see Patent Document 1). .

JP 2013-92858 A

  In the case of Patent Document 1, the amount of stored data increases along with the operation period of the monitoring control device, and it takes time to extract data by specifying a period from the stored data until the system is reproduced in a past state. There was a problem that the preparation time was long.

  SUMMARY OF THE INVENTION The present invention has been made to solve the above-described problem, and does not retrieve data directly from stored data at the time of reproduction, but retrieves data via index data to perform time-series search. In other words, it is an object of the present invention to shorten the preparation time until the system is reproduced in the past state.

The monitoring and control device according to the present invention includes monitoring data added from the plant device and accumulated data for saving time information added to the control data sent to the plant device,
Index data for which a table has been created by adding an index to the monitoring data and the control data for each of the facilities of the plant apparatus for each of the times,
A stored data management unit that obtains the index corresponding to the past time set by the user and obtains data corresponding to the index from the stored data;
A screen data supply unit that realizes reproduction of the data on the monitoring control screen ,
Further, there is provided a storage data search unit for searching display data from the storage data using the index data and storing the display data in a search result in advance .

  According to the monitoring and control device configured as described above, data is not retrieved directly from the stored data at the time of reproduction, but is retrieved from the stored data via the index data. Be faster.

FIG. 2 is a block diagram showing a monitoring control apparatus according to the first embodiment. 5 is a table showing a configuration of current data according to the first embodiment. 5 is a table showing a configuration of stored data according to the first embodiment. 5 is a table showing a configuration of index data according to the first embodiment. 5 is a flowchart illustrating an operation of saving data according to the first embodiment. 5 is a flowchart illustrating an operation during normal monitoring control according to the first embodiment. 5 is a flowchart showing an operation at the time of reproducing a past system state according to the first embodiment. FIG. 9 is a block diagram illustrating a monitoring control device according to a second embodiment. 9 is a table showing accumulated information for recording and a table showing accumulated information for storage according to the second embodiment. 9 is a flowchart illustrating an operation of storing data according to the second embodiment. 9 is a flowchart illustrating an operation during normal monitoring control according to the second embodiment. FIG. 13 is a block diagram illustrating a monitoring control device according to a third embodiment. 13 is a table showing search results according to the third embodiment. 13 is a flowchart showing an operation according to the third embodiment. FIG. 13 is a block diagram illustrating a monitoring control device according to a fourth embodiment. 14 is a flowchart showing an operation at the time of reproducing a past system state according to Embodiment 4. FIG. 13 is a block diagram showing a monitoring control device according to a fifth embodiment. It is a table based on data priority and a table based on time priority according to the fifth embodiment. 21 is a flowchart showing an operation at the time of reproducing the past system state according to the fifth embodiment.

Embodiment 1 FIG.
The present invention relates to a monitoring and control device for a plant such as a water treatment facility, a sewage treatment facility, and a pump facility. Rewinds at the specified past time, and reproduces and confirms the past system state. Hereinafter, a first embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a block diagram showing the configuration of a monitoring control apparatus according to the first embodiment. The monitoring control device 100 communicates with the plant device 1 by the data transmission / reception unit 110, and saves various collected data as current data 101, accumulated data 102, and index data 103. The data is stored by the data transmission / reception unit 110 and the stored data management unit 111. On the monitoring control screen 120, the user performs monitoring control on the plant apparatus 1. The information displayed on the monitor control screen 120 is provided by the screen data supply unit 112. The screen data supply unit 112 acquires data from the current data 101, the accumulated data 102, or both according to a user's instruction. Using the reproduction management unit 114, the user can reproduce the past system state. The user creates playback information (for example, playback speed) 104 using the playback information setting unit 113, and the playback management unit 114 controls the playback. As the reproduction pattern, start / stop / pause, fast-forward / rewind direction control, and double speed / five-speed speed control can be performed.

FIG. 2 is a table showing the configuration of the current data 101. In FIG. 2, DI is an abbreviation for digital input, and ID is a device identification number. The value is, for example, 0 when the switch is open, and 1 when the switch is closed. AI is an abbreviation for analog input, and the value is, for example, water volume, current, voltage, or the like. Further, DO is an abbreviation for digital output, and AO is an abbreviation for analog output. The current data 101 stores only the latest state of the plant apparatus 1, and manages values for each data type in a file. Inputs (input values) are monitored, and output values are controlled.
FIG. 3 is a table showing the configuration of the stored data 102. The accumulated data 102 stores the state of the plant apparatus 1 with time, and manages values in a file for each data type.

  FIG. 4 is a table showing the configuration of the index data 103. The index data 103 creates a table in chronological order, and records, for each equipment ID, address information (index) for acquiring data at the corresponding time. For example, regarding the equipment DI0001, the index (address information) is 100 from 2015/12/12 09:00:00 to 2015/12/12 09:00:00 from FIG. Since the value becomes 1 at 129: 00: 05, the index thereafter becomes 102. For example, for the equipment AO0001, since the analog output value does not change from 2015/12/12 09:00:00 to 2015/12/12 09:00:10, the same index 76 is entered. Division management is performed to prevent the index data from becoming too large. The index is divided on a daily or monthly basis, and can be specified by setting. For example, in FIG. 4, management can be performed for the entire December, and management can be performed separately from January.

  Next, the operation will be described. FIG. 5 is a flowchart showing the data storage operation. After establishing communication with the plant apparatus 1, the data transmission / reception unit 110 waits in a data reception state (step 501). When the monitoring data is received from the plant apparatus 1 and the control data is received from the monitoring control screen 120, the current data is updated with respect to the current data 101 (step 502). When receiving the control data, the data transmission / reception unit 110 transmits the control data to the plant device 1. The data transmitting / receiving unit 110 sends the received data to the stored data management unit 111. The accumulated data management unit 111 adds time information to the received data and adds the accumulated data to the accumulated data 102 (step 503).

  Further, index data is added by adding address information (index) of the data addition destination to the index data 103 (step 504). The structure of the index data 103 in FIG. 4 is characterized by a time series, and the stored data management unit 111 newly adds a row of the reception time to the index data 103 at the data reception timing. Then, time information is added to the received data, and the accumulated data 102 is also added. Address information (for example, a line number) to the accumulated data 102 is added to the index data 103 as index information. For example, for the equipment DI0001, an index 100 is assigned to 2015/12/12 09:00:00. The index of the data not received at the corresponding time is assigned the same index as the previous value. For example, regarding the equipment DI0001, no data is received at 2015/12/12 09:00:01 and the value is the same as that at 2015/12/12 09: 00: 0, so the same index 100 is assigned.

  FIG. 6 is a flowchart showing the operation during normal monitoring control. The screen data supply unit 112 obtains the current data from the current data 101 immediately after the startup (step 601), and supplies display data to the monitoring control screen 120. When a control instruction is given from the user (step 602), the control data is transmitted to the plant apparatus 1 via the data transmitting / receiving unit 110 (step 603), and the current data is updated with respect to the current data 101 (step 603). 604). Further, while adding the accumulated data to the accumulated data 102 (step 605), the index data is added to the index data 103 (step 606). If there is no control instruction from the user (step 602), the process waits until the next timing (step 610).

  Next, FIG. 7 is a flowchart showing the operation at the time of reproducing the past system state. The user sets playback information in the playback information setting unit 113 (step 701), sets a past time, and creates the playback information 104. For example, a reproduction speed, a date, a time, and the like are created. When the setting of the reproduction information is completed, the reproduction can be started (step 702). When the user instructs to start reproduction, the reproduction management unit 114 reads the reproduction information 104, analyzes the reproduction information (Step 703), and acquires the past time set by the user. The reproduction management unit 114 notifies the past time to the screen data supply unit 112. The screen data supply unit 112 requests display data from the stored data management unit 111 at the specified past time.

  The accumulated data management unit 111 acquires an index corresponding to the past time specified from the index data 103 (step 704), and acquires accumulated data (value) corresponding to the index acquired from the accumulated data 102 (step 704). 705). If there is no instruction to stop the reproduction from the user (step 706), the standby time until the next timing is calculated, and the operation waits (step 707). As for the calculation of the standby time, the standby time is calculated from the user's specification of the reproduction speed, and the next time is calculated from the specification of the reproduction direction. Here, the reproduction direction indicates whether the reproduction is going to the future or to the past (fast forward, rewind), and the standby time also changes depending on double speed, five times speed, and the like. The screen data supply unit 112 acquires data corresponding to the specified past time, and realizes reproduction of the data on the monitoring control screen 120.

During reproduction of the past system state, the data acquisition destination of the screen data supply unit 112 is switched from the current data 101 to the accumulated data 102. After the reproduction is stopped, the data acquisition destination returns from the accumulated data 102 to the current data 101. If an abnormality of the plant apparatus 1 is detected during the past system state reproduction, the reproduction is automatically stopped and the display returns to the normal system state display. As described above, since the data is not retrieved directly from the stored data 102 at the time of reproduction but is retrieved from the stored data 102 via the index data 103, the retrieval is performed in chronological order, and the retrieval speed is increased. Also, when the past state is reproduced from the time designated from the recording data, the past state can be reproduced not as a function unit (for example, for each equipment DI0001 in the above example) but as the whole system.
In this embodiment, a case where the past state is represented by a graph can be applied.

Embodiment 2 FIG.
FIG. 8 is a block diagram showing a monitoring control apparatus according to the second embodiment. The second embodiment is different from the first embodiment in that the storage efficiency of the stored data and the index data is improved by preparing an area for storing the stored data in advance. Writing data to memory is faster than writing to disk. Therefore, unlike the first embodiment, two areas for storing the accumulated information 801 on a device which is a device memory and can be accessed at high speed are prepared. FIG. 8 shows a case where three are prepared. The stored data management unit 111 temporarily stores the received data in one of the two pieces of stored information 801.

  When the recording area is full, the accumulated data management unit 111 switches the recording destination of the received data to another area of the accumulated information 801 and simultaneously stores the data of the accumulated information 801 in the accumulated data storage unit 810. Issues a write notification. The accumulated data storage unit 810 adds the data of the accumulated accumulated information 801 to the accumulated data 102 and the index data 103. The method of addition is the same as that described in the first embodiment. When the capacity of one piece of stored information 801 is large and it takes time to save and write, three pieces of stored information 801 can be prepared. FIG. 8 shows a case where three are prepared. In the search request from the screen data supply unit 112, data in the accumulated information 801 is also searched.

  FIG. 9A is a table showing the storage information 801A for recording, and shows a state in which data is currently being recorded. FIG. 9B is a table showing the storage information 801B for storage, in which the recording area is full and is to be written. The stored data management unit 111 rearranges the received data in time series and stores the data in the stored information 801. When two pieces of storage information 801 are prepared as shown in FIG. 9, one becomes storage information 801A for recording in which the stored data management unit 111 stores received data, and the other is stored in the stored data storage unit 810. The stored data is used as storage information 801B for storage for writing and storing the data in the storage data 102 and the index data 103. The two pieces of accumulated information 801A and 801B are switched and used. When three pieces of accumulated information 801 are prepared, only one is used by the accumulated data management unit 111 for recording, and the other two are used by the accumulated data storage unit 810 to write the accumulated data 102 and the index data 103. Used for storage.

  Next, the operation of the second embodiment will be described. FIG. 10 is a flowchart showing an operation of storing data in the second embodiment. Unlike the first embodiment, after updating the current data (step 502), the stored data management unit 111 adds the stored information to the stored information 801 (step 1001). In the storage information switching (step 1002), if there is a vacant area for storing the next received data in the storage information 801, the apparatus waits for data reception. If the vacant area is insufficient, the storage information 801 is switched and the stored data is saved. A request for storing stored data is made to the unit 810 (step 1003). After the storage data storage unit 810 is activated, it waits for reception of storage data storage (step 1010). When a storage request is received from the storage data management unit 111, data is acquired from the storage area of the storage information 801 and the storage data 102 is additionally written (step 1011), and the index data is additionally written (step 1012). .

  FIG. 11 is a flowchart showing the operation during normal monitoring control. Unlike the first embodiment, after updating the current data (step 604), the stored data management unit 111 adds the stored information to the stored information 801 (step 1101). In the storage information switching (step 1102), if the storage information 801 has a vacant area for storing the next received data, the process waits until data reception. If the vacant area is insufficient, the storage information 801 is switched and the storage data is stored. A request for storing stored data is made to the unit 810 (step 1103). After being started, the stored data storage unit 810 waits for reception of stored data storage (step 1110). When a storage request is received from the storage data management unit 111, data is obtained from the storage area of the storage information 801 and the storage data 102 is added (step 1011) and the index data 103 is added (step 1012). The operation at the time of reproducing the past system state is the same as that of the first embodiment.

  As described above, in this embodiment, high-speed access storage information 801 for storing storage information is added, so that a certain amount of data can be stored in the storage information 801 before writing can be performed. The number of times of writing to the data 102 and the index data 103 can be reduced. Further, by alternately using a plurality of storage caches (storage information 801), it is possible to minimize the overhead to the system when storing the stored data.

Embodiment 3 FIG.
The third embodiment is different from the first embodiment in that the area for storing the search result is prepared, so that the search efficiency of the stored data can be improved as compared with the first embodiment.
FIG. 12 is a block diagram showing a monitoring control apparatus according to the third embodiment. Unlike the first embodiment, two areas for storing the search result 1201 on a device which is a memory of the apparatus and which can be accessed at high speed are prepared. Upon receiving a search request from the screen data supply unit 112, the stored data search unit 1210 searches the stored data 102 for display data using the index data 103. That is, in the present embodiment, the stored data search unit 1210 searches for data instead of the screen data supply unit 112. In order to improve the search efficiency, not only one data but also data necessary for the next reproduction are detected together in one search and stored in the search result (1201). Note that the range to be extracted in one search can be specified.

  FIG. 13 is a table showing the search results. FIG. 13 (A) shows the search results as indexes, and FIG. 13 (B) shows the search results as values. In FIG. 13A, "index" is all displayed, but in actuality, for example, if the equipment is DI0001, "100" in FIG. 4 is displayed. The stored data search unit 1210 searches the index data 103 based on the time designation of the screen data supply unit 112 and stores the result in the search result 1201. The structure of the search result 1201 is a search result based on an index (FIG. 13A). The amount of index data to be detected once can be changed by designation. Thereafter, the stored data search unit 1210 detects a value from the stored data 102 based on the index information of the search result 1201A and stores the value in the search result 1201. In this case, the structure of the search result 1201 is the search result (FIG. 13B).

  Next, the operation of the third embodiment will be described. FIG. 14 is a flowchart showing the operation of the third embodiment. The operation of storing data (FIG. 5) and the operation during normal monitoring control (FIG. 6) are the same as in the first embodiment. FIG. 14 shows an operation when a past system state is generated according to the third embodiment. After the reproduction starts, the stored data search unit 1210 searches the index data 103, and stores the index information of the specified time and the specified amount in the search result 1201A (step 1401). Here, the designated amount refers to the number of lines. In FIG. 13, data every 5 seconds is stored for 25 seconds from 2015/12/12 09:00:00 to 2015/12/12 09:00:25, and the number of rows is six. Thereafter, a value is searched from the accumulated data 102 by using the index, and stored in the search result 1201B (step 1402). If there is no reproduction stop command, the next search result cache (save) time is calculated and the standby is performed according to the reproduction speed (step 1403).

  When the system is played back in the past, the next search is predictable because of the characteristic of searching data in time series. A plurality of rows of data (six rows in FIG. 13) are collectively searched in one search and stored in the search result 1201, thereby reducing the number of searches. Further, by using a plurality of search results 1201 alternately, search efficiency can be improved. This embodiment can be used in the second embodiment.

Embodiment 4 FIG.
The fourth embodiment differs from the first embodiment in that the information indicating the relationship between the display screen and the display data is prepared, so that the amount of search for the stored data 102 can be suppressed to the minimum necessary. The performance can be improved. FIG. 15 is a block diagram showing a monitoring control apparatus according to the fourth embodiment. Unlike the first embodiment, the screen data supply unit 112 requests the storage data management unit 111 to supply display data based on the time and the display screen ID. Here, the display screen ID is a screen number assigned to each facility. For example, if a screen of only the facility DI0001 is required, only the display screen ID of the facility DI0001 is transmitted, and the other facility (for example, AI0001 or the like) is transmitted. No screen is required, so no data is needed for other equipment.

  The stored data management unit 111 refers to the display data list 1501 and grasps data necessary for the designated screen, and then searches the stored data 102 using the index data 103. Here, the display data list 1501 is, for example, such that the screen number 1 corresponds to the facility DI0001 and the screen 2 corresponds to the facility DI0002. If only the screen number 1 is designated, the display data list 1501 Is searched for data of only the equipment DI0001.

Next, the operation of the fourth embodiment will be described. The operation of storing data (FIG. 5) and the operation during normal monitoring control (FIG. 6) are the same as in the first embodiment. FIG. 16 is a flowchart showing the operation when the past system state is generated according to the fourth embodiment. The difference from the first embodiment is that the stored data management unit 111 checks the display data list 1501 using the display screen ID, specifies search data (step 1601), and uses the index data 103. The stored data 102 is searched.
By configuring as described above, it is possible to specify only the data necessary for the reproduction screen during the reproduction of the past state, and to search only the necessary data, thereby reducing the amount of data to be searched and improving the search efficiency. Can be planned. This embodiment can be used together with the second and third embodiments.

Embodiment 5 FIG.
The fifth embodiment differs from the fourth embodiment in that search results that are frequently used are saved to reduce the amount of search and improve the performance of stored data search. FIG. 17 is a block diagram showing a monitoring control apparatus according to the fifth embodiment. Unlike the first embodiment, the stored data management unit 111 provides the search result for the stored data 102 to the screen data supply unit 112 and also supplies the search result to the cache management unit 1710. The cache management unit 1710 stores the search result in the search result cache 1701. The data structure of the search result cache 1701 is the same as the search result of FIG. In order to keep the capacity of the search result cache 1701 within the specified range, the cache management unit 1710 stores data in the search result cache 1701 and, at the same time, performs maintenance so that data with a low usage rate is deleted.

  Next, maintenance of the search result cache 1701 will be described. Since the accumulated data management unit 111 also provides the data provided to the screen data supply unit 112 to the cache management unit 1710, the cache management unit 1710 performs the search count (data for each facility) as shown in FIG. Priority) and the number of searches for each time (time priority) can be totaled. FIG. 18A is a table based on data priorities, and FIG. 18B is a table based on time priorities. When the remaining capacity of the search result cache 1701 is detected to be insufficient (for example, when the usage rate exceeds 90%), column data is deleted from monitoring data having a low data priority. The deletion of the column data is performed on the search result shown in FIG. 13B. For example, in FIG. 18A, since AI0002 is searched only three times, the column data of AI0002 in FIG. 99.79, 125.7...) Are deleted.

  Note that the column data is not deleted below the specified value. When the deletion of the column data reaches the limit, the row data is deleted from the reproduction time having the lower time priority shown in FIG. The row data is deleted from the search result shown in FIG. 13B. For example, in FIG. 18B, since 2015/12/23 19:00:00 is searched only three times, FIG. Row data (horizontal data) corresponding to 2015/12/23 19:00:00 (not shown in FIG. 13B) of (B) is deleted. When the search result cache 1701 deletes the row data based on the time priority, the row data is also deleted based on the time priority shown in FIG. In addition, one deletion deletes data from the search result cache 1701 with approximately 10% of the usage rate as a guide. If the time priority cannot be determined based on the number of times, the line data is deleted from the oldest one at the last search time.

  Next, the operation will be described. FIG. 19 is a flowchart showing the operation when the past system state is generated according to the fifth embodiment. As a different point from the first embodiment, the stored data management unit 111 searches whether the search result cache 1701 itself exists before searching the stored data 102 (step 1901). If the search result cache 1701 does not exist, the stored data 102 is searched in the same manner as in the first embodiment. If the search result cache 1701 exists, the accumulated data management unit 111 provides the data of the search result cache 1701 to the screen data supply unit 112.

  Next, maintenance processing by the cache management unit 1710 will be described. It waits at the search result reception (step 1910). When the data is received, the search result is cached in the search result cache 1701 (step 1911). Next, the remaining capacity of the cache is checked (step 1912). If the remaining capacity is sufficient, the process waits for reception of the search result (step 1910). If the remaining capacity is insufficient, the cache area is released. And waits (step 1913).

That is, it is checked whether or not the data in the search result cache 1701 exceeds the area. If the area is full, the data is canceled. Since the search result is left as described above, the search efficiency is improved if the search result is the same. Further, it is not necessary to perform a new search, and it is sufficient to retrieve the one on the memory, so that the search becomes easy. By reusing the search results that are frequently used in this way, the amount of data that needs to be searched during the reproduction of the past state can be further reduced, and the search efficiency can be improved. Note that this embodiment can be used in combination with Embodiments 2 to 4.
In the present invention, each embodiment can be freely combined, or each embodiment can be appropriately modified or omitted within the scope of the invention.

1 plant equipment, 102 accumulated data, 103 index data,
111 accumulated data management unit, 112 screen data supply unit, 120 monitoring control screen,
801 accumulated information, 810 accumulated data storage unit, 1201 search result,
1210 accumulated data search unit, 1701 search result cache,
1710 Cache management unit.

Claims (4)

Accumulated data for adding and storing time information to monitoring data from the plant device and control data sent to the plant device,
Index data for which a table has been created by adding an index to the monitoring data and the control data for each of the facilities of the plant apparatus for each of the times,
A stored data management unit that obtains the index corresponding to the past time set by the user and obtains data corresponding to the index from the stored data;
A screen data supply unit that realizes reproduction of the data on the monitoring control screen ,
A monitoring control device further comprising a stored data search unit for searching display data from the stored data using the index data and storing the display data in a search result in advance. A plurality of accumulated information for temporarily storing the monitoring data and the control data;
2. The monitoring control apparatus according to claim 1, further comprising a storage data storage unit for writing the data of the storage information that is full to the storage data and the index data. 3. The monitoring control device according to claim 1, wherein the storage data management unit acquires only the monitoring data and the control data necessary for screen display. The storage data management unit supplies the data acquired from the storage data to a cache management unit, and the cache management unit stores the data in a search result cache,
The monitoring control device according to claim 1, wherein the cache management unit deletes the data having a low utilization rate.

Images