PERFORMANCE DATA MANAGEMENT DEVICE AND BUSINESS MANAGEMENT SYSTEM

A performance data processing section that receives performance data generated by a manufacturing site system; a performance data storage section that stores received performance data; a master data storage section that stores master data that has data to be basic information when the performance data is managed; a business data generation section that generates business data by processing the performance data into a structure used by a business application based on data to be the basic information in the master data; and a business data storage section that stores the business data are included, in which the master data includes an attribute that represents start of an effective period of data to be the basic information and an attribute that represents end of the effective period.

TECHNICAL FIELD

The present invention relates to a performance data management device and a business management system.

BACKGROUND ART

Business performance data is conventionally managed by a program processed on a computer for the purpose of streamlining and improving business. The above program is referred to as business application. At a manufacturing site, a certain business application operates on a computerized information system to perform management information of performance data.

For example, PTL 1 discloses “finding a future production index value by performing a production simulation on the basis of the performance data, and, in a case where the future production index value becomes lower than the current production index value, performing a production simulation by improvement master data corrected on the basis of possible improvement master data”.

CITATION LIST

Patent Literature

SUMMARY OF INVENTION

Technical Problem

Performance data of a manufacturing site is used in many business applications. Therefore, there is a product that manages data of a manufacturing site and cooperates with a business application without performing program modification. However, there is not a product that has a function of maintaining consistency of a change in data, manages performance data, and cooperates with a business application without a program.

In a case where a change occurs in the content of performance data managed by the business application, data inconsistency occurs unless related data is changed with consistency maintained. For example, when a name of specific data is changed, data related to this specific data refers to data after the change. In this case, for example, past data registered before the name change refers to the data after the name change, and therefore data inconsistency occurs. At a manufacturing site, since it is necessary to trace a trail from past performance data, a mechanism for changing data while ensuring consistency of past data is necessary.

The present invention has been made in view of the above circumstances, and an object thereof is to ensure consistency of related data even when a change occurs in content of performance data of a manufacturing site system.

Solution to Problem

In order to solve the above problem, a performance data management device of one aspect of the present invention includes: a performance data processing section that receives performance data generated by a manufacturing site system; a performance data storage section that stores and accumulates the performance data received by the performance data processing section; a master data storage section that stores master data that has data to be basic information when the performance data is managed; a business data generation section that generates business data by processing the performance data into a structure used by a business application based on data to be the basic information in the master data; and a business data storage section that stores the business data generated by the business data generation section. The master data includes an attribute that represents start of an effective period of data to be the basic information and an attribute that represents end of the effective period.

A business management system of one aspect of the present invention includes: the performance data management device and a business application that uses performance data managed by the performance data management device.

Advantageous Effects of Invention

According to at least one aspect of the present invention, it is possible to ensure consistency of related data even when a change occurs in content of performance data of a manufacturing site system.

Problems, configurations, and effects other than those described above will be made clear by the description of the following embodiments.

DESCRIPTION OF EMBODIMENTS

In general, business is repeatedly practiced, business performance data increases (accumulates) every day. This business data is used in various business applications. Therefore, there is a high demand for a method of managing a large amount of business performance data and cooperating the performance data with the business applications. For performance data management at a manufacturing site, various methods have been established. However, a performance data management method having a method for ensuring consistency with respect to a change in the performance data being managed has not been established.

For example, when a name of specific data is changed, related data refers to data after the change. In this case, since past data registered before the name change refers to the data after the name change, data inconsistency occurs. At a manufacturing site, since it is necessary to trace a trail from past performance data, a mechanism for changing data while ensuring consistency of past data is necessary. Therefore, the inventors have invented a management method that enables cooperation between management of performance data and a business application and secures consistency of data.

First Embodiment

Examples of embodiments for carrying out the present invention will be described below with reference to the accompanying drawings. In the present description and the accompanying drawings, constituent elements having substantially identical function or configuration are denoted by identical reference signs, and redundant description is omitted. As the first embodiment of the present invention, a case where the present invention is applied to a business management system in which performance data of a manufacturing site system is used by a business application will be described.

[Example of Work Site System]

First, an example of a manufacturing site system that generates performance data will be described with reference toFIG.1.FIG.1illustrates an example of a manufacturing site system. A manufacturing site system1(an example of a control system) illustrated inFIG.1includes a processing machine10that performs preset processing on a processing target object to produce a processed product20, and a plurality of machines such as an assembly machine and an inspection machine that are not illustrated. The manufacturing site system1is connected with a controller not illustrated that controls the manufacturing site system1based on various state quantities, a production target, and the like acquired from the manufacturing site system1. In the processing machine10, a housing that protects the processing machine is provided with an operation panel11, a processing start button12, a processing end button13, and a reader/writer device14.

The manufacturing site system1is connected with a terminal device31and a performance data management device200via a field network N1. The performance data management device200is connected to a terminal device32via a control network N2. The field network N1and the control network N2are wired or wireless local area networks (LAN). This network configuration is an example, and for example, the controller may be connected between the manufacturing site system1and the field network N1.

A worker40sees work instructions R displayed on the terminal device31or work content described in the printed matter of the work instructions R to confirm that the processing work is instructed, and operates the processing machine10. For example, before operating the processing machine10, the worker40holds an employee card41made of an IC card over the reader/writer device14of the processing machine10, and inputs worker information recorded on an IC chip of the employee card41to the processing machine10. Due to this, worker information (for example, contact name) of the worker40who has operated the processing machine10is recorded in the processing machine10, that is, the manufacturing site system1.

Thereafter, when the worker40presses the processing start button12and the processing end button13based on the work instructions, the processing machine10executes processing start and processing end. The processing machine10(manufacturing site system1) outputs information indicating operation performance to the performance data management device200as performance data. The processing machine10(manufacturing site system1) creates performance data in a format that can be processed by the performance data management device200.

Similarly, the worker40in charge of the work performs assembly work, inspection work, or other works based on the work instructions R. According to the work having been carried out, each performance data is sequentially captured and managed in the performance data management device200. In the present embodiment, a series of works at a manufacturing site is referred to as “business”.

Note that the worker40may register the worker information of the worker40(and information on processing start by the worker40) into the performance data management device200by operating the operation panel11or operating the terminal device31. The processing machine10may execute processing start and processing end by the worker40inputting commands of processing start and processing end via the operation panel11.

For example, an operation procedure may be set such that a processing start command to the processing machine10becomes possible by the operator40operating the operation panel11or the terminal device31to input worker information. In this case, the registration of the worker information (information on the processing start by the worker40) and the processing start of the processing machine10may be registered in the performance data management device200at the same time.

The processing machine10may include a code reader, and the worker40may instruct processing start and processing end to the processing machine10by operating the code reader to read information of a code (barcode, two-dimensional code, and the like) for each work printed (displayed) on the work instructions R.

[Overall Configuration of Business Management System]

Next, an overall configuration example of the business management system will be described with reference toFIG.2.

FIG.2is a block diagram illustrating an overall configuration example of a business management system1000in which the business application according to the first embodiment uses performance data of the manufacturing site system1.

