公开(公告)号：US20090157775A1

公开(公告)日：2009-06-18

申请号：US12329681

申请日：2008-12-08

Applicant: May Pederson ,  James Chapman ,  Cuong Nhan ,  Jeremy Davis ,  Donald Pederson ,  James Pierce ,  Sunanda Reddy ,  Stephen Sheldon

Inventor： May Pederson ,  James Chapman ,  Cuong Nhan ,  Jeremy Davis ,  Donald Pederson ,  James Pierce ,  Sunanda Reddy ,  Stephen Sheldon

IPC: G06F12/16

CPC classification number: G06F17/30309 ,  G06F11/1471

Abstract: A method of archiving a set of source tables in a database system. Each source table has a plurality of rows. Initially, a consistency point for the set of source tables is established. The database system creates a log record for each change (insert, modify, or delete) effected to a row of the source tables subsequent to the consistency point. Substantially all source table rows are copied to an archive (a data storage object that is external to the database system). Then the accumulated log records for the affected source tables are distilled and appended to the archive.

Abstract translation: 归档数据库系统中的一组源表的方法。 每个源表具有多个行。 最初，建立了一组源表的一致性点。 数据库系统为每个更改（插入，修改或删除）创建一个日志记录，对一致性点后面的源表执行。 基本上所有源表行都将复制到存档（数据库系统外部的数据存储对象）。 然后将受影响的源表的累积日志记录进行蒸馏并附加到存档。

公开(公告)号：US08452730B2

公开(公告)日：2013-05-28

申请号：US12329681

申请日：2008-12-08

Applicant: May Pederson ,  James Chapman ,  Cuong Nhan ,  Jeremy Davis ,  Donald Pederson ,  James Pierce ,  Sunanda Reddy ,  Stephen Sheldon

Inventor： May Pederson ,  James Chapman ,  Cuong Nhan ,  Jeremy Davis ,  Donald Pederson ,  James Pierce ,  Sunanda Reddy ,  Stephen Sheldon

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30309 ,  G06F11/1471

Abstract: A method of archiving a set of source tables in a database system. Each source table has a plurality of rows. Initially, a consistency point for the set of source tables is established. The database system creates a log record for each change (insert, modify, or delete) effected to a row of the source tables subsequent to the consistency point. Substantially all source table rows are copied to an archive (a data storage object that is external to the database system). Then the accumulated log records for the affected source tables are distilled and appended to the archive.

Abstract translation: 归档数据库系统中的一组源表的方法。 每个源表具有多个行。 最初，建立了一组源表的一致性点。 数据库系统为每个更改（插入，修改或删除）创建一个日志记录，对一致性点后面的源表执行。 基本上所有源表行都将复制到存档（数据库系统外部的数据存储对象）。 然后将受影响的源表的累积日志记录进行蒸馏并附加到存档。