TW578077B - Apparatus wholesale list updating method and system - Google Patents

Abstract

An apparatus wholesale list updating method comprises: first, inspecting at least one lot of wholesale with a changed behavior in a source database based on the updated timestamp of the corresponding wholesale in the source database; next, deleting a record corresponding to the lot of wholesale in a target database; and finally updating the target database based on the changed behavior of the wholesale.

Description

578077

The present invention relates to a method and system for updating a batch list of equipment, and more particularly, to a method for quickly completing target data in a source database without comparing the source batch database with all equipment batch lists in the target database. Method and system for updating the equipment batch list of the updated library. A. For the method of copying data in a database to another database, there are already many methods, such as event triggering.

Trigger), store procedures, and database records (DataBase Log), etc., can achieve the purpose of data replication. For example

Let ’s say that when one database is updated, another database can be updated through event triggering. In addition, for some more complex or multiple database systems, if the data requires additional calculations or conversions (, Pre_Summary ,,), the system 'designs the corresponding data blocks that must be calculated or converted in advance. Templates, such as, Loader Program〃, can also make it possible to complete the purpose of database replication in complex systems. In ^ Loader Program 〃, first calculate the recently changed data in the source database; then, perform the data, Pre-Summary, and then update the changed data to the target database.

In a professional foundry, the control system for the batches (lots) performed on all equipment (Equipment) affects the overall production capacity. A database in the automated management system (MES) also records the batches and their status on each device and machine, and these data can be called the work in process (Wafer In Process) list or batch list. But after a given time, the database of the automated management system

0503-7799TWf; TSMC2001-1542; Yianhou.ptd page 4 578077 5. In the description of the invention (2), the target database and the database of the automated management system could not be consistent due to changes in the information. Therefore, an automated management system, such as IBM's Si View (Si 1 icon View), must copy the database data through a mechanism like Program ’to maintain the consistency of the target database data. Figure 1 shows the conventional method of updating and copying the batch list in the source database. First, as in step S10, the batch data and corresponding batch status on different equipment platforms are read from the target database. Then, according to step 311, the batch data and corresponding batch status on different equipment and machines are read from the source database.

state. Then, according to step S12, the batch list read from the target database and the source database is compared. When a record in the target database (a certain machine, batch, and corresponding status) exists in the source database (Yes in S13), the record is not processed. When a record in the target database is not stored in the source database (No in S13), it means that the record is not the latest data (outdated). Then, in step 814, delete this record from the target data. After that, & step S15, obtain the change from the source database: record, and, as in step S16, update the changed record to the target database. From the above, it is known that there is a record in the copy method because the target needs to be read , And all records contain a large amount of data, it will consume permitting resources. Update of the batch list in the source database · The comparison between the database and the source database, so when the database contains more time, it also wastes a lot of resources.

0503-7799W; TSMC2001-1542; Yianhou.ptd

578077

In view of this, all the methods and systems for updating the source database and list in the main database and the target database of the present invention can be quickly completed. The purpose is to provide a cleanup of equipment batches without the need to compare the list of equipment batches from the source and update the tender database. In order to achieve the above objective, the method and system for updating the equipment batch manifest provided by the present invention can be used. According to the method for updating the batch list of equipment according to the embodiment of the present invention, first, at least one batch of goods with a changed behavior in the source database is checked according to the update time of the corresponding batch in the source database. Then, delete the record corresponding to this batch in a target database. Finally, the target database is updated based on the change behavior of the shipment. The change behavior may include the removal of a batch of goods from a first device to a second device or a corresponding change of status of the batch of goods. 2. When the batch is moved from a first device to a second device, deleting the record corresponding to the batch in the target database is to delete the batch from the record of the corresponding first device in the target database. The update of the target database according to the change behavior of the batch is to add the batch to the corresponding second device record in the target database. When the corresponding status of the batch is changed, deleting the record of the corresponding batch in the target database is to delete the status of the corresponding batch of records in the target database. The update of the target database based on the change behavior of the batch is to update the status of the corresponding batch record in the target database. In addition, the equipment batch list updating system according to the embodiment of the present invention includes a source database, a target database, and a replication module. Source The equipment database contains at least one batch of goods in the database.

0503-7799HVf; TSMC200M542; Yianhou.ptd page 6 578077 V. Description of the invention (4) When there is a change in behavior ’m automatically records the batch t: Ji. The target database, '-at-time', has the same equipment lot list as it did. , Copy the module, at a second time, query the update timestamp in the source database through J to learn that the source database and; change the batch of =, the target database corresponding to this batch of records Delete and update the target database according to the change behavior of the batch. Similarly, the change behavior may include the removal of a batch of goods from a first device to a second device or a corresponding change in the status of the batch of goods. When the shipment is moved from a first device to a second device, the target