The business management system1000includes the performance data management device200that acquires and manages performance data110and master data120from the manufacturing site system1, a business extract/transform/load (ETL)710, a business data storage section720, and a business application730.

The manufacturing site system1generates and transmits, to the performance data management device200, the performance data110including information indicating performance of the manufacturing site system1. The performance of the manufacturing site system1is a result of operation, a produced product, a consumed substance, their amounts, and the like as a result of the dynamics and operation of the manufacturing site system1.

The performance data management device200acquires and manages the performance data110generated by the manufacturing site system1. The performance data management device200creates business data from the performance data110and provides the business data to the business application730. The performance data management device200acquires and manages the master data120transmitted from the manufacturing site system1.

This performance data management device200includes a performance data processing section310, a performance data storage section410, a master data processing section320, a master data storage section420, a business data generation section500, a business data storage section600, and a master data registration section210.

The performance data processing section310performs processing of acquiring and recording, in the performance data storage section410, the performance data110transmitted from the manufacturing site system1. The performance data110is data in which details of events that have occurred with actual business are recorded. The performance data is sometimes referred to as transaction data.

The performance data storage section410is a nonvolatile or volatile storage section in which the performance data110is recorded by the performance data processing section310.

The master data processing section320performs processing of acquiring and recording, in the master data storage section420, the master data120transmitted from the manufacturing site system1. The master data120is ledger data in which basic attribute information of items related to business is collected. In the present invention, transmission of the master data120by the manufacturing site system1is not essential.

The master data storage section420is a nonvolatile or volatile storage section in which the master data120is recorded by the master data processing section320.

The business data generation section500acquires performance data recorded in the performance data storage section410and records the performance data into performance data610in the business data storage section600. The business data generation section500updates the performance data610in the business data storage section600with the acquired performance data. The business data generation section500processes the acquired performance data into a structure (see an actual process table611inFIG.12, for example) that can be used by the business application. The business data generation section500acquires master data recorded in the master data storage section420, and records (adds) the master data into master data620in the business data storage section600.

The business data storage section600is a nonvolatile or volatile storage section in which the performance data610and the master data620are recorded (accumulated) as data (business data) used by the business application. The business data storage section600records the master data620to be registered by the master data registration section210. As the master data620, data necessary for management of the performance data, such as an ID and a name of an item, and an ID and a name of a process, are managed.

The business data storage section600is also an example of a performance data storage section and a master data storage section. An area in the business data storage section600where the performance data610is recorded is sometimes referred to as “business data storage section600(performance data)”. An area in the business data storage section600where the master data620is recorded is sometimes referred to as “business data storage section600(master data)”.

On the basis of an instruction from a system manager45, for example, the master data registration section210registers the master data620into the business data storage section600or updates the master data620.

The business ETL710is a business data conversion processing section that generates business data based on the performance data610and the master data620. The business ETL710extracts performance data corresponding to a designated item ID, process ID, and the like from the performance data610accumulated in the business data storage section600, and performs processing of converting the performance data according to a purpose (business application730). Then, the business ETL710stores the performance data subjected to the conversion processing, that is, the business data into the business data storage section720. Thus, when registering or updating the performance data into the business data storage section720, the business ETL710registers the transaction data by using information of the master data620.

The business data storage section720is a nonvolatile or volatile storage section that accumulates business data extracted from the business data storage section600by the business ETL710and converted according to the purpose.

The business application730is an application used for managing, streamlining, and improving business. Cooperating with the performance data management device200, the business application730outputs a result by using business data stored in the business data storage section720. The user uses the business data in the performance data management device200through the output result of the business application730.

Note that the business data generation section500and the business data storage section600may be configured to function of both the business ETL710and the business data storage section720.

[Hardware Configuration of Each Device]

FIG.3is a block diagram illustrating a hardware configuration example of a computer included in each device constituting the manufacturing site system1and the business management system1000. Each section in the device is selected according to the function and purpose of use of each device. Here, a hardware configuration example of the above-described performance data management device200will be described.

A computer50of the performance data management device200includes a central processing unit (CPU)51, a read only memory (ROM)52, a random access memory (RAM)53, a nonvolatile storage57, and a communication interface58. Sections in the performance data management device200are connected to be able to transmit and receive data to and from one another via a system bus54.

The CPU51, the ROM52, and the RAM53constitute a control section. This control section controls the operation of the entire performance data management device200or each section. The CPU51reads, from the ROM52, and executes a program code of software for implementing each function according to the present embodiment, and performs control of each section and various arithmetic operations. Instead of the CPU51, another arithmetic processing unit such as a micro processing unit (MPU) may be used.

The ROM52is used as an example of a nonvolatile memory (recording medium), and the ROM52stores a program, data, and the like necessary for the CPU51to operate. The RAM53is used as an example of a volatile memory, and the RAM53temporarily stores a variable, a parameter, and the like generated in the middle of arithmetic processing by the CPU51.

The nonvolatile storage57is an example of a recording medium, and can store a program such as an operating system (OS), a parameter used when the program is executed, data obtained by executing the program, and the like. For example, the performance data storage section410, the master data storage section420, and the business data storage section600inFIG.2are configured using the nonvolatile storage57.

A program executed by the CPU51may be stored in the nonvolatile storage57. As the nonvolatile storage57, a semiconductor memory, a hard disk, a solid state drive (SSD), a recording medium using magnetism or light, or the like is used. Note that the program may be provided via a wired or wireless transmission medium such as a local area network (LAN), the Internet, or digital satellite broadcasting.

As the communication interface58, for example, a network interface card (NIC), a modem, or the like is used, and is configured to be able to transmit and receive various data to and from an external device via a network such as a LAN to which a terminal is connected, a dedicated line, or the like.

Note that the computer50may be provided with a display section55such as a liquid crystal display and an operation section56such as a mouse and a keyboard. The display section55displays a GUI screen, a result of processing performed by the CPU51, and the like, and the operation section56generates and supplies, to the CPU51, an input signal according to a user's operation. For example, the worker40, the system manager45, and the like can check the screen displayed on the display section55and perform necessary editing through the operation section56.

The hardware configuration of the terminal devices31and32illustrated inFIG.1can also be configured similarly to the performance data management device200. A device mounted with at least the business ETL710and/or the business application730can also have the hardware configuration illustrated inFIG.3.

(Configuration of Performance Data)

FIG.4illustrates a configuration example of the performance data110transmitted by the manufacturing site system1.

As attributes (data items), the performance data110has, for example, an item ID111, a process ID112, a product ID113, a data type114, an event type115, and an event occurrence time116.

The item ID111is information for uniquely identifying the item (information for uniquely identifying the type of the product).

The process ID112is information for uniquely identifying the process.

The product ID113is information for uniquely identifying the product of the corresponding item. These IDs are information for citing a name registered in the master data620.

The data type114indicates the type (an event related to a machine, an event related to a man, and the like) of data included in the present data.

The event type115indicates the event that has occurred. The events include start, end, middle, plan start, and plan end.

