JP2003303011A - Management system for production and processing processes - Google Patents

Abstract

(57) [Summary] [Problem] Regarding a management system of a production / processing process, when materials and products are processed while flowing between devices,
It is an object of the present invention to speed up processing and reduce the burden on an operator by converting materials, products, and devices into objects. In a process in which a material is processed, a computer program is used which is provided with a database for recording data relating to each material and each processing, and managing a data object for each processing stage for each material. It is a management system for production and processing steps.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a management system using a computer program in a production process or a processing process.

When processing data in a production process or a processing process, a function for managing data on a memory is provided, and when accessing the same recorded data, the contents of the memory are used as they are without rereading. By doing so, it is desirable to reduce the frequency of access to the data and facilitate the consistency of the data between the programs.

Further, when a material or a product is processed while flowing between processing devices in a production process or a processing process, the data of the material, the product or the device is converted into an object so that the worker can realize the actual device. It is desirable to be able to input data by a corresponding operation.

[0004]

2. Description of the Related Art In a conventional production process or processing process, when data is processed, the data is made into an object, and even when a plurality of processes share the image of a database in a plurality of memories in each process. Since it was imported, data inconsistency was easy to occur. In addition, it was necessary to perform a process for fetching the contents of the database each time the data was accessed.

FIG. 1 shows a conventional data processing method as described above.
The database will be divided into data objects for each processing module. For example, in FIG. 1, in a manufacturing process of a certain product, module A is referred to as “actual introduction processing” and module B is referred to as “inspection introduction processing”. In the module A, the database was accessed and the data object was created each time the performance input process was performed. That is, every time the module A is executed, the module A accesses the database and rewrites the object. Similarly, in the next module B,
Even when performing the inspection input process, the module B accesses the database and rewrites the data object each time.

As described above, on the assumption that a certain machining process is completed in a certain production process, the actual result indicating that the machining process is completed is searched from the database (SQL execution). Then populate the data object for module A.

Thus, in the conventional data processing method,
Since the database is accessed for each module and the contents of the database are fetched and rewriting is performed, there is a problem that data processing cannot be performed quickly. In addition, it is extremely complicated to manage the database for each data object divided into modules.

Further, in the conventional production management system, a program modularized for each function is created, and each program performs processing while directly searching the database. For this reason, in the operation, the operator separates the processing depending on the product or process and operates it.

FIG. 2 shows such a conventional production management system.
For example, in the manufacturing process of a certain product, the material is processed in the order of acceptance inspection, first processing, second processing, intermediate inspection, third processing, fourth processing, shipping inspection, shipping. The case is assumed. In this case, in the process of performing the acceptance inspection, the worker searches the database for the data for the acceptance inspection (acceptance inspection), and in each of the first, second, third, and fourth machining steps, Performs the performance input process to the database,
The inspection result is output in the steps of the intermediate inspection and the shipping inspection, and the inspection result output and the data of the shipping process are output in the shipping step.

As described above, in the conventional production control system, a modularized program is created for each of the functional units, that is, the acceptance inspection, the actual result input process, the inspection result input, the inspection result output, and the shipping process. The method of directly searching the database and performing the process of each step according to the search result was adopted.

[0011]

As described above, according to the conventional data processing method or the conventional production management system, it is necessary for the operator to divide the processing depending on the product or process, and the work is complicated. Therefore, there has been a demand for a data processing method in a production management system that can reduce the work load on the worker and perform a quick process.

In view of this, according to the present invention, when a material or a product is processed while flowing between devices or the like, the material, the product, the device, or the like is made into an object to achieve speeding up of the processing. Another object is to reduce the burden on the operator.

Further, in the conventional production management system, the contents of the database had to be fetched every time the database was accessed, so that the processing was very complicated.

Therefore, it is an object of the present invention to reduce the frequency of access to the database, speed up the processing, and facilitate consistency.

[0015]

In order to achieve the above-mentioned object, according to the present invention, a database is provided which records each material and data relating to each processing in the step of processing the material, and the database is provided. When a data object is common to a predetermined stored material, a computer program characterized by referring to the same data object over a plurality of processing steps without creating a data object for each processing is used. A management system for production / treatment processes is provided. In this case, the database for the material is created only when there is no data object for the predetermined material stored in the database.

Further, according to the present invention, in the process of processing the material, it is provided with a database for recording the data on each material and each processing, and managing the data object for each processing step for each material. Provided is a management system of production / processing steps using a computer program having the characteristics.

