JP4813816B2 - Information processing apparatus and performance data collection management apparatus - Google Patents

Description

The present invention relates to an information processing apparatus that obtains and outputs results data of products manufactured by a batch process, and results data collection that collects, manages, and provides results information of products manufactured by a batch process to the information processing apparatus. related to the management device.

  For products manufactured by a batch process, it is necessary to manage the manufacturing history. Conventionally, a lot data, which is a unit of production, is used as a unit to create a report of actual data in the form of lot reports, The result data of each lot is displayed on the screen or output as a form (for example, see Patent Document 1).

In order to realize this, specifically, the performance data is extracted in units of brands and lots from the history server that collects and manages the performance data, and the lot performance list display and the lot information are output.
JP 2004-21298 A

  However, in the batch process, recipe data is different for each brand, and the collection timing of performance data is different.

  From now on, in order to perform the process of extracting the actual data in units of brands and lots from the history server and outputting the lot actual list display and the lot information, conventionally, this has been developed by developing a program with a single product. It was to be realized.

  For this reason, according to the prior art, there are various problems such as an increase in man-hours for program development and difficulty in remodeling the program.

The present invention has been made in view of such circumstances, and it is an object of the present invention to provide a new technology capable of collecting required performance data without modifying a program for a certain brand manufactured by a batch process. And

  In order to achieve this object, the information processing apparatus of the present invention and the performance data collection management apparatus of the present invention adopt the following configuration.

[1] Configuration of the information processing apparatus of the present invention The information processing apparatus of the present invention is configured to obtain and output actual data of a lot of a brand produced by a batch process, and (1) A setting means for setting a process for collecting performance data for a certain brand by interacting with the user using an editing screen that displays what processes are included in the batch process; (2 ) By interacting with the user using the edit screen, a lot ID collection instruction is assigned to each process set by the setting means, and an arbitrary record data name is assigned to the record data item possessed by those processes. By assigning, creating means for creating a lot definition, and (3) notifying the lot definition created by the creating means to the result data collection management device of the present invention, A configuration is provided that includes instruction means for instructing collection of performance data of each process defined in the lot definition and instructing collection of a lot ID in synchronization with the collection.

  When adopting this configuration, by interacting with the user using the edit screen of the data sheet format used to create the form template, the form data of the form template can be created using the actual data name described in the lot definition. There may be provided a second creation means for creating the format of the data sheet used for creation. In the case of providing this second creation means, the instruction means provides the second result data collection management device of the present invention with a second. By notifying the format information created by the creating means, it is instructed how to arrange the collection data when the collection instruction result data is transmitted.

  Here, each of the processing means described above can be realized by a computer program, and this computer program is provided by being recorded on an appropriate computer-readable recording medium or provided via a network to implement the present invention. In this case, the present invention is realized by being installed and operating on a control means such as a CPU.

[2] Configuration of Actual Data Collection and Management Device of the Present Invention The actual data collection and management device of the present invention has a configuration in which actual data of lots of a certain brand manufactured by a batch process is collected and managed. (1) By presenting a lot definition editing screen to the information processing apparatus of the present invention, a lot definition that defines a process for which performance data is collected is created for a certain brand, and the lot definition is obtained. An acquisition means; (2) a collection means for collecting actual data of each process defined by the lot definition obtained by the acquisition means together with a lot ID; and (3) an information processing apparatus according to the present invention from the actual data collected by the collection means. The system includes an execution unit that extracts a piece having a lot ID specified by and transmits the extracted result data to the information processing apparatus of the present invention.

  When adopting this configuration, by presenting the data sheet format editing screen used to create the form template to the information processing apparatus of the present invention, the result data items of each process defined in the lot definition May be provided with a second acquisition means for generating the format of the data sheet and obtaining the format information. When the second acquisition means is provided, the execution means may include the extracted result data. By writing them in the order specified by the format information obtained by the second obtaining means and sending them to the information processing apparatus of the present invention, writing into the form template is performed.

  Here, each of the processing means described above can be realized by a computer program, and this computer program is provided by being recorded on an appropriate computer-readable recording medium or provided via a network to implement the present invention. In this case, the present invention is realized by being installed and operating on a control means such as a CPU.

