Data management assisting device and data management assisting method

Abstract

To assist the decision by a user when the user determines whether multiple pieces of operation data can be combined or not.SOLUTION: A data management assisting device 10 according to the present disclosure includes a control unit 15. This control unit: obtains multiple pieces of operation data which record the operation states of the facilities in a factory, each piece of operation data including time-series data with at least one column; determines whether the number of columns of the time-series data in reference operation data which is selected as a reference from the multiple pieces of operation data matches the number of columns in the other operation data; and determines, by statistical processing, whether the attribute of the time-series data in the reference operation data matches the attribute of the time-series data in the other operation data.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present disclosure relates to a data management support device and a data management support method. [Background technology]

[0002] Conventionally, operation data that records the operating status of factory equipment has been acquired and used. For example, when an abnormality occurs in factory equipment, facilities, production processes, etc., the operation data has been used to identify the cause of the abnormality by looking back at past events.

[0003] For example, Patent Document 1 discloses a deterioration diagnosis device that acquires operation data of equipment and calculates the degree of deterioration of the equipment based on the operation data. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Application Laid-Open No. 2024-13399 Summary of the Invention [Problem to be solved by the invention]

[0005] Operational data is often output as tabular data at a predetermined frequency, such as once a day. When a facility is operated over a long period of time, the amount of such operational data becomes enormous.

[0006] When a facility has been in operation for a long period of time, the management method may change and the names of some of the equipment in the facility may change. In this case, the item names of the data corresponding to the equipment whose names have changed may be changed in the tabular operating data.

[0007] Furthermore, when a facility is operated for a long period of time, additional sensors may be installed and measurement items may be added. In this case, the number of columns corresponding to the added measurement items may increase in the tabular operating data.

[0008] When using past operating data, it is convenient to combine multiple pieces of operating data into a single file if they can be combined. For example, if there is several months' worth of operating data that records one day's worth of data, combining these into a single file is convenient for use in data analysis. Examples of data analysis using operating data include "detecting signs of abnormalities before they occur" and "discovering previously unnoticed value through big data analysis."

[0009] However, as mentioned above, when equipment is operated for a long period of time, data item names may be changed or columns may be added to the operation data. Therefore, when combining operation data, a user (e.g., an operator) must open the operation data files, check the contents of the operation data, and determine whether the operation data can be combined. This task of a user determining whether the operation data can be combined is extremely time-consuming, especially when the amount of operation data is enormous.

[0010] Therefore, an object of the present disclosure is to provide a data management support device and a data management support method that can support a user in determining whether or not to combine multiple pieces of driving data. [Means for solving the problem]

[0011] A data management support device according to some embodiments includes a control unit that acquires a plurality of pieces of operating data that record the operating status of factory equipment, each piece of operating data including at least one column of time-series data, determines whether the number of columns of time-series data included in reference operating data selected from the plurality of pieces of operating data matches the number of columns of time-series data included in other operating data, and determines whether attributes of the time-series data included in the reference operating data match attributes of the time-series data included in the other operating data through statistical processing. Such a data management support device can assist a user in determining whether or not to combine a plurality of pieces of operating data.

[0012] In one embodiment, the control unit may use a nonparametric method as the statistical processing to determine whether attributes of the time-series data included in the reference driving data match attributes of the time-series data included in the other driving data. This makes it possible to determine whether attributes of the time-series data included in the driving data match without specifying the attributes of the time-series data included in the driving data by assuming that the attributes have a specific distribution.

[0013] In one embodiment, the control unit may calculate a p-value using the nonparametric method, and if the p-value is not outside a critical region, determine that there is a high degree of match between attributes of the time-series data included in the reference driving data and attributes of the time-series data included in the other driving data, and that the time-series data included in the reference driving data and the time-series data included in the other driving data can be combined. This makes it possible to determine whether attributes of the time-series data included in the driving data match based on the calculated p-value.

