Event locality using queue services
    1.
    发明申请
    Event locality using queue services 有权
    事件地点使用队列服务

    公开(公告)号:US20070101341A1

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

    申请号:US11246043

    申请日:2005-10-07

    IPC分类号: G06F9/46

    CPC分类号: G06F9/544 G06F9/542

    摘要: An approach for reducing transport of messages between nodes of a multi-node system is presented wherein a message queue is associated with a queue service, and based on which node the message queue resides, one of the nodes is registered as hosting the associated queue service. In response to a client attempting to connect and requesting a particular queue service, the client is caused to connect to the node on which the queue service resides.

    摘要翻译: 提出了一种用于减少多节点系统的节点之间的消息传输的方法,其中消息队列与队列服务相关联,并且基于消息队列所在的哪个节点,其中一个节点被注册为托管关联的队列服务 。 响应于客户端尝试连接并请求特定队列服务,导致客户端连接到队列服务所在的节点。

    High availability for distributed non-persistent event propagation
    2.
    发明申请
    High availability for distributed non-persistent event propagation 有权
    分布式非持久性事件传播的高可用性

    公开(公告)号:US20070061444A1

    公开(公告)日:2007-03-15

    申请号:US11224770

    申请日:2005-09-12

    IPC分类号: G06F15/173

    摘要: Techniques are provided for maintaining high propagation availability for non-persistent messages. Destination-to-instance mapping information is provided to a listener process for a cluster database. The destination-to-instance mapping indicates the current owner instance of each single-instance destination within the cluster database. To establish a connection to a single-instance destination, a sending process sends a connection request to the global listener. The connection request identifies the desired destination queue, but not the owner instance of the queue. The global listener for the cluster database uses the destination-to-instance mapping to determine which instance is the current owner of the specified queue, and establishes a connection between the sending process and the appropriate owner instance.

    摘要翻译: 提供了为非持久性消息保持高传播可用性的技术。 将目标到实例的映射信息提供给集群数据库的侦听器进程。 目标对实例映射指示集群数据库中每个单实例目标的当前所有者实例。 要建立与单实例目标的连接,发送进程会向全局侦听器发送连接请求。 连接请求标识所需的目标队列,但不标识队列的所有者实例。 集群数据库的全局侦听器使用目标到实例映射来确定哪个实例是指定队列的当前所有者,并在发送进程和适当的所有者实例之间建立连接。

    Event locality using queue services
    3.
    发明授权
    Event locality using queue services 有权
    事件地点使用队列服务

    公开(公告)号:US08196150B2

    公开(公告)日:2012-06-05

    申请号:US11246043

    申请日:2005-10-07

    IPC分类号: G06F3/00 G06F15/173

    CPC分类号: G06F9/544 G06F9/542

    摘要: An approach for reducing transport of messages between nodes of a multi-node system is presented wherein a message queue is associated with a queue service, and based on which node the message queue resides, one of the nodes is registered as hosting the associated queue service. In response to a client attempting to connect and requesting a particular queue service, the client is caused to connect to the node on which the queue service resides.

    摘要翻译: 提出了一种用于减少多节点系统的节点之间的消息传输的方法,其中消息队列与队列服务相关联,并且基于消息队列所在的哪个节点,其中一个节点被注册为托管关联的队列服务 。 响应于客户端尝试连接并请求特定队列服务,导致客户端连接到队列服务所在的节点。

    High availability for distributed non-persistent event propagation
    4.
    发明授权
    High availability for distributed non-persistent event propagation 有权
    分布式非持久性事件传播的高可用性

    公开(公告)号:US07856461B2

    公开(公告)日:2010-12-21

    申请号:US11224770

    申请日:2005-09-12

    IPC分类号: G06F17/00

    摘要: Techniques are provided for maintaining high propagation availability for non-persistent messages. Destination-to-instance mapping information is provided to a listener process for a cluster database. The destination-to-instance mapping indicates the current owner instance of each single-instance destination within the cluster database. To establish a connection to a single-instance destination, a sending process sends a connection request to the global listener. The connection request identifies the desired destination queue, but not the owner instance of the queue. The global listener for the cluster database uses the destination-to-instance mapping to determine which instance is the current owner of the specified queue, and establishes a connection between the sending process and the appropriate owner instance.

    摘要翻译: 提供了为非持久性消息保持高传播可用性的技术。 将目标到实例的映射信息提供给集群数据库的侦听器进程。 目标对实例映射指示集群数据库中每个单实例目标的当前所有者实例。 要建立与单实例目标的连接,发送进程会向全局侦听器发送连接请求。 连接请求标识所需的目标队列,但不标识队列的所有者实例。 集群数据库的全局侦听器使用目标到实例映射来确定哪个实例是指定队列的当前所有者,并在发送进程和适当的所有者实例之间建立连接。

    Finer grained point-to-point event propagation
    5.
    发明授权
    Finer grained point-to-point event propagation 有权
    更精细的点对点事件传播

    公开(公告)号:US07725902B2

    公开(公告)日:2010-05-25

    申请号:US11224918

    申请日:2005-09-12

    IPC分类号: G06F13/00

    摘要: A method and apparatus for propagating and managing data, transactions and events either within a database, or from one database to another is provided. In one embodiment, messages are propagated from a source to a first queue and a second queue with the queues associated with the same database. The connection from the source to each queue maintains its own propagation job. This method could also be employed with cluster databases.

    摘要翻译: 提供了一种用于在数据库内或从一个数据库到另一个数据库中传播和管理数据,事务和事件的方法和装置。 在一个实施例中,消息从源传播到第一队列,并且具有与同一数据库相关联的队列的第二队列。 从源到每个队列的连接保持自己的传播作业。 这种方法也可以用于集群数据库。

    Finer grained point-to-point event propagation
    6.
    发明申请
    Finer grained point-to-point event propagation 有权
    更精细的点对点事件传播

    公开(公告)号:US20070061380A1

    公开(公告)日:2007-03-15

    申请号:US11224918

    申请日:2005-09-12

    IPC分类号: G06F17/30

    摘要: A method and apparatus for propagating and managing data, transactions and events either within a database, or from one database to another is provided. In one embodiment, messages are propagated from a source to a first queue and a second queue with the queues associated with the same database. The connection from the source to each queue maintains its own propagation job. This method could also be employed with cluster databases.

    摘要翻译: 提供了一种用于在数据库内或从一个数据库到另一个数据库中传播和管理数据,事务和事件的方法和装置。 在一个实施例中,消息从源传播到第一队列,并且具有与同一数据库相关联的队列的第二队列。 从源到每个队列的连接保持自己的传播作业。 这种方法也可以用于集群数据库。

    ACCESSING DATA IN COLUMN STORE DATABASE BASED ON HARDWARE COMPATIBLE DATA STRUCTURES
    7.
    发明申请
    ACCESSING DATA IN COLUMN STORE DATABASE BASED ON HARDWARE COMPATIBLE DATA STRUCTURES 审中-公开
    基于硬件兼容数据结构的数据库存储数据库

    公开(公告)号:US20110246432A1

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

    申请号:US13107399

    申请日:2011-05-13

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30315

    摘要: Embodiments of the present invention provide one or more hardware-friendly data structures that enable efficient hardware acceleration of database operations. In particular, the present invention employs a column-store format for the database. In the database, column-groups are stored with implicit row ids (RIDs) and a RID-to-primary key column having both column-store and row-store benefits via column hopping and a heap structure for adding new data. Fixed-width column compression allow for easy hardware database processing directly on the compressed data. A global database virtual address space is utilized that allows for arithmetic derivation of any physical address of the data regardless of its location. A word compression dictionary with token compare and sort index is also provided to allow for efficient hardware-based searching of text. A tuple reconstruction process is provided as well that allows hardware to reconstruct a row by stitching together data from multiple column groups.

    摘要翻译: 本发明的实施例提供了一个或多个能够有效地加速数据库操作的硬件友好的数据结构。 特别地,本发明采用数据库的列存储格式。 在数据库中,列组通过列跳转和用于添加新数据的堆结构存储隐式行ids(RID)和具有列存储和行存储优势的RID至主键列。 固定宽度列压缩允许直接对压缩数据进行硬件数据库处理。 使用全局数据库虚拟地址空间,允许对数据的任何物理地址的算术推导,而不管其位置如何。 还提供了具有令牌比较和排序索引的单词压缩字典,以允许对文本进行高效的基于硬件的搜索。 还提供了一个元组重建过程,允许硬件通过将来自多个列组的数据进行拼接来重建行。

    ACCESSING DATA IN A COLUMN STORE DATABASE BASED ON HARDWARE COMPATIBLE DATA STRUCTURES
    8.
    发明申请
    ACCESSING DATA IN A COLUMN STORE DATABASE BASED ON HARDWARE COMPATIBLE DATA STRUCTURES 有权
    基于硬件兼容的数据结构访问存储库数据库中的数据

    公开(公告)号:US20090254532A1

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

    申请号:US12099131

    申请日:2008-04-07

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30315

    摘要: Embodiments of the present invention provide one or more hardware-friendly data structures that enable efficient hardware acceleration of database operations. In particular, the present invention employs a column-store format for the database. In the database, column-groups are stored with implicit row ids (RIDs) and a RID-to-primary key column having both column-store and row-store benefits via column hopping and a heap structure for adding new data. Fixed-width column compression allow for easy hardware database processing directly on the compressed data. A global database virtual address space is utilized that allows for arithmetic derivation of any physical address of the data regardless of its location. A word compression dictionary with token compare and sort index is also provided to allow for efficient hardware-based searching of text. A tuple reconstruction process is provided as well that allows hardware to reconstruct a row by stitching together data from multiple column groups.

    摘要翻译: 本发明的实施例提供了一个或多个能够有效地加速数据库操作的硬件友好的数据结构。 特别地,本发明采用数据库的列存储格式。 在数据库中,列组通过列跳转和用于添加新数据的堆结构存储隐式行ids(RID)和RID至主键列,具有列存储和行存储优势。 固定宽度列压缩允许直接对压缩数据进行硬件数据库处理。 使用全局数据库虚拟地址空间,允许对数据的任何物理地址的算术推导,而不管其位置如何。 还提供了具有令牌比较和排序索引的单词压缩字典,以允许对文本进行高效的基于硬件的搜索。 还提供了一个元组重建过程,允许硬件通过将来自多个列组的数据进行拼接来重建行。

    FAST BATCH LOADING AND INCREMENTAL LOADING OF DATA INTO A DATABASE
    10.
    发明申请
    FAST BATCH LOADING AND INCREMENTAL LOADING OF DATA INTO A DATABASE 有权
    快速批量加载和数据加载到数据库中

    公开(公告)号:US20110099155A1

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

    申请号:US12984284

    申请日:2011-01-04

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30595

    摘要: Embodiments of the present invention provide for batch and incremental loading of data into a database. In the present invention, the loader infrastructure utilizes machine code database instructions and hardware acceleration to parallelize the load operations with the I/O operations. A large, hardware accelerator memory is used as staging cache for the load process. The load process also comprises an index profiling phase that enables balanced partitioning of the created indexes to allow for pipelined load. The online incremental loading process may also be performed while serving queries.

    摘要翻译: 本发明的实施例提供数据批量和增量加载到数据库中。 在本发明中,装载机基础设施利用机器码数据库指令和硬件加速来将加载操作与I / O操作并行化。 大型的硬件加速器内存用作加载进程的分段缓存。 加载过程还包括一个索引分析阶段,可以对所创建的索引进行平衡分区,以允许流水线负载。 在提供查询时也可以执行在线增量加载过程。