公开(公告)号：US20240126785A1

公开(公告)日：2024-04-18

申请号：US18379684

申请日：2023-10-13

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23

CPC classification number: G06F16/275 ,  G06F11/2023 ,  G06F16/2322 ,  G06F16/2379 ,  G06F2201/80

Abstract: Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.

公开(公告)号：US10585881B2

公开(公告)日：2020-03-10

申请号：US14989936

申请日：2016-01-07

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Michael Ullrich Zoll ,  Vladimir Begun ,  Rajkumar Arockia Irudayaraj ,  Logan O'Sullivan Bruns

IPC: G06F16/00 ,  G06F16/23 ,  G06F9/50 ,  G06F16/25 ,  G06F16/84 ,  G06F16/28 ,  H04L29/08

Abstract: A method and apparatus is provided for dynamically generating data to dataset mappings and dataset to logical instance mappings and distributing these mappings to subscribers for the purpose of routing work. An advisory engine updates the mappings of data to data sets based at least in part on changing demands and patterns of access to data, and updates the mappings of datasets to logical instances based at least in part on anticipated capacity and change in conditions of the database servers. The subscribers receive and store the mapping information that maps the data to dataset identifiers, and dataset identifiers to logical database instances. The subscribers may also receive information that describes the current availability conditions of database instances, which are used to override the mapping of logical database instances to physical database instances. Subscribers may use the data to dataset mapping to map data identified from in an incoming database request to a dataset. Subscribers may use the dataset to logical instance mapping to map a dataset to a possible database server, and the logical instance to physical instance mapping to map a possible database server to an available database server. In this manner, the subscribers may route data efficiently even when access patterns and server conditions change.

公开(公告)号：US12204558B2

公开(公告)日：2025-01-21

申请号：US18379684

申请日：2023-10-13

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23 ,  G06F16/2455

Abstract: Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.

公开(公告)号：US11652892B2

公开(公告)日：2023-05-16

申请号：US16948773

申请日：2020-09-30

Applicant: Oracle International Corporation

Inventor： Chandrajith Ramachandran Unnithan ,  Michael Ullrich Zoll ,  Wai Shun Wilson Chan ,  Tak Fung Wang ,  Carol Lyndall Colrain ,  Troy Anthony

IPC: H04L67/148 ,  G06F9/50

CPC classification number: H04L67/148 ,  G06F9/505 ,  G06F9/5088

Abstract: Disclosed is a method, a computer program product, and a computer system for implementing automatic connection load balancing of database connections between instances of a cluster. Load imbalances are detected globally in the cluster, and can be corrected autonomously by the local instances. The local controller/orchestrator detects the imbalance, computes a target for the instance, and makes any necessary adjustments on the instance, where a server marks the connections to redistribute, and then implements draining and/or planned failover to move sessions.

公开(公告)号：US09760584B2

公开(公告)日：2017-09-12

申请号：US13828490

申请日：2013-03-14

Applicant: Oracle International Corporation

Inventor： Paul Parkinson ,  Todd J. Little ,  Stefan Heinrich Roesch ,  Carol Lyndall Colrain ,  Edward Heeren

IPC: G06F17/00 ,  G06F7/00 ,  G06F17/30 ,  G06F9/46 ,  G06F11/07 ,  G06F11/14

CPC classification number: G06F17/30289 ,  G06F9/466 ,  G06F11/0709 ,  G06F11/1474

Abstract: Systems and methods are provided for supporting transaction recovery based on inline delegation of transaction logs to a database. The system can retrieve transaction recovery information of a transaction from a persistence store, wherein the transaction recovery information is persisted on a resource manager that is associated with the persistence store during a prepare phase. Furthermore, the system can retrieve one or more in-doubt transactions from one or more participating resource managers of the transaction. Then, the system can determine whether to commit or roll back the one or more in-doubt transactions by matching the one or more in-doubt transactions to the transaction recovery information.

公开(公告)号：US20250147982A1

公开(公告)日：2025-05-08

申请号：US19014766

申请日：2025-01-09

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23 ,  G06F16/2455

Abstract: Techniques are described for failing over from a primary database to the replicated logical database of the primary database. Techniques are also described for the client-side object references to be preserved when failing over to the logical replica database, for AS OF and other queries preserved, and for versioning of checksums, signatures and structures across logical replicas.

公开(公告)号：US20250094294A1

公开(公告)日：2025-03-20

申请号：US18884628

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Natesh Kedlaya ,  Sukhada Pendse ,  Ajit Mylavarapu ,  Tirthankar Lahiri ,  Carol Lyndall Colrain ,  Xiaoli Qi ,  Juan R. Loaiza

