JPH0985589A - Data management system and controlling method for it - Google Patents

Abstract

PROBLEM TO BE SOLVED: To decrease load of an operator managing the manufacturing process of products by providing a process hysteresis data judging means for judging the state of the process hysteresis of the product having the target number on the basis of the process hysteresis data. SOLUTION: A file server(FS) 1 obtains the number of the process by the initially selected input item, refers to a product process hysteresis master table of the input product number, and retrieves the number of the process of the finished product process. The product hysteresis master table for holding and renewing the process number of the finished manufacturing process in relation to all product numbers is stored in the file server 1. The data are sequentially inputted by a manufacturing device connected to a data base managing computer 2 and a network 6. The optional data item is selected by handy terminals(HT) 5, the number of the product subjected to processing is input, and enquiry is performed to the FS. The result is displayed on the HT and helps an operator to judge.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management system for managing process management data in a manufacturing process of products and a control method thereof.

[0002]

2. Description of the Related Art Conventionally, when process control is performed in a manufacturing process for a mass-produced product, at the end of each manufacturing process,
For each product or each lot, the worker fills in the history of the finished process using a predetermined form sheet, or a predetermined storage place is provided to judge the finished process by the storage position,
Furthermore, those products were moved to the next process, and processing and inspection were performed.

[0003]

However, in the above-mentioned conventional example, when the number of manufacturing processes is large and the product is a mass-produced product, the operator may omit omissions or mistakes in the entry process history sheet. Raise, duplicate manufacturing process, skip process,
There was a problem of making the product defective. Further, in the inspection process and the like, since it is difficult for the operator to immediately judge the already completed manufacturing process from the appearance of the product, it is necessary to confirm it with the form data and the work efficiency is not good.

Therefore, an object of the present invention is to provide a data management system and a control method thereof that can reduce the burden on an operator who manages a product manufacturing process.

[0005]

As a configuration of the present invention for attaining the above-mentioned object, claim 1 is an input means for inputting product data of a plurality of products in a manufacturing process, and the input product data. In a data management system of a manufacturing facility, which has an arithmetic processing unit for calculating the calculation result and a storage unit for storing the calculation result and the product data, the target product among the product numbers of the plurality of products individually for each product. An inquiry means for inputting a number and a target process number among the process numbers of the manufacturing process, and inquiring process history data which is a history of the manufacturing process of the product having the target product number; and the product number. Updating and storing the process number of the processed process in the manufacturing process in correspondence with each completion of the manufacturing process, and Based on a product number and the target process number, a database means for searching the process history data in the storage means, and the target product number according to the process history data obtained from the database means Is a process history data judging means for judging the state of the process history of the product, and a display means for displaying the judgment result.

As a result, the latest process history in the manufacturing process of a plurality of products is maintained and managed by the data management system,
The product number unique to each product and the manufacturing process number can be used as keys to make inquiries, reducing the burden on the operator.

According to a second aspect of the present invention, the inquiry means, the process history data determination means and the display means are provided in one or more wireless communication handy terminals connected via a modem. It is a data management system for manufacturing equipment according to Item 1.

The addition of a plurality of wireless handheld terminals to the system of claim 1 provides manufacturing site level agility of the data management system.

As another configuration of the present invention for achieving the above-mentioned object, claim 3 inputs the product data of a plurality of products in the manufacturing process and performs an operation, and stores the operation result and the product data. In the control method of the manufacturing equipment data management system, the product number that each of the plurality of products individually has and the process number of the processed process in the manufacturing process correspond to each time the manufacturing process completes one process. A process that is a history of the manufacturing process of the product having the target product number from the target product number among the product numbers and the target process number among the process numbers of the manufacturing process. Inquire history data,
The process history data is searched based on the target product number and the target process number, and the state of the process history of the product with the target product number is determined according to the obtained process history data. A method for controlling a manufacturing equipment data management system, characterized by making a judgment.

With this, the latest process history in the manufacturing process of a plurality of products is maintained and managed by the data management system,
The product number unique to each product and the manufacturing process number can be used as keys to make inquiries, reducing the burden on the operator.

[0011]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings.

First, the overall configuration of a data management system according to an embodiment of the present invention will be described with reference to FIG.

FIG. 1 is a block diagram of a data management system as an embodiment of the present invention.

In the figure, 1 is a file server as a storage means for accumulating process management data of products collected by a predetermined procedure, and 2 is a process number for inputting each process (hereinafter referred to as process N).
o. ) And a database management computer for managing the data in the file server 1, 5
Is a plurality of wireless communication handy terminals as an input means for inquiring about processes, inputting process data, etc.
Reference numeral 4 is a handy terminal transmitting / receiving station for communicating with the handy terminal 5, and 3 is a handy terminal transmitting / receiving computer for communicating with the handy terminal transmitting / receiving station 4 and for data communication with devices on the network 6. These devices are connected to a network 6 such as a local area LAN or Ethernet.
It is provided with a mutual communication means via. In addition, the database management computer 2 and the handy terminal transmission / reception computer 3 are each a display device 2 such as a CRT.
1. The display device 31 is provided.

