Method and system for performing a redistribute transparently in a multi-node system
    1.
    发明申请
    Method and system for performing a redistribute transparently in a multi-node system 审中-公开
    在多节点系统中透明地执行再分发的方法和系统

    公开(公告)号:US20070162506A1

    公开(公告)日:2007-07-12

    申请号:US11330554

    申请日:2006-01-12

    IPC分类号: G06F17/00

    CPC分类号: G06F16/278

    摘要: A method for performing a redistribute of data in a database system including a plurality of nodes is disclosed. The data includes a plurality of partitions distributed between the plurality of nodes. At least one new node is being added. The method and system include selecting at least one partition of the plurality of partitions to be moved from the plurality of nodes only to the at least one new node. The method and system also include moving the at least one partition only to the at least one new node. The method and system further include removing the at least one partition from the plurality of nodes.

    摘要翻译: 公开了一种用于在包括多个节点的数据库系统中执行数据重新分配的方法。 数据包括分布在多个节点之间的多个分区。 正在添加至少一个新节点。 该方法和系统包括选择要从多个节点移动到至少一个新节点的多个分区的至少一个分区。 该方法和系统还包括将至少一个分区移动到至少一个新节点。 所述方法和系统还包括从所述多个节点移除所述至少一个分区。

    System and method for starting a buffer pool
    2.
    发明申请
    System and method for starting a buffer pool 失效
    启动缓冲池的系统和方法

    公开(公告)号:US20050050443A1

    公开(公告)日:2005-03-03

    申请号:US10921469

    申请日:2004-08-19

    IPC分类号: G06F17/00 G06F17/30 H04L12/16

    CPC分类号: G06F17/30312

    摘要: For an information retrieval system coupled to a buffer pool maintaining a plurality of pages of recently accessed information for subsequent re-access, a technique for starting the buffer pool is provided. The technique facilitates a quicker start to the buffer pool by deferring allocation of page storing portions, for example, until they are needed. The technique makes the buffer pool available for storing pages while deferring allocation of a page storing portion of the buffer pool and allocates the page storing portion of the buffer pool in response to a demand to store pages to the buffer pool. The technique may be used to re-start a buffer pool with pages stored to a memory coupled to the information retrieval system where the pages where stored upon a buffer pool shutdown. Further, buffer pool readers or prefetchers may be configured to read pages for storing to the buffer pool and allocate the page storing portions of the buffer pool in response to instructions to read particular pages.

    摘要翻译: 对于一个信息检索系统,耦合到缓冲池,保持多页最近访问的信息用于随后的重新访问,提供了启动缓冲池的技术。 该技术通过延迟页面存储部分的分配来促进对缓冲池的更快启动,例如直到需要它们。 该技术使得缓冲池可用于存储页面,同时延迟缓冲池的页面存储部分的分配,并且响应于将页面存储到缓冲池的需求而分配缓冲池的页面存储部分。 该技术可用于重新启动缓冲池,其中页面存储到耦合到信息检索系统的存储器,其中存储在缓冲池关闭时的页面。 此外,缓冲池读取器或预取器可以被配置为读取用于存储到缓冲池的页面,并响应于读取特定页面的指令来分配存储缓冲器池的部分的页面。

    DYNAMIC SCALING BACK OF LATCH REQUESTS FOR COMPUTER SYSTEM RESOURCES
    3.
    发明申请
    DYNAMIC SCALING BACK OF LATCH REQUESTS FOR COMPUTER SYSTEM RESOURCES 失效
    计算机系统资源的拉动要求的动态缩放

    公开(公告)号:US20060248532A1

    公开(公告)日:2006-11-02

    申请号:US11457572

    申请日:2006-07-14

    IPC分类号: G06F9/46

    CPC分类号: G06F9/52

    摘要: A computer system dynamically scales back latch requests for system resources. Tasks seeking access to system resources each dynamically determine the probability that the task will gain access to the latch relating to a given system resource. Where the task estimates that its probability is below a defined threshold, the task will suspend itself for a defined sleep time. The task dynamically adjusts the length of the sleep time based on the number of times the task enters the suspended state and on the relative changes in the estimated probability that the task will gain access to the resource.

    摘要翻译: 计算机系统动态地缩小系统资源的锁存请求。 寻求访问系统资源的任务每个动态地确定任务将获得对与给定系统资源相关联的锁存器的访问的概率。 在任务估计其概率低于定义的阈值的情况下,任务将暂停自己定义的休眠时间。 任务根据任务进入暂停状态的次数以及任务将获得资源访问的概率的相对变化动态调整睡眠时间长度。

    Handling access requests to a page while copying an updated page of data to storage
    4.
    发明申请
    Handling access requests to a page while copying an updated page of data to storage 有权
    在将更新的数据页复制到存储时,处理对页面的访问请求

    公开(公告)号:US20060155774A1

    公开(公告)日:2006-07-13

    申请号:US11034518

    申请日:2005-01-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30362

    摘要: Provided are a method, system, and program for handling access requests to a page while copying an updated page of data to storage. An update to a page in a memory is received and indication is made that the page has an exclusive lock. The update is applied to the page and an operation is initiated to copy the updated page to a physical log in a storage in response to applying the update to the page. Reads and writes are allowed to proceed against the page while the operation to copy the updated page to the physical log in the storage is occurring.

    摘要翻译: 提供了一种用于在将更新的数据页复制到存储时处理对页面的访问请求的方法,系统和程序。 接收对存储器中的页面的更新,并且指示该页面具有排他锁。 更新应用于页面,并且响应于将更新应用于页面,启动操作以将更新的页面复制到存储器中的物理日志。 允许读取和写入对页面进行操作,而将更新页面复制到存储器中的物理日志的操作正在发生。