Furthermore, according to the present invention, the material is inspected, a plurality of processing steps, an intermediate inspection, a plurality of processing steps,
When each processing stage of shipping inspection and shipping is processed in time series, a database for recording data on individual materials and individual processing is provided, and the database is accessed for each processing step for each material. There is provided a production / processing process management system using a computer program characterized by performing a database rewriting process.

Furthermore, according to the present invention, after the products are packed in a box, loaded on a truck, and transported to a predetermined point,
Equipped with a database that records data on individual products, individual packaging boxes, and individual transportation trucks when unloaded and unloaded There is provided a production / processing step management system using a computer program, characterized in that a database is accessed for each processing step and the database is rewritten.

Furthermore, according to the present invention, in a rental business in which members rent products, a database is provided which records data on individual members, individual products, and individual storage units for storing these products. Regarding the members, when renting a certain product or returning a certain product, the database is accessed at each stage, and the database is rewritten. A management system is provided.

[0020]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

FIG. 3 shows a data processing method according to the present invention. In FIG. 3, for example, in the manufacturing process of a certain product,
Module A is referred to as "actual introduction processing" and module B is referred to as "inspection introduction processing". The database has one data object for a particular material.

For the module A, when performing the performance input processing, the database is accessed in the object management. Check the database for the presence or absence of data objects for specific materials. If there is no data object for the material, create a data object (execute SQL).

If there is a data object for the material, the next module B is executed without creating a new data object. Prior to execution of module B, the presence or absence of a data object for the material is confirmed from the database. In this case, since a data object for the material already exists, that data object is used as it is (SQ
Do not run L).

In this way, when the function of managing the data on the memory is provided and the same record is accessed, the frequency of access to the data can be increased by using the already existing memory contents without re-reading. It was possible to reduce the data loss and make the data consistency between programs easier.

FIG. 4 shows one embodiment of the production control system according to the present invention. In FIG. 4, for example, in the material processing step, the acceptance inspection, the first processing,
It is assumed that the material is processed in the order of second processing, intermediate inspection, third processing, fourth processing, and shipping inspection. First,
In the process of conducting the acceptance inspection, the worker searches the database for data for the acceptance inspection (acceptance inspection), and in the process of performing the first machining, the worker searches the database for the data for the first machining process (first machining). ), And similarly, in each step of the second processing, the intermediate inspection, the third processing, the fourth processing, the shipping inspection, and the shipping, the worker searches the database for the data for each step.

In this way, in the process in which each material or product and each processing device is made into an object, and the material or product is processed while flowing through each processing / processing device in time series, the worker is the same as an actual device. Or, the data can be input by the corresponding operation. Further, even if the process or the processing device is replaced in the manufacturing line, it is possible to flexibly cope with the change.

For example, assuming that a fifth machining step is newly added between the fourth machining and the shipping inspection, the data regarding the fifth machining is stored in the database, and the process shifts to the fifth machining. , The worker accesses the database and reads the data regarding the fifth processing. As described above, even when the process or the device is replaced, it is possible to respond more flexibly and promptly as compared with the conventional production management system.

FIG. 5 is a flow chart showing another embodiment of the production control system according to the present invention. In this embodiment, in the manufacturing process of the semiconductor device, the manufacturing process of mounting the semiconductor chip on the substrate is taken as an example.

In FIG. 5, first, the substrate is put into the manufacturing process. The board has its own data object. Next, the substrate is moved to the mounting process,
There are some work in progress when moving to the DSP chip mounting process (nnn).

On the other hand, in the DSP chip manufacturing process, first, a wafer is loaded. Wafers have their own data objects. When the wafer is processed into individual chips, it is moved to the picking process, but there are some work in progress when moving to the picking process (n
nn). In the picking process, individual DS from wafer
Processed to P chip. It has a data object for each picking device and the chip itself.

In the mounting process, chips are mounted on the substrate. Here, there are data objects for each of the substrate, chip, and mount.

The semiconductor substrate on which the DSP chips have been mounted is moved to the next processing step, for example, a chip bonding step by wire bonding or reflow. There are some work in progress for this transition (nnn). In this processing step, there is a data object for each of the substrate on which the DSP chip is mounted and the processing completion.

Next, the substrate is moved to the CMOS chip mounting process, and there are some work in progress (nnn) when shifting to this mounting process.