Next, an external view of the handy terminal 5 is shown in FIG.
Shown in

FIG. 2 is an external view of the handy terminal 5 as one embodiment of the present invention.

In the figure, 8 is a common input key, and 7 is a display screen such as an LCD as a display means. In this embodiment, the display screen 7 also serves as a touch panel type input key as an input means. On the display screen 7, data input items, inquiry results, etc. can be displayed. Further, by using the up and down two kinds of arrow keys of the common key 8, the display screen can be scrolled and expanded, and the data input item can be selected.

Next, referring to FIGS. 4 to 10, a flow chart showing the flow of operation of the data management system of FIG.
The data management of the product number “A1234” in the data input item “process No. 3” will be described as an example. .

FIG. 3 is a flow chart showing the operation of the data management system as an embodiment of the present invention.

In the figure, in step S301, an arbitrary data input item is selected from the display screen 7 of the handy terminal 5. For example, pressing the up and down two types of arrow keys to scroll the display screen and selecting “process No. 3” which is one of the manufacturing steps (pressing the “process No. 3” portion on the display screen 7). ). When the data input item is selected, the display screen 7 has the display contents shown in FIG.

FIG. 4 is a diagram showing a product number input screen as one embodiment of the present invention.

In step S302, the product number of the product to be processed is entered in the data input area 10 of the screen shown in FIG. For example, the product number "A123
4 ". Next, in step S303, the file server 1 for the input product number "A1234".
Contact us. Inquiry request data is
Handy terminal 5 → Handy terminal transceiver station 4
→ Data transmission / reception computer 3 for handy terminal →
The files are transmitted in order of the file server 1 via the wireless line and the network.

Here, the file server 1 stores a process order master table indicating the order of each process which is input in advance from the database management computer 2.
An example of the process order master table is shown in FIG.

FIG. 5 is a diagram showing a process order master table as one embodiment of the present invention.

The file server 1 obtains the process No. by the input item selected first, then refers to the product process history master table of the product number input next, and the process No. of the finished manufacturing process. To search. The file server 1 stores a product process history master table for storing and updating process numbers of finished manufacturing processes for all product numbers, and the data is stored in the database management computer 2 and the network 6. The data are sequentially input from the manufacturing device (not shown) connected above. Therefore,
At the initial stage when the manufacturing process is started, the product process history master table contains only the product number data, and the end process number is blank. FIG. 6 is an example of the product process history master table, and shows that the manufacturing processes that have already been completed are up to process No3.

FIG. 6 is a diagram showing a product process history master table as an embodiment of the present invention.

The selected input item is "process No. 3",
That is, the process number is set to 4, and the entered product number is "A1".
234 ”, the three search patterns of the process No. of the manufacturing process that has already been completed will be described (note that the process No. corresponding to the selected input item is the input process No.).

1. Pattern 1 (input process No) ≤
There is at least one end process that is (end process No.).

2. Pattern 2 (input process No.)>
(All end process Nos.) And the end process No does not include the previous process of the input process No (here, process No = 3).

3. Pattern 3 (input process No.)>
(All end process Nos.) And the end process No includes the previous process No of the input process No.

The results retrieved by these three patterns are transmitted through the wireless line and the network in the order of file server 1 → handy terminal data transmitting / receiving computer 3 → handy terminal transmitting / receiving station 4 → handy terminal 5.

In step S304, the result is displayed on the display screen 7 of the handy terminal 5. As an example of displaying the inquiry result, FIGS. 7 to 9 show each of the judgment patterns 1 to 3 described above.

FIG. 7 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when the pattern 1 is applied).

The comment on the display screen 7 indicates that all the manufacturing processes for the product number "A1234" inquired about have been processed.

FIG. 8 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when pattern 2 is applied).

The comment in the display screen 7 is the previous step of the "process No. 3" of the product number "A1234" inquired, that is, "inspection No. 1" in which the process No. 3 is.
Is unprocessed.

FIG. 9 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when pattern 3 is applied).

The comment in the display screen 7 is the process number for the product number "A1234" inquired about.
3 shows a state in which the manufacturing process up to the preceding process is normally completed.

Next, in step S305, the operator is made to determine whether or not to input the process data from the handy terminal 5, and if the process data is not input or the process No. of interest is processed, the input of the process data cannot be accepted. In this case (in the case of FIG. 7), the inquiry process is ended by proceeding to step S308 and pressing the stop key on the display screen 7. On the other hand, in the case of the display of FIG. 9, process No3
Since the process is not yet performed, process data can be input, and if the continuation key of the display screen 7 is pressed, the display screen 7 is expanded to the screen shown in FIG. 10 (step S306).

FIG. 10 is a diagram showing a display example of a process data input screen as an embodiment of the present invention.