IPC: G06F11/14 ,  G06F16/23

Abstract: Techniques are described for Transaction Guard to impose at-most-once execution by generating and using the database's native transaction identifier, DB XID. In an implementation, DB XID is unique within a (pluggable) database instance (with local undo) and uniquely identifies a transaction in the database. The Transaction Guard that is extended to use native transaction information determines the commit outcome using the native transaction identifier of the transaction instead of relying on the persistence of the Logical Transaction Identifier (LTXID) in a separate table. Using the native transaction identifier, the Transaction Guard significantly improves performance by eliminating the extra write(s) incurred during commit operations.

公开(公告)号：US20160117357A1

公开(公告)日：2016-04-28

申请号：US14989936

申请日：2016-01-07

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Michael Ullrich Zoll ,  Vladimir Begun ,  Rajkumar Arockia Irudayaraj ,  Logan O'Sullivan Bruns

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/2379 ,  G06F9/5011 ,  G06F9/5027 ,  G06F16/25 ,  G06F16/284 ,  G06F16/84 ,  G06F16/86 ,  G06F2212/7201 ,  H04L67/32

Abstract: A method and apparatus is provided for dynamically generating data to dataset mappings and dataset to logical instance mappings and distributing these mappings to subscribers for the purpose of routing work. An advisory engine updates the mappings of data to data sets based at least in part on changing demands and patterns of access to data, and updates the mappings of datasets to logical instances based at least in part on anticipated capacity and change in conditions of the database servers. The subscribers receive and store the mapping information that maps the data to dataset identifiers, and dataset identifiers to logical database instances. The subscribers may also receive information that describes the current availability conditions of database instances, which are used to override the mapping of logical database instances to physical database instances. Subscribers may use the data to dataset mapping to map data identified from in an incoming database request to a dataset. Subscribers may use the dataset to logical instance mapping to map a dataset to a possible database server, and the logical instance to physical instance mapping to map a possible database server to an available database server. In this manner, the subscribers may route data efficiently even when access patterns and server conditions change.

Abstract translation: 提供了一种方法和装置，用于动态生成数据到数据集映射和数据集到逻辑实例映射的数据，并将这些映射分发给用户以进行路由工作。 咨询引擎至少部分地基于不断变化的对数据访问的需求和模式来更新数据到数据集的映射，并且至少部分地基于数据库的预期容量和条件变化将数据集的映射更新为逻辑实例。 服务器 用户接收并存储将数据映射到数据集标识符的映射信息，以及数据集标识符存储到逻辑数据库实例。 用户还可以接收描述数据库实例的当前可用性条件的信息，其用于覆盖逻辑数据库实例到物理数据库实例的映射。 订阅者可以使用数据对数据集映射将从传入数据库请求标识的数据映射到数据集。 订阅者可以将数据集用于逻辑实例映射以将数据集映射到可能的数据库服务器，并将逻辑实例映射到物理实例映射，以将可能的数据库服务器映射到可用的数据库服务器。 以这种方式，即使当访问模式和服务器条件改变时，用户也可以有效地路由数据。

公开(公告)号：US20130246368A1

公开(公告)日：2013-09-19

申请号：US13828490

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Paul Parkinson ,  Todd J. Little ,  Stefan Heinrich Roesch ,  Carol Lyndall Colrain ,  Edward Heeren

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F9/466 ,  G06F11/0709 ,  G06F11/1474

Abstract: Systems and methods are provided for supporting transaction recovery based on inline delegation of transaction logs to a database. The system can retrieve transaction recovery information of a transaction from a persistence store, wherein the transaction recovery information is persisted on a resource manager that is associated with the persistence store during a prepare phase. Furthermore, the system can retrieve one or more in-doubt transactions from one or more participating resource managers of the transaction. Then, the system can determine whether to commit or roll back the one or more in-doubt transactions by matching the one or more in-doubt transactions to the transaction recovery information.

Abstract translation: 提供了系统和方法，用于支持基于事务日志的内联授权到数据库的事务恢复。 系统可以从持久性存储中检索事务的事务恢复信息，其中事务恢复信息在准备阶段期间被持久存储在与持久性存储相关联的资源管理器上。 此外，系统可以从交易的一个或多个参与资源管理器检索一个或多个不确定交易。 然后，系统可以通过将一个或多个不确定事务与事务恢复信息相匹配来确定是提交还是回滚一个或多个不确定事务。