-
11.发明授权公开(公告)号：US09124670B2
公开(公告)日：2015-09-01
申请号：US14231347
申请日：2014-03-31
Applicant: Oracle International Corporation
Inventor： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
CPC classification number: H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
Abstract: Transactional and non-transactional data for maintaining session state is described. In a session, a server instance receives, from a client, a request to execute transactional commands and non-transactional commands. The server instance sends at least one first directive executable at the client to store, in a first set of information, one or more first items representing one or more particular transactional commands that are open but not yet committed. The first set of information is maintained separately from a second set of information including one or more second items representing one or more particular non-transactional commands that have been processed. Based on committing one or more particular transactional commands, the server instance sends at least one second directive executable at the client to purge, from the first set of information, the one or more first items without purging, from the second set of information, the one or more second items.
Abstract translation: 描述用于维护会话状态的事务和非事务性数据。 在会话中，服务器实例从客户端接收执行事务命令和非事务命令的请求。 服务器实例在客户端处发送至少一个第一指令可执行文件，以在第一组信息中存储一个或多个表示一个或多个已经开放但尚未提交的特定事务命令的第一项。 第一组信息与第二组信息分开维护，包括表示一个或多个已处理的特定非事务性命令的一个或多个第二项。 基于提交一个或多个特定事务命令，服务器实例在客户端发送至少一个第二指令可执行文件，从第一组信息中清除一个或多个第一项目，而不从第二组信息中清除 一个或多个第二个项目。
-
公开(公告)号：US20150172390A1
公开(公告)日：2015-06-18
申请号：US14587570
申请日：2014-12-31
Applicant: Oracle International Corporation
Inventor： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
CPC classification number: H04L67/142 , H04L67/146 , H04L67/148 , H04L67/42
Abstract: A method, machine, and computer-readable medium is provided for managing transactional sets of commands sent from a client to a server for execution. A server receives, from a client in a second session, a request that identifies a set of commands that were sent by the client in a first session. The set of commands comprises one or more transactions. The server determines that at least one transaction of the one or more transactions in the set of commands has not committed. Based at least in part on determining that the at least one transaction of the one or more transactions has not committed, the server blocks, from the second session, completion of the at least one transaction in the first session to prevent committing of the at least one transaction in the first session.
Abstract translation: 提供了一种方法，机器和计算机可读介质，用于管理从客户机发送到服务器以执行的事务性命令集。 服务器从第二会话中的客户端接收标识由客户端在第一会话中发送的一组命令的请求。 该组命令包括一个或多个事务。 服务器确定该组命令中的一个或多个事务的至少一个事务尚未提交。 至少部分地基于确定一个或多个事务的至少一个事务尚未提交，服务器从第二会话阻止第一会话中的至少一个事务的完成，以防止至少提交至少 一次交易在第一次会议。
-
公开(公告)号：US20130297566A1
公开(公告)日：2013-11-07
申请号：US13936061
申请日：2013-07-05
Applicant: Oracle International Corporation
Inventor： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda
IPC: G06F17/30
CPC classification number: G06F17/30289 , G06F17/30371
Abstract: A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable due to a planned or unplanned recoverable error. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state, which was exposed to the client from the previous database session, on the new database session. The process masks the outage from the application.
Abstract translation: 提供了一种过程，装置和计算机可读介质，用于在先前数据库会话变得不可用时重建数据库会话，并且先前发送用于执行先前数据库会话的命令满足特定标准。 该过程包括确定至少部分地基于该组命令是否满足一个或多个标准来确定由客户端发送的用于在先前的数据库会话上执行的一组命令是否可接受重播。 该过程还包括由于计划的或计划外的可恢复的错误确定先前的数据库会话不可用。 响应于确定先前的数据库会话不可用，如果该组命令对于重放是可接受的，则该组命令被发送以在新的数据库会话上执行以重建从先前数据库向客户端公开的状态 会话，在新的数据库会话。 该过程掩盖了应用程序中断。
-
公开(公告)号：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.
-
公开(公告)号：US10942907B2
公开(公告)日：2021-03-09
申请号：US15803644
申请日：2017-11-03
Applicant: Oracle International Corporation
Inventor： Carol L. Colrain , Kevin S. Neel , Douglas N. Surber , Tong Zhou , Nancy R. Ikeda , Jean De Lavarene , Rohan Ankalikar
Abstract: Techniques are described for closing one or more connections with a database management system (DBMS) as part of a planned operation such as maintenance and load balancing. In an embodiment, a request is received for a planned operation of a database server of a DBMS that requires releasing and migrating database sessions. Over a database connection with the database server, the DBMS or a Client-Driver on the client system that interfaces with the DBMS, may receive request(s) from the client system. Based on the request(s), a safe point, for the database connection with the database server, at which the database connection of the client system with the database server can be closed without affecting the success of execution of next one or more command that the client system intended to request the DBMS to execute on the database server, is determined. In an embodiment, in response to the request(s), the DBMS and/or Client-Driver, while the connection is valid, provide to the client system an invalid status for a connection test request. Such a response may cause the client system to use a different database connection to connect with the DBMS. After returning the response to the client system, the DBMS and/or Client-Driver causes the database session with the DBMS to close. In an embodiment, for database sessions to be released, the DBMS identifies a safe point in a database session by a detected request boundary or where the session states are determined to be recoverable or the failover is determined to be expected to succeed. At such a safe point, all database session states are known, and failing the session over to another database instance offering the requested service can be performed safely and transparent to applications.
-
Patent Agency Ranking
公开(公告)号：US10250693B2
公开(公告)日：2019-04-02
申请号：US14587570
申请日：2014-12-31
Applicant: Oracle International Corporation
Inventor： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
Abstract: A method, machine, and computer-readable medium is provided for managing transactional sets of commands sent from a client to a server for execution. A server receives, from a client in a second session, a request that identifies a set of commands that were sent by the client in a first session. The set of commands comprises one or more transactions. The server determines that at least one transaction of the one or more transactions in the set of commands has not committed. Based at least in part on determining that the at least one transaction of the one or more transactions has not committed, the server blocks, from the second session, completion of the at least one transaction in the first session to prevent committing of the at least one transaction in the first session.
-
公开(公告)号：US09779116B2
公开(公告)日：2017-10-03
申请号：US13936061
申请日：2013-07-05
Applicant: Oracle International Corporation
Inventor： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda , Paul Parkinson
IPC: G06F17/30
CPC classification number: G06F17/30289 , G06F17/30371
Abstract: A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable due to a planned or unplanned recoverable error. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state, which was exposed to the client from the previous database session, on the new database session. The process masks the outage from the application.
-
公开(公告)号：US09268840B2
公开(公告)日：2016-02-23
申请号：US14448987
申请日：2014-07-31
Applicant: Oracle International Corporation
Inventor： Wei-Ming Hu , Lakshminaray Chidambaran , Mark Dilman , Feroz A. Khan , Bhaskar Mathur , Kevin S. Neel , Leonid Novak , Kant C. Patel , Saravanakumar Ramasubramanian , Michael J. Stewart , Hubert Sun
CPC classification number: G06F17/30595 , H04L41/02 , H04L67/1002
Abstract: Techniques are provided to allow users to define a global service that is offered across multiple replicated databases. Database clients connect to and use a global service just as they do with regular services on a single database today. Upon receiving a connection request, a collection of components, referred to collectively as the Global Data Service framework (GDS framework), automatically chooses the best database server instances to which to connect a client. Once those connections have been established, the clients determine which database server instance, of those database server instances to which they are connected, to send requests to based, at least in part, on advisory messages sent to the clients by the GDS framework.
Abstract translation: 提供技术以允许用户定义跨多个复制数据库提供的全局服务。 数据库客户端连接到并使用全局服务，就像现在一个数据库上的常规服务一样。 一旦接收到连接请求，将统称为全局数据服务框架（GDS框架）的组件集合自动选择连接客户端的最佳数据库服务器实例。 一旦建立了这些连接，客户端将确定哪些数据库服务器实例（与其连接的数据库服务器实例）发送请求至少部分地基于由GDS框架发送给客户端的咨询消息。
-
19.发明申请公开(公告)号：US20150326673A1
公开(公告)日：2015-11-12
申请号：US14748451
申请日：2015-06-24
Applicant: Oracle International Corporation
Inventor： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
CPC classification number: H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
Abstract: Transactional and non-transactional data for maintaining session state is described. In a session, a server instance receives, from a client, a request to execute transactional commands and non-transactional commands. The server instance sends at least one first directive executable at the client to store, in a first set of information, one or more first items representing one or more particular transactional commands that are open but not yet committed. The first set of information is maintained separately from a second set of information including one or more second items representing one or more particular non-transactional commands that have been processed. Based on committing one or more particular transactional commands, the server instance sends at least one second directive executable at the client to purge, from the first set of information, the one or more first items without purging, from the second set of information, the one or more second items.
Abstract translation: 描述用于维护会话状态的事务和非事务性数据。 在会话中，服务器实例从客户端接收执行事务命令和非事务命令的请求。 服务器实例在客户端处发送至少一个第一指令可执行文件，以在第一组信息中存储一个或多个表示一个或多个已经开放但尚未提交的特定事务命令的第一项。 第一组信息与第二组信息分开维护，包括表示一个或多个已处理的特定非事务性命令的一个或多个第二项。 基于提交一个或多个特定事务命令，服务器实例在客户端发送至少一个第二指令可执行文件，从第一组信息中清除一个或多个第一项目，而不从第二组信息中清除 一个或多个第二个项目。
-
20.发明申请公开(公告)号：US20140229531A1
公开(公告)日：2014-08-14
申请号：US14231347
申请日：2014-03-31
Applicant: Oracle International Corporation
Inventor： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
IPC: H04L29/06
CPC classification number: H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
Abstract: Transactional and non-transactional data for maintaining session state is described. In a session, a server instance receives, from a client, a request to execute transactional commands and non-transactional commands. The server instance sends at least one first directive executable at the client to store, in a first set of information, one or more first items representing one or more particular transactional commands that are open but not yet committed. The first set of information is maintained separately from a second set of information including one or more second items representing one or more particular non-transactional commands that have been processed. Based on committing one or more particular transactional commands, the server instance sends at least one second directive executable at the client to purge, from the first set of information, the one or more first items without purging, from the second set of information, the one or more second items.
Abstract translation: 描述用于维护会话状态的事务和非事务性数据。 在会话中，服务器实例从客户端接收执行事务命令和非事务命令的请求。 服务器实例在客户端处发送至少一个第一指令可执行文件，以在第一组信息中存储一个或多个表示一个或多个已经开放但尚未提交的特定事务命令的第一项。 第一组信息与第二组信息分开维护，包括表示一个或多个已处理的特定非事务性命令的一个或多个第二项。 基于提交一个或多个特定事务命令，服务器实例在客户端发送至少一个第二指令可执行文件，从第一组信息中清除一个或多个第一项目，而不从第二组信息中清除 一个或多个第二个项目。
-
-
-
-
-
-
-
-
-
Search Results
20
records
(took 0.031 seconds)
