Data Management System

Abstract

We provide a data management system that addresses the market demand for aggregating and displaying equipment downtime by reason for downtime. [Solution] A data management system 1 that displays the operating status of each piece of equipment based on status information of each piece of equipment transmitted at predetermined intervals from multiple pieces of equipment installed on a production line, comprising: a first processing unit 13 that stores in a database 11 only the status information of each piece of equipment that has changed in operating status from the status information of each piece of equipment transmitted from each piece of equipment; a second processing unit 14 that aggregates the downtime for each reason for stopping each piece of equipment during a specified time period based on the status information of each piece of equipment stored in the database 11; and a display unit 15 that acquires and displays the aggregated results of the second processing unit 14. The status information includes ID information that identifies each piece of equipment, information regarding the operation and stopping of each piece of equipment, information regarding the reason in the case of operation stopping, and time information when the status information was transmitted.

Description

Technical Field

[0001] The present invention relates to a data management system.

Background Art

[0002] Conventionally, data such as device numbers, the status of each device (in production, stopped, abnormal stop, etc.), and the time at data output (hereinafter referred to as status information) is collected from a plurality of devices installed on a production line every minute, and a system has been known that visualizes the operating status of each device.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, the conventional system has a problem that it cannot respond to the market demand for aggregating and displaying the stop time of each device for each stop reason.

[0005] Therefore, the present invention has been made in view of the above problems, and an object thereof is to provide a data management system that can respond to the market demand for aggregating and displaying the stop time of each device for each stop reason.

Means for Solving the Problems

[0006] A data management system according to one embodiment displays the operating status of a plurality of devices installed on a production line based on status information of each device transmitted at predetermined intervals from each device, comprising: a first processing unit that stores in a database only the status information of each device that indicates a change in the operating status of each device from the status information of each device transmitted from each device; a second processing unit that aggregates the downtime for each reason for stopping each device during a specified time period based on the status information of each device stored in the database; and a display unit that acquires and displays the aggregation results of the second processing unit, wherein the status information includes ID information that identifies each device, information regarding the operation and stopping of each device, information regarding the reason in the case of operation stopping, and time information when the status information was transmitted. [Effects of the Invention]

[0007] According to the present invention, it is possible to provide a data management system that can meet the market demand for aggregating and displaying equipment downtime by reason for downtime. [Brief explanation of the drawing]

[0008] [Figure 1] Figure 1 is a diagram showing an example of the overall configuration of the data management system 1 according to the first embodiment. [Figure 2] Figure 2 shows an example of a display screen provided by the display unit 15 of the data management system 1 according to the first embodiment. [Figure 3] Figure 3 is a flowchart showing an example of the operation of the data management system 1 according to the first embodiment. [Modes for carrying out the invention]

[0009] Preferred embodiments of the present invention will be described in detail below with reference to the attached drawings. In the following drawings, identical or similar parts are denoted by the same or similar reference numerals. However, it should be noted that the drawings are schematic, and the ratios of dimensions, etc., may differ from those of reality. Therefore, specific dimensions, etc., should be determined by referring to the following description. Furthermore, there may be parts in the drawings where the relationships and ratios of dimensions differ from those of other parts. In this specification and drawings, elements having substantially the same function and configuration are denoted by the same reference numerals to avoid redundant explanations, and elements not directly related to the present invention are omitted from the illustration.

[0010] (First Embodiment) The data management system 1 according to the first embodiment of the present invention will be described below with reference to Figures 1 to 3. Figure 1 is a diagram showing an example of the overall configuration of the data management system 1 according to the first embodiment, Figure 2 is a diagram showing an example of the display screen by the display unit 15 of the data management system 1 according to the first embodiment, and Figure 3 is a flowchart showing an example of the operation of the data management system 1 according to the first embodiment.

[0011] The data management system 1 according to this embodiment is configured to display the operating status of each of the multiple pieces of equipment A to C, which are installed on the production line, based on the status information of each piece of equipment A to C, which is transmitted at predetermined intervals from each piece of equipment A to C, which are installed on the production line.

[0012] Here, the multiple devices A to C... include, for example, any devices capable of transmitting status information such as combination weighing devices, weight inspection devices, and label inspection devices.

[0013] As shown in Figure 1, the data management system 1 according to this embodiment includes a database 11, a cache 12, a first processing unit 13, a second processing unit 14, and a display unit 15.

[0014] Here, the functions 11 to 15 included in the data management system 1 may be installed in one or more devices. Alternatively, the functions 11 to 15 included in the data management system 1 may be distributed across one or more devices and the cloud.

[0015] The first processing unit 13 stores in the database 11 only the status information from each device A to C that indicates a change in the operating status of each device A to C, among the status information transmitted from each device A to C, etc.