[0014] In one embodiment, the data management support device further includes an output unit, and the control unit may display on the output unit a determination result of whether the number of columns of time-series data included in the reference operating data matches the number of columns of time-series data included in the other operating data, and a determination result of whether the attributes of the time-series data included in the reference operating data match the attributes of the time-series data included in the other operating data. This allows a user to easily confirm whether the number of columns of time-series data included in the operating data matches and whether the attributes of the time-series data included in the operating data match.

[0015] In one embodiment, the data management support device may further include an input unit capable of receiving input from a user, and when the input unit receives a combine instruction to combine the reference operating data with the other operating data, the control unit may combine the reference operating data with the other operating data. This allows the reference operating data to be combined with the other operating data based on a user instruction.

[0016] In one embodiment, the control unit may automatically combine the reference operating data with the other operating data when it determines that the number of columns of time-series data included in the reference operating data matches the number of columns of time-series data included in the other operating data and that the attributes of the time-series data included in the reference operating data match the attributes of the time-series data included in the other operating data. This allows the reference operating data to be automatically combined with the other operating data when both the number of columns of time-series data included in the operating data and the attributes of the time-series data included in the operating data match.

[0017] A data management support method according to some embodiments is a data management support method for a data management support device, and includes the steps of: acquiring a plurality of pieces of operating data recording the operating status of equipment in a factory, each piece of operating data including at least one column of time-series data; determining whether the number of columns of time-series data included in reference operating data selected from the plurality of operating data matches the number of columns of time-series data included in other operating data; and determining by statistical processing whether the attributes of the time-series data included in the reference operating data match the attributes of the time-series data included in the other operating data. Such a data management support method can assist a user in determining whether or not to combine a plurality of pieces of operating data. [Effects of the Invention]

[0018] According to the present disclosure, it is possible to provide a data management support device and a data management support method that can support a user in determining whether or not to combine multiple pieces of driving data. [Brief explanation of the drawings]

[0019] [Figure 1] FIG. 10 is a diagram illustrating how a data management support device according to an embodiment acquires operation data from equipment. [Figure 2] 1 is a block diagram showing a configuration of a data management support device according to an embodiment; [Figure 3] FIG. 4 is a diagram illustrating an example of operation data. [Figure 4] FIG. 10 is a diagram showing an example of a state in which reference operating data is selected. [Figure 5] 10A and 10B are diagrams illustrating an example of a display of a determination result of whether the number of columns matches and a determination result of whether the attributes match. [Figure 6] FIG. 10 is a diagram showing another example of the driving data. [Figure 7] 10 is a flowchart illustrating an example of an operation of the data management support device according to an embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0020] Hereinafter, an embodiment of the present disclosure will be described with reference to the drawings.

[0021] FIG. 1 is a diagram showing how a data management support device 10 according to an embodiment acquires operation data from equipment 20. As shown in FIG.

[0022] The facility 20 is a facility such as a factory. Various types of equipment may be installed in the facility 20. The facility 20 may include, for example, a turbine, a compressor, etc. As the various types of equipment, the facility 20 may also be installed with sensors that detect the status of the various types of equipment. The sensors may be, for example, vibration sensors, temperature sensors, pressure sensors, flow rate sensors, gas sensors, etc.

[0023] Sensors installed in the facility 20 detect the status of various devices at predetermined time intervals. A control device installed in the facility 20 creates operation data including at least one column of time-series data, such as time-series data in a tabular format, based on the data output by the various sensors. In this way, the facility 20 creates operation data that records the operating status of the facility 20 in the factory.

[0024] The equipment 20 may create operating data for each predetermined period. For example, the equipment 20 may create operating data for each day. The equipment 20 transmits the created operating data to the data management support device 10.

[0025] Although FIG. 1 shows one piece of equipment 20, if a factory has multiple pieces of equipment 20, each of the multiple pieces of equipment 20 may create operating data at predetermined intervals and transmit the created operating data to the data management support device 10.

[0026] The data management support device 10 acquires operation data that records the operating status of the factory equipment 20 from the equipment 20. For example, if the equipment 20 creates operation data every day, the data management support device 10 acquires new operation data from the equipment 20 every day.