The event occurrence time116indicates the time at which an event occurs (start time, end time, and the like of a machine).

When these data are transmitted in a file format, the data type114or the like may be transmitted as a file name.

(Configuration of Master Data)

FIG.5illustrates a configuration example of the master data120transmitted by the manufacturing site system1.

As attributes (data items), the master data120has, for example, a data transmission time121, an update/delete flag122, a data type123, data type specific information124, a vendor name125, a data update date126, a data effective period start date127, and a data effective period end date128.

The data transmission time121indicates the time at which the present data is transmitted.

The update/delete flag122is a flag indicating the type of registration, update, or deletion. Registration (addition), update, and deletion of the present data to the master data620are determined on the basis of the information of the update/delete flag122.

The data type123indicates the type of the present data. The types of data include an item master and a process master.

The data type specific information124is specific information for each master in the data type123. An item name in the item master is an example thereof.

The vendor name125indicates the name of the vendor. For example, the vendor is a company that manufactures (or delivers) a product, a component, a material, or the like, a company that executes a process, and the like.

The data update date126indicates the date when the present data is updated in a case where the update/delete flag122indicates update.

The data effective period start date127indicates the start date of the effective period of the present data.

The data effective period end date128indicates the end date of the effective period of the present data.

In a case where these data are transmitted in a file format, the data type123or the like may be transmitted as a file name.

[Operation of Performance Data Processing Section]

Next, the operation of the performance data processing section310will be described with reference toFIG.6.

FIG.6is a flowchart illustrating an operation example of the performance data processing section310.

First, the performance data processing section310determines whether the performance data110has been received from the manufacturing site system1(S1), and ends the processing of the present flowchart if the performance data110has not been received (NO in S1).

Next, if the performance data110has been received (YES in S1), the performance data processing section310determines whether an invalid value has been set in the performance data110(S2), and ends the processing of the present flowchart if an invalid value has been set (YES in S2). For example, in a case where the start time and the end time of the performance data are reversed in time series, it is regarded as an invalid value. In a case where the event occurrence time is ahead of the current time point, it corresponds to an invalid value.

Next, if an invalid value has not been set (NO in S2), the performance data processing section310registers the performance data110into the performance data storage section410(S3), and ends the processing of the present flowchart.

Next, the operation of the master data processing section320will be described with reference toFIG.7.

FIG.7is a flowchart illustrating an operation example of the master data processing section320.

First, the master data processing section320determines whether the master data120has been received from the manufacturing site system1(S11), and ends the processing of the present flowchart if the master data120has not been received (NO in S11).

Next, if the master data120has been received (YES in S11), the master data processing section320determines whether an invalid value has been set in the master data120(S12), and ends the processing of the present flowchart if an invalid value has been set (YES in S12). For example, in a case where the event occurrence time is ahead of the current time point, it corresponds to an invalid value.

Next, if an invalid value has not been set (NO in S12), the master data processing section320registers the master data120into the master data storage section420(S13), and ends the processing of the present flowchart.

[Configuration of Performance Data Storage Section]

FIG.8illustrates a configuration example of the performance data storage section410.

The performance data storage section410has a field of the same attribute (data item) as that of the performance data110(FIG.4). That is, the performance data storage section410includes fields of the item ID111, the process ID112, the product ID113, the data type114, the event type115, and the event occurrence time116.

For example, inFIG.8, each piece of information of the item ID111“1”, the process ID112“010”, the product ID113“1234567”, the data type114“MACHINE 001”, the event type115“START”, and the event occurrence time116“2019/12/01 10:00:00” is registered in the first record of the performance data storage section410.

[Configuration of Master Data Storage Section]

FIG.9illustrates a configuration example of the master data storage section420.

The master data storage section420has a field of the same attribute (data item) as that of the master data120(FIG.4). That is, the master data storage section420has each field of the data transmission time121, the update/delete flag122, the data type123, the data type specific information124, the vendor name125, the data update date126, the data effective period start date127, and the data effective period end date128. In each data (record), the start date and the end date of the data effective period are set.

For example, inFIG.9, each piece of information of the data transmission time121“2019/11/01 10:00:00”, the update/delete flag122“REGISTRATION”, the data type123“ITEM MASTER”, the data type specific information124“TELEVISION A”, the vendor name125“VENDOR A”, the data update date126“2019/12/01 00:00:00”, the data effective period start date127“2019/11/01 10:00:00”, and the data effective period end date128“2020/11/30 23:59:59” is registered in the first record of the master data storage section420.

Each data in the performance data storage section410and the master data storage section420can be configured using comma-separated values (CSV) as an example.

[Operation of Business Data Generation Section]

Next, the operation of the business data generation section500will be described with reference toFIG.10.

FIG.10is a flowchart illustrating an operation example of the business data generation section500. The business data generation section500executes the processing of the present flowchart at a predetermined cycle.

First, the business data generation section500determines whether data stored in the master data storage section420has been updated (registration and change of data). For example, whether the data in the master data storage section420has been updated can be determined by detecting an increase in recorded data (record), an increase in file size, or the like. Then, if the data in the master data storage section420has not been updated (NO in S21), the business data generation section500moves to step S22.

Next, the business data generation section500determines whether data stored in the performance data storage section410has been updated (registration and change of data) (S22). If the data in the performance data storage section410has been updated (YES in S22), the business data generation section500determines whether reference data (data item) of the corresponding performance data exists in the business data storage section600(master data) (S23). Here, if the reference data (data item) exists in the business data storage section600(master data) (YES in S23), the business data generation section500registers the corresponding performance data into the business data storage section (performance data) (S24). After the processing of step S24, the business data generation section500ends the processing of the present flowchart.

If the data in the performance data storage section410has not been updated (NO in S22) or if the reference data (data item) of the corresponding performance data does not exist in the business data storage section600(master data) (NO in S23), the business data generation section500ends the processing of the present flowchart. Unless the reference data exists in the business data storage section600(master data), the performance data subject to update cannot be managed as business data.

Next, if the data in the master data storage section420has been updated (YES in S21), the business data generation section500determines whether the effective period of the updated data is valid (S25). For example, in a case where the effective period start date and the effective period end date are reversed in time series, the effective period is not valid. If the effective period of the updated data is not valid (NO in S25), the business data generation section500ends the processing of the present flowchart.

Next, if the effective period is valid (YES in S25), the business data generation section500determines whether a parent ID exists in the data item of the updated data (S26). The parent ID has a parent-child relationship between data in a BOM master table, a sequence master table, and the like. Then, the business data generation section500moves to step S27if the parent ID exists (YES in S26), and ends the processing of the present flowchart if the parent ID does not exist (NO in S26).

Next, the business data generation section500confirms the update/delete flag122(seeFIG.9) of the corresponding master data and determines whether master data registration processing is necessary (S27). If the registration flag is on in the update/delete flag122, it is necessary to register the corresponding master data into the business data storage section600. Here, the business data generation section500moves to step S28if performing the master data registration processing (YES in S27), and moves to step S30if not performing the master data registration processing (NO in S27).

