Information collection and display system, information collection method, and information display method

An information collection and display system is provided, in which a data generation device that generates site data and a transaction data accumulation unit that stores the site data are connected. The system includes an association data accumulation unit storing association data which defines an association of each of multiple pieces of information included in the site data; an association data search unit which searches for second information associated with first information included in the pieces of information, on the basis of the association data; and a user interface that displays a connection relation of the pieces of information associated by the association data. The association data search unit searches for the second information associated with the first information displayed on the user interface and displays the first information and the second information on the user interface with the connection relation of the pieces of information.

INCORPORATION BY REFERENCE

This application claims priority based on Japanese patent application, No. 2018-037446 filed on Mar. 2, 2018, the entire contents of which are incorporated herein by reference.

BACKGROUND OF THE INVENTION

The present invention relates to an information collection and display system, an information collection method, and an information display method.

Conventionally, there are many tasks configuring a manufacturing process when finished products and the like are manufactured in factories or offices in a manufacturing industry. In each task configuring the manufacturing process, site data is generated and collected when the task is completed or a predetermined event is generated and the site data is analyzed to optimize work efficiency in each task. On the other hand, if departments managing the respective tasks are different, information sharing between the departments becomes difficult and an improvement on a problem associated with the departments (tasks) does not progress. As one of the reasons why the improvement on the problem associated with the departments (tasks) does not progress, it is considered that a system used for managing the task in each department is different and a management system is not standardized. In each department, optimization of work efficiency in the department progresses by analyzing the collected site data. For this reason, if overall optimization of a series of manufacturing processes is sought, efficiency of an own department may be lowered. As a result, a department evaluation may be lowered.

However, in the manufacturing industry, a production system proceeds from a mass production system to a small quantity multi-product production system and cooperation between the departments is indispensable to increase production efficiency of the whole manufacturing process. As a method for promoting the cooperation between the departments, it is considered that the cooperation between the departments is promoted by presenting site data managed by an own department and site data managed by other departments in association with each other, instead of presenting a problem using fact data (fact information) capable of analyzing the problem commonly in each department.

JP 2015-153196 A discloses an information collection system in which it is not necessary to configure a link between databases and various site data and supplementary information of each manufacturing process can be efficiently collected easily from the viewpoint of traceability.

In addition, JP 2017-102548 A discloses a production management device in which traceability data can be managed for each work without using an ID tag and the traceability data can be easily specified from a defective product.

SUMMARY

However, in the information collection system described in JP 2015-153196 A, it is necessary to store all associated data as supplementary information in a database and the database having an enormous storage capacity is required. For this reason, a facility cost or a maintenance cost increases. Furthermore, if a user does not understand a data structure of the data stored in the database, the user cannot acquire desired data.

In the production management device described in JP 2017-102548 A, a data generation device that generates the site data is limited to a specific device and it is difficult to associate all the site data collected or generated by a series of manufacturing processes. In addition, although an identifier is attached to the collected site data, only association between a finished product and parts corresponding to the finished product is known and how to associate and display the site data in a series of manufacturing processes is not presented. For this reason, it is difficult to effectively use the collected site data.

Accordingly, the present invention has been made in view of the above problems and an object of the present invention is to accumulate and manage necessary minimum information to associate task information and task association information included in site data as association data to decrease a capacity of a storage device that stores the association data and search for and display predetermined first information and second information associated with the first information using the association data to easily analyze site data at each site.

To solve the above problems, according to an aspect of the present invention, there is an information collection and display system in which a data generation device that generates site data and a storage device that stores the site data generated by the data generation device are connected.

The information collection and display system includes an association data accumulation unit that stores association data defining association of each of a plurality of pieces of information included in the site data; an association data search unit that searches for second information associated with first information included in the plurality of pieces of information, on the basis of the association data stored in the association data accumulation unit; and a user interface unit that displays a connection relation of the plurality of pieces of information associated by the association data. The association data search unit searches for the second information associated with the first information on the basis of the association data, according to selection of the first information in the connection relation of the plurality of pieces of information displayed on the user interface unit, and displays the first information and the second information on the user interface unit with the connection relation of the plurality of pieces of information.

According to the aspect, necessary minimum information to associate the plurality of pieces of information included in the site data is accumulated and managed as the association data, so that a capacity of the storage device that stores the association data can be decreased, and the predetermined first information and the second information associated with the first information are searched and displayed using the association data, so that site data at each site can be easily analyzed.

According to the present invention, site data can be easily analyzed.

The details of one or more implementations of the subject matter described in the specification are set forth in the accompanying drawings and the description below. Other features, aspects, and advantages of the subject matter will become apparent from the description, the drawings, and the claims.

DETAILED DESCRIPTION OF THE EMBODIMENTS

Hereinafter, an information collection and display system1according to an embodiment of the present invention will be described using the drawings. In this embodiment, the case where the information collection and display system1is applied to a system for collecting and displaying site data generated by each manufacturing process in a manufacturing factory is described as an example.

FIG.1is a diagram illustrating a connection relation between the information collection and display system1and a data generation device5and accumulation units3and4accumulating actual data.

As shown inFIG.1, the information collection and display system1is connected to a network2. A plurality of data generation devices5a,5b, and5c(hereafter, the data generation devices5a,5b, and5care simply referred to as the data generation device5unless otherwise distinguished) that collects or generates actual data, the master data accumulation unit3, and the transaction data accumulation unit4that accumulates the actual data (hereinafter, referred to as site data100) are connected to the network2and the data generation device5, the master data accumulation unit3, and the transaction data accumulation unit4are connected to the information collection and display system1via the network2.