[0027] If the data management support device 10 is capable of communicating with a control device installed in the facility 20 via wireless or wired communication, the data management support device 10 may acquire operating data from the control device installed in the facility 20 via wireless or wired communication. In this embodiment, an example will be described in which the data management support device 10 is capable of communicating with a control device installed in the facility 20 via wireless or wired communication. If the data management support device 10 is not capable of communicating with a control device installed in the facility 20, the data management support device 10 may read operating data stored in, for example, a USB (Universal Serial Bus) memory from a USB terminal.

[0028] The configuration of the data management support device 10 according to an embodiment of the present disclosure will be described with reference to FIG.

[0029] The data management support device 10 is, for example, a dedicated computer configured to function as a server, or may be a general-purpose PC (Personal Computer).

[0030] The data management support device 10 includes a communication unit 11, a storage unit 12, an input unit 13, an output unit 14, and a control unit 15.

[0031] The communication unit 11 includes a communication module. For example, the communication unit 11 may include a communication module compatible with a LAN (Local Area Network). In one embodiment, the data management support device 10 is connected to a network via the communication unit 11. The communication unit 11 transmits and receives various information via the network. The communication unit 11 is capable of communicating with a control device installed in the facility 20 via the network.

[0032] The storage unit 12 may be, for example, a semiconductor memory, a magnetic memory, an optical memory, or the like, but is not limited to these. The storage unit 12 may function as, for example, a main storage device, an auxiliary storage device, or a cache memory. The storage unit 12 stores any information used in the operation of the data management support device 10. For example, the storage unit 12 may store system programs, application programs, and various information received by the communication unit 11. A portion of the storage unit 12 may be installed external to the data management support device 10. In this case, the externally installed portion of the storage unit 12 may be connected to the data management support device 10 via any interface.

[0033] The input unit 13 can receive input from a user and includes one or more input interfaces that detect the input from the user and acquire input information based on the user's operation. For example, the input unit 13 includes, but is not limited to, physical keys, capacitive keys, a touch screen integrated with the display of the output unit 14, or a microphone that receives voice input.

[0034] The output unit 14 includes one or more output interfaces that output information to notify the user. For example, the output unit 14 includes, but is not limited to, a display that outputs information as an image, a speaker that outputs information as sound, etc.

[0035] Control unit 15 includes at least one processor, at least one dedicated circuit, or a combination of these. The processor is a general-purpose processor such as a CPU (Central Processing Unit) or a GPU (Graphics Processing Unit), or a dedicated processor specialized for a specific process. The dedicated circuit is, for example, an FPGA (Field-Programmable Gate Array) or an ASIC (Application Specific Integrated Circuit). Control unit 15 controls each unit of data management support device 10 and executes processes related to the operation of data management support device 10.

[0036] (Operation of the data management support device) Next, the operation of the data management support device 10 will be described.

[0037] As described above, the control device installed in the equipment 20 transmits operation data that records the operating status of the factory equipment 20 to the data management support device 10. For example, if operation data is created daily in the equipment 20, the control device installed in the equipment 20 transmits the operation data daily to the data management support device 10.

[0038] The communication unit 11 of the data management support device 10 receives the operating data transmitted by the control device of the equipment 20. The control unit 15 acquires the operating data via the communication unit 11. The control unit 15 stores the acquired operating data in the memory unit 12. The control unit 15 stores the operating data acquired from the equipment 20 in the memory unit 12.

[0039] In this way, the control unit 15 acquires a plurality of pieces of operating data from the equipment 20 and stores the acquired plurality of pieces of operating data in the storage unit 12.

[0040] An example of the driving data is shown in Figure 3. The driving data includes at least one row of time-series data.

[0041] In the example shown in Fig. 3, the driving data includes time-series data in which data acquisition started at midnight on January 1, 2015, and data was acquired every minute. The driving data shown in Fig. 3 also includes nine measurement items: "data1_a," "data1_b," ... "data3_c." In the driving data shown in Fig. 3, item names such as "data1_a" may correspond to physical quantities detected by specific sensors.

