DYNAMIC DATA COMPACTION FOR DATA REDISTRIBUTION
    1.
    发明申请
    DYNAMIC DATA COMPACTION FOR DATA REDISTRIBUTION 有权
    用于数据重新分配的动态数据压缩

    公开(公告)号:US20090063526A1

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

    申请号:US11849159

    申请日:2007-08-31

    IPC分类号: G06F17/30

    摘要: 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.

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

    DATA REDISTRIBUTION IN SHARED NOTHING ARCHITECTURE
    2.
    发明申请
    DATA REDISTRIBUTION IN SHARED NOTHING ARCHITECTURE 审中-公开
    共享架构中的数据重新分配

    公开(公告)号:US20090063807A1

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

    申请号:US11847270

    申请日:2007-08-29

    IPC分类号: G06F12/02

    摘要: 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.

    摘要翻译: 一种用于数据重新分配的系统和方法。 在一个实施例中,该方法包括在发送分区处分批数据; 在第一数据结构中填充具有第一页面和第一控制信息的第一数据结构; 将所述第一数据结构存储在所述发送分区的高速缓存中; 通过网络将更改发送到接收分区; 接收在所述接收分区处已将所述更改成功存储在所述第二硬盘中的通知; 以及响应于所述通知存储所述发送分区上的所述第一硬盘上的改变。