The deletion of the record corresponding to this batch in the material library is to delete the batch from the record of the corresponding first device in the target database. The update of the target database according to the change behavior of the batch is to add the batch to the corresponding second device record in the target database. … A. When the corresponding status of the batch is changed, deleting the record of the corresponding batch in the target database is to delete the status of the corresponding batch of records in the target database. The update of the target database according to the change behavior of the batch is to update the status in the target ^ database corresponding to the batch record. Examples

Fig. 2 is a flow chart showing a method for updating an equipment batch list according to an embodiment of the present invention. In the embodiment of the present invention, the source database stores the batches and their states on the corresponding different equipment machines. The target database can be updated regularly or irregularly through the batch list to make the data on the target database consistent with the data in the source database. First ’after a given time, such as step 82,

0503-7799W; TSMC2001-1542; Yianhou.ptd

578077 V. Description of the invention (5) The source database has a record of the record as the standby machine because the record is located at the place where the goods are received. The record will be taken to the first record of the equipment. When the status of the materials to be approved is updated, the status of the target asset library and the change log are updated, and when the goods are approved, a predetermined time can be used to delete the target data. The current records in the library will be deleted. Update timestamp of the consignment in the material library. Check the consignment for the consignment in the source database. Note that every time the source database is updated, the database system automatically records the time of the update. Among them, each record can include a certain setting and corresponding status. By retrieving whether the time stamp is updated within the database system, you can know which piece of data, that is, which batch has been changed. In step S21, the batch corresponding to the change is stored in the target database. Finally, according to step S22, the database is updated according to the change of the batch. The change behavior may include the removal of a batch of goods from a first device or the corresponding status change of the batch of goods. When the batch is from a first and second device, the target database corresponding to the batch in the target database will be updated from the target device to the target database based on the change behavior of the batch. This batch is added to the record of the corresponding second device. When the corresponding status of the batch is changed, the deletion of the target database is performed in the target database. The corresponding corresponding batch is recorded in the target database and the target database is updated based on the change of the batch. Update to change the latter example to explain. Figure 3a is a schematic diagram showing the initial situation of the source asset target database. As shown in the figure,

578077 V. Description of the invention (6) Both the material library and the target database have equipment equipment, equipment equipment A and equipment equipment B (represented by t〇〇-a and Tool_B respectively), and equipment equipment There are batches d in the waiting state on A, indicated by ,, Lot — D + WAIT 〃. • There are batches a, b, and c in the waiting state on equipment machine B.