On the other hand, in the CMOS chip manufacturing process, first, a wafer is loaded. Wafers have their own data objects. When the wafer is processed into individual chips, it is moved to the picking process, but there are some work in progress when moving to the picking process (nn
n). In the picking process, the wafer is processed into individual CMOS chips. It has data objects for the picking device and the CMOS chip itself.

In the CMOS chip mounting process, CM on the substrate
OS chip is installed. Here, there are data objects for the substrate on which the DSP chip is already mounted, the CMOS chip, and the mount, respectively.

The CMOS chip is mounted on the substrate, and the product is completed. In the picking process, if a defective product is generated in the DSP chip or the CMOS chip, it is treated as scrap. Again, there are several tricks, each with a data object.

FIG. 6 shows still another embodiment of the production control system according to the present invention. In this embodiment, it is assumed that the product is transported from the point A to the point B.
The upper part of FIG. 6 shows the flow of an actual object, and the lower part shows a virtual system on a computer.

At point A, the products are packed in boxes and loaded on a truck. The truck passes the designated road B
Reached the point and was unloaded from the truck at point B,
Unpacked.

In this series of transportation processes, a product database, a packaging database, and a truck database are used. That is, there is a database object for each item being shipped, a database object for each box in which multiple items are packaged, and a database object for each truck used for shipping.

FIG. 7 shows still another embodiment of the production management system according to the present invention, which is applied to rental of CDs (compact discs) and video tapes. The upper part of FIG. 7 shows an outline of the actual rental business, and the lower part shows a virtual system on a computer.

Member A returns the borrowed CD to the rental company and borrows a new CD. Meanwhile, member B
Returns the borrowed CD to the rental company and creates a new CD
At the same time as renting the CD, the borrowed video tape will be returned to the rental company and a new CD will be rented.

In such rental business, there are a database regarding members, a database regarding products such as CDs and video tapes, and a database regarding shelves for storing CDs and video tapes. Then, there are database objects for each member of the members A and B, individual database objects for rental products such as CDs and video tapes, and database objects for individual shelves storing the CDs and video tapes.

Although some of the embodiments of the present invention have been described above with reference to the accompanying drawings, the present invention is not limited to these embodiments, and various embodiments within the spirit or scope of the present invention. , Deformation, modification, etc. are possible.

[0044]

As described above, according to the present invention,
When a material or product is processed while flowing between devices, by making the material, product, or device an object, it is possible to speed up the processing and reduce the burden on the operator. became. Moreover, in the conventional production management system, the frequency of access to the database is reduced,
It speeds up the process and makes it easier to achieve consistency.

[Brief description of drawings]

FIG. 1 is a schematic diagram showing a conventional data processing method.

FIG. 2 is a flowchart showing a conventional production management method.

FIG. 3 is a schematic diagram showing a data processing method of the present invention.

FIG. 4 is a flowchart showing a production management method of the present invention.

FIG. 5 is a flowchart when the production control method of the present invention is applied to a step of mounting a chip on a substrate.

FIG. 6 is a flowchart when the production management method of the present invention is applied to a transportation operation.

FIG. 7 is a flowchart when the production management method of the present invention is applied to a rental business.

Claims (6)

[Claims] 1. A process for processing a material, comprising a database for recording data on each material and each processing, and for each processing when a data object is common for a predetermined material stored in the database. A production / processing step management system using a computer program, characterized in that the same data object is referenced over a plurality of processing steps without creating a data object. 2. The production / process management system according to claim 1, wherein the database for the material is created only when there is no data object for the predetermined material stored in the database. 3. A computer program comprising a database for recording data on individual materials and individual processing in a process of processing the materials, and managing a data object for each processing step for each material. A management system for the production and processing processes used. 4. Material acceptance inspection, multiple processing steps,
When processing each processing step of intermediate inspection, multiple processing steps, shipping inspection, and shipping in time series, it is equipped with a database that records data on individual materials and individual processing, and each processing step for each material A production / processing management system using a computer program, characterized in that a database is accessed for each time and the database is rewritten. 5. A product is packed in a box and loaded on a truck,
It has a database that records data on individual products, individual packing boxes, and individual transport trucks when they are unloaded and unpacked after being transported to a predetermined point. Loading, transporting,
Access the database for each process of unpacking,
A production / processing process management system using a computer program, characterized in that the database is rewritten. 6. A rental business for a member to rent a product, comprising a database for recording data about each member, each product, and an individual storage section for storing these products, and renting a certain product for each member. A production / processing management system using a computer program, characterized in that a database is accessed at each stage and a rewriting process is performed when a certain product is returned.