[0042] The control unit 15 compares the reference driving data selected from the plurality of driving data stored in the storage unit 12 with other driving data. Hereinafter, the "reference driving data" may be referred to as "reference driving data."

[0043] 4 shows an example of how reference operating data is selected from a plurality of operating data.

[0044] Before performing an operation to select the reference driving data, the user can select a plurality of driving data to be subjected to the comparison process from the plurality of driving data stored in the storage unit 12. For example, the user can select a plurality of driving data to be subjected to the comparison process by operating the input unit 13 to select a specific folder or to select a plurality of driving data files.

[0045] When a plurality of driving data to be subjected to the comparison process is selected by a user's operation on the input unit 13, the control unit 15 causes the output unit 14 to display the plurality of driving data to be subjected to the comparison process.

[0046] In the example shown in Fig. 4, the control unit 15 displays file names corresponding to a plurality of pieces of driving data for which comparison processing is to be performed in the area 102. In the example shown in Fig. 4, driving data with file names "2023-1", "2023-2", "2023-3", and "2023-4" are displayed.

[0047] The user can select the reference operating data by operating the input unit 13 and checking one of the check boxes in the area 101. In the example shown in Fig. 4, the user selects the operating data with the file name "2023-1" as the reference operating data.

[0048] When the confirmation button 106 is clicked with the reference operating data selected, the control unit 15 executes a process of comparing the reference operating data with other operating data. In the example shown in FIG. 4, the reference operating data is operating data with the file name "2023-1". The other operating data are operating data with the file names "2023-2", "2023-3", and "2023-4". The control unit 15 executes a process of comparing each of the operating data with the file name "2023-2", "2023-3", and "2023-4" with the reference operating data with the file name "2023-1".

[0049] As a process for comparing the reference operating data with other operating data, the control unit 15 executes a process for determining whether the number of columns of time series data included in the reference operating data matches the number of columns of time series data included in the other operating data, and a process for determining by statistical processing whether the attributes of the time series data included in the reference operating data match the attributes of the time series data included in the other operating data.

[0050] First, a process for determining whether the number of columns of the time-series data included in the reference operating data matches the number of columns of the time-series data included in the other operating data will be described. The number of columns corresponds to, for example, the number of measurement items measured by various sensors in the facility 20.

[0051] The control unit 15 compares the number of columns of time series data included in the reference operating data with the number of columns of time series data included in other operating data. For example, the control unit 15 compares the number of columns of time series data included in operating data with the file name "2023-1" with the number of columns of time series data included in operating data with the file name "2023-2".

[0052] If the number of columns of time series data included in the reference operating data is the same as the number of columns of time series data included in the other operating data, the control unit 15 determines that the number of columns of time series data included in the reference operating data is the same as the number of columns of time series data included in the other operating data.If the number of columns of time series data included in the reference operating data is not the same as the number of columns of time series data included in the other operating data, the control unit 15 determines that the number of columns of time series data included in the reference operating data is not the same as the number of columns of time series data included in the other operating data.

[0053] Next, a process for determining whether the attributes of the time-series data included in the reference driving data match the attributes of the time-series data included in other driving data through statistical processing will be described. Here, the attributes of the time-series data may represent the statistical tendency of the distribution of the time-series data. The attributes of the time-series data may include, for example, data such as the average value and variance value as statistical data of the distribution of the time-series data.

[0054] The control unit 15 determines, by statistical processing, whether the attributes of the time-series data included in the reference operating data match those of the time-series data included in the other operating data. For example, the control unit 15 determines, by statistical processing, whether the attributes of the time-series data included in the operating data with the file name "2023-1" match those of the time-series data included in the operating data with the file name "2023-2".

[0055] Here, determining whether the attributes of the time series data contained in the reference driving data match those of the time series data contained in the other driving data means determining whether the attributes of the time series data contained in the reference driving data match those of the time series data contained in the other driving data to the extent that the reference driving data and the other driving data can be combined.

[0056] For example, if the reference operating data and the other operating data are operating data of the same equipment 20 but differ only in date, the attribute trends of the time series data contained in the reference operating data and the attribute trends of the time series data contained in the other operating data are nearly the same, and the attribute trends of the time series data contained in the reference operating data and the attribute trends of the time series data contained in the other operating data are similar to the extent that they may be combined.