Next, the business data generation section500determines whether master data having an effective period overlapping with that of the updated master data in the master data storage section420exists in the business data storage section600(master data) (S28). Next, if the effective period of the master data does not overlap (NO in S28), the business data generation section500registers the updated master data into the business data storage section600(master data) (S29). After the processing of step S29or if the effective period of the master data overlaps (YES in S28), the business data generation section500ends the processing of the present flowchart.

On the other hand, if not performing the master data registration processing (NO in S27), the business data generation section500confirms the update/delete flag122and determines whether the master data subject to update exists (the update flag is on) (S30). If the master data subject to update exists (YES in S30), the business data generation section500determines whether master data having an effective period overlapping with that of the updated master data in the master data storage section420exists in the business data storage section600(master data) (S31). Next, if master data having an overlapping effective period does not exist (NO in S31), the business data generation section500records (updates) the updated master data into the business data storage section600(master data) (S32).

After the processing of step S31, the processing of the present flowchart is ended. If the master data subject to update does not exist (NO in S30) or if master data having an overlapping effective period exists (YES in S31), the business data generation section500ends the processing of the present flowchart.

[Table Configuration of Master Data]

FIG.11illustrates a configuration example of each table of the master data620stored in the business data storage section600.

As examples of the master data620, an item master table621, a process master table622, a BOM master table623, and a sequence master table624are presented in the business data storage section600.

The item master table621is a table indicating a correspondence relationship between the item ID and the item name, and has “ITEM ID”, “ITEM NAME”, “EFFECTIVE PERIOD START DATE”, and “EFFECTIVE PERIOD END DATE” as fields.

The item ID is the same as the item ID111(FIGS.4and8), and is information for uniquely identifying the item.

The item name indicates the name of the item specified by the item ID.

The effective period start date indicates the start date of the effective period of the present data (record).

The effective period end date indicates the end date of the effective period of the present data (record).

In the example ofFIG.11, “TELEVISION A” and “TELEVISION B” are registered as the item name for the item ID “1”. As illustrated inFIG.9, the television A is manufactured by the vendor A, and the television B is manufactured by a vendor B. After the effective period of the data for the television A ends, the effective period of the data for the television B subsequently starts.

The process master table622is a table indicating a correspondence relationship between the process ID and the process name, and has “PROCESS ID”, “PROCESS NAME”, “EFFECTIVE PERIOD START DATE”, and “EFFECTIVE PERIOD END DATE” as fields.

The process ID is the same as the process ID112(FIGS.4and8), and is information for uniquely identifying the process.

The process name indicates the name of the process specified by the process ID.

The effective period start date indicates the start date of the effective period of the present data (record).

The effective period end date indicates the end date of the effective period of the present data (record).

In the example ofFIG.11, “painting” and “PAINTING” are registered as the process name for the process ID “10”. This is because the manager45has input one process name in lower case and the other process name in upper case when registering the process name. For example, also in a case of using other scripts or other symbols, there is a possible difference in half-width/full-width, upper-case/lower-case, and the like. After the effective period of the data for “painting” ends, the effective period of the data for “PAINTING” subsequently starts.

The BOM master table623is a table indicating a correspondence relationship among the parent item ID, the child item ID, and the number, and has “PARENT ITEM ID”, “CHILD ITEM ID”, “NUMBER”, “EFFECTIVE PERIOD START DATE”, and “EFFECTIVE PERIOD END DATE” as fields.

The parent item ID indicates a parent item among items in a parent-child relationship, and corresponds to the item ID of the item master table.

The child item ID indicates a child item among items in the parent-child relationship.

The number indicates the quantity of child items.

The effective period start date indicates the start date of the effective period of the present data (record).

The effective period end date indicates the end date of the effective period of the present data (record).

The sequence master table624is a table indicating a correspondence relationship between the parent process ID and the child process ID, and has “PARENT PROCESS ID”, “CHILD PROCESS ID”, “EFFECTIVE PERIOD START DATE”, and “EFFECTIVE PERIOD END DATE” as fields.

The parent process ID indicates a parent process (upstream process) among processes in a parent-child relationship, and corresponds to the process ID in the process master table.

The child process ID indicates a child process among processes in the parent-child relationship.

The effective period start date indicates the start date of the effective period of the present data (record).

The effective period end date indicates the end date of the effective period of the present data (record).

In the master table described above, the effective period sometimes changes when the data is changed. For example, in a case where the item name is changed in the item master table621, the effective period is changed while the item ID remains the same, and the item name after the change is registered. Therefore, consistency of related data is ensured by the attribute of this effective period even if the content of the performance data is changed.

[Table Configuration of Performance Data (Actual Process Table)]

FIG.12illustrates a configuration example of the table of the performance data610stored in the business data storage section600.

In the business data storage section600, the actual process table611is illustrated as an example of the performance data610. The actual process table611includes “ACTUAL PROCESS ID”, “ITEM ID”, “PROCESS ID”, “PERFORMANCE START TIME”, and “PERFORMANCE END TIME”.

The actual process ID is identification information for process management, and IDs are given in time series, for example. The item ID is the same as the item ID111(FIGS.4and8), and is information for uniquely identifying the item.

The process ID is the same as the process ID112(FIGS.4and8), and is information for uniquely identifying the process.

The performance start time is a time indicated by the event occurrence time116when the event type115(FIGS.4and8) is “START”.

The performance end time is a time indicated by the event occurrence time116when the event type115(FIGS.4and8) is “END”.

As described above, the business data storage section600manages the master data620by the effective period. Therefore, the process name and the item name to be acquired from the master data620by the business data generation section500vary depending on the performance start time and the performance end time of the process.

Next, the master data registration section210will be described in detail.

FIG.13is a block diagram illustrating a configuration example of the master data registration section210.FIG.13will be described assuming that the performance data management device200includes the display section55and the operation section56.

The master data registration section210includes a master data display control section211, a master definition edit section212, and a master data registration screen processing section213. The master data display control section211and the master definition edit section212correspond to a server (application software). The master data registration screen processing section213corresponds to a browser (application software).

The master data display control section211reads the master data620from the business data storage section600(master data), and outputs a file of the master data620to the master data registration screen processing section213together with a file such as a registration screen or an update screen.

On the basis of the master data620input from the master data display control section211and the files of various screens, the master data registration screen processing section213constitutes the various screens and displays the master data on the display section55. The master data registration screen processing section213outputs, to the master definition edit section212, an editing instruction for the master data620performed through the operation section56by the manager45or the like who saw the various screens.

The master definition edit section212edits and stores, into the business data storage section600(master data), the master data620on the basis of the editing instruction input from the master data registration screen processing section213.

Next, the master data registration processing will be described with reference toFIG.14.

FIG.14is a flowchart illustrating a procedure example of the master data registration processing by the master data registration section210.

First, when the manager45selects a menu for registering (adding) master data from a menu screen (not illustrated) with the operation section56, the master data registration section210receives an instruction of this selection. The master data registration screen processing section213displays, on the display section55, a screen for registering (adding) the master data (for example, an item addition screen220illustrated inFIG.15).

