Dynamic configuration and self-tuning on inter-nodal communication resources in a database management system
    1.
    发明授权
    Dynamic configuration and self-tuning on inter-nodal communication resources in a database management system 失效
    数据库管理系统中节点间通信资源的动态配置和自整定

    公开(公告)号:US07650400B2

    公开(公告)日:2010-01-19

    申请号:US12166316

    申请日:2008-07-01

    IPC分类号: G06F15/173

    CPC分类号: G06F9/5016

    摘要: A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

    摘要翻译: 一种数据库管理系统,其中多个节点形成数据库实例,每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块,而不需要循环实例。 通过将关联的通信资源元素放置在隔离中,直到与存储器块相关联的所有通信资源元素被隔离,才能异步地分配内存块。

    DYNAMIC CONFIGURATION AND SELF-TUNING OF INTER-NODAL COMMUNICATION RESOURCES IN A DATABASE MANAGEMENT SYSTEM
    2.
    发明申请
    DYNAMIC CONFIGURATION AND SELF-TUNING OF INTER-NODAL COMMUNICATION RESOURCES IN A DATABASE MANAGEMENT SYSTEM 有权
    数据库管理系统内部通信资源的动态配置与自我调整

    公开(公告)号:US20090024653A1

    公开(公告)日:2009-01-22

    申请号:US12243101

    申请日:2008-10-01

    IPC分类号: G06F7/00

    CPC分类号: G06F9/5016

    摘要: A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

    摘要翻译: 一种数据库管理系统,其中多个节点形成数据库实例,每个节点包括用于动态配置节点间通信资源的通信管理器。 通信管理器从客户端接收通信资源分配请求或自调整算法。 资源自整定机制实时分配或解除分配用于通信资源元素的存储块,而不需要循环实例。 通过将关联的通信资源元素放置在隔离中,直到与存储器块相关联的所有通信资源元素被隔离,才能异步地分配内存块。

    Reduced synchronization reservation system and method for a shared memory buffer
    3.
    发明授权
    Reduced synchronization reservation system and method for a shared memory buffer 失效
    减少同步预留系统和共享内存缓冲区的方法

    公开(公告)号:US07080228B2

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

    申请号:US10425755

    申请日:2003-04-29

    IPC分类号: G06F12/00

    摘要: A reservation system for making reservations in a shared memory buffer to store information from applications is logically partitioned in a number of fixed size indexed contiguous slots. The reservation system uses an atomic counter that is stored in the shared memory buffer. The value of the atomic counter can be associated with the index of a slot available for reservation. An application making a reservation increases the atomic counter value on a number of reserved slots to provide a value that is associated with the index of the next slot available for reservation. After the reservation is accomplished, the information is written into the reserved slots. The reservation system writes parsing information for further parsing to validate information in the shared memory buffer. The reservation system provides functionality for continuous and instantaneous dumping of the shared memory buffer into a file for cleaning and for wrapping the buffer.

    摘要翻译: 用于在共享存储器缓冲器中预留以存储来自应用程序的信息的预约系统在多个固定大小的索引连续槽中被逻辑地分区。 预留系统使用存储在共享内存缓冲区中的原子计数器。 原子计数器的值可以与可用于预留的时隙的索引相关联。 进行预约的应用增加了多个保留时隙上的原子计数器值,以提供与可用于预留的下一个时隙的索引相关联的值。 预约完成后,将信息写入保留的时隙。 预留系统写入解析信息以进一步解析以在共享存储器缓冲器中验证信息。 预留系统提供了将共享内存缓冲区连续和即时转储到文件中进行清理和包装缓冲区的功能。

    System and program for joining source table rows with target table rows
    4.
    发明授权
    System and program for joining source table rows with target table rows 有权
    将源表行与目标表行连接的系统和程序

    公开(公告)号:US08655877B2

    公开(公告)日:2014-02-18

    申请号:US12212100

    申请日:2008-09-17

    IPC分类号: G06F17/30

    摘要: Disclosed is a data processing system, and an article of manufacturing for use with the data processing system. The data processing system joins rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The data processing system further includes a generating module for generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, a filtering module for filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and a joining module for joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.

    摘要翻译: 公开了一种数据处理系统和与数据处理系统一起使用的制造物品。 数据处理系统将与源表的列相关联的行与与目标表的列相关联的行加入。 数据处理系统包括包含源表并包括目标表的目标节点的源节点。 数据处理系统还包括生成模块,用于生成与源表的列相关联的所选行的缩小表示,以及生成目标表的列的表示;过滤模块,用于过滤生成的所选行的缩小表示 通过生成的目标表的列的表示与源表的列相关联,所筛选的生成的缩减表示,标识不必与目标表连接的源表行的所选行,以及用于加入的加入模块 ,到与目标表的列相关联的行,与源表的列相关联的行减去经过滤的生成的所选行的缩小表示。

    SYSTEM AND PROGRAM FOR JOINING SOURCE TABLE ROWS WITH TARGET TABLE ROWS
    5.
    发明申请
    SYSTEM AND PROGRAM FOR JOINING SOURCE TABLE ROWS WITH TARGET TABLE ROWS 有权
    用目标表格方式加工源表的系统和程序

    公开(公告)号:US20090012990A1

    公开(公告)日:2009-01-08

    申请号:US12212100

    申请日:2008-09-17

    IPC分类号: G06F17/30

    摘要: Disclosed is a data processing system, and an article of manufacturing for use with the data processing system. The data processing system joins rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The data processing system further includes a generating module for generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, a filtering module for filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and a joining module for joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.

    摘要翻译: 公开了一种数据处理系统和与数据处理系统一起使用的制造物品。 数据处理系统将与源表的列相关联的行与与目标表的列相关联的行加入。 数据处理系统包括包含源表并包括目标表的目标节点的源节点。 数据处理系统还包括生成模块,用于生成与源表的列相关联的所选行的缩小表示,以及生成目标表的列的表示;过滤模块,用于过滤生成的所选行的缩小表示 通过生成的目标表的列的表示与源表的列相关联,所筛选的生成的缩减表示,标识不必与目标表连接的源表行的所选行的缩减表示,以及用于加入 ,到与目标表的列相关联的行,与源表的列相关联的行减去经过滤的生成的所选行的缩小表示。