[0057] Furthermore, for example, if the item name of one column of at least one column of time-series data is different between the reference operating data and the other operating data, but the data is essentially the same sensor measurement data except for the item name, the attribute trends of the time-series data included in the reference operating data and the attribute trends of the time-series data included in the other operating data are approximately the same, and the attribute trends of the attributes of the time-series data included in the reference operating data and the attribute trends of the time-series data included in the other operating data match to an extent that they may be combined. In this way, if only the item name has changed, the control unit 15 can determine that the attribute trends of the attributes of the time-series data included in the reference operating data and the attribute trends of the time-series data included in the other operating data match to an extent that they may be combined.

[0058] The control unit 15 may determine whether the attributes of the time series data included in the reference operating data match those of the time series data included in the other operating data, for example, by using a nonparametric method as statistical processing. By using a nonparametric method, the control unit 15 can determine whether the attributes of the time series data included in the reference operating data match those of the time series data included in the other operating data, without having to assume and specify that the attributes of the time series data included in the operating data are attributes of time series data included in a specific distribution such as a normal distribution.

[0059] When the nonparametric method is used for the determination, the control unit 15 calculates a p-value using the nonparametric method, and if the p-value does not exceed the rejection region, the control unit 15 determines that the attribute of the time-series data included in the reference operating data and the attribute of the time-series data included in the other operating data are highly consistent, and the reference operating data and the other operating data are combinable, i.e., match. If the p-value exceeds the rejection region, the control unit 15 determines that the attribute of the time-series data included in the reference operating data and the attribute of the time-series data included in the other operating data are low consistent, and the reference operating data and the other operating data are not combinable, i.e., do not match. The value of the rejection region may be set in advance.

[0060] The control unit 15 causes the output unit 14 to display the determination result of whether the number of columns of the time series data included in the reference operating data matches the number of columns of the time series data included in the other operating data. The control unit 15 also causes the output unit 14 to display the determination result of whether the attributes of the time series data included in the reference operating data match the attributes of the time series data included in the other operating data.

[0061] FIG. 5 shows an example of a display of the determination result of whether the number of columns of time series data included in the reference operating data matches the number of columns of time series data included in other operating data, and the determination result of whether the attributes of time series data included in the reference operating data match the attributes of time series data included in other operating data.

[0062] 5, the result of the determination as to whether the number of columns of the time-series data included in the driving data matches is displayed in area 103. The result of the determination as to whether the attributes of the time-series data included in the driving data match is displayed in area 104.

[0063] In the example shown in Fig. 5, the operating data with the file name "2023-2" is determined to have the same number of columns as the reference operating data, and the attributes of the time-series data included in the operating data are also determined to be similar to the reference operating data to the extent that they can be combined with the reference operating data. Furthermore, the operating data with the file name "2023-3" is determined to have a different number of columns than the reference operating data, and the attributes of the time-series data included in the operating data are also determined to be similar to the reference operating data to the extent that they can be combined with the reference operating data. Furthermore, the operating data with the file name "2023-4" is determined to have the same number of columns as the reference operating data, and the attributes of the time-series data included in the operating data are also determined to be similar to the reference operating data to the extent that they can be combined with the reference operating data.

[0064] As an example, assume that FIG. 3 shows reference operating data with the file name "2023-1". Also assume that FIG. 6 shows operating data with the file name "2023-3". In this case, the reference operating data with the file name "2023-1" shown in FIG. 3 starts acquiring data at midnight on January 1, 2015, and includes time-series data acquired every minute. In contrast, the operating data with the file name "2023-3" shown in FIG. 6 starts acquiring data at midnight on January 1, 2016, and includes time-series data acquired every minute. Looking at the operating data shown in FIG. 6, we see that a column with the measurement item "data4" has been added.