[3] Operation of the present invention In the present invention configured as described above, the performance data collection and management apparatus of the present invention presents a lot definition edit screen in response to a presentation request from the information processing apparatus of the present invention. .

  In response to this, the information processing apparatus of the present invention uses this editing screen to interact with the user, thereby setting a process for collecting performance data for a certain brand, and further using this editing screen. By interacting with the user, a lot definition is assigned to each set process and a lot definition is created by assigning an arbitrary result data name to the result data items of those processes.

  In response to this, the actual data collection management apparatus of the present invention obtains this lot definition.

  Thereafter, the performance data collection management device of the present invention presents an edit screen for the format of the data sheet used for creating the form template in response to the presentation request from the information processing device of the present invention.

  In response to this, the information processing apparatus of the present invention interacts with the user by using this editing screen, and uses the result data name described in the previously created lot definition to generate data for creating the form template. Create a sheet format.

  In response to this, the result data collection and management apparatus of the present invention obtains this format information.

  When the user creates the format of the data sheet using the data sheet format editing screen used for creating the form template, the user activates Excel or the like and creates the form template linked to the data sheet.

  When these series of processes are completed, the result data collection and management device of the present invention can provide the result data of the lot required by the information processing device of the present invention.

  That is, the actual data collection management device of the present invention collects and accumulates actual data of each process defined in the lot definition together with the lot ID according to the acquired lot definition.

  And when performing this accumulation, if there is a request for providing actual data by specifying a lot ID from the information processing apparatus of the present invention, those having the lot ID are extracted from the collected actual data, The result data extracted is transmitted to the information processing apparatus of the present invention.

  At this time, when the format information of the data sheet used for creating the form template is obtained from the information processing apparatus of the present invention, the extracted performance data is arranged in the order specified by the format information, and the information processing apparatus of the present invention is arranged. By sending to, write to the form template.

  As described above, when a user who uses the information processing apparatus of the present invention wants to obtain performance data of a certain brand manufactured by a batch process, a lot definition is created using the lot definition editing screen. By just doing, you will be able to obtain the actual data for each lot you want.

  In this way, according to the present invention, the user can obtain the desired performance data for a certain brand manufactured by the batch process without modifying the program.

  When the user who uses the information processing apparatus of the present invention wants to obtain the performance data of a certain brand manufactured by the batch process and output it to a freely designed form, first, the editing screen is displayed. Use it to create a lot definition, create a data sheet format for creating a form template, and then use Excel to design the form while linking with the created data sheet format. Now, you can get the actual data for each lot you want and output it to a freely designed form.

  In this way, according to the present invention, the user obtains the desired performance data for a certain brand manufactured by the batch process without modifying the program, and outputs it to a freely designed form. Will be able to.

  Hereinafter, the present invention will be described in detail according to embodiments.

  FIG. 1 shows an example of the system configuration of a lot performance data collection system to which the present invention is applied.

  As shown in this figure, a lot performance data collection system to which the present invention is applied includes a batch process 1 for manufacturing a product of a certain brand, a controller 2 for controlling the batch process 1, and a controller 2 via a network 100. Connected to the results data collection management device 3 that collects and manages the results data of the lots generated by the controller 2, and to the results data collection management device 3 via the network 200, the results data collection management device 3 The client apparatus 4 that obtains lot actual data from the data and displays it on a screen or outputs it as a form.

  In the lot result data collecting system configured as described above, a plurality of different lots of the same brand may be manufactured simultaneously.

  Even in such a case, the present invention realizes a new mechanism that enables the client device 4 to provide the record data of the lot required by the user.

  Next, a mechanism for realizing the present invention will be described in detail by explaining functions of each device.

  The controller 2 includes a process control unit 20 that controls the batch process 1 and a set of flags that are provided in association with the result data generated by the batch process 1. “0” is displayed when data is not generated, “1” is displayed when actual data is generated, and an actual data storage unit 22 for storing actual data generated by the batch process 1 is displayed. Prepare.

  The performance data collection management device 3 monitors whether or not the performance data has been generated by monitoring the web service execution unit 30 that provides the web service to the client device 4 and the flag area 21 of the controller 2. When the performance data is generated, the performance data collection unit 31 that collects the performance data together with the lot ID from the performance data storage unit 22 of the controller 2 and the performance data collected by the performance data collection unit 31 (the pair of lot IDs) A record data DB 32 for storing data) and a definition storage unit 33 for storing the lot definition defined by the client device 4 and the format information of the data sheet.

  The client device 4 displays the edited data presented from the web service execution unit 30 of the actual data collection management device 3 on the screen, creates a lot definition, and saves it in the definition storage unit 33 of the actual data collection management device 3 Edit data presented from the lot definition creation unit 40 and the web service execution unit 30 of the result data collection management device 3 are displayed on the screen, and a data sheet format used to create a form template is created. The format creation unit 41 stored in the definition storage unit 33 of the collection management device 3, the form template 42 created by Excel (not shown) using the format information created by the format creation unit 41, and the result data using the form template 42 The lot data obtained from the collection management device 3 is developed into a form image and the form file is displayed. And a form file creating unit 43 for creating yl.

