公开(公告)号：US20230185795A1

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

申请号：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.

公开(公告)号：US06615214B1

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

申请号：US09614358

申请日：2000-07-12

申请人： Paul M. Bird ,  Yuk-kuen Chan ,  Michael J. Snowbell

发明人： Paul M. Bird ,  Yuk-kuen Chan ,  Michael J. Snowbell

IPC分类号： G06F1700

CPC分类号： G06F17/30433 ,  G06F8/433 ,  Y10S707/954 ,  Y10S707/99933

摘要： A relational database management system which determines the shareable status of an executable object (section) in an cache. The shareable status is defined for a section in a cache by the system maintaining an identification list which has reference to database entities which are affected by a statement in the current unit of work. When a statement is compiled, the compiler generates a list of dependencies, which list is compared with the identification list. If the statement data dependencies are on the identification list, the statement will be treated as non-shareable until the completion of the current unit of work.

摘要翻译： 确定缓存中可执行对象（部分）的可共享状态的关系数据库管理系统。 由系统维护一个标识列表的高速缓存中的一个部分定义了可共享状态，该标识列表参考受当前工作单元中的语句影响的数据库实体。 当编译语句时，编译器生成依赖关系列表，该列表与标识列表进行比较。 如果声明数据依赖关系在识别列表上，则声明将被视为不可共享，直到完成当前工作单元。

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

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

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

公开(公告)号：US20220405178A1

公开(公告)日：2022-12-22

申请号：US17890934

申请日：2022-08-18

申请人： 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.

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

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

公开(公告)号：US20090063579A1

公开(公告)日：2009-03-05

申请号：US11847226

申请日：2007-08-29

申请人： Yuk Kuen CHAN ,  Amy CHANG ,  Yin Ling CHEUNG

发明人： Yuk Kuen CHAN ,  Amy CHANG ,  Yin Ling CHEUNG

IPC分类号： G06F12/16

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

公开(公告)号：US20220253363A1

公开(公告)日：2022-08-11

申请号：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.