[0065] Therefore, the number of columns of time-series data included in the operating data shown in Fig. 6 is greater than the number of columns of time-series data included in the reference operating data shown in Fig. 3. Therefore, in area 103 shown in Fig. 5, the part with the file name "2023-3" is displayed as "NG".

[0066] On the other hand, the operating data shown in Fig. 6 only has a column for the measurement item "data4" added, and the attributes of the time-series data included in the operating data shown in Fig. 6 match to the extent that they can be combined with the attributes of the time-series data included in the reference operating data shown in Fig. 3. Therefore, in area 104 shown in Fig. 5, the part with the file name "2023-3" is displayed as "OK".

[0067] The control unit 15 can display the determination result as shown in FIG. 5 on the output unit 14, thereby assisting the user in determining whether or not to combine a plurality of pieces of driving data.

[0068] The user can select the operating data to be combined with the reference operating data by operating the input unit 13 to check the checkbox in the area 105. In the example shown in Fig. 5, the user selects the operating data with the file name "2023-2" and the operating data with the file name "2023-4" as the operating data to be combined with the reference operating data.

[0069] When the combine button 107 is clicked while the operating data to be combined with the reference operating data is selected, i.e., when the input unit 13 receives a combine instruction, the control unit 15 executes a process of combining the reference operating data with the selected operating data. In the example shown in Fig. 5, the control unit 15 executes a process of combining the operating data with the file name "2023-2" and the operating data with the file name "2023-4" with the reference operating data with the file name "2023-1".

[0070] FIG. 5 shows an example in which the user selects driving data to be combined with the reference driving data. However, if the control unit 15 determines that the number of columns of time series data included in the reference driving data matches the number of columns of time series data included in the other driving data, and also determines that the attributes of the time series data included in the reference driving data match the attributes of the time series data included in the other driving data, the control unit 15 may automatically combine the reference driving data with the other driving data.

[0071] The operation of the data management support device 10 will be described with reference to the flowchart shown in FIG.

[0072] In step S101 , the control unit 15 of the data management support device 10 acquires operation data from the equipment 20 .

[0073] In step S102, the control unit 15 compares the reference operating data selected from the acquired plurality of operating data with other operating data.

[0074] In step S103, the control unit 15 determines whether the number of columns of the time-series data included in the reference operating data matches the number of columns of the time-series data included in the other operating data.

[0075] In step S104, the control unit 15 determines whether the attribute of the time-series data included in the reference operating data matches the attribute of the time-series data included in the other operating data through statistical processing.

[0076] After executing step S103 and step S104, the control unit 15 may cause the output unit 14 to display the determination result of whether the number of columns of time series data included in the reference operating data matches the number of columns of time series data included in the other operating data, and the determination result of whether the attributes of the time series data included in the reference operating data match the attributes of time series data included in the other operating data.

[0077] The data management support device 10 according to the embodiment described above can assist a user in determining whether to combine multiple pieces of operating data. More specifically, in the data management support device 10 according to the embodiment, the control unit 15 acquires multiple pieces of operating data from the factory equipment 20, determines whether the number of columns of time-series data included in reference operating data selected from the multiple pieces of operating data matches the number of columns of time-series data included in the other operating data, and performs statistical processing to determine whether the attributes of the time-series data included in the reference operating data match the attributes of the time-series data included in the other operating data. This allows the user to easily confirm the match between the number of columns of time-series data included in the reference operating data and the number of columns of time-series data included in the other operating data, and to easily confirm the match between the attributes of the time-series data included in the reference operating data and the attributes of the time-series data included in the other operating data. Therefore, the data management support device 10 according to the embodiment can assist a user in determining whether to combine multiple pieces of operating data.

[0078] It will be apparent to those skilled in the art that the present disclosure can be embodied in other specific forms other than the above-described embodiments without departing from the spirit or essential characteristics thereof. Therefore, the foregoing description is illustrative and not limiting. The scope of the disclosure is defined not by the foregoing description but by the appended claims. All modifications within the range of equivalents of any modifications are intended to be encompassed therein.

[0079] For example, the arrangement and number of each component described above are not limited to the above description and the illustrations in the drawings, and may be arbitrarily configured as long as the functions thereof can be realized.