The data generation device5is, for example, a barcode reader that acquires a work log of a worker, a PC or a server (for example, the data generation device5a) that collects the work log, a machine (for example, the data generation device5b) that processes a part or assemble a finished product, a sensor (for example, the data generation device5c) that collects inspection information of a radio frequency identifier (RFID) attached to the part or the finished product, or the like. The site data100(actual data) collected or generated by the data generation device5is transmitted to the information collection and display system1, the master data accumulation unit3, or the transaction data accumulation unit4via the network2.

The master data accumulation unit3is, for example, a storage device such as a server and a memory and accumulates a model for defining what kind of information is accumulated in the transaction data accumulation unit4or the like. The model is also referred to as master data. That is, the master data (model) defined by the master data accumulation unit3is changed, so that it is possible to change what kind of site data100(type of information to be collected) is collected from the data generation device5. The master data of the master data accumulation unit3can be set or changed by an external device (not shown in the drawings).

The transaction data accumulation unit4is, for example, a storage device such as a server and a memory and the site data100including the information defined by the master data of the master data accumulation unit3is accumulated in the transaction data accumulation unit4. In the embodiment, the site data100(seeFIG.7) such as identification information, a generation date and time, and an actual measurement value is accumulated in the transaction data accumulation unit4.

[Information Collection and Display System]

Next, main functions of the information collection and display system1will be described. The information collection and display system1includes a central processing unit (CPU) that performs whole control of the information collection and display system1, a storage device (Read Only Memory: ROM) that stores each control program to control the information collection and display system1, a primary storage device (Random Access Memory: RAM) that temporarily stores information processed by the CPU, and a hard disk drive (HDD) and the CPU executes each control program stored in the ROM, so that the following functions are realized.

FIG.2is a block diagram illustrating the functions of the information collection and display system.

As shown inFIG.2, the information collection and display system1includes an association data model creation unit10, an association data registration unit11, an association data search unit12, an accumulation data acquisition unit13, an analysis data accumulation unit14, an association data accumulation unit15, a data provision API unit16, a comparison data definition unit17, and a temporary accumulation unit18.

As described above, the information collection and display system1is connected to a dictionary database6, the transaction data accumulation unit4, the data generation device5, and the master data accumulation unit3via the network2. Further, the association data model creation unit10and the association data search unit12of the information collection and display system1are connected to a user interface7such as a display and can display information of a result processed by the information collection and display system1on the user interface7to provide the information to a user or the user can input predetermined information to the association data model creation unit10or the association data search unit12via the user interface7. In the information collection and display system1, the analysis data accumulation unit14or the data provision API unit16can provide the information of the result processed by the information collection and display system1to an application8outside the information collection and display system1.

The association data model creation unit10reads master data corresponding to model data from the master data accumulation unit3, on the basis of the model data input from the user interface7, and creates definition information300(400) to be described later. The definition information300(400) created by the association data model creation unit10has a predetermined data structure and defines what kind of data structure the association data registration unit11acquires the site data100with, from the data generation device5.

The association data registration unit11receives the site data100from the data generation device5and structures the site data100on the basis of the data structure defined by the definition information300(400) acquired from the association data model creation unit10. In addition, the association data registration unit11determines whether the site data100acquired according to the definition information300(400) is task information, information of a worker, information of a machine, information of a work procedure, or information of a material (part), on the basis of identification information assigned to the site data100. Hereinafter, initial letters M of the worker (Man), the machine (Machine), the work procedure (Method), and the material (Material) may be taken and these may be referred to as 4M information (or 4M nodes) or task association information.

Here, the comparison data definition unit17is connected to the association data registration unit11. A relation between the 4M information determined by the association data registration unit11and the identification information assigned to the site data100is defined in the comparison data definition unit17and the association data registration unit11correlates the 4M information determined by the association data registration unit11with the actually acquired site data100(maps the identification information of the site data100to the 4M information), on the basis of the definition. The association data registration unit11transmits the 4M information after the site data100is correlated to the association data accumulation unit15. Further, the temporary accumulation unit18is connected to the association data registration unit11. The temporary accumulation unit18is a storage device such as a memory and information to constitute a connection relation (to generate a connection line) of each information (the task information and the 4M information) included in the site data100is registered in the temporary accumulation unit18.

The accumulation data acquisition unit13acquires the site data100from the transaction data accumulation unit4or the master data accumulation unit3, on the basis of association data200accumulated in the association data accumulation unit15.

When the user selects 4M information (first information) of the predetermined task from the user interface7, the association data search unit12searches for other 4M information (second information) of the task associated with the 4M information (first information) on the basis of identification information assigned to the 4M information (first information) and displays the searched 4M information (second information) on the user interface7by hatching, color coding, or the like to provide the 4M information to the user. In addition, the association data search unit12transmits a connection relation of the selected 4M information (first information) and the searched 4M information (second information) to the analysis data accumulation unit14. An example of a method of searching the 4M information by the association data search unit12will be described later.

The analysis data accumulation unit14accumulates the connection relation of the selected 4M information (first information) and the searched 4M information (second information), transmitted from the association data search unit12. The analysis data accumulation unit14transmits the accumulated connection relation of the 4M information to the application8, so that other 4M information of the task associated with the selected 4M information can be used for various analysis methods.