Then, when the manager45inputs, on the item addition screen220, the information of the master data desired to register by the operation section56, the information of the master data to be registered is input to the master data registration screen processing section213(S41). Thereafter, the master data registration screen processing section213receives a registration instruction by pressing a registration button (seeFIG.15) and instructs the master definition edit section212for registration processing. Next, the master definition edit section212determines whether an invalid value has been set in the input master data information (S42). Here, if determining that an invalid value has not been set in the input information (NO in S42), the master definition edit section212stores the input master data information (item data) into the master data620in the business data storage section600(S43).

In the present embodiment, when the master data is registered using the item addition screen220, the master definition edit section212automatically gives and registers, into the master data620, an item ID on the basis of the item name and/or item description. However, an item ID field may be provided so as to allow the manager45to directly input the item ID with the operation section56. Note that the initial value of the version of the newly registered master data is “1”. The version is information for distinguishing between new and old master data, and in the present embodiment, the larger the value is, the newer the master data is.

On the other hand, if determining that an invalid value has been set in the input information (YES in S42), the master definition edit section212invalidates the input information and notifies the master data display control section211of an error. Upon receiving the error notification, the master data display control section211outputs an error screen225(seeFIG.16) described later to the display section55(S44). After the processing of step S43or S44, the processing of the present flowchart is ended.

Next, a screen for registering item data (item addition screen) will be described with reference toFIG.15.

FIG.15illustrates an example of a screen for registering item data (the item addition screen220).

The item addition screen220includes an item name field221and an effective period field222. In addition, the item addition screen220includes at least an item description field, a part number field, a figure number field, an item group field, a registration button, and a cancel button. A feature of the item addition screen220is to include the effective period field222. A well-known technique can be used for other configurations of the item addition screen220.

The item name field221is a field for inputting the name of an item to be added.

The effective period field222is a field for inputting the effective period of the master data (record) registered on the item addition screen220.

The item description field is a field for inputting the description of an item (product) indicated by an item name. The part number field is a field for inputting a number (a numeral or a symbol such as Roman alphabet) for identifying the type of the item (product) indicated by the item name.

The figure number is a field for inputting the number of a design drawing (mostly CAD data in general) of the item to be specified by the part number.

The item group is a field for inputting a group into which the item (product) indicated by the item name is classified.

The registration button is a button for registering the input information into the master data620.

The cancel button is a button for canceling registration of the input information into the master data620.

FIG.16illustrates an example of an error screen to be output when an invalid value is set in the input information. As explained in step S44ofFIG.14, the master definition edit section212outputs the error screen225when an invalid value is set in the input information. For example, in a case where the effective period start date and the effective period end date in the effective period field222are reversed in time series, an error occurs. At this time, a message “UNABLE TO REGISTER INPUT DATA BECAUSE EFFECTIVE PERIOD IS IMPROPER” is displayed on the error screen225.

Next, the master data update processing will be described with reference toFIG.17.

FIG.17is a flowchart illustrating a procedure example of the master data update processing by the master data registration section210.

First, when the manager45selects a menu for updating (changing) master data from a menu screen (not illustrated) with the operation section56, the master data registration section210receives an instruction of this selection. The master data registration screen processing section213displays, on the display section55, a screen for updating (changing) the master data. When the manager45designates master data desired to update by the operation section56, a screen (for example, an item update screen230illustrated inFIG.18) for updating the designated master data is displayed on the display section55.

Then, when the manager45inputs, on the item update screen230, the information of the master data desired to update by the operation section56, the information of the master data to be updated is input to the master data registration screen processing section213(S51). Thereafter, the master data registration screen processing section213receives an update instruction by pressing an update button (seeFIG.18) and instructs the master definition edit section212for update processing.

Next, the master definition edit section212determines whether addition of master data of a new version has been instructed (S52). Here, if addition of master data of the new version has not been instructed (NO in S52), the master definition edit section212moves to step S53. Then, the master definition edit section212determines whether the effective period of the master data (designated record) to which update information is input overlaps the effective period of master data (another record) of another version (S53). The version of master data will be described in detail with reference toFIG.18.

Next, if the effective period of the master data to which update information is input overlaps the effective period of master data of another version (YES in S53), the master definition edit section212invalidates the input information and ends the processing of the present flowchart. Note that, in a case where there is only one version, determination is not performed regarding overlap of the effective period. However, similarly to step S42, it is determined whether or not an invalid value has been set in the input information. If an invalid value has been set in the input information, it is desirable to invalidate the input information and output an error. Also if there is an overlap in the effective period, it is preferable to output an error.

Next, if the effective period of the master data to which update information is input does not overlap the effective period of master data of another version (NO in S53), the master definition edit section212updates the master data620in the business data storage section600(S54).

On the other hand, if addition of master data of the new version has been instructed (YES in S52), the master definition edit section212moves to step S55. Then, the master definition edit section212determines whether the effective period of the master data (new record) of the new version overlaps the effective period of master data (another record) of an existing version (S55).

Next, if the effective period of the master data of the new version overlaps the effective period of the master data of an existing version (YES in S55), the master definition edit section212invalidates the input information and ends the processing of the present flowchart.

Next, if the effective period of the master data of the new version does not overlap the effective period of the master data of an existing version (NO in S55), the master definition edit section212stores information of the master data of the new version into the master data620in the business data storage section600(S56). After the processing of step S54or S56, the processing of the present flowchart is ended.

Next, a screen (item update screen) for updating item data will be described with reference toFIG.18.

FIG.18illustrates an example of a screen (item update screen230) for updating item data.

The item update screen230includes at least an item ID field233and a version field234in addition to the configuration of the item addition screen220. The item update screen230includes an update button instead of a registration button. A feature of the item update screen230is to include an effective period field232and the version field234.

An item name field231is the same as the item name field221.

The effective period field232is a field for inputting the effective period of the master data (record) updated on the item update screen230.

The item ID field233is a field for inputting information corresponding to the item ID field of the item master table621illustrated inFIG.11. In the item master table621, the item ID “1” indicates “TELEVISION”. In the present embodiment, the item addition screen220does not display the item ID, but the item update screen230displays the item ID.

The version field234is a field for inputting the version of the present data (record). It is possible to increase the version of data by operating the version field234. As the version field234, for example, a graphical user interface (GUI) such as a pull-down menu or a list box can be used.

In the item update screen230ofFIG.18, “VERSION 2” is displayed in the version field234. When the version of the designated master table is changed from “1” to “2”, the master table of the version 2 is newly created while leaving the master table of the old version 1. On the item update screen230, the item name is changed to “TELEVISION B” with respect to the master table (version 1) registered on the item addition screen220, and the effective period is set to “2019/01/01 TO 2024/12/31” in order to avoid overlap with the version 1. Then, by selecting the version 2 in the version field234and pressing the update button, the master table of the version 2 is created with this content.

[Bills of Materials Definition Screen (Item) Before Registration]

