公开(公告)号：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.

公开(公告)号：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.

摘要翻译： 公开了一种数据处理系统实现的方法，数据处理系统和用于制造的物品，用于引导数据处理系统回滚到位于具有由边界发生器产生的边界的工作单元中的保存点。 数据处理系统实现的方法包括检查与保存点相关联的保存点状态指示符，并且根据被检查的保存点状态指示符是否指示向保存点返回超过边界是允许的，并且将边界回滚到边界。

公开(公告)号：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.

摘要翻译： 一种在数据库管理系统的远程节点上释放嵌套保存点的方法。 要发布的保存点是由其所代表的保存点的创建顺序排列在链表中的控制块所表示的一系列保存点之一。 释放待发布的保存点从接收到释放待发布的保存点的请求开始。 选择一个控制块，以便它表示要发布的保存点或即将发布的保存点之后的下一个最近创建的保存点。 所选择的控制块与表示比由所选控制块表示的保存点最近创建的保存点的所有其他控制块合并。 所得到的合并控制块表示从最近创建的所有保存点到先前由所选控制块表示的保存点。

公开(公告)号：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语句的回滚和释放保存点语句中的一个传播到数据源。

公开(公告)号：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.

摘要翻译： 提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。 该系统包括多个节点。 节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。