[0080] For example, a general-purpose electronic device such as a smartphone or a computer can be configured to function as the data management support device 10 according to the above-described embodiment. Specifically, a program describing the processing content for realizing each function of the data management support device 10 according to the embodiment can be stored in the memory of the electronic device, and the program can be read and executed by a processor of the electronic device.

[0081] For example, in the above-described embodiment, the control unit 15 uses a nonparametric method to determine whether the attributes of the time series data included in the reference operating data match those of the time series data included in the other operating data. However, the process by which the control unit 15 determines whether the attributes of the time series data included in the reference operating data match those of the time series data included in the other operating data is not limited to using a nonparametric method and may be performed using other statistical processing. For example, the control unit 15 may compare the average value and variance of the reference operating data with the average value and variance of the other operating data to determine whether the attributes of the time series data included in the reference operating data match those of the time series data included in the other operating data.

[0082] For example, in the above-described embodiment, the display examples of the output unit 14 shown in Figures 4 and 5 are merely examples. The control unit 15 may cause the output unit 14 to display a display in a different manner.

[0083] For example, in the above-described embodiment, the equipment 20 may be provided with a storage device that stores operation data. In this case, the data management support device 10 may communicate with the storage device of the equipment 20 to acquire the operation data of the storage device of the equipment 20.

[0084] For example, the operating data stored in the storage unit 12 of the data management support device 10 may be in a predetermined file format (e.g., CSV format, etc.). Furthermore, when the operating data is stored in a storage device provided in the equipment 20, the operating data stored in the storage device provided in the equipment 20 may be in a predetermined file format (e.g., CSV format, etc.). [Explanation of symbols]

[0085] 10. Data management support device 11 Communications Department 12 Storage section 13 Input section 14 Output section 15 Control Unit 20 Equipment

Claims

1. Acquire a plurality of pieces of operation data that record the operating status of equipment in a factory, each piece of operation data including at least one row of time-series data; determining whether the number of columns of time-series data included in reference operating data selected from the plurality of operating data matches the number of columns of time-series data included in the other operating data; a control unit that determines whether an attribute of time-series data included in the reference operating data matches an attribute of time-series data included in the other operating data by statistical processing; A data management support device comprising:

2. 2. The data management support device according to claim 1, The control unit uses a non-parametric method as the statistical processing to determine whether an attribute of the time series data included in the reference operating data matches an attribute of the time series data included in the other operating data.

3. 3. The data management support device according to claim 2, The control unit calculates a p-value using the nonparametric method, and if the p-value does not exceed a rejection region, determines that there is a high degree of match between the attributes of the time series data contained in the reference operating data and the attributes of the time series data contained in the other operating data, and that the time series data contained in the reference operating data and the time series data contained in the other operating data can be combined.

4. 2. The data management support device according to claim 1, further comprising an output unit; The control unit causes the output unit to display a determination result of whether the number of columns of time series data included in the reference operating data matches the number of columns of time series data included in the other operating data, and a determination result of whether the attributes of the time series data included in the reference operating data match the attributes of the time series data included in the other operating data.

5. 5. The data management support device according to claim 4, further comprising an input unit capable of receiving input from a user; When the input unit receives a combining instruction to combine the reference operating data with the other operating data, the control unit combines the reference operating data with the other operating data.

6. 2. The data management support device according to claim 1, The control unit determines that the number of columns of time series data included in the reference operating data matches the number of columns of time series data included in the other operating data, and if it determines that the attributes of the time series data included in the reference operating data match the attributes of the time series data included in the other operating data, the control unit automatically combines the reference operating data with the other operating data.

7. A data management support method in a data management support device, acquiring a plurality of pieces of operation data that record the operating status of equipment in a factory, each piece of operation data including at least one row of time-series data; determining whether the number of columns of time-series data included in reference operating data selected from the plurality of operating data matches the number of columns of time-series data included in other operating data; determining whether an attribute of time-series data included in the reference operational data matches an attribute of time-series data included in the other operational data by statistical processing; A data management support method, including:

Images