Next, a screen (bills of materials definition screen) for registering BOM management information will be described with reference toFIG.19. In business management, a parts list is also referred to as bills of materials (BOM).

FIG.19illustrates an example of a screen (bills of materials definition screen240) for registering BOM management information.

The bills of materials definition screen240has a BOM management information area241in the upper part of the screen and a component hierarchical structure area248indicating components constituting an item (product) in the lower part of the screen.

The BOM management information area241is an area for displaying information for managing components and materials necessary for assembly of an item (product).

The component hierarchical structure area248is an area for displaying a hierarchical structure of components.

The BOM management information area241includes an item ID field242, an item name field243, a version field244, an effective period field245, a parent-child item start point field246(parent item), and a parent-child item end point field247(child item). In addition, the BOM management information area241includes a hierarchy field, a number field, an inventory field, an add button, an update button, and a delete button.

The item ID field242is a field into which information of “PARENT ITEM ID+CHILD ITEM ID” of the BOM master table623illustrated inFIG.11is input.

The item name field243is a field for inputting the name of an item (component) subjected to definition.

The version field244is a field for inputting the version of the present data (record).

The effective period field245is a field for inputting the effective period of the master data (record) defined on the bills of materials definition screen240.

The parent-child item start point field246(parent item) is a field for inputting the item name of a parent item among items in a parent-child relationship.

The parent-child item end point field247(child item) is a field for inputting the item name of a child item among items in a parent-child relationship.

The hierarchy field is a field for inputting the number of hierarchies of components of an item (television A in this example) specified by the item ID.

The number field is a field for inputting the quantity of the items indicated by the item name.

The inventory field is a field for inputting the inventory of the items indicated by the item name.

The add button is a button for adding (registering) the input information to the master data620.

The update button is a button for updating the master data620with the input information.

The delete button is a button for canceling registration of the input information into the master data620.

An item ID field, a date and time designation field249, and a display button are provided above the component hierarchical structure area248.

The item ID field is a field for inputting information corresponding to the item ID field of the item master table621illustrated inFIG.11.

The date and time designation field249is a field for inputting the date and time desired to designate. When the date and time is designated, the hierarchical structure of the components at the designated date and time is displayed in the component hierarchical structure area248. That is, the hierarchical structure of the components to be displayed changes depending on the designated date and time.

The display button is a button for displaying the hierarchical structure of components. When the display button is pressed after the date and time is designated, the hierarchical structure of the components defined at the time point of the designated date and time is displayed.

A feature of the bills of materials definition screen240is to include the effective period field245, the version field244, and the date and time designation field249.

On the bills of materials definition screen240illustrated inFIG.19, components constituting the television A are displayed in a 3-layer hierarchical structure in the component hierarchical structure area248. “LIQUID CRYSTAL PANEL”, “SUBSTRATE”, and “COVER” are connected to a layer (second layer) below “TELEVISION A” (first layer), and “GLASS” is connected to a layer (third layer) below “LIQUID CRYSTAL PANEL”. In the figure, “×n” (n is a natural number) on the right side of the component indicates the number of components.

[Bills of Materials Definition Screen (Item) after Registration]

FIG.20illustrates an example of a screen (bills of materials definition screen280) after registration of BOM management information.

When the add button is pressed in a state where the BOM management information illustrated inFIG.19is input onto the bills of materials definition screen240, the content changes to the content of the bills of materials definition screen240illustrated inFIG.20. Here, in the component hierarchical structure area248, one “LIQUID CRYSTAL” is connected to the layer below “LIQUID CRYSTAL PANEL” in addition to “GLASS”.

This allows the manager45to confirm that “LIQUID CRYSTAL” has been added to the hierarchical structure of the components of the television A in the component hierarchical structure area248of the bills of materials definition screen240.

[Bills of Materials Definition Screen (Item) after Designated Date and Time is Changed]

Next, a change in the display content of the screen after registration of the BOM management information due to the change of the designated date and time will be described with reference toFIG.21.

FIG.21illustrates a change example of the display content of the screen (bills of materials definition screen) after registering BOM management information due to a change in designated date and time.

In the date and time designation field249, the date and time to be designated is changed from “2017/01/01” to “2020/01/01”, and the display button is pressed. Due to this, the hierarchical structure of components associated with an effective period including “2020/01/01” is displayed. For example, inFIG.21, the item is changed from “TELEVISION A” to “TELEVISION B” and the components of the television B are indicated in a 3-layer hierarchical structure. “LIQUID CRYSTAL PANEL”, “CENTER SUBSTRATE”, and “COVER” are connected to a layer (second layer) below “TELEVISION B” (first layer), “GLASS” and “LIQUID CRYSTAL” are connected to a layer (third layer) below “LIQUID CRYSTAL PANEL”, and “SUBSTRATE (1)” and “SUBSTRATE (2)” are connected to a layer (third layer) below “CENTER SUBSTRATE”.

FIG.22illustrates an example of hierarchical structure data of components registered for each effective period.

The upper part ofFIG.22illustrates hierarchical structure data251of the components with the effective period in 2015/01/01 to 2018/12/31. The lower part ofFIG.22illustrates hierarchical structure data252of the components with the effective period in 2019/01/01 to 2024/12/31. Between the two effective periods, the item is changed from “TELEVISION A” to “TELEVISION B”, and “TELEVISION B” has an increased number of components than “TELEVISION A”. The hierarchical structure data of the components for each effective period is stored in the nonvolatile storage57.

Thus, in the present embodiment, by having a function of setting an effective period to the master data and designating a date and time in the date and time designation field249, it is possible to confirm the hierarchical structure of components at the designated date and time.

Next, a screen (process addition screen) for registering process data will be described with reference toFIG.23.

FIG.23illustrates an example of a screen (process addition screen260) for registering process data.

The process addition screen260includes a process name field261and an effective period field262. In addition, the process addition screen260includes at least a process description field, a standard time (ST) field, a registration button, and a cancel button. The most characteristic feature of the process addition screen260is to include an effective period field262.

The process name field261is a field for inputting the name of a process to be added.

The effective period field262is a field for inputting the effective period of the master data (record) to be registered on the process addition screen260.

The process description field is a field for inputting the description of a process indicated by the process name.

The ST field is a field for inputting work time required to complete a target process.

By executing the flowchart ofFIG.14using the process addition screen260, the master data registration section210stores the input master data information (process data) into the master data620in the business data storage section600.

Next, a screen (process update screen) for updating process data will be described with reference toFIG.24.

FIG.24illustrates an example of a screen (process update screen270) for updating process data.

The process update screen270includes at least a process ID field273and a version field274in addition to the configuration of the process addition screen260. The process update screen270includes an update button instead of a registration button. A feature of the process update screen270is to include a version field274and an effective period field272.

A process name field271is the same as the process name field261.

The effective period field272is a field for inputting the effective period of the master data (record) updated on the process update screen270.

The process ID field273is a field for inputting information corresponding to the process ID field of the process master table622illustrated inFIG.11. In the process master table622, the process ID “10” indicates “painting” or “PAINTING”. In the present embodiment, the process addition screen260does not display the process ID, but the process update screen270displays the process ID.