The data provision API (Application Programming Interface) unit16transmits data associated by the association data200to the application8. Here, the data provision API unit16is connected to the dictionary database6. Here, item names of the 4M information used in each manufacturing process (task) may be different for each manufacturing process. Therefore, different words having the same meanings in the item names of the 4M information used in each manufacturing process are registered in association with each other in the dictionary database6and the data provision API unit16can surely acquire the data associated by the association data200, including different words having the same meanings as well as the same words.

Here, an example of a data structure of the association data200managed by the information collection and display system1will be described.

FIG.3is a diagram illustrating an example of a data structure of the association data200. The association data200is data that is accumulated in the association data accumulation unit15.

As shown inFIG.3, the data structure of the association data200can represent what worker, machine, and part are associated in what way according to what work procedure, for the predetermined task (manufacturing process), by associating the site data100generated from various devices (data generation device5) in each manufacturing process. In the embodiment, the association data200is configured by a task node210used as a center node, a part node220showing a material necessary for executing a task, a worker node230executing the task, a machine node240used to execute the task, a finished product node250generated as a result of executing the task using the part as the material, and a work procedure node260defining an execution procedure of the task. The finished product node250generated by executing the task node210becomes a material (part) to be used in a post-process and the part node220becoming the material of the task node210is a finished product generated in a pre-process. In other words, the meanings of the attributes of the part node220and the finished product node250are the same and the part node220and the finished product node250may be collectively referred to as a material node unless otherwise distinguished. As described above, the part node220, the worker node230, the machine node240, and the work procedure node260are referred to as the 4M information or the 4M nodes.

In the information collection and display system1, when a problem occurs in the finished product, it is possible to search the 4M information associated with the finished product by the association data200and it is possible to find a cause for a problem in a predetermined manufacturing process (task). In the embodiment, the case where identification information is assigned to each of the site data100collected or generated by the data generation device5in each manufacturing process is described as an example. In the information collection and display system1, association between tasks can be managed by accumulating the association data200defining the association of machines, workers, and the like for the tasks, over a plurality of manufacturing processes (tasks).

Basic information of the association data200is timing (date and time) associated with the association between the identification information showing each information. The site data100(actual data) shown by each identification information of the association data200is accumulated in the externally managed transaction data accumulation unit4and a method of accessing the site data100accumulated in the transaction data accumulation unit4(a memory address for accessing the transaction data accumulation unit4) is managed by the information collection and display system1.

The association data200is configured by the task node210and the 4M information. Each connection line to connect the nodes has an item necessary for executing the task as an input and the finished product generated by the actions as an output and this is represented by a directed graph. If manufacturing processes in which a plurality of tasks is linked are represented, these can be displayed as shown inFIGS.9and10to be described later.

FIG.4is a diagram illustrating an example of a structure of the definition information300created by the association data model creation unit10.

As shown inFIG.4, the association data model creation unit10has the definition information300and the definition information300is configured by task information310to be definition information of the task node210, worker information320to be definition information of the worker node230, part information330to be definition information of the part node230, finished product information340to be definition information of the finished product node250, machine information350to be definition information of the machine node240, and work procedure information360to be definition information of the work procedure node260.

The task information310is configured to include task identification information311, operation time information312, operation data access information313, and connection information314.

The task identification information311is identification information for defining what kind of task in the task node210. For example, in a manufacturing process of a vehicle, identification information that can uniquely specify a chassis pressing task or an assembling task is set. The task identification information311is identification information for defining association with other tasks and has a function of associating a plurality of tasks with each other. Information functioning as a key to acquire the site data100(actual data) from the transaction data accumulation unit4or the master data accumulation unit3on the basis of the operation data access information313is also included in the task identification information311.

Information on a start time and an end time at the time of executing a predetermined task is set in the operation time information312. For example, in the case of generating a finished product from parts in the predetermined task, an input time of the parts is set as the start time and a generation time of the finished product is set as the end time. The operation time information312is used as information for narrowing down from the viewpoint of time, in the case of referring to the operation information of the workers, the parts, the machines, and the like. By including the operation time information312, even in time series data in which association is difficult in the viewpoints other than time series, the definition information300can be associated as the time series data when the task is executed and can be provided to the user.

The operation data access information313is used at the time of accessing the site data100accumulated in the transaction data accumulation unit4managed at the outside of the information collection and display system1. Specifically, the operation data access information313includes a memory address of the site data100accumulated in the transaction data accumulation unit4or the master data accumulation unit3. From-To of connection information for associating the task node210with the 4M node is described in the connection information314. Details of the connection information314will be described later (seeFIG.6).

The worker information320is configured to include worker identification information321and operation data access information322. In the worker identification information321, an identifier for identifying a worker responsible for the task at the time of executing the task at the worker node230is set. The worker identification information321is used as a key for accessing a work record (log) of the worker accumulated in the transaction data accumulation unit4or the master data accumulation unit3, on the basis of the operation data access information322.

The part information330is configured to include part identification information331and operation data access information332. The part identification information331is defined for identifying a material (part) used in the task and the operation data access information332includes memory addresses for accessing information such as materials and processing histories of parts accumulated in the transaction data accumulation unit4or the master data accumulation unit3.

The finished product information340is configured to include finished product identification information341and operation data access information342. The finished product identification information341is defined for identifying a finished product generated in the task and the operational data access information342includes memory addresses for accessing information such as processing histories of finished products accumulated in the transaction data accumulation unit4or the master data accumulation unit3.

The machine information350is configured to include machine identification information351and operation data access information352. In the machine identification information351, information for identifying a machine to be used in the task is defined. For example, it is possible to identify whether the machine to be used in the task is a pressing machine, a coating machine, or an assembling machine, by the machine identification information351. The operation data access information352can refer to the operation data by using the operation data access information352and the machine identification information351, in the case where the user desires to refer to the operation data when the task is executed by the machine.