[1] Lot Definition Creation Processing Next, lot definition creation processing executed by the lot definition creation unit 40 will be described.

  FIG. 2 illustrates an example of a lot definition editing screen displayed by the lot definition creation unit 40. Here, the lot definition editing unit 40 displays the lot definition editing screen upon receiving the lot definition information from the web service execution unit 30 of the actual data collection management device 3.

  As shown in this figure, the user-defined event is displayed in the right pane of the lot definition editing screen, and the lot definition created based on this user-defined event is displayed in the left pane (first Is blank.

  In the user-defined event provided in the right pane, what are the processes of batch process 1 that manufactures the product of the selected brand, and what are the actual data items of those processes? Whether or not there is.

  In the example of FIG. 2, it is assumed that orange juice is selected as the brand. As a process of batch process 1 for producing orange juice, the steps of “preparation” and “stirring” are performed in the step of using the mixing tank. Yes, it is displayed that there is a record data item “Item-A” in the process “preparation”, and there is a record data item “Kakuhan” in the process “mixing”.

  When the user designates a record data item from user-defined events in the right pane and presses the “← key”, the lot definition creation unit 40 displays the designated record data item in the lot definition in the left pane. On the other hand, when the user designates a record data item from the lot definition in the left pane and presses the “→ key”, the designated record data item is deleted.

  In this way, the user interacts with the lot definition creation unit 40 to select the actual data item required by the user from the actual data items described in the user-defined event in the right pane, and to the left It is processed so as to be displayed in the lot definition of the pane.

  Subsequently, when the user selects a process from the lot definitions in the left pane and then selects it as a start process using the menu, the lot definition creation unit 40 selects the selected process in the actual data. It is set as a process to start acquisition and an “S” icon is added. Then, when the user selects a process from the lot definition in the left pane and subsequently selects it as an end process using the menu, the selected process is set as a process to end the acquisition of the actual data. To add an “E” icon.

  In the example of FIG. 2, an example in which the process “preparation” is set as a process for starting acquisition of actual data and the process “addition” is set as a process for completing acquisition of actual data.

  In this way, the user can interact with the lot definition creation unit 40 to select one process from among the processes displayed in the lot definition in the left pane, and start acquisition of performance data. In addition, by selecting one process different from that, processing is performed so as to set a process for ending acquisition of the result data.

  Subsequently, when the user requests that the result data item be assigned to the result data item described in the lot definition in the left pane, the lot definition creation unit 40 can write the result data item to the user. Assign the actual data name.

  In the example of FIG. 2, the result data name “Item A” is assigned to the result data item “Item-A”, and the result data name “Agitation time” is assigned to the result data item “Kakuhan”. In this example, the actual data item “Geneki-T” is assigned the actual data name “raw solution T” and the actual data item “Ph” is assigned the actual data name “Ph value”. ing.

  In this way, the user interacts with the lot definition creation unit 40 to perform processing so as to set an arbitrary result data name for the result data item of the process displayed in the lot definition in the left pane. To do.

  Subsequently, when the user selects a record data item from the lot definition in the left pane and subsequently requests the assignment of a lot ID using the menu, the lot definition creation unit 40 selects the record data item for the selected record data item. To assign the lot ID.

  Setting of lot ID assignment is indispensable for the actual data items described in the lot definition in the left pane. From the example of FIG. 2, the actual data item “item A” and the “stirring time” An example is shown in which lot ID assignments are set for all the performance data items, such as the performance data item “stock solution T” and the performance data item “Ph value”.

  The creation of the lot definition is completed by the above processing. The lot definition created in this way is stored in the definition storage unit 33 of the actual data collection management device 3, and the actual data collection management device 3 performs the controller. 2 will be referred to when collecting performance data.

  The meaning of the lot definition created in this way is as follows.

  That is, the actual data of the actual data items described in the lot definition is the actual data that the client device 4 actually acquires, and the actual data items of all the processes from the start setting process to the end setting process. The actual result data is the acquisition target.

  As shown in FIG. 3, since the collection timing of each performance data collected by the performance data collection management device 3 is determined by the control operation of the controller 2, defining the performance data item in the lot definition means This means deciding which performance data is to be collected and deciding when to collect the data.

  However, the actual data collection management device 3 determines the collection timing according to the lot definition because the actual data collection timing is monitored by monitoring the flag in the flag area 21 provided in association with the actual data to be collected. I do not do such processing.

  In addition, any actual data name will be added by the user to the actual data item described in the lot definition. As will be described later, the user must design a form using this actual data name. become. Therefore, the presence of this function allows the user to create a form in a form using words preferable to him / her by adding a record data name preferable to him / her.

  In addition, lot ID assignment is set to the actual data items described in the lot definition. This lot ID assignment setting is performed by collecting actual data to the actual data collection management device 3. This means that it is instructed to collect the lot ID in synchronism with it.

  Since the actual data generated by the controller 2 and the lot ID set as the lot identification number managed by the controller 2 have nothing to do with the lot ID, If the command to collect the data is not given, the performance data can be collected, but the lot ID cannot be collected.

  This cannot cope with the case where a plurality of different lots of the same brand are manufactured simultaneously. Therefore, the process of setting the assignment of the lot ID to the record data item described in the lot definition is performed.

[2] Data Sheet Format Creation Processing Next, data sheet format creation processing used by the format creation unit 41 for creating the form template 42 will be described.

  FIG. 4 shows an example of a form output definition editing screen displayed by the format creation unit 41. Here, the form creation unit 41 displays the form output definition editing screen upon receipt of the form definition information provided from the web service execution unit 30 of the result data collection management device 3.

  As shown in this figure, the right pane of the form output definition editing screen is used to set the input area used to set the file name of the form file to be created and the format of the data sheet used to create the form template 42. The lot definition created by the lot definition creation unit 40 is displayed in the left pane.

  First, the format creation unit 41 uses a file name setting input area in the right pane to select a lot from the start date / time of a lot production, brand name, lot ID, etc., and a combination thereof. If the command is used to set the file name of the form file, the file name of the form file is set according to the instruction.

  Subsequently, the format creation unit 41 selects the actual data name described in the lot definition in the left pane, drags it as it is, and drops it in the output item column of the format setting input area in the right pane. The format of the data sheet used to create the form template 42 is created by setting the result data name selected by the user in the output item column of the drop destination.

  The example of FIG. 4 shows a format example in which “stock solution T” of the actual data name is arranged in the first line of “sheet name: tank A” and “Ph value” of the actual data name is arranged in the second line. ing. Actually, there are the third and subsequent lines, but they are omitted in this figure.

  After completing these settings, the user presses the “form template edit button” displayed in the right pane.

  From now on, when the user presses the “form template edit button”, the format creation unit 41 activates Excel and instructs creation of a form file.

  When Excel is activated in this way, the user designs a form in the form he or she desires using Excel, and each cell of the designed form and the format creation unit 41 are displayed in accordance with the drag / drop operation. A form template 42 is created by linking each output item described in the format of the created data sheet.

Here, the data format of the result data output to the form template 42 is, for example, for each output item:
"Collecting date / time, process name, actual data name, actual data value, industrial unit"
Thus, the link between the form cells is set between these items.

  When such a form template 42 is created, the form file creation unit 43 can automatically create a form having a design desired by the user simply by writing the result data to the data sheet in accordance with the data sheet format. .

  With the above processing, the creation of the format of the data sheet used to create the form template 42 and the creation of the form template 42 are completed. For the format information of the data sheet thus created, the actual data The data is stored in the definition storage unit 33 of the collection management device 3 and is referred to when the result data collection management device 3 transmits the result data to the client device 4.

[3] Process Flow According to the Present Invention Next, the flow of the lot creation data form creation process to be executed according to the present invention configured as described above will be described.

  In the present invention, a user first creates a lot definition.

  When the user creates a lot definition, the user requests the client device 4 to create a lot definition, and in response to this, the result data collection management device 3 responds to the request from the client device 4. A lot definition editing screen as shown in FIG.

  In response to this, the client device 4 creates a lot definition by performing the above-described processing, and saves it in the definition storage unit 33 of the result data collection management device 3.

  Subsequently, the user creates a data sheet format used to create the form template 42.

  When creating a data sheet format used for creating the form template 42, the user requests the client device 4 to create a data sheet format. In response to a request from the client device 4, a form output definition editing screen as shown in FIG. 4 is presented to the client device 4.

  In response to this, the client device 4 creates the format of the data sheet used to create the form template 42 by performing the above-described processing, and saves the format information in the definition storage unit 33 of the result data collection management device 3. To do.

  After this, the user designs the form as desired by using Excel, and in accordance with the drag-and-drop operation, each cell of the designed form and the format of the data sheet created by the format creation unit 41 are described. A form template 42 is created by linking each output item.

  In this state, the actual data collection management device 3 enters the process of collecting the actual data defined in the lot definition together with the lot ID according to the obtained lot definition. It becomes possible to provide actual data of lots.

  For example, the performance data collection management device 3 notifies the client device 4 of the ID of the lot when the production of the lot is completed.

  In response to this notification, the client device 4 displays a list of lot IDs that have been manufactured, and when the user wants to create a form of performance data for the lot indicated by a certain lot ID, The lot ID is designated and a form is requested.

  In response to this, the client device 4 requests the result data collection management device 3 to provide the result data by specifying the lot ID, and in response to this, the result data collection management device 3 collects the collected results. The actual data having the lot ID is extracted from the data, and the actual data is arranged in the order specified by the format information received from the client apparatus 4 and provided to the client apparatus 4.

  In response to the provision of the record data, the client device 4 writes the record data sent from the record data collection management device 3 to the data sheet linked to the form template according to the order, thereby automatically creating the form. Will be.

  As explained above, when the user wants to obtain the actual data of a certain brand manufactured by the batch process, the user only needs to create a lot definition using the lot definition editing screen, for each desired lot. You will be able to obtain the actual data.

  When the user wants to obtain actual data of a certain brand manufactured by a batch process and output it to a freely designed form, first create a lot definition using the edit screen of the lot definition. Then, use the edit screen of the form output definition to create the format of the data sheet used to create the form template, and then use Excel to create the form while linking with the format of the created data sheet. By simply designing, you can get the actual data for each lot you want and output it to a freely designed form.

It is a figure which shows an example of the system configuration | structure of the lot performance data collection system to which this invention is applied. It is a figure which shows an example of the edit screen of a lot definition. It is explanatory drawing of a lot definition. It is a figure which shows an example of the edit screen of a form output definition.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Batch process 2 Controller 3 Actual data collection management apparatus 4 Client apparatus 20 Process control part 21 Flag area 22 Actual data storage part 30 Web service execution part 31 Actual data collection part 32 Actual data DB
33 definition storage unit 40 lot definition creation unit 41 format creation unit 42 form template 43 form file creation unit 100 network 200 network

Claims (4)

In an information processing device that obtains and outputs the performance data of a lot of a brand manufactured by a batch process,
Setting means to set the process for collecting performance data for a certain brand by interacting with the user using an edit screen that displays what the batch process is as a process.
By interacting with the user using the above editing screen, assigning lot ID collection instructions to each set process and assigning any actual data name to the actual data items of those processes. , A creation means for creating a lot definition that defines a process for which performance data is collected ,
By notifying the lot definition to the actual data collection management device, it is instructed to collect the actual data of each process defined in the lot definition, and to collect the lot ID in synchronization with the collection. Providing instruction means for instructing,
A characteristic information processing apparatus. The information processing apparatus according to claim 1,
Create a data sheet format used to create a form template by using the actual data name described in the lot definition above by interacting with the user using the data sheet format editing screen used to create the form template. With creation means,
The instructing means, by notifying the format information to the results data collection management device, instructing how to arrange the results when collecting the results data of the collection instruction,
A characteristic information processing apparatus. In the performance data collection management device that collects and manages the performance data of a lot of a brand manufactured by a batch process,
By presenting a lot definition editing screen to the information processing device, for a certain brand, a lot definition that defines the process for which performance data is to be collected is created, and obtaining means for obtaining the lot definition,
A collection means for collecting actual data of each process defined in the lot definition together with a lot ID;
Extracting the one having the lot ID specified by the information processing device from the collected result data, and providing execution means for transmitting the extracted result data to the information processing device,
A featured data collection and management device. In the performance data collection management device according to claim 3,
By presenting the edit screen of the data sheet format used to create the form template to the information processing apparatus, the data sheet format is created using the actual data items of each process defined in the lot definition, It has a means to obtain the format information,
The execution means arranges the extracted result data in the order specified by the format information and transmits the information to the information processing apparatus, thereby writing the form template.
A featured data collection and management device.

Images