The version field274is a field for inputting the version of the present data (record).

By executing the flowchart ofFIG.17using the process update screen270, the master data registration section210updates the master data620in the business data storage section600with the input master data information (process data).

[Bills of Materials Definition Screen (Process) Before Registration]

Next, a screen (bills of materials definition screen) for registering a process branch will be described with reference toFIG.25.

FIG.25illustrates an example of a screen (bills of materials definition screen280) for registering a process branch.

The bills of materials definition screen280has a process management information area281in the upper part of the screen and a process hierarchical structure area288indicating a process procedure in the lower part of the screen.

The process management information area281is an area for displaying information for managing a process of manufacturing an item (product).

The process hierarchical structure area288is an area for displaying the hierarchical structure of the process.

The process management information area281includes a process ID field282, a process name field283, a version field284, an effective period field285, an upstream-side parent-child process field286, and a downstream-side parent-child process field287. In addition, the process management information area281includes a hierarchy field, an add button, an update button, and a delete button.

The process ID field282is a field into which information of “PARENT PROCESS ID+CHILD PROCESS ID” of the sequence master table624illustrated inFIG.11is input.

The process name field283is a field for inputting the name of a process subjected to definition.

The version field284is a field for inputting the version of the present data (record).

The effective period field285is a field for inputting the effective period of the master data (record) defined on the bills of materials definition screen280.

The upstream-side parent-child process field286is a field for inputting the process names of a start point and an end point of an upstream-side path among the paths constituting the branch process. The process name of this start point is the name of a process specified by the parent process ID of the sequence master table624(FIG.11), and the process name of the end point is the name of a process specified by the child process ID of the sequence master table624.

The downstream-side parent-child process field287is a field for inputting the process names of a start point and an end point of a downstream-side path among the paths constituting the branch process. The process name of this start point is the name of a process specified by the parent process ID of the sequence master table624(FIG.11), and the process name of the end point is the name of a process specified by the child process ID of the sequence master table624.

The hierarchy field is a field for inputting the number of hierarchies of the processes specified by the process ID282.

An item ID field, a date and time designation field289, and a display button are provided above the process hierarchical structure area288.

The item ID field is a field for inputting information corresponding to the item ID field of the item master table621illustrated inFIG.11.

The date and time designation field289is a field for inputting the date and time desired to designate. When the date and time is designated, the hierarchical structure of the processes at the designated date and time is displayed in the process hierarchical structure area288. That is, the hierarchical structure of the processes to be displayed changes depending on the designated date and time.

The display button is a button for displaying the hierarchical structure of processes. When the display button is pressed after the date and time is designated, the hierarchical structure of the processes defined at the time point of the designated date and time is displayed.

On the bills of materials definition screen280illustrated inFIG.25, the process hierarchical structure area288displays a 3-layer hierarchical structure as processes indicated by the upstream-side parent-child process field286and the downstream-side parent-child process field287. That is, “SORTING” is set in a downstream process (second layer) of “CABLE PRODUCTION” (first layer), and “UNIT ASSEMBLY” is set in a downstream process (third layer) of “SORTING”.

[Bills of Materials Definition Screen (Process) after Registration]

FIG.26illustrates an example of a screen (bills of materials definition screen280) after registering the process branch.

When the add button is pressed in a state where the process management information illustrated inFIG.25is input onto the bills of materials definition screen280, the content changes to the content of the bills of materials definition screen280illustrated inFIG.26. Here, the process hierarchical structure area288displays a state of branching into “SORTING” and “ELECTRIC WIRE FABRICATION” as a downstream process of “CABLE PRODUCTION”. Then, after “SORTING” and “ELECTRIC WIRE FABRICATION”, the process merges with the process of “UNIT ASSEMBLY”.

This allows the manager45to confirm that the process of “ELECTRIC WIRE FABRICATION” is branched separately from “SORTING” between “CABLE PRODUCTION” and “UNIT ASSEMBLY” in the process hierarchical structure area288of the bills of materials definition screen280.

[Bills of Materials Definition Screen (Process) after Designated Date and Time is Changed]

Next, a change in the display content of the screen after registration of the process branch due to the change of the designated date and time will be described with reference toFIG.27.

FIG.27illustrates a change example of the display content of the screen (bills of materials definition screen) after registering a process branch due to a change in designated date and time.

In the date and time designation field289, the date and time to be designated is changed from “2020/01/01” to “2018/01/01”, and the display button is pressed. Due to this, the hierarchical structure of processes associated with an effective period including “2018/01/01” is displayed. For example, inFIG.27, a process having a three-layer hierarchical structure is illustrated by one path. That is, the sequence of “CABLE PRODUCTION”, “SORTING”, and “UNIT ASSEMBLY” is displayed. This is the hierarchical structure of the process before adding the branch process illustrated inFIG.25.

The hierarchical structure data of the processes for each effective period is stored in the nonvolatile storage57.

[Display Example of Business Data]

Next, screen display when the business application730acquires data from the performance data management device200through the business ETL710will be described.

FIG.28illustrates an example of screen display when the business application730acquires data from the performance data management device200.FIG.28illustrates a business performance data list721stored in the business data storage section720and accessed by the business application730. The business performance data list721is an example of data accessed by the business application730according to the purpose, and is not limited to this example.

The business performance data list721is created by the business ETL710and is displayed in a table format. The business performance data list721has an item name field, a process name field, a version field, an ST field, a performance start time field, and a performance end time field.

The item name field indicates the name of the item specified by the item ID of the actual process table611(FIG.12).

The process name field indicates the name of the process specified by the process ID of the actual process table611(FIG.12). The business ETL710acquires the names of the item name field and the process name field from the master data620in the business data storage section600.

The version field indicates the version of master data updated on the item update screen230(FIG.18), for example.

The ST field indicates the time in the ST field displayed on the process addition screen260or the process update screen270.

The performance start time field indicates the performance start time of the actual process table611(FIG.12), the time at which the process is actually started.

The performance end time field indicates the performance end time of the actual process table611(FIG.12), the time at which the process is actually ended.

In the first record of the business performance data list721, the item name is “TELEVISION A”, the process name is “painting”, the version is “1”, the ST is “120”, the performance start time is “2018/12/28 09:00:00”, and the performance end time is “2018/12/31 17:00:00”. In the second record, the item name is “TELEVISION B”, the process name is “PAINTING”, the version is “2”, the ST is “120”, the performance start time is “2019/01/01 09:00:00”, and the performance end time is “2019/01/03 17:00:00”.

Thus, since (the effective period of) the data read from the master data620is different depending on the performance start time and the performance end time, the item name changes from the television A to the television B. In the present example, since the data read from the master data620is different, the process name, the version, and the ST are also changed.

