专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US11669518B1 Method and system for processing database transactions in a distributed online transaction processing (OLTP) database 有权
公开(公告)号：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.

2. 发明授权

US11436110B2 Distributed database remote backup 有权
公开(公告)号：US11436110B2
公开(公告)日：2022-09-06
申请号：US17174024
申请日：2021-02-11
申请人： Huaxin Zhang , Ping Chen , Yuk Kuen Chan , Sherman Lau
发明人： Huaxin Zhang , Ping Chen , Yuk Kuen Chan , Sherman Lau
IPC分类号： G06F11/20 , G06F11/14 , G06F16/27
摘要： Generating, by a first primary site that is included in a group of primary sites of a distributed database system, a commit action redo log message for a commit action performed by the first primary site for a first database transaction, the commit action redo log message including a transaction ID for the first database transaction and a transaction order indicator that represents an order of database transactions in a group of database transactions performed at one or more primary sites of the group of primary sites; and sending, by the first primary site, the commit action redo log message, for a corresponding first standby site that backs up the first primary site.

3. 发明授权

US07818301B2 Method, system and article of manufacture for rolling back past a boundary generator to a savepoint located in a unit of work 有权
标题翻译：通过边界发生器回滚到位于工作单位的保存点的方法，系统和制品
公开(公告)号：US07818301B2
公开(公告)日：2010-10-19
申请号：US11016061
申请日：2004-12-17
申请人： Paul Miller Bird , Yuk Kuen Chan , Yin Ling Cheung
发明人： Paul Miller Bird , Yuk Kuen Chan , Yin Ling Cheung
IPC分类号： G06F17/30
CPC分类号： G06F17/30371
摘要： Disclosed is a data processing system-implemented method, a data processing system and an article for manufacture for directing a data processing system to roll back to a savepoint located in a unit of work having a boundary generated by a boundary generator. The data processing system-implemented method includes examining a savepoint status indicator associated with the savepoint, and rolling back past the boundary to the savepoint depending on whether the examined savepoint status indicator indicates rolling back past the boundary towards the savepoint is permitted.
摘要翻译：公开了一种数据处理系统实现的方法，数据处理系统和用于制造的物品，用于引导数据处理系统回滚到位于具有由边界发生器产生的边界的工作单元中的保存点。数据处理系统实现的方法包括检查与保存点相关联的保存点状态指示符，并且根据被检查的保存点状态指示符是否指示向保存点返回超过边界是允许的，并且将边界回滚到边界。

4. 发明授权

US07640277B2 Method for releasing a savepoint 失效
标题翻译：释放保存点的方法
公开(公告)号：US07640277B2
公开(公告)日：2009-12-29
申请号：US11069733
申请日：2005-02-28
申请人： Paul Miller Bird , Yin Ling Cheung , Yuk Kuen Chan
发明人： Paul Miller Bird , Yin Ling Cheung , Yuk Kuen Chan
IPC分类号： G06F17/30
CPC分类号： G06F17/30359 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953 , Y10S707/99954
摘要： A method for releasing a nested savepoint on a remote node of a database management system. The to-be-released savepoint is one of a series of savepoints represented by control blocks arranged in a linked list in the creation order of the savepoints they represent. Releasing of the to-be-released savepoint begins with receiving of a request to release the to-be-released savepoint. A control block is selected such that it represents the to-be-released savepoint or the next more recently created savepoint after the to-be-released savepoint. The selected control block is merged with all other control blocks that represent savepoints that are more recently created than the savepoint represented by the selected control block. The resulting merged control block represents all of the savepoints from the most recently created to the savepoint previously represented by the selected control block.
摘要翻译：一种在数据库管理系统的远程节点上释放嵌套保存点的方法。要发布的保存点是由其所代表的保存点的创建顺序排列在链表中的控制块所表示的一系列保存点之一。释放待发布的保存点从接收到释放待发布的保存点的请求开始。选择一个控制块，以便它表示要发布的保存点或即将发布的保存点之后的下一个最近创建的保存点。所选择的控制块与表示比由所选控制块表示的保存点最近创建的保存点的所有其他控制块合并。所得到的合并控制块表示从最近创建的所有保存点到先前由所选控制块表示的保存点。

5. 发明授权

US07991752B2 Managing and coordinating savepoint functionality in a distributed database system 有权
标题翻译：管理和协调分布式数据库系统中的保存点功能
公开(公告)号：US07991752B2
公开(公告)日：2011-08-02
申请号：US11847226
申请日：2007-08-29
申请人： Yuk Kuen Chan , Amy Chang , Yin Ling Cheung
发明人： Yuk Kuen Chan , Amy Chang , Yin Ling Cheung
IPC分类号： G06F17/30
CPC分类号： G06F17/30371
摘要： Provided are techniques for savepoint processing. One of a savepoint statement, a rollback to savepoint statement, and a release savepoint statement is received. It is determined whether to propagate the received one of the savepoint statement, the rollback to savepoint statement, and the release savepoint statement to a data source based on an asymmetrical model in which a nested level of savepoints on a federated server side is capable of being greater than a nested level of savepoints on a data source side and wherein a two-tiered data structure is used to preserve savepoint information in the asymmetrical model. In response to determining that propagation is to occur, the one of the savepoint statement, the rollback to savepoint statement, and the release savepoint statement is propagated to the data source.
摘要翻译：提供保存点处理的技术。接收到一个保存点语句，对savepoint语句的回滚和释放savepoint语句。基于联合服务器端的嵌套级别的保存点能够被使用的不对称模型，确定是否将接收到的一个savepoint语句，回滚到savepoint语句和release savepoint语句传播到数据源大于数据源侧的保存点的嵌套级别，并且其中使用双层数据结构来保存不对称模型中的保存点信息。响应确定要进行传播，将保存点语句，对savepoint语句的回滚和释放保存点语句中的一个传播到数据源。

6. 发明授权

US06735605B2 Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system 失效
标题翻译：用于在多节点关系数据库管理系统中同步未记录的应用程序临时表的方法和装置
公开(公告)号：US06735605B2
公开(公告)日：2004-05-11
申请号：US09796843
申请日：2001-02-28
申请人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
发明人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , Y10S707/99943 , Y10S707/99956
摘要： A multi-node relational database management system is provided that can be embodied in software for managing a database having declared temporary tables associated with respective software application programs. The system comprises a plurality of nodes. The nodes include a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporary tables.
摘要翻译：提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。该系统包括多个节点。节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式