[0016] Specifically, the first processing unit 13 performs two processes: process 1, which saves the latest status information to the cache 12; and process 2, which compares the newly acquired status information with the status information stored in the cache 12, and if there is a discrepancy between the two, saves the newly acquired status information to the database 11 and also saves it to the cache 12 as the latest value.

[0017] If there is no discrepancy between the newly acquired status information and the status information stored in the cache 12, the first processing unit 13 discards the newly acquired status information without saving it to the database 11.

[0018] Here, the first processing unit 13 may obtain the status information of each device A to C from each device A to C, or it may obtain it from a hub device or edge computer connected to each device A to C that is capable of obtaining the status information of each device A to C.

[0019] The status information includes ID information that identifies each device A to C…, information regarding the operation and shutdown of each device A to C… (e.g., operating time, shutdown time, shutdown time due to errors, etc.), information regarding the reason for shutdown in the case of shutdown, and time information when the status information was transmitted.

[0020] The second processing unit 14 aggregates the downtime for each reason for stopping each device A to C… during the specified time period, based on the status information of each device A to C… stored in the database 11.

[0021] Further, the first processing unit 13 or the second processing unit 14 may process and format the status information of each of the devices A to C... so that it can be displayed in a displayable format or the like on the display unit 15.

[0022] The display unit 15 acquires and displays the aggregation result of the second processing unit 14. FIG. 2 shows an example of a display screen by the display unit 15. The example of FIG. 2 shows an example of a display screen for displaying the operating status of the measuring devices 1 to 3 installed on the smoothie line (production line).

[0023] In the area X in the display screen shown in FIG. 2, the operating time of the measuring devices 1 to 3, the operation stop time of the measuring devices 1 to 3, and the operation stop time due to errors of the measuring devices 1 to 3 during the specified time (from 0:00:00 on December 6, 2024 to 23:59:59 on December 6, 2024) are displayed. Here, the operation stop time due to errors of the measuring devices 1 to 3 is displayed for each of the stop reasons (information regarding the reason in the case of operation stop) A to C.

[0024] Hereinafter, an example of the operation of the data processing system 1 according to the present embodiment will be described with reference to FIG. 3.

[0025] As shown in FIG. 3, in step S101, the first processing unit 13 acquires the status information of each of the devices A to C...

[0026] In step S102, the first processing unit 13 compares the acquired status information of each of the devices A to C... with the status information stored as the latest value in the cache 12.

[0027] If there is a deviation between the two, this operation proceeds to step S103. If there is no deviation between the two, this operation proceeds to step S104.

[0028] In step S103, the first processing unit 13 stores the acquired status information of each of the devices A to C... as the latest value in the database 11 and the cache 12.

[0029] In step S104, the first processing unit 13 discards the acquired status information of each device A to C... without saving it.

[0030] In step S105, the second processing unit 14 aggregates the downtime for each reason for stopping each device A to C… during the specified time period, based on the status information of each device A to C… stored in the database 11.

[0031] In step S106, the display unit 15 acquires and displays the aggregated results from the second processing unit 14 (for example, the display screen shown in Figure 2).

[0032] According to the data processing system 1 of this embodiment, only the status information that has changed in operating status from each device A to C... is stored in the database 11, and based on the stored status information of each device A to C..., the downtime for each reason for stopping of each device A to C... during a specified time period can be aggregated and displayed, thus enabling a response to market demands.

[0033] Although the present invention has been described in detail using the embodiments described above, it will be clear to those skilled in the art that the present invention is not limited to the embodiments described herein. The present invention can be implemented in modified and altered forms without departing from the spirit and scope of the invention as defined by the claims. Therefore, the description herein is for illustrative purposes only and is not intended to be restrictive in any way to the present invention. [Explanation of Symbols]

[0034] 1…Data processing system 11…Database 12…cache 13…First Processing Unit 14…Second Processing Unit 15…Display section

Claims

1. A data management system that displays the operating status of each piece of equipment based on status information of each piece of equipment transmitted at predetermined intervals from multiple pieces of equipment installed on a production line, A first processing unit that stores in a database only the status information of each device that has changed in its operating status, from the status information of each device transmitted from each device. A second processing unit aggregates the downtime for each reason for stopping each device during a specified time period, based on the status information of each device stored in the database. The system includes a display unit that acquires and displays the aggregated results of the second processing unit, A data management system in which the status information includes ID information that identifies each of the devices, information regarding the operation and shutdown of each of the devices, information regarding the reason for the shutdown, and time information when the status information was transmitted.

2. The first processing unit is, The process involves saving the latest value of the aforementioned status information to the cache, The data management system according to claim 1, which performs the following steps: compare the newly acquired status information with the status information stored in the cache, and if there is a discrepancy between the two, save the newly acquired status information to the database and save it to the cache as the latest value.

Images