公开(公告)号：US07792798B2

公开(公告)日：2010-09-07

申请号：US11849159

申请日：2007-08-31

申请人： David Tremaine ,  Leo T. M. Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox

发明人： David Tremaine ,  Leo T. M. Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30584 ,  Y10S707/964 ,  Y10S707/966

摘要： A method and system for optimizing data redistribution in a database. In one embodiment, the method includes moving, during a first scan, outgoing records from a sending partition to one or more receiving partitions, where free space is created in the sending partition due to the outgoing records leaving the sending partition. The method also includes filling, during the first scan, some of the free space with remaining records that do not leave the sending partition.

摘要翻译： 一种用于优化数据库中数据重新分配的方法和系统。 在一个实施例中，该方法包括在第一次扫描期间将输出记录从发送分区移动到一个或多个接收分区，其中由于离开发送分区的传出记录在发送分区中创建可用空间。 该方法还包括在第一次扫描期间填充一些可用空间，剩余的记录不会留下发送分区。

公开(公告)号：US20090063526A1

公开(公告)日：2009-03-05

申请号：US11849159

申请日：2007-08-31

申请人： David Tremaine ,  Leo T.M. Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox

发明人： David Tremaine ,  Leo T.M. Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox

IPC分类号： G06F17/30

CPC分类号： G06F17/30584 ,  Y10S707/964 ,  Y10S707/966

摘要： A method and system for optimizing data redistribution in a database. In one embodiment, the method includes moving, during a first scan, outgoing records from a sending partition to one or more receiving partitions, where free space is created in the sending partition due to the outgoing records leaving the sending partition. The method also includes filling, during the first scan, some of the free space with remaining records that do not leave the sending partition.

摘要翻译： 一种用于优化数据库中数据重新分配的方法和系统。 在一个实施例中，该方法包括在第一次扫描期间将输出记录从发送分区移动到一个或多个接收分区，其中由于离开发送分区的传出记录在发送分区中创建可用空间。 该方法还包括在第一次扫描期间填充一些可用空间，剩余的记录不会留下发送分区。

公开(公告)号：US09672244B2

公开(公告)日：2017-06-06

申请号：US12274741

申请日：2008-11-20

申请人： Leo Tat Man Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox ,  David Tremaine

发明人： Leo Tat Man Lau ,  Adil Mohammad Sardar ,  Philip Shawn Cox ,  David Tremaine

IPC分类号： G06F17/30

CPC分类号： G06F17/30377 ,  G06F17/30339 ,  G06F17/30575 ,  G06F17/30584 ,  G06F2201/80

摘要： A method and system for facilitating an undo operation. In one embodiment, the method includes generating a plurality of control files, where each of the control files is associated with a batch of data that is received from a sending partition during a redistribution process, and where each control file includes a list of pages and corresponding ranges of rows of data that have been appended to the pages. The method also includes writing the control files to a persistent memory for each control file where all of the associated rows of the respective consistency point have been appended to pages and written to a persistent memory. The method also includes, in response to an interruption in the redistribution process, identifying pages and rows to be deleted during an undo operation based on the plurality of control files.