Dynamic cluster database architecture
    3.
    发明授权
    Dynamic cluster database architecture 失效
    动态集群数据库架构

    公开(公告)号:US07937377B2

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

    申请号:US11780446

    申请日:2007-07-19

    IPC分类号: G06F7/00

    摘要: distributed database management system implemented on a cluster of computers. The cluster including disks organized as data nodes. The data nodes being locally connected to one or more computers in the cluster. The distributed database management system includes a distributed database manager layer having a lock manager, a resource manager, and an architecture manager. The lock manager serializes access to the data nodes in the cluster. The resource manager maintains a data representation of the resources of each computer in the cluster and makes the data available to other computers in the cluster to facilitate access to the resources by the other computers. The architecture manager defines logical ownership relationships between data nodes and computers in the cluster to permit the architecture of the database to be dynamically reconfigured to provide improved performance.

    摘要翻译: 分布式数据库管理系统在一组计算机上实现。 集群包括组织为数据节点的磁盘。 数据节点本地连接到集群中的一台或多台计算机。 分布式数据库管理系统包括具有锁管理器,资源管理器和架构管理器的分布式数据库管理器层。 锁定管理器将访问集群中的数据节点序列化。 资源管理器维护集群中每台计算机的资源的数据表示,并使数据可用于集群中的其他计算机,以便其他计算机访问资源。 架构管理员定义集群中数据节点和计算机之间的逻辑所有权关系,以允许动态重新配置数据库的体系结构以提供改进的性能。

    DYNAMIC CLUSTER DATABASE ARCHITECTURE
    4.
    发明申请
    DYNAMIC CLUSTER DATABASE ARCHITECTURE 有权
    动态群集数据库架构

    公开(公告)号:US20080288554A1

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

    申请号:US12184796

    申请日:2008-08-01

    IPC分类号: G06F17/30

    摘要: A method for implementing distributed database management system operations on a computer cluster. The method includes defining ownership relationships between a plurality of computers in the computer cluster and a plurality of data nodes in the computer cluster, wherein a distributed database management system operation can be directly carried out by a first computer only on those data nodes owned by the first computer. The method further includes monitoring database usage characteristics. The method further includes carrying out a re-architecture step in response to the database usage characteristics by redefining ownership relationships to improve the efficiency of the distributed database management system operations.

    摘要翻译: 一种在计算机集群上实现分布式数据库管理系统操作的方法。 该方法包括定义计算机集群中的多个计算机与计算机集群中的多个数据节点之间的所有权关系,其中分布式数据库管理系统操作可以由第一计算机直接执行,仅在由 第一台电脑 该方法还包括监视数据库使用特性。 该方法还包括通过重新定义所有权关系来实现响应于数据库使用特性的重新架构步骤,以提高分布式数据库管理系统操作的效率。

    Dynamic cluster database architecture
    5.
    发明授权
    Dynamic cluster database architecture 有权
    动态集群数据库架构

    公开(公告)号:US07447693B2

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

    申请号:US10390812

    申请日:2003-03-17

    IPC分类号: G06F7/00 G06F17/30

    摘要: A distributed database management system implemented on a cluster of computers. The cluster including disks organized as data nodes. The data nodes being locally connected to one or more computers in the cluster. The distributed database management system includes a distributed database manager layer having a lock manager, a resource manager, and an architecture manager. The lock manager serializes access to the data nodes in the cluster. The resource manager maintains a data representation of the resources of each computer in the cluster and makes the data available to other computers in the cluster to facilitate access to the resources by the other computers. The architecture manager defines logical ownership relationships between data nodes and computers in the cluster to permit the architecture of the database to be dynamically reconfigured to provide improved performance.

    摘要翻译: 在一组计算机上实现的分布式数据库管理系统。 集群包括组织为数据节点的磁盘。 数据节点本地连接到集群中的一台或多台计算机。 分布式数据库管理系统包括具有锁管理器,资源管理器和架构管理器的分布式数据库管理器层。 锁定管理器将访问集群中的数据节点序列化。 资源管理器维护集群中每台计算机的资源的数据表示,并使数据可用于集群中的其他计算机,以便其他计算机访问资源。 架构管理员定义集群中数据节点和计算机之间的逻辑所有权关系,以允许动态重新配置数据库的体系结构以提供改进的性能。

    Adaptive spin latches
    6.
    发明授权
    Adaptive spin latches 失效
    自适应旋转锁存器

    公开(公告)号:US06976107B2

    公开(公告)日:2005-12-13

    申请号:US10242524

    申请日:2002-09-12

    CPC分类号: G06F9/526

    摘要: An adaptive spin latch system is provided for use in a multiprocessor computer system. The spin latch system includes a run queue, a spin latch module and a wait queue. The run queue is adapted to store agent index data correlated to at least one agent in run mode. The spin latch module is adapted to put the at least one agent into sleep mode for a period of time correlated to a number of agents awaiting access to a resource. The wait queue is adapted to store agent index data correlated to the at least one agent in sleep mode. A method of regulating access by agents to a resource in a multiprocessor computing system is also provided.

    摘要翻译: 提供了一种在多处理器计算机系统中使用的自适应旋转锁存系统。 自旋锁存系统包括运行队列,自旋锁存模块和等待队列。 运行队列适于在运行模式下存储与至少一个代理相关的代理索引数据。 自旋锁存模块适于将至少一个代理进入休眠模式一段时间,其与等待访问资源的代理的数量相关。 等待队列适于在休眠模式下存储与至少一个代理相关的代理索引数据。 还提供了一种调节代理对多处理器计算系统中的资源的访问的方法。

    Dynamic cluster database architecture
    7.
    发明授权
    Dynamic cluster database architecture 有权
    动态集群数据库架构

    公开(公告)号:US07970797B2

    公开(公告)日:2011-06-28

    申请号:US12184796

    申请日:2008-08-01

    IPC分类号: G06F17/30

    摘要: A method for implementing distributed database management system operations on a computer cluster. The method includes defining ownership relationships between a plurality of computers in the computer cluster and a plurality of data nodes in the computer cluster, wherein a distributed database management system operation can be directly carried out by a first computer only on those data nodes owned by the first computer. The method further includes monitoring database usage characteristics. The method further includes carrying out a re-architecture step in response to the database usage characteristics by redefining ownership relationships to improve the efficiency of the distributed database management system operations.

    摘要翻译: 一种在计算机集群上实现分布式数据库管理系统操作的方法。 该方法包括定义计算机集群中的多个计算机与计算机集群中的多个数据节点之间的所有权关系,其中分布式数据库管理系统操作可由第一计算机直接执行,仅在由 第一台电脑 该方法还包括监视数据库使用特性。 该方法还包括通过重新定义所有权关系来实现响应于数据库使用特性的重新架构步骤,以提高分布式数据库管理系统操作的效率。

    Dynamic cluster database architecture
    8.
    发明授权
    Dynamic cluster database architecture 失效
    动态集群数据库架构

    公开(公告)号:US07933882B2

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

    申请号:US12259994

    申请日:2008-10-28

    IPC分类号: G06F7/00

    摘要: A method for implementing a set of database management components in a distributed database management system, the distributed database management system being implemented on a computer cluster. The method includes managing resources associated with an associated computer, the associated computer being one of a plurality of computers in the computer cluster. The method also includes managing locks on data stored on a plurality of associated data nodes coupled to the associated computer, wherein the associated data nodes are data nodes of a plurality of data nodes in the computer cluster. The method also includes specifying logical connections for the plurality of associated data nodes.

    摘要翻译: 一种在分布式数据库管理系统中实现一组数据库管理组件的方法,该分布式数据库管理系统正在计算机集群上实现。 该方法包括管理与相关联的计算机相关联的资源,相关联的计算机是计算机集群中的多个计算机之一。 该方法还包括对存储在耦合到相关联的计算机的多个相关联的数据节点上的数据进行管理锁定,其中相关联的数据节点是计算机集群中的多个数据节点的数据节点。 该方法还包括指定多个关联的数据节点的逻辑连接。

    Methods to Minimize Communication in a Cluster Database System
    9.
    发明申请
    Methods to Minimize Communication in a Cluster Database System 有权
    最小化群集数据库系统中的通信的方法

    公开(公告)号:US20110137874A1

    公开(公告)日:2011-06-09

    申请号:US12632750

    申请日:2009-12-07

    IPC分类号: G06F17/00

    摘要: An ordering of operations in log records includes: performing update operations on a shared database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.

    摘要翻译: 日志记录中的操作顺序包括:由节点对共享数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区,每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应,向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器,其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

    System and method for using a buffer to facilitate log catchup for online operations
    10.
    发明授权
    System and method for using a buffer to facilitate log catchup for online operations 失效
    使用缓冲区来促进在线操作的日志追踪的系统和方法

    公开(公告)号:US07203802B2

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

    申请号:US10425163

    申请日:2003-04-29

    IPC分类号: G06F12/00

    CPC分类号: G06F17/30368

    摘要: A memory buffer facilitates log catchup for online operations. Certain designated areas of memory are allocated for one or more buffers for use during online operations (e.g., reorganization, create index, etc.). Concurrent update activities to the target object write informational records into the one or more buffers. If the buffers become full, the informational records may be written to logs for persistent storage. After online operations finish building all or a suitable portion of the shadow object, log catchup is performed by first applying activities in the informational records from the buffer and thereafter applying activities from logs, if necessary. The invention helps solve the drawbacks of log catchup since the buffer contains only the information related to the target shadow object. Also it does not involve physical I/Os, as these records are all in memory.

    摘要翻译: 内存缓冲区有助于日志追踪在线操作。 某些指定的存储区域被分配用于在线操作期间使用的一个或多个缓冲器(例如,重组,创建索引等)。 目标对象的并发更新活动将信息记录写入一个或多个缓冲区。 如果缓冲区已满,则可将信息记录写入日志以进行持久存储。 在线操作完成构建阴影对象的所有或适当部分后,通过首先在缓冲区中的信息记录中应用活动,然后在必要时从日志应用活动来执行日志追踪。 本发明有助于解决日志追踪的缺点,因为缓冲器仅包含与目标影子对象相关的信息。 此外,它不涉及物理I / O,因为这些记录都在内存中。