Finally, the work procedure information360is configured to include work procedure identification information361and work procedure data access information362. In the work procedure identification information361, identification information for specifying a work procedure manual in a target task is defined. The work procedure data access information362includes a memory address functioning as a key for accessing work procedure manual data accumulated in the transaction data accumulation unit4managed at the outside of the information collection and display system1.

To shorten an access time to the transaction data accumulation unit4managed at the outside of the information collection and display system1, information with a high utilization rate in the site data100may be held in the definition information.

FIG.5is a diagram illustrating an example of a structure of definition information400according to another embodiment ofFIG.4.

As shown inFIG.5, a basic structure of the definition information400according to a second embodiment is the same as the basic structure described in the definition information300ofFIG.4, but extension information470is added to each information. The information collection and display system1manages the association data200showing the connection relation of the respective site data100collected or generated in each manufacturing process and acquires the actual data of the site data100from the transaction data accumulation unit4managed at the outside of the information collection and display system1, so that it may take time to acquire the site data100. Therefore, in the information collection and display system1, when it is necessary to acquire the site data100more quickly, the extension information470to be a storage area for storing information with a high utilization rate selectively in advance is set in the definition information400. In this way, the information with the high utilization rate in the site data100can be directly held in the definition information400, so that the information with the high utilization rate can be quickly acquired. Further, information important for management of operation information of information such as tasks and parts may be stored in the extension information470. In this way, an analysis for an operation of the flow of the manufacturing process (line) can be easily performed.

Next, an example of the connection information314configuring the task information310described inFIG.4will be described. The connection information314is information for defining a connection relation of the task node210, the part node220, the worker node230, the machine node240, the finished product node250, and the work procedure node260in the association data200. That is, data of the connection relation of the respective nodes connected on the basis of the connection information314is matched with the association data200described inFIG.3and is stored in the association data accumulation unit15.

FIG.6is a diagram illustrating an example of each node connected on the basis of the connection information314. InFIG.6, descriptions of information such as each identification information and each data access information (seeFIGS.4and5) described above are omitted and only necessary information is described in the description of the connection information314.

As shown inFIG.6, the connection information314is configured to include a label311aand a manufacturing ID311bincluded in the task identification information311and a worker ID314a, a part ID input314b, a part ID output314c, a machine ID314d, a procedure ID314e, a pre-process ID314f, and a post-process ID314gincluded in the connection information314.

InFIG.6, all elements necessary for executing the task are defined by a direction from each 4M node (the part, the worker, the machine, and the work procedure) to the task node210and an output by execution of the work is defined by a direction from the task node210to the finished product node250. A connection relation of each node is defined by describing an ID set to each node in the connection information314. As a result, for example, a part ID (ID:Met001) set to the part node220and a part ID (ID:Met001) of the task node210are associated with each other and a connection line of a direction from the part node220to the task node210is created.

Similar to the above, even in each of the worker node230, the machine node240, and the work procedure node260, an ID set to each node and a corresponding ID of the task node210are matched with each other and are associated with each other and a connection line of a direction from each node to the work node210is defined. For the finished product node250, a finished product ID set to the finished product node250and a finished product ID of the task node210are associated with each other and a connection line of a direction from the task node210to the finished product node250is defined.

Next, an example of a configuration of the site data100will be described. The site data100collected or generated by the data generation device5is acquired by the association data registration unit11according to items and structures shown inFIG.7to be described below.

FIG.7is a diagram illustrating an example of a configuration of the site data100.

As shown inFIG.7, the site data100is configured to include task information110, worker information120, part information130, finished product information140, machine information150, and work procedure information160.

The task information110is configured to include task identification information111, generation date and time information112, and performance value information113. The task identification information111is an identifier for defining what type of task a task in which the site data100has been generated is. The generation date and time information112is information of a date and time when the site data100has been generated. For example, a date and time when the site data is collected or generated by the data generation device5is recorded in the generation date and time information112. The performance value information113is performance value information attached by the data generation device5. For example, in the case where the task is pressing, the number of finished products produced by one pressing work or the number of non-defective products sent to the post-process is recorded as the performance value information.

The worker information120is configured to include worker identification information121, generation date and time information122, and performance value information123. The worker identification information121is an identifier for specifying a worker responsible for a work who has performed the work. For example, an ID card held by the worker is read before the work, so that the worker identification information121for specifying the worker responsible for the work can be acquired. The generation date and time information122is information of a date and time when the worker has started the work. For example, when the worker performs a pressing work, a date and time at which one pressing work starts is recorded as date and time information. The performance value information123is information of a period during which the worker performed the work. For example, when the worker performs the pressing work, a work period (time) required for one pressing work is recorded as period information.

The part information130is configured to include part identification information131, generation date and time information132, and performance value information133. The part identification information131is an identifier for specifying a material (part) used in the work. The generation date and time information132is information showing a date and time when the part has been produced. The performance value information133is information such as the number of parts produced.

The finished product information140is configured to include finished product identification information141, generation date and time information142, and performance value information143. The finished product identification information141is an identifier for specifying a finished product produced by the work. The generation date and time information142is information showing a date and time when the finished product has been produced. The performance value information143is information such as the number of finished products produced by the corresponding task.

