-
公开(公告)号:US09672244B2
公开(公告)日:2017-06-06
申请号:US12274741
申请日:2008-11-20
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.
-
公开(公告)号:US07792798B2
公开(公告)日:2010-09-07
申请号:US11849159
申请日:2007-08-31
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.
摘要翻译: 一种用于优化数据库中数据重新分配的方法和系统。 在一个实施例中,该方法包括在第一次扫描期间将输出记录从发送分区移动到一个或多个接收分区,其中由于离开发送分区的传出记录在发送分区中创建可用空间。 该方法还包括在第一次扫描期间填充一些可用空间,剩余的记录不会留下发送分区。
-
公开(公告)号:US20090063807A1
公开(公告)日:2009-03-05
申请号:US11847270
申请日:2007-08-29
IPC分类号: G06F12/02
CPC分类号: G06F16/2379 , G06F16/2282 , G06F16/27 , G06F16/278 , G06F2201/80
摘要: A system and method for data redistribution. In one embodiment, the method includes dividing data into batches at a sending partition; populating a first data structure with the first pages and the first control information in a first data structure; storing the first data structure in a cache at the sending partition; sending the changes over the network to the receiving partition; receiving a notification that the changes have been successfully stored in the second hard disk at the receiving partition; and storing, in response to the notification, the changes on the first hard disk at the sending partition.
摘要翻译: 一种用于数据重新分配的系统和方法。 在一个实施例中,该方法包括在发送分区处分批数据; 在第一数据结构中填充具有第一页面和第一控制信息的第一数据结构; 将所述第一数据结构存储在所述发送分区的高速缓存中; 通过网络将更改发送到接收分区; 接收在所述接收分区处已将所述更改成功存储在所述第二硬盘中的通知; 以及响应于所述通知存储所述发送分区上的所述第一硬盘上的改变。
-
公开(公告)号:US20090063526A1
公开(公告)日:2009-03-05
申请号:US11849159
申请日:2007-08-31
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.
摘要翻译: 一种用于优化数据库中数据重新分配的方法和系统。 在一个实施例中,该方法包括在第一次扫描期间将输出记录从发送分区移动到一个或多个接收分区,其中由于离开发送分区的传出记录在发送分区中创建可用空间。 该方法还包括在第一次扫描期间填充一些可用空间,剩余的记录不会留下发送分区。
-
公开(公告)号:US20100125555A1
公开(公告)日:2010-05-20
申请号:US12274741
申请日:2008-11-20
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.
摘要翻译: 一种便于撤销操作的方法和系统。 在一个实施例中,该方法包括生成多个控制文件,其中每个控制文件与在再分配过程期间从发送分区接收的一批数据相关联,并且其中每个控制文件包括页面列表和 已经附加到页面的数据行的相应范围。 该方法还包括将控制文件写入到每个控制文件的持久存储器中,其中相应一致性点的所有相关联的行已被附加到页面并写入持久存储器。 该方法还响应于重分发过程中的中断,在基于多个控制文件的撤销操作期间识别要删除的页面和行。
-
-
-
-