| 摘要 |
A method transfers data to be archived from a runtime database into an archive database. A temporary database acts as a buffer database for a selected data record set for archiving. For each table of the runtime table subset, the selected record subset to be archived is copied into its corresponding table of the temporary table set. For each table of the temporary table set, the selected record subset to be archived is copied into its corresponding table of the archive table subset. For each table of the temporary table set, a temporary deletion table containing a set of primary keys of the records to be deleted from the runtime database is created. In the runtime database, for each runtime table having a corresponding temporary deletion table of the set of temporary deletion tables, deleting records having a primary key matching the primary key set of its corresponding temporary table. |
| 主权项 |
1. A method for transferring data to be archived from a runtime database into a long-term archive database in a manufacturing execution system (MES), which comprises the steps of:
a) providing the runtime database with a set of runtime tables, each of the runtime tables relating to a MES component and having a specific data structure; b) providing the long-term archive database with a set of long-term archive tables, the set of long-term archive tables mirroring the set of runtime tables, meaning that each long-term archive table has a same data structure of a corresponding runtime table; c) according to specific archiving criteria, selecting a set of data records to be archived in the runtime database, data archiving being performed by transferring a selected data record set from a subset of the runtime tables to a corresponding subset of the long-term archive tables; d) providing an additional database being a temporary database acting as a buffer database for the selected data record set to be archived; e) creating, for each table of a runtime table subset, a corresponding matching table in the temporary database so as to generate a set of temporary tables; f) copying, for each table of the runtime table subset, the selected record subset to be archived into a corresponding table of the temporary table set in the temporary database; g) copying, for each table of the temporary table set, the selected record subset to be archived into a corresponding table of the long-term archive table subset in the long-term archive database; h) if the copying of the step g) is successful, creating, for each table of the temporary table set, a temporary deletion table containing a set of primary keys of records to be deleted from the runtime database, the set of primary keys being extracted from the temporary table so as to generate a set of temporary deletion tables within the temporary database; i) in the runtime database, for each runtime table having a corresponding temporary deletion table of the set of temporary deletion tables, deleting each record having primary key matching the primary key of the primary key set of its corresponding temporary table; and j) executing the steps f), g) and step h) under a same transaction and wherein step i) is executed under another transaction. |
