Method using virtual replicated tables in a cluster database management system
    2.
    发明授权
    Method using virtual replicated tables in a cluster database management system 失效
    在群集数据库管理系统中使用虚拟复制表的方法

    公开(公告)号:US07457796B2

    公开(公告)日:2008-11-25

    申请号:US10886997

    申请日:2004-07-08

    IPC分类号: G06F17/30 G06F7/00

    摘要: A method for improved data sharing within a cluster of nodes having a database management system. The method defines a virtual replicated table as being useable in a hybrid of a shared-cache and shared-nothing architecture. The virtual replicated table is a physically single table sharable among a plurality of cluster nodes for data read operations and not sharable with other cluster nodes for data modification operations. Default owner node is assigned for each virtual replicated table to ensure the page validity and provide requested pages to the requesting node.

    摘要翻译: 一种用于改进具有数据库管理系统的节点簇内的数据共享的方法。 该方法将虚拟复制表定义为在共享高速缓存和无共享架构的混合中可用。 虚拟复制表是在用于数据读取操作的多个集群节点之间可共享的物理单个表,并且与用于数据修改操作的其他集群节点不可共享。 为每个虚拟复制表分配默认所有者节点,以确保页面有效性,并将请求的页面提供给请求节点。

    SYSTEM USING VIRTUAL REPLICATED TABLES IN A CLUSTER DATABASE MANAGEMENT SYSTEM
    3.
    发明申请
    SYSTEM USING VIRTUAL REPLICATED TABLES IN A CLUSTER DATABASE MANAGEMENT SYSTEM 有权
    在集群数据库管理系统中使用虚拟替代表的系统

    公开(公告)号:US20090043863A1

    公开(公告)日:2009-02-12

    申请号:US12253812

    申请日:2008-10-17

    IPC分类号: G06F15/167

    摘要: A system for improved data sharing within a cluster of nodes having a database management system. The system defines a virtual replicated table as being useable in a hybrid of a shared-cache and shared-nothing architecture. The virtual replicated table is a physically single table sharable among a plurality of cluster nodes for data read operations and not sharable with other cluster nodes for data modification operations. Default owner node is assigned for each virtual replicated table to ensure the page validity and provide requested pages to the requesting node.

    摘要翻译: 用于改进具有数据库管理系统的节点簇内的数据共享的系统。 系统将虚拟复制表定义为在共享缓存和无共享架构的混合中可用。 虚拟复制表是在用于数据读取操作的多个集群节点之间可共享的物理单个表,并且与用于数据修改操作的其他集群节点不可共享。 为每个虚拟复制表分配默认所有者节点,以确保页面有效性,并将请求的页面提供给请求节点。

    System using virtual replicated tables in a cluster database management system
    4.
    发明授权
    System using virtual replicated tables in a cluster database management system 有权
    在群集数据库管理系统中使用虚拟复制表的系统

    公开(公告)号:US08032488B2

    公开(公告)日:2011-10-04

    申请号:US12253812

    申请日:2008-10-17

    IPC分类号: G06F17/30 G06F7/00

    摘要: A system for improved data sharing within a cluster of nodes having a database management system. The system defines a virtual replicated table as being useable in a hybrid of a shared-cache and shared-nothing architecture. The virtual replicated table is a physically single table sharable among a plurality of cluster nodes for data read operations and not sharable with other cluster nodes for data modification operations. Default owner node is assigned for each virtual replicated table to ensure the page validity and provide requested pages to the requesting node.

    摘要翻译: 用于改进具有数据库管理系统的节点簇内的数据共享的系统。 系统将虚拟复制表定义为在共享缓存和无共享架构的混合中可用。 虚拟复制表是在用于数据读取操作的多个集群节点之间可共享的物理单个表,并且与用于数据修改操作的其他集群节点不可共享。 为每个虚拟复制表分配默认所有者节点,以确保页面有效性,并将请求的页面提供给请求节点。

    METHOD AND SYSTEM FOR DISTRIBUTED TASK DISPATCH IN A MULTI-APPLICATION ENVIRONMENT BASED ON CONSENSUS
    5.
    发明申请
    METHOD AND SYSTEM FOR DISTRIBUTED TASK DISPATCH IN A MULTI-APPLICATION ENVIRONMENT BASED ON CONSENSUS 有权
    基于共识的多应用环境中分布式任务分发方法与系统

    公开(公告)号:US20110179105A1

    公开(公告)日:2011-07-21

    申请号:US12688337

    申请日:2010-01-15

    IPC分类号: G06F15/16 G06F17/30

    摘要: A method and system for distributing tasks from an external application among concurrent database application server instances in a database system for optimum load balancing, based on consensus among the instances. Each application instance identifies a task partition ownership by those in a membership group based on a time window and generates a new membership group and partition ownership based on the current partition ownership. The instance makes the new membership group and partition ownership known to other members by recoding them in the membership table and partition map. Each participation by an instance in the membership group is identified by a random number. The new membership group and partition ownership are generated and adjusted based on an average partition allocation to achieve consensus among the instances.

    摘要翻译: 基于实例之间的一致性,用于在数据库系统中的并发数据库应用服务器实例之间从外部应用程序分发任务以实现最佳负载平衡的方法和系统。 每个应用程序实例基于时间窗口标识成员组中的任务分区所有权,并根据当前分区所有权生成新的成员组和分区所有权。 该实例通过在成员资格表和分区映射中对它们进行重新编码,使其他成员获得了新的成员组和分区所有权。 会员组中的实例的每个参与由随机数来标识。 根据平均分区分配生成和调整新成员组和分区所有权,以实现实例之间的一致。

    System for distributed task dispatch in multi-application environment based on consensus for load balancing using task partitioning and dynamic grouping of server instance
    6.
    发明授权
    System for distributed task dispatch in multi-application environment based on consensus for load balancing using task partitioning and dynamic grouping of server instance 有权
    基于使用任务分区和服务器实例的动态分组的负载平衡一致的多应用环境中的分布式任务分派系统

    公开(公告)号:US08910176B2

    公开(公告)日:2014-12-09

    申请号:US12688337

    申请日:2010-01-15

    IPC分类号: G06F15/16 G06F17/30 G06F9/50

    摘要: A method and system for distributing tasks from an external application among concurrent database application server instances in a database system for optimum load balancing, based on consensus among the instances. Each application instance identifies a task partition ownership by those in a membership group based on a time window and generates a new membership group and partition ownership based on the current partition ownership. The instance makes the new membership group and partition ownership known to other members by recoding them in the membership table and partition map. Each participation by an instance in the membership group is identified by a random number. The new membership group and partition ownership are generated and adjusted based on an average partition allocation to achieve consensus among the instances.

    摘要翻译: 基于实例之间的一致性,用于在数据库系统中的并发数据库应用服务器实例之间从外部应用程序分发任务以实现最佳负载平衡的方法和系统。 每个应用程序实例基于时间窗口标识成员组中的任务分区所有权,并根据当前分区所有权生成新的成员组和分区所有权。 该实例通过在成员资格表和分区映射中对它们进行重新编码,使其他成员获得了新的成员组和分区所有权。 会员组中的实例的每个参与由随机数来标识。 根据平均分区分配生成和调整新成员组和分区所有权,以实现实例之间的一致。

    Index partition maintenance over monotonically addressed document sequences
    7.
    发明授权
    Index partition maintenance over monotonically addressed document sequences 有权
    索引分区维护通过单调寻址的文档序列

    公开(公告)号:US08738673B2

    公开(公告)日:2014-05-27

    申请号:US12875615

    申请日:2010-09-03

    IPC分类号: G06F17/30

    摘要: Provided are techniques for partitioning a physical index into one or more physical partitions; assigning each of the one or more physical partitions to a node in a cluster of nodes; for each received document, assigning an assigned-doc-ID comprising an integer document identifier; and, in response to assigning the assigned-doc-ID to a document, determining a cut-off of assignment of new documents to a current virtual-index-epoch comprising a first set of physical partitions and placing the new documents into a new virtual-index-epoch comprising a second set of physical partitions by inserting each new document to a specific one of the physical partitions in the second set using one or more functions that direct the placement based on one of the assigned-doc-id, a field value derived from a set of fields obtained from the document, and a combination of the assigned-doc-id and the field value.

    摘要翻译: 提供了用于将物理索引分割成一个或多个物理分区的技术; 将一个或多个物理分区中的每一个分配给节点簇中的节点; 对于每个接收到的文档,分配包括整数文档标识符的分配文档ID; 并且响应于将分配的文档ID分配给文档,确定新文档的分配到当前虚拟索引时期的截断,该当前虚拟索引时期包括第一组物理分区,并将新文档放入新的虚拟 - 指数 - 历元包括第二组物理分区,通过使用一个或多个基于所分配的文档ID中的一个来指导所述布局的功能,将每个新文档插入第二组中的特定一个物理分区 从文档获得的一组字段中导出的值以及分配的doc-id和字段值的组合。