The machine information150is configured to include machine identification information151, generation date and time information152, and performance value information153. The machine identification information151is an identifier for specifying a machine used in the work and types such as a pressing machine, a coating machine, and an assembling machine are specified by the machine identification information151. The generation date and time information152is information showing a date and time when the machine has started the work. The performance value information153is information such as an operation time of the machine.

The work procedure information160is configured to include work procedure identification information161, generation date and time information162, and performance value information163. The work procedure identification information161is an identifier for specifying a work procedure manual necessary for the work. The generation date and time information162is information showing a date and time when the work procedure manual has been acquired. The performance value information163is information showing a time required when the work is performed according to a work procedure.

Next, an example of a connection relation of each information configuring the definition information300(definition information400) after being connected by the connection information314(connection information414) will be described. The connection relation is accumulated in the association data accumulation unit15.

FIG.8is a diagram illustrating an example of a connection relation of each information configuring the definition information300(definition information400) after being connected by the connection information314.

As shown inFIG.8, each information (for example, the task information310and the worker information320and the task information310and the part information330) configuring the definition information300(FIG.4) or the definition information400(FIG.5) is associated by relation information500. The relation information500is generated by expanding the connection information314(414) of the task information310(410) of the definition information300(400) on the database.

The relation information500is configured to include relation identification information501, relation data access information502, and connection information503.

The relation identification information501is information for defining a connection relation of each information and is identification information for defining association between the task information310and the part information330and connection between the task information310and the worker information320, for example. That is, the relation identification information501can be said to be an identifier for specifying a connection line between each information.

The relation data access information502is information including a memory address to access logic for prescribing a connection relation of each information of the definition information300(400) stored in the database different from the association data accumulation unit15(the information collection and display system1). Processing for defining the connection relation of each information is performed by the logic applied by the relation data access information502. Here, the logic is information such as a flowchart for prescribing processing for connecting predetermined information and other information. That is, the relation data access information502can also be said to be information showing the meaning of the connection between each information.

The connection information503is information necessary for connection between each information and includes information for defining a start point of predetermined information (for example, the part information330) and information for defining an end point of other information (for example, the task information310) associated with the predetermined information. As a result, the start point and the end point of the predetermined information (for example, the part information330) and other information (for example, the task information310) can be determined and a direction of the connection line is determined.

All information configuring the definition information300(400) are associated by the relation information500. An example of the association data200in which each information of the definition information300(400) are specifically associated by the relation information500is shown inFIGS.9and10.

InFIGS.9and10, a task710of a pre-process and a task720of a post-process are associated on the basis of a predetermined task700and each information such as a machine and a worker is connected to each of the tasks700,710, and720with predetermined association, by the relation information500. InFIGS.9and10, although only a part of the relation information500to connect each information is described for the sake of convenience of explanation, the relation information500is set to all connections between each information in actuality.

Here, in the embodiment, the case where a plurality of tasks is connected linearly (in a line shape) and information such as a part and a machine is associated with each task has been described as an example. However, it is considered that the information associated with the predetermined task is associated with a plurality of other tasks and it is considered that each information associated with each of the plurality of tasks is associated with the predetermined task. When a plurality of tasks exists in the manufacturing process, it is considered that each task is not directly connected by the relation information500but is associated with other tasks via information associated with each task.

FIG.11is a schematic diagram illustrating only a connection relation of each information (node) of the association data200and exemplifies the case where a part B node1010associated with a predetermined task B node1011is used as inputs of a plurality of other task nodes (a task C node1020and a task E node1030) and a part D node1061generated by a task D node1060and a part F node1071generated by a task F node1070are used as an input of a task G node.

As shown inFIG.11, a plurality of parts B (nodes1010) are produced by executing a task B (node1011) corresponding to the pre-process and the plurality of parts B (nodes1010) are used as materials of a task C (node1020) and a task E (node1030) corresponding to a post-process. In the task G (node1040), it is seen that a part D (node1061) produced by a task D (node1060) and a part F (node1071) produced by a task F (node1070) are used as materials and a finished product1080is produced. In this case, in the operation data access information313configuring the task information310shown inFIG.4, the plurality of parts B may be lot-managed in actual operation information (that is, one identifier is assigned to the plurality of parts B) and one part B may be managed as a single product (that is, one identifier is assigned to one part B). For example, when the parts B are lot-managed, the parts B are used in a lot unit in the task D and the task E and when each part B is managed as a single product, the part B is used in a single product unit in the task D and the task E.

The connection relation of each information configuring the association data200is not limited to the case exemplified inFIG.11. For example, as shown in FIG.12, a plurality of pieces of information nodes may be associated with one task node.

In the embodiment, as shown inFIG.12, a part A node1110and a part B node1120to be two part nodes, a worker A node1130and a worker B node1140to be two worker nodes, and a machine A node1150and a machine B node1160to be two machine nodes, defined as 4M nodes, are associated with one task G node1111. That is, in the predetermined task G node1111, a plurality of workers A and B may process a plurality of parts A and B using a plurality of machines A and B. Here, because a work procedure node1170defines task content (work procedure) of the task G node1111, one work procedure node1170is associated with the work G node1111.

In addition, as shown inFIG.13, a connection relation in which a part produced by a predetermined task is returned to the predetermined task again via other task and the part is used may be used