As described above, the performance data management device200according to the first embodiment of the present invention includes: the performance data processing section310that receives the performance data110generated by the manufacturing site system1; the performance data storage section410that stores and accumulates the performance data110received by the performance data processing section310; the master data storage section (business data storage section600) that stores the master data620has data to be basic information when the performance data110is managed; the business data generation section500that generates business data (performance data610) by processing the performance data110into a structure used by the business application730based on data (data item and field) to be the basic information of the master data620; and the business data storage section600that stores the business data generated by the business data generation section500. Then, the master data620includes an attribute that represents start of an effective period of data to be the basic information (effective period start date) and an attribute that represents end of an effective period (effective period start date).

In the present embodiment configured as described above, it is possible to ensure consistency of related data by the attribute of this effective period even if the content of the performance data of the manufacturing site system is changed.

When the business performance data list721is viewed through the business application730, the effective period of the data is not displayed. Therefore, the user can use the performance data without being conscious of the effective period of the data.

In the performance data management device200according to the first embodiment of the present invention described above, the business data generation section500generates business data from performance data on the basis of the effective period of the data to be the basic information of the master data.

In the performance data management device200according to the first embodiment of the present invention described above, the business data generation section500determines whether an invalid value has been set in the performance data110on the basis of the effective period of the data to be the basic information of the master data.

The performance data management device200according to the first embodiment of the present invention described above includes the master data registration section210that registers the master data620into the master data storage section (business data storage section600) in accordance with an instruction from the operation section56. When registering master data, the master data registration section210invalidates the value instructed from the operation section56in a case where the value of the effective period instructed from the operation section56is an invalid value as an effective period.

In the performance data management device200according to the first embodiment of the present invention described above, when registering the master data, the master data registration section210outputs an error in a case where the value of the effective period instructed from the operation section56is an invalid value as an effective period.

In the performance data management device200according to the first embodiment of the present invention described above, when registering the master data, the master data registration section210displays, on the display section55, a registration screen (the item addition screen220or the process addition screen260) representing the hierarchical structure of components or processes necessary for assembly of the item to be manufactured.

In the performance data management device200according to the first embodiment of the present invention described above, the master data620has data to be the basic information in which an effective period is set for each component necessary for assembly of the item to be manufactured.

In the performance data management device200according to the first embodiment of the present invention described above, in a case where the master data120including data to be the basic information when managing the performance data110is acquired from the manufacturing site system1, the business data generation section500determines whether to register the master data120on the basis of a state of the flag (update/delete flag122) for registering or updating the master data120included in the acquired master data120into the master data storage section (business data storage section600).

Second Embodiment

In general, as four elements of production, resources used in business can be classified into so-called 4M, i.e., man, machine, material, and method. Then, business is analyzed from the viewpoint of the four elements of production in order to achieve key performance indicator (KPI) targeted by a management organization.

FIG.29illustrates a configuration example of performance data classified into four elements of production according to the second embodiment of the present invention.

As the types of the performance data,FIG.29illustrates performance data110A where a man is a resource, performance data110B where a machine is the resource, performance data110C where a material is the resource, and performance data110D where a method is the resource.

As attributes (data items), the performance data110A includes a 4M type131, a resource ID132, and a contact name133, for example, in addition to the item ID111, the process ID112, the product ID113, the event type115, and the event occurrence time116.

The 4M type131stores information indicating the type of resource for use in practice of business (generating performance data). In the present embodiment, it is indicated which element in the 4M of production the performance data belongs to. This 4M type information makes it possible to sort the performance data for each of the 4M type.

The resource ID132stores a resource ID corresponding to a resource name (in charge of painting, in charge of drying, and the like) defined by master data not illustrated. In this master data, a relationship between business and resources associated with the business is defined.

The contact name133stores the name of the person in charge of work engaged in business as information indicating details of the resource.

As attributes (data items), the performance data110B includes the 4M type131, the resource ID132, and a name134, for example, in addition to the item ID111, the process ID112, the product ID113, the event type115, and the event occurrence time116.

The resource ID132stores a resource ID corresponding to a resource name (painting device, drying device, and the like) defined by master data not illustrated.

The name134stores the name of the machine used for business as information indicating details of the resource.

As attributes (data items), the performance data110C includes the 4M type131, the resource ID132, a member name135, and a quantity136, for example, in addition to the item ID111, the process ID112, and the product ID113.

The resource ID132stores a resource ID corresponding to a resource name (members, components, materials, and the like) defined by master data not illustrated.

The member name135stores the names of members (components), materials, and the like used or produced in business as information indicating details of the resource.

As information indicating performance, the quantity136stores information indicating an increase or decrease from a set value (initial number, target number, or the like) of the quantity of a target member, for example. This may be a value of the quantity of a target member.

As attributes (data items), the performance data110D includes the 4M type131, the resource ID132, a procedure name137, and a result138, for example, in addition to the item ID111, the process ID112, and the product ID113.

The resource ID132stores a resource ID corresponding to a resource name (methods, procedures, and the like) defined by master data not illustrated.

The procedure name137stores the name of the method (procedure) used in business as information indicating details of the resource.

As information indicating performance, the result138stores information on a result (good, not good, or the like) of execution of a method instructed in business.

In the second embodiment described above, an example in which performance data (resource) is classified into four elements of production has been described, but it may be classified into three elements or two elements of the four elements. Alternatively, performance data (resource) may be classified into a type of elements different from the four elements of production.

The present invention is not limited to the first and second embodiments described above, and can be applied to general systems such as FA systems and process automation (PA) systems. The present invention is suitably applied to a system in which a start time and an end time of a process, a work, or the like are obtained as performance data.

Furthermore, the present invention is not limited to each of the above-described embodiments, and it goes without saying that various other application examples and modifications can be taken without departing from the gist of the present invention described in the claims.

For example, each of the above-described embodiments is described with the configuration of the performance data management device in detail and specifically in order to describe the present invention in an easy-to-understand manner, and the present invention is not necessarily limited to those including all the constituent elements described above. A part of the configuration of an embodiment can be replaced with a constituent element of another embodiment. A constituent element of another embodiment can be added to the configuration of an embodiment. Another constituent element can be added to, replaced with, or deleted from a part of the configuration of each embodiment.

The above-described configurations, functions, processing sections, and the like may be partially or entirely implemented by hardware by designing with an integrated circuit, for example. A field programmable gate array (FPGA), an application specific integrated circuit (ASIC), or the like may be used as the hardware.

Each constituent element of the performance data management device according to the first and second embodiments described above may be implemented in any hardware as long as each piece of the hardware can transmit and receive information to and from one another via a network. The processing performed by a certain processing section may be implemented by one piece of hardware or may be implemented by distributed processing by a plurality of pieces of hardware.

REFERENCE SIGNS LIST

110performance data120master data127data effective period start date128data effective period end date200performance data management device210master data registration section220item addition screen230item update screen240bills of materials definition screen (item)241BOM management information area248component hierarchical structure area260process addition screen270process update screen280bills of materials definition screen (process)288process hierarchical structure area310performance data processing section320master data processing section410performance data storage section420master data storage section500business data generation section600business data storage section610performance data611actual process master table620master data621item master table622process master table623BOM master table624sequence master table730business application1000business management system