Lot-A + WAIT〃,,, L〇t-B + WAIT〃,, Lot —C + WAIT〃 Representation 0 Figure 3b is a schematic diagram showing the situation of the source database after a period of time. After a period of time has passed, because batch D is moved from equipment machine A to equipment machine B, and batch b is removed from equipment machine b within this time. Therefore, the source database records the batches A, C, and D in the waiting state on the equipment machine B, respectively,,, Lot-A + WAIT 、,,, Lot-C + WAIT, and " Lot-D + WAIT " said. —, Next ’describes the process of updating the target database, as shown in Figure 3c. First of all, by searching the update timestamp of the source database, we can know that the batches that have changed behavior during this period are batch D and batch B. Therefore, the records of these changed batches in the target database 30 are deleted. As a result, as shown in the target database 31, there are no batches of the equipment machine a in the target database; while the equipment machine B is left The batches a and (:, Lot, A — WAIT, and “Lot — C + WAIT, respectively,” are waiting for the status. After that, the target database is updated according to the change behavior of the batch. Because these batches The change behavior of the goods is that the goods D are moved from the equipment machine A to the equipment machine and the goods B are removed from the equipment machine B. Therefore, the equipment machine B is added with the goods D. In addition, because the example does not indicate Batch B is moved from equipment machine B to which equipment machine, so batch B will disappear; and if batch B is transferred from equipment machine

578077

When station B is moved to an equipment station C, a new batch B will be added to the corresponding equipment station c. Λ In addition, the equipment batch list updating system according to the embodiment of the present invention includes a source database (as shown in FIG. 3a), a target database (as shown in FIG. 3a), and a replication module (Not shown). The stomach source database has a batch list of equipment that contains at least one batch of products (the batches and their status on different equipment machines). When the batch has a change in behavior, it will automatically record the update time of one of the batches. stamp. At the first time, the target database has the same equipment batch list as the source database.

At the first time, by querying the update timestamp in the source database, the replication module can know the batches with changed behavior in the source database. Change the behavior of the goods and update the target database.

Similarly, the change behavior may include the removal of a batch of goods from a first device to a second device or a corresponding change in the status of the batch of goods. When the batch is moved from a first device to a second device, deleting the record corresponding to the batch in the target database is to delete the batch from the record of the corresponding first device in the target database. And update the target database based on the change behavior of the batch of goods is to add this batch of goods to the record of the corresponding second device in the target asset = library ^ When the corresponding status of the batch of goods is changed, the corresponding batch of goods in the target database is changed The record deletion is to delete the corresponding status in the batch record in the target database. And updating the target database according to the change behavior of the batch is to update the status in the corresponding batch record in the target g database. Therefore, by using the method for updating the batch list of equipment provided by the present invention and

0503-779OTf; TSMC2001-1542; Yianhou.ptd page 10 578077 5. Description of the invention (8) The system can complete the source quickly without comparing the source database with the list of all equipment batches in the target database. Database and target database updates. At the same time, the present invention can also be applied to the Loader Program, which allows the copying of database data, thereby making the system more efficient and saving system resources. -Although the present invention has been disclosed as above with a preferred embodiment, it is not intended to be used as an invention of a soldier. Anyone who is familiar with this art can make some changes and retouches without departing from the scope of the present invention. Therefore, the scope of the present invention shall be determined by the scope of the appended patent claims. Friends of the Moon

578077

^ The above-mentioned objects, features, and advantages of the present invention can be made more obvious. The following specific embodiments are described in detail with the accompanying drawings as follows: Figure 1 shows a conventional method for updating and copying the batch list in the source database. . Fig. 2 is a flow chart showing a method for updating an equipment batch list according to an embodiment of the present invention. Figure 3a is a schematic diagram showing the initial situation of the source database and the target database. Figure 3b is a schematic diagram showing the source database over time. 'Figure 3c is a schematic diagram showing the update process of the eyepiece database. Explanation of symbols μ 'sl0, su ..... S16 ~ operation steps; S20, S21, S22 ~ operation steps; 3 0, 3 1, 3 2 ~ target database.

0503-7799TWf; TSMC2001-1542; Yianhou.ptd p. 12

Claims (1)

578077 VI. Application scope " '------ • A method for updating the batch list of equipment, including the following steps: According to the update timestamp of the corresponding batch in a source database, check that "the source database has A change of at least one batch of goods; deletion of the record of the corresponding batch of goods in the target database; and updating of the target database based on the change of the batch of goods. Basin 2 · As described in the first patent application The method for updating the batch list of equipment: The change behavior is the removal of the batch from a first device to a second device. • The method for updating the batch list of equipment as described in the first item of the patent application. The corresponding status of the batch is changed. 4. As described in the method for updating the equipment batch list as described in item 2 of the patent application, 删除 delete the record corresponding to the batch in the target database to the target database The batch is deleted from the record of the corresponding first device. 5. The method for updating the batch list of equipment as described in the second item of the patent application: 更新: The target database is updated based on the change of the batch. Add the batch to the record of the corresponding second equipment in the target database. 6. The method for updating the batch list of equipment as described in item 3 of the patent application, in the target database to the corresponding batch. The deletion of records is to delete the status of the corresponding batch of cargo records in the target tribune. 7. The method of updating the batch list of equipment as described in item 3 of the patent application, according to the change of the batch The behavior update of the target database is to update the status of the corresponding batch record in the catalogue database. 8 · The method for updating the equipment batch list as described in the first item of Shenyan Patent, where the update timestamp The time when the corresponding goods in the source database 578077 VI. New system for applying for patents, including: When one of the batches contains less than one batch of equipment, it is time to clear the batch, record the corresponding one of the batches for a better time, and have the source database and time with the source, by querying the source data The source database has the record of the corresponding batch of goods in the changed database deleted, and the target database is updated. In the equipment batch list update system described above, a first device is automatically noted when it is moved out to a second setting for updating. 9 · An equipment batch list is a source database with a single order, when the batch has a new timestamp of the changed line; a first target database, the same equipment batch list in the same; a copy module, In the second time stamp of the update, knowing that the shipment is for the batch, the target data and the change behavior I 0 according to the batch of goods · As in the application for item 9 of the application, the change behavior is the batch By the preparation. II. The equipment batch list update system as described in item 9 of the application patent, wherein the change behavior is a corresponding state change of the batch. 12. The equipment batch list update system according to item 10 of the application patent, wherein the copy module deletes the record of the corresponding batch in the target database from the target database and deletes the batch from the corresponding database. Deleted from the record of the first device. 〃 /, Λ3 .: Λ, please request the equipment batch list update system described in item 1G of the patent. The material base updates the target asset according to the change behavior of the batch. The target database adds the batch by 1 ^ · Page 14 0503-7799W; TSMC2001-1542; Yianhou.ptd 578077 VI. Application scope 14 · The equipment batch list update system as described in the 11th application for the patent 'where the replication module will be used to update the target database The deletion of the record of the batch of shipments is to delete the status of the corresponding batch of shipments in the target database. 15. The equipment batch system according to item U of the application patent, wherein the copy fork group updates the corresponding batch of items in the target database according to the modification database of the batch of items. Buy ,,,, and record status are more