专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US09348882B2 Method, system, and computer readable medium for long term archiving of data in a MES system 有权
标题翻译：用于在MES系统中长期归档数据的方法，系统和计算机可读介质
公开(公告)号：US09348882B2
公开(公告)日：2016-05-24
申请号：US14057176
申请日：2013-10-18
申请人： SIEMENS AKTIENGESELLSCHAFT
发明人： Federico Risso , Marco Mazzarone
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F17/30067 , G06F17/30233 , G06F17/303
摘要： 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.
摘要翻译：一种方法将要归档的数据从运行时数据库传输到归档数据库。临时数据库充当用于归档的所选数据记录集的缓冲数据库。对于运行时表子集的每个表，要归档的所选记录子集被复制到临时表集合的相应表中。对于临时表集合的每个表，要归档的所选记录子集被复制到归档表子集的相应表中。对于临时表集合的每个表，创建一个临时删除表，其中包含要从运行时数据库中删除的记录的主键集合。在运行时数据库中，对于具有一组临时删除表的对应的临时删除表的每个运行时间表，删除具有与其对应的临时表的主键集合相匹配的主键的记录。

IPRDB

热门服务

关于我们

友情链接

联系方式