In the display screen 7, 11 and 12 are data input areas in which arbitrary process data within a predetermined range can be input.

Next, in step S307, the data input to the handy terminal 5 in step S306 is transmitted to the file server 1 in the same order as in the above-described inquiry request. The file server 1 uses the end process N of the product process history master table of FIG. 6 corresponding to the product number.
The update process for adding the process No. in which the process data is input to the o column (process No. 4 corresponding to the process No. 3 in this case) is performed, and the series of data management processes ends.

Needless to say, the inquiry processing and process data input processing described above can be performed not only from the handy terminal 5 but also from the database management computer 2.

<Modification of Embodiment> 1. In the above embodiment, the determination result is displayed for one product number, but a plurality of product numbers may be determined at once.

2. Further, in the above-described embodiment, only the determination result is displayed, but in addition to the determination result, the entire end process history of the product number may be displayed.

3. Further, the handy terminal may have a master table input function as an input means.

The present invention may be applied to a system including a plurality of devices such as a host computer, an interface and a printer, or may be applied to an apparatus including a single device. Further, it goes without saying that the present invention can be applied to the case where it is implemented by supplying a program to a system or an apparatus. In this case, the storage medium storing the program according to the present invention constitutes the present invention. Then, by reading the program from the storage medium to the system or device, the system or device operates in a predetermined manner.

<Effects of the Embodiment> (1) Since the process history of the manufacturing process of the product is maintained and managed by the data management system, the process history can be inquired by the product number, and the process data can be input. When I had to make a decision, I was able to provide prompt support. As a result, it is possible to prevent the duplication of the manufacturing process, the occurrence of the process skipping, etc. in advance, and improve the workability and the non-defective rate. (2) Since the handy terminal transceiver station 4 and the plurality of wireless communication handy terminals 5 are provided with the data management system of the effect (1) of the embodiment, the worker at the manufacturing site can judge on the spot. Made possible This made the system more mobile and improved workability.

[0049]

As described above, according to the present invention, it is possible to provide a data management system and a control method therefor capable of reducing the burden on a worker who manages a manufacturing process of a product.

[0050]

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a data management system as an embodiment of the present invention.

FIG. 2 is an external view of a handy terminal 5 as an embodiment of the present invention.

FIG. 3 is a flowchart showing an operation of the data management system as one embodiment of the present invention.

FIG. 4 is a diagram showing a product number input screen according to an embodiment of the present invention.

FIG. 5 is a diagram showing a process order master table as one embodiment of the present invention.

FIG. 6 is a diagram showing a product process history master table as one embodiment of the present invention.

FIG. 7 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when pattern 1 is applied).

FIG. 8 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when pattern 2 is applied).

FIG. 9 is a diagram showing a display example of an inquiry result as one embodiment of the present invention (when pattern 3 is applied).

FIG. 10 is a diagram showing a display example of a process data input screen as an embodiment of the present invention.

[Explanation of symbols]

 1 File Server 2 Database Management Computer 3 Data Transmission / Reception Computer for Handy Terminal 4 Handy Terminal Transmission / Reception Station 5 Wireless Communication Handy Terminal 6 Network 7 Display Screen 8 Common Input Key 10 Data Input Area 11 Data Input Area 12 Data Input Area 21 Data Display 31 Display

Front Page Continuation (72) Inventor Hiroyuki Kawauchi 3-30-2 Shimomaruko, Ota-ku, Tokyo Canon Inc.

Claims (3)

[Claims] 1. An input means for inputting product data of a plurality of products in a manufacturing process, an arithmetic processing means for arithmetically operating the input product data, and a storage means for storing the arithmetic result and the product data. In a data management system of a manufacturing facility, a target product number among the product numbers that the plurality of products individually have for each product, and a target process number among the process numbers of the manufacturing process are input, and the purpose thereof. Inquiry means for inquiring process history data that is a history of the manufacturing process of the product having the product number, the product number, and the process number of the processed process in the manufacturing process complete one process. The process history data is searched and updated based on the target product number and the target process number. Database means, process history data judging means for judging the state of the process history of the product of the target product number according to the process history data obtained from the database means, and display means for displaying the judgment result. A data management system for manufacturing equipment, comprising: 2. The one or more wireless communication type handy terminals connected via a modem with the inquiry means, the process history data determination means, and the display means. Manufacturing equipment data management system. 3. A control method of a manufacturing equipment data management system, which inputs product data of a plurality of products in a manufacturing process, calculates the product data, and stores the calculation result and the product data. The product number and the process number of the processed step in the manufacturing process are updated and stored in correspondence with each time the manufacturing process completes one process, and the target product number among the product numbers and the Inquiry process history data, which is the history of the manufacturing process of the product having the target product number, from the target process number among the process numbers of the manufacturing process, and the target product number and the target process number Based on the above, the process history data is searched, and the state of the process history of the product of the target product number is determined according to the obtained process history data. The method of manufacturing equipment data management system, characterized in that.