公开(公告)号：US11669518B1

公开(公告)日：2023-06-06

申请号：US17550547

申请日：2021-12-14

申请人： Yuk Kuen Chan ,  Ronen Grosman ,  Seyyed Mohammad Hadi Sajjadpour ,  Hoi leng Lao ,  Wen Hao Zhang ,  Chung Yin Alan Wong

发明人： Yuk Kuen Chan ,  Ronen Grosman ,  Seyyed Mohammad Hadi Sajjadpour ,  Hoi leng Lao ,  Wen Hao Zhang ,  Chung Yin Alan Wong

IPC分类号： G06F16/23 ,  G06F16/245

CPC分类号： G06F16/2379 ,  G06F16/245

摘要： A method and system of processing database transactions in a distributed online transaction processing (OLTP) database is provided. Overhead and network bandwidth associated with a global transaction manager are reduced and scalability improved by determining whether incoming statements are single-shard or multi-shard. For single-shard statements, a local transaction identifier (TXID) stored and associated with a data record reference by the statement is retrieved. The retrieved TXID is compared against a copy of a list of prepared transactions that are pending in a respective data node. If the TXID is in the copy of the prepared list, the statement is caused to await until the previous transaction has been committed or aborted. The visibility of a change committed by the previous is then determined, and the statement is processed.

公开(公告)号：US20060224600A1

公开(公告)日：2006-10-05

申请号：US11096900

申请日：2005-04-01

申请人： Ronen Grosman ,  Gary Valentin

发明人： Ronen Grosman ,  Gary Valentin

IPC分类号： G06F7/00

CPC分类号： G06F17/30321 ,  G06F17/30312 ,  Y10S707/99938 ,  Y10S707/99944

摘要： Provided are a method, system, and article of manufacture for the traversal of empty regions in a searchable data structure such as a table. A plurality of elements are allocated in logical storage, wherein the plurality of elements correspond to entries of the searchable data structure. An indicator is maintained corresponding to contiguously allocated empty elements in the plurality of elements. An operation is performed on the searchable data structure by avoiding the contiguously allocated empty elements.

公开(公告)号：US08285755B2

公开(公告)日：2012-10-09

申请号：US11249217

申请日：2005-10-13

申请人： Adrian Chan ,  Ronen Grosman ,  Teresa C. Kan ,  Yang Lei

发明人： Adrian Chan ,  Ronen Grosman ,  Teresa C. Kan ,  Yang Lei

IPC分类号： G06F17/30

CPC分类号： G06F17/30584

摘要： Embodiments of the present invention address deficiencies of the art in respect to programmatic database access and provide a method, system and computer program product for programmatic partial updating of a row. In one embodiment, a data processing system for programmatic partial updating of a row in a database can include a database proxy driver configured to expose an interface for interacting with the database and to accept an execution of a prepared statement without requiring set values for all fields bound by the prepared statement. The interface can include, for example, a Java Database Connectivity (JDBC) compliant interface. The prepared statement can include a binding to multiple fields in a designated row and a set of setter methods defined for a subset of the multiple fields.

摘要翻译： 本发明的实施例解决了有关编程数据库访问的本领域的缺点，并且提供了用于一行的程序化部分更新的方法，系统和计算机程序产品。 在一个实施例中，用于数据库中的行的程序化部分更新的数据处理系统可以包括数据库代理驱动器，其被配置为暴露用于与数据库交互的接口并且接受准备语句的执行而不需要所有字段的设置值 受准备声明约束。 接口可以包括例如符合Java数据库连接（JDBC）的接口。 准备好的语句可以包括绑定到指定行中的多个字段以及为多个字段的子集定义的一组setter方法。

公开(公告)号：US08122167B1

公开(公告)日：2012-02-21

申请号：US12851634

申请日：2010-08-06

申请人： Vaijayanthimala K. Anand ,  Ronen Grosman ,  Michael E. Lyons ,  Bret R. Olszewski

发明人： Vaijayanthimala K. Anand ,  Ronen Grosman ,  Michael E. Lyons ,  Bret R. Olszewski

IPC分类号： G06F13/24 ,  G06F3/00

CPC分类号： G06F13/22 ,  G06F13/24

摘要： A software thread is dispatched for causing the system to poll a device for determining whether a condition has occurred. Subsequently, the software thread is undispatched and, in response thereto, an interrupt is enabled on the device, so that the device is enabled to generate the interrupt in response to an occurrence of the condition, and so that the system ceases polling the device for determining whether the condition has occurred. Eventually, the software thread is redispatched and, in response thereto, the interrupt is disabled on the device, so that the system resumes polling the device for determining whether the condition has occurred.

摘要翻译： 调度软件线程使系统轮询设备以确定是否已经发生条件。 随后，软件线程未分配，并且响应于此，在设备上启用中断，使得设备能够响应于条件的发生而产生中断，并且使得系统停止轮询设备 确定病情是否发生。 最终，软件线程被重新分配，并且响应于此，设备上的中断被禁用，使得系统恢复轮询该设备以确定该条件是否已经发生。