In the embodiment, a part A (node1210) produced by a task C (node1250) to be a post-process is input as a material of a task E (node1260) and a part B (node1220) is output as a finished product. The part B (node1220) is input again as a material of the task C (node1250). This shows a flow in which, in the course of producing a finished product via a manufacturing line configured by the task A, the task B, the task C, and the task D having the same identification information, the task C (node1250) is output once as the part A (node1210) and as a result of processing in the task E (node1260), the part A changes to a part equivalent to a part1(node1230) and the work C is executed again. For example, this shows a flow of processing in which the task C is a task such as inspection, there is a quality problem as a result of the inspection, the task C is out of a line once, modification is performed by the task E, and the processing is executed again from the task C. The task node in the drawing shows a manufacturing process having identification information showing a specific finished product and when the same identification information passes through the same task, it is assumed to be an input of a task node created so far, in this case, the task C (node1250). Because the parts having the same identification information are input to the task C (node1250) a plurality of times, the parts input the plurality of times are stored as operation data or the parts input the plurality of times are stored in the extension information470(seeFIG.5).

Next, an example of a model data creation screen600by the association data model creation unit10will be described usingFIG.14. The model data creation screen600is displayed on a display to be an example of the user interface7connected to the association data model creation unit10. The user creates model data of the manufacturing process while viewing the model data creation screen600.

As shown inFIG.14, the model data creation screen600is configured to include a task candidate sub-screen610to display a list of task candidates, a location sub-screen620to show what manufacturing factory the manufacturing process is performed in, a line sub-screen630to show entire information of a production line (task) in the manufacturing factory, a data model display sub-screen640to define association with a predetermined manufacturing line (task), and a node definition information sub-screen650to define a property value of a node of the predetermined manufacturing line (task) displayed on the data model display sub-screen640.

Task nodes (a task 1 node to a task 16 node) registered in the task candidate sub-screen610are previously registered as system information and are previously set according to task content of the user. The line sub-screen630can define a process sequence of each task in the manufacturing process by sequentially connecting each task node using the task 1 node to the task 16 node displayed on the task candidate sub-screen610. The 4M nodes are associated with each of the task 1 node to the task 16 node and details of the 4M nodes or details of the task nodes are input using the data model display sub-screen640and the node definition information sub-screen650. In the node definition information sub-screen650, a task property screen651to set properties of the task nodes and a 4M property screen652to set properties of the 4M nodes are selectively switched.

In the embodiment, because the task 1 node is selected in the line sub-screen630(see a colored portion shown inFIG.14), each information such as parts and workers is associated with the task 1 node as a center, in the data model display sub-screen640. Because the task 1 node is selected in the data model display sub-screen640(see a colored portion shown inFIG.14), a task node name (task 1 node) is registered in the task property screen651of the node definition information sub-screen650and a period where the selected task 1 node is applied on a system is divided into an application start date and time (for example, Jan. 1, 2018, 8:30 am) and an application end date and time (for example, Mar. 31, 2018, 5:30 pm) and registered in the task property screen651. Here, when a property value of the task 1 node is changed and a new task 1 node is used, the task node can be updated by matching the application end date and time of the previous task 1 node with an application start date and time of the new task 1 node and revising the task 1 node with the new task 1 node.

Here, if the 4M nodes such as the worker node and the machine node are selected in the data model display sub-screen640, properties of the selected 4M nodes are displayed on the 4M property screen652.FIG.15is different fromFIG.14in that a machine candidate sub-screen653is displayed in place of the task candidate sub-screen610, at a position of the task candidate sub-screen610ofFIG.14. A list of machine nodes registered in advance is displayed on the machine candidate sub-screen653and one machine node selected from the list of machine nodes can be allocated to the machine node of the node definition information sub-screen650. In the embodiment, a machine2node is selected from the list of machine nodes (see a colored portion shown inFIG.15) and is allocated to the machine node of the node definition information sub-screen650.

Furthermore, in the node definition sub-screen650, a property value of the selected machine2node can be set and a machine node name (for example, the machine2node), an application start date and time (for example, Jan. 1, 2018, 8:30 am), an application end date and time (for example, Mar. 31, 2018, 17:30 pm), a machine ID (for example, M002), and an access key (for example, ZZ-XXXX-M002) can be input and set. The access key is an access key to access a database in which operation information of the 4M node (for example, the machine node) is stored. The association data registration unit11can acquire the operation information of the predetermined 4M node from the database, on the basis of the access key.

Next, a flow of processing until the association data200is registered in the association data accumulation unit15will be described.

FIGS.16and17are flowcharts illustrating the flow of the processing until the association data200is registered in the association data accumulation unit15.

First, in each manufacturing process (task), the data generation device5collects or generates the site data100(step S101) and then transmits the site data100to the information collection and display system1via the network2(step S102).

In the information collection and display system1, if the site data100is received (step S103), identification information (identification information111,121,131,141,151, and161shown inFIG.7) included in the site data100received by the association data registration unit11is acquired (step S104) and the definition information300(or400) corresponding to each of the acquired identification information is acquired from the association data model creation unit10(step S105). In addition, the association data registration unit11determines whether the definition information300(or400) acquired from the association data model creation unit10is the task information310(410) or the 4M information such as the worker information320(420), the part information330(430), the machine information350(450), and the work procedure information360(460) other than the task information310(410) (step S106).

When it is determined that the acquired definition information300(400) is the task information310(410) (step S106: Yes), the association data registration unit11searches for the task node corresponding to the task information310(410) from the association data accumulation unit15(step S107). When the task node corresponding to the task information310(410) cannot be searched (step S108: No), the association data registration unit11generates a corresponding task node, on the basis of the acquired identification information and definition information300(or400) (step S109). When the task node corresponding to the task information310(410) is searched (step S108: Yes), the association data registration unit11proceeds to step S111.