公开(公告)号：US20110137874A1

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

申请号：US12632750

申请日：2009-12-07

申请人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

发明人： Ronen Grosman ,  Matthew A. Huras ,  Timothy R. Malkemus ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Kelly W. Schlamb ,  Nickolay V. Tchervenski ,  Xun Xue

IPC分类号： G06F17/00

CPC分类号： G06F17/30368 ,  G06F11/1471 ,  G06F17/30353 ,  G06F17/30377

摘要： 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.

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

公开(公告)号：US20080306990A1

公开(公告)日：2008-12-11

申请号：US12194464

申请日：2008-08-19

申请人： Ronen Grosman ,  Keriley Kay Romanufa ,  Robin D. Van Boeschoten

发明人： Ronen Grosman ,  Keriley Kay Romanufa ,  Robin D. Van Boeschoten

IPC分类号： G06F17/30

CPC分类号： G06F16/278

摘要： 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. At least one partition of the plurality of partitions is selected to be moved from the plurality of nodes only to the at least one new node. The at least one partition is moved only to the at least one new node. At least one partition is removed from the plurality of nodes.

摘要翻译： 公开了在包括多个节点的数据库系统中执行数据的再分配。 数据包括分布在多个节点之间的多个分区。 正在添加至少一个新节点。 多个分区中的至少一个分区被选择为仅从多个节点移动到至少一个新节点。 所述至少一个分区仅被移动到所述至少一个新节点。 从多个节点移除至少一个分区。

公开(公告)号：US08666958B2

公开(公告)日：2014-03-04

申请号：US12626714

申请日：2009-11-27

申请人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

发明人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

IPC分类号： G06F7/00

CPC分类号： G06F17/30362

摘要： Lock communications in a shared disk database system is reduced by several approaches: sending a single message to a lock manager for locks required for an operation and locks that will be required in the future, the operations may include row update, row delete, large scan, and row insert; performing an operation in two executions, where in a first execution locks required for the operation is determined without performing the operation, and in a second execution a single message is sent to a lock manager for the required locks and the operation is performed; in free space searching, sending a single message to a lock manager for row and page locks before a row insert is actually performed; and granting locks in an unfair manner.

摘要翻译： 在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描 ，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

公开(公告)号：US20120036292A1

公开(公告)日：2012-02-09

申请号：US12851634

申请日：2010-08-06

申请人： Vaijayanthimala K. Anand ,  Ronen Grosman ,  Michael E. Lyons ,  Bret R. Olszewski

发明人： Vaijayanthimala K. Anand ,  Ronen Grosman ,  Michael E. Lyons ,  Bret R. Olszewski

IPC分类号： G06F13/22 ,  G06F13/24

CPC分类号： G06F13/22 ,  G06F13/24

摘要： A software thread is dispatched for causing the system to poll a device for determining whether a condition has occurred. Subsequently, the software thread is undispatched and, in response thereto, an interrupt is enabled on the device, so that the device is enabled to generate the interrupt in response to an occurrence of the condition, and so that the system ceases polling the device for determining whether the condition has occurred. Eventually, the software thread is redispatched and, in response thereto, the interrupt is disabled on the device, so that the system resumes polling the device for determining whether the condition has occurred.

摘要翻译： 调度软件线程使系统轮询设备以确定是否已经发生条件。 随后，软件线程未分配，并且响应于此，在设备上启用中断，使得设备能够响应于条件的发生而产生中断，并且使得系统停止轮询设备 确定病情是否发生。 最终，软件线程被重新分配，并且响应于此，设备上的中断被禁用，使得系统恢复轮询该设备以确定该条件是否已经发生。

公开(公告)号：US20110131192A1

公开(公告)日：2011-06-02

申请号：US12626714

申请日：2009-11-27

申请人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue ,  Roger L.Q. Zheng

发明人： James L. Finnie ,  Ronen Grosman ,  Matthew A. Huras ,  Keriley K. Romanufa ,  Aamer Sachedina ,  Xun Xue ,  Roger L.Q. Zheng

IPC分类号： G06F17/30 ,  G06F15/16

CPC分类号： G06F17/30362

摘要： Lock communications in a shared disk database system is reduced by several approaches: sending a single message to a lock manager for locks required for an operation and locks that will be required in the future, the operations may include row update, row delete, large scan, and row insert; performing an operation in two executions, where in a first execution locks required for the operation is determined without performing the operation, and in a second execution a single message is sent to a lock manager for the required locks and the operation is performed; in free space searching, sending a single message to a lock manager for row and page locks before a row insert is actually performed; and granting locks in an unfair manner.

摘要翻译： 在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描 ，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

公开(公告)号：US20070162506A1

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

申请号：US11330554

申请日：2006-01-12

申请人： Ronen Grosman ,  Keriley Romanufa ,  Robin Van Boeschoten

发明人： Ronen Grosman ,  Keriley Romanufa ,  Robin Van Boeschoten

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.

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