The association data registration unit11acquires generation date and time information (for example, 112, 122, 132, 142, 152, and 162) included in the site data100for the generated task node and registers the generation date and time information as start information of the generated task node in the association data accumulation unit15(step S110). Then, the association data registration unit11updates a property value of the task node, for example, data in the extension information510(step S111).

Then, as shown inFIG.17, the association data registration unit11constructs connection lines between the respective nodes. Specifically, the association data registration unit11determines whether or not an associated node (connection destination) exists on the basis of the definition information300(400) acquired from the association data model creation unit10(step S112). When it is determined that the association node exists (step S112: Yes), the association data registration unit11constructs the connection line on the basis of the definition information300(400) (step S113) and updates a property value of the connection line (step S114). Here, the property value of the connection line refers to information added to the connection line, such as the relation identification information501, the relation data access information502, and the connection information503of the relation information500shown inFIG.8.

After the connection line from the task node is constructed, the association data registration unit11acquires information (connection line information) for generating the connection line, stored in the temporary accumulation unit18, and constructs the connection line (step S115). When the connection line information is not accumulated (step S116: No), this processing ends. When the connection line information is accumulated in the temporary accumulation unit18(step S116: Yes), the association data registration unit11returns to step S112and performs generation of the connection line and updating of the property until it is determined that the connection line information is not accumulated in the temporary accumulation unit18. When it is determined in step S112that the connection destination does not exist (step S112: No), the association data registration unit11accumulates the connection line information in the temporary accumulation unit18(step S117) and ends this processing.

Returning toFIG.16, when it is determined in step S106that the identification information acquired from the site data100is the 4M information different from the task information (step S106: No), the association data registration unit11searches for the 4M information corresponding to the identification information from the association data accumulation unit15(step S118). When it is determined that the 4M information corresponding to the identification information is accumulated in the association data accumulation unit15(step S119: Yes), the 4M information is completely registered as existing information at the time of constructing the manufacturing process. Therefore, the association data registration unit11updates the property value (step S120) and proceeds to step S112. When it is determined that the 4M information does not exist (step S119: No), the association data registration unit11discards the site data100received from the data generation device5(step S121) and ends this processing.

[Generation and Registration Processing of 4M Information]

Next, generation and registration processing of the 4M information by the association data registration unit11will be described. The worker information, the machine information, and the work procedure information in the 4M information are previously defined at the user side at the time of introducing the manufacturing process and are not generated whenever the predetermined processing is performed, different from the task information. Although a work shift may be changed in a predetermined task unit in the worker information, the worker is registered in the information collection and display system1and the machine to execute the task is also already determined and completely installed, when the task starts. Therefore, for the information, the site data is previously registered before the information collection and display system1steadily operates.

FIG.18is a flowchart of the generation and registration processing of the 4M information by the association data registration unit11.

First, the association data model creation unit10generates configuration information (definition information300or400) of the association data on the basis of the master data accumulated in the master data accumulation unit3(step S201) and transmits the generated configuration information to the association data registration unit11(step S202). The association data registration unit11receives the configuration information transmitted from the association data model creation unit10(step S203), generates 4M information according to the received configuration information (step S204), and registers the generated 4M Information in the association data accumulation unit15(step S205). As a result, the association data registration unit11can generate the 4M information according to the configuration information received from the association data model creation unit10and can register the 4M information in the association data accumulation unit15.

[Extraction Processing of Association Data]

Next, extraction processing of association data in the association data search unit12will be described.

FIG.19is a flowchart of extraction processing of the association data200in the association data search unit12. The extraction processing of the association data200by the association data search unit12is performed using a data extraction tool800(seeFIG.23) displayed on the user interface7such as a display.

First, using the data extraction tool800displayed on the user interface7, a period, a task range, and the like are input from an entry form802to specify an extraction range of the association data200(step S301). The association data search unit12displays a plurality of task nodes801in the manufacturing process to be extracted, from the association data200extracted on the basis of the specified range (step S302). The user selects a desired node (for example, a machine2node shown inFIG.23) from the displayed task nodes801(step S303) and the association data search unit12displays a list of performance value names associated with the node selected by the user (step S304). In the embodiment, a list of performance value names of items10to14associated with the machine2node is displayed by the association data search unit12, on the basis of the selection of the machine2node by the user.

Next, the user selects one item (for example, the item12shown inFIG.23) from the list of performance values (step S305) and displays a sample of the extracted association data on a data display sub-screen (not shown in the drawings) under a screen of the data extraction tool800(step S306). The user repeats processing of steps S301to S306a plurality of times until the user extracts a list of data items that is required for data analysis and is determined by the user as having a relation (step S307: No). If the selection ends (step S307: Yes) and processing is executed, the association data search unit12acquires actual data from the transaction data accumulation unit4or the master data accumulation unit3on the basis of operational data access information held by each node and creates a data mart in the temporary accumulation unit18(step S308).

FIG.20is a flowchart of processing for accumulating data defined by the user in the association data accumulation unit15. The processing (steps S401to S408shown inFIG.20) for extracting the data defined by the user has the same flow as the flowchart described in FIG.19. A process until association data extracted by ETL (Extract/Transform/Load) is analyzed and an analysis result is displayed is defined. A connection line of association data is constructed between data necessary for the analysis in ETL and an access key to call logic defined by ETL is registered in access information thereof.

Next, data analysis processing performed by a data analysis tool such as the application8on the basis of the data mart (analysis data) created by the processing of steps S301to S308(or steps S401to S408) will be described.

FIG.21is a flowchart illustrating the data analysis processing performed by the data analysis tool such as the application8on the basis of the data mart (analysis data) created by the processing of steps S301to S308(or steps S401to S408). The data analysis processing is performed by analyzing the analysis data accumulated in the analysis data accumulation unit14by the application8.

The application8(data analysis tool) acquires the data mart extracted by the processing of steps S301to S308(or steps S401to S408) described above and accumulated in the analysis data accumulation unit14(step S501). The user of the data analysis tool displays the acquired data on the screen using the data analysis tool and performs data analysis (step S502).

[Generation Processing of Analysis Data]

Next, generation processing of analysis data by the data provision API unit16will be described.

FIG.23is a flowchart of generation processing of the analysis data by the data provision API unit16.

First, the application8instructs the data provision API unit16to search for the association data200necessary for generating the analysis data (step S601). Specifically, the application8transmits a search key for searching for the necessary association data200to the data provision API unit16. The data provision API unit16searches for the association data200from the association data accumulation unit15, using the search key acquired from the application8(step S602). The data provision API unit16acquires data access information of the acquired association data200(step S603) and transmits the information to the accumulation data acquisition unit13(step S604). The accumulation data acquisition unit13acquires transaction data to be acquired, from the transaction data accumulation unit4, on the basis of the received data access information (step S605). The accumulation data acquisition unit13transmits the acquired data to the data provision API unit16(step S606). The data provision API unit16shapes the acquired data and transmits the data to the application8.

Next, the data extraction tool800displayed on the user interface7such as the display will be described. The user can simply perform extraction of the association data200by visual recognition, using the data extraction tool800displayed on the user interface7.

FIG.23is a diagram illustrating an example of the data extraction tool800displayed on the user interface7such as the display. InFIG.23, nodes and connection lines of the association data registered in the association data accumulation unit15are represented by circles and lines.

The entry form802is provided in an upper portion of the screen of the data extraction tool800and a search range of the association data200necessary for the entry form802is input. In a lower portion of the screen of the data extraction tool800, a plurality of task nodes801corresponding to the input search range are displayed. In the task nodes801, data items803registered in the nodes can be displayed in the association data200constructed by the circles and the lines. If the data item803is a machine node, a performance value name of the machine node is displayed and the performance value name is acquired from the master data accumulation unit3. The performance value name acquired from the master data accumulation unit3is converted into a name easily recognized by the user from a name managed by a machine compared with the machine node by the dictionary database6. Portion hatched in the data items are data specified by the user and data associated with the specified data and hatching display is performed by the processing ofFIG.19.

For example, using the data extraction tool800, a period, a task range, and the like are input from the entry form802to specify an extraction range of the association data200(step S301ofFIG.19). The association data search unit12displays the plurality of task nodes801in the manufacturing process to be extracted, from the association data200extracted on the basis of the specified range (step S302ofFIG.19).

The user selects a desired node (for example, a machine2node) from the displayed task nodes801(step S303ofFIG.19) and the association data search unit12displays a list of performance value names (data item803) associated with the node selected by the user (step S304ofFIG.19). In the embodiment, a list of performance value names of items10to14associated with the machine2node is displayed by the association data search unit12, on the basis of the selection of the machine2node by the user.

Next, when the user selects one item (for example, the item12) from the list of performance values (step S305ofFIG.19), the association data search unit12can search for the item4of another task 1 associated with the item12selected by the user, display the item4by hatching, and extract the item4associated with the item12. Similarly, the user selects the item14of the machine2node, so that the item6of another task 1 associated with the item14is searched and is displayed by hatching. As a result, because a search result of an item (second information) of another task associated with a selection item (first information) of a predetermined task can be visually recognized easily, it becomes easy to perform the following association analysis.

As described above, in the embodiment, there is the information collection and display system1in which the data generation device5that generates the site data100and the transaction data accumulation unit4that stores the site data100generated by the data generation device5are connected. The information collection and display system1includes the association data accumulation unit15that stores the association data200defining the association of each of the plurality of pieces of information included in the site data100; the association data search unit12that searches for another 4M information (second information) associated with the predetermined 4M information (first information) included in the plurality of pieces of information, on the basis of the association data200stored in the association data accumulation unit15; and the user interface7that displays the connection relation of the plurality of pieces of information associated by the association data200. The association data search unit12searches for the second information associated with the first information on the basis of the association data200, according to selection of the first information in the connection relation of the plurality of pieces of information displayed on the user interface7, and displays the first information and the second information on the user interface7with the connection relation of the plurality of pieces of information.

By this configuration, in the information collection and display system1, the association data200may be generated and managed as the definition information defining the connection relation of the site data100, it is not necessary to hold data in which all the site data100are associated, and the capacity of the storage device that stores the association data200can be decreased. In addition, in the information collection and display system1, the first information of the predetermined task is selected from the user interface7, so that that the second information associated with the first information is searched, and the first information and the second information are displayed on the user interface7with the connection relation of the site data100, so that it is easy to analyze the association by visual recognition.

Although the examples of the embodiments of the present invention have been described, in the present invention, all of the embodiments may be combined and any two or more embodiments may be combined.

In addition, the present invention is not limited to including all of the configurations of the embodiment and a part of the configurations of the embodiment may be replaced by the configurations of another embodiment or the configurations of the embodiment may be replaced by the configurations of another embodiment.

In addition, a part of the configurations of the embodiment may be added, removed, or replaced for the configurations of another embodiment.

Although the present disclosure has been described with reference to example embodiments, those skilled in the art will recognize that various changes and modifications may be made in form and detail without departing from the spirit and scope of the claimed subject matter.