公开(公告)号：US10802890B2

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

申请号：US15878606

申请日：2018-01-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Yuri Dolgov ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F9/52 ,  G06F9/50 ,  G06F16/245 ,  G06F16/28 ,  G06F16/22

Abstract: In accordance with an embodiment, a system enables multidimensional search within a resource pool, to support complex borrow operations such as, for example, specifying ranges for particular connection properties. As threads access the pool, attempting to borrow connections having particular connection properties, one or more skipped pool elements can be represented as skip lists within a k-dimensional tree (KD-tree) or other data structure that enables searching across multiple dimensions. In response to receiving a request to borrow a connection having particular connection properties, a multidimensional search can be performed within the KD-tree to determine the availability of a connection having the requested properties.

公开(公告)号：US09984096B2

公开(公告)日：2018-05-29

申请号：US15087895

申请日：2016-03-31

Applicant: Oracle International Corporation

Inventor： Paul Parkinson ,  Todd J. Little ,  Carol Colrain ,  Jean De Lavarene ,  Vivekanandhan Raja ,  Douglas Surber ,  Stefan Roesch ,  Nancy Ikeda ,  Kevin Neel

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30227 ,  G06F9/46 ,  G06F9/466

Abstract: A system and method for reducing communications overhead in a distributed transaction processing environment such as an XA environment. In accordance with an embodiment communication overhead is reduced in a transaction start method by deferring a transaction start communication. The deferred transaction start communication is determined from a subsequent transaction processing communication thereby reducing the number of networks calls required for each transaction and enhancing system performance.

公开(公告)号：US09569472B2

公开(公告)日：2017-02-14

申请号：US14253580

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F12/08 ,  G06F17/30

CPC classification number: G06F17/303 ,  G06F12/0813 ,  G06F12/0815 ,  G06F12/0868 ,  G06F17/30345 ,  G06F17/30902 ,  G06F2212/465

Abstract: Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的2级连接高速缓存的系统和方法。 根据实施例，使用第二级别或级别2（L2）连接高速缓存来缓存与数据库一起使用的非会话连接。 当请求连接时，可以从高速缓存检索无会话连接（NSC），并附加数据库会话。 稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

公开(公告)号：US09251178B2

公开(公告)日：2016-02-02

申请号：US13912086

申请日：2013-06-06

Applicant: Oracle International Corporation

Inventor： Jean de Lavarene ,  Tong Zhou ,  Douglas Surber ,  Stephen Felts ,  David Merrill

IPC: G06F17/30 ,  G06F9/50

CPC classification number: G06F17/30289 ,  G06F9/5011 ,  G06F17/30943 ,  G06F2209/5011

Abstract: A system and method for connection labeling for use with connection pools. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and avoids using those high-cost connections to serve requests when the total number of connections is below a particular threshold value.

Abstract translation: 用于连接池的连接标签的系统和方法。 根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及标识为高成本连接的连接标识的连接池逻辑，并且当连接总数低于特定阈值时，避免使用这些高成本连接来提供请求。

公开(公告)号：US10313477B2

公开(公告)日：2019-06-04

申请号：US15215372

申请日：2016-07-20

Applicant: Oracle International Corporation

Inventor： Yuri Dolgov ,  Douglas Surber ,  Jean De Lavarene

IPC: H04L29/08

Abstract: In accordance with an embodiment, described herein is a system and method for use of a non-blocking process with a resource pool, for example a connection pool, or another type of computing environment. A generic wait-free approach can be used with a variety of different types of resource pools and pool elements. Threads which require access to a collection of resources do not have to wait for a lock on that collection of resources to become available. Although a borrowing thread may still be required to wait for a particular resource to be released, the wait-free approach allows the thread to browse through a list of available resources. The approach can be used with connection pools, or with other types of computing environments, to provide improved scalability in such systems.

公开(公告)号：US20150026405A1

公开(公告)日：2015-01-22

申请号：US14253580

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F12/08

CPC classification number: G06F17/303 ,  G06F12/0813 ,  G06F12/0815 ,  G06F12/0868 ,  G06F17/30345 ,  G06F17/30902 ,  G06F2212/465

Abstract: Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的2级连接高速缓存的系统和方法。 根据实施例，使用第二级别或级别2（L2）连接高速缓存来缓存与数据库一起使用的非会话连接。 当请求连接时，可以从高速缓存检索无会话连接（NSC），并附加数据库会话。 稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

公开(公告)号：US20150026213A1

公开(公告)日：2015-01-22

申请号：US14253573

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F17/30

CPC classification number: G06F17/3048

Abstract: Described herein is a system and method for providing a shareable global cache for use with a database environment. In accordance with an embodiment, a shareable global cache is used for caching connections to database instances. When a request is received for a particular service, the system looks for an idle connection to that service, and, if none is available, locates an existing connection to a database instance serving that service and switches a service on the existing connection to that service.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的可共享全局缓存的系统和方法。 根据实施例，可共享的全局缓存用于缓存到数据库实例的连接。 当接收到特定服务的请求时，系统会查找到该服务的空闲连接，如果没有可用的连接，则将现有连接定位到服务于该服务的数据库实例，并将现有连接上的服务切换到该服务 。

公开(公告)号：US20140324911A1

公开(公告)日：2014-10-30

申请号：US13912098

申请日：2013-06-06

Applicant: Oracle International Corporation

Inventor： Jean de Lavarene ,  Tong Zhou ,  Douglas Surber ,  Stephen Felts ,  David Merrill

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F9/5011 ,  G06F17/30943 ,  G06F2209/5011

Abstract: A system and method for connection labeling for use with connection pools, including support for cloud-based multi-tenant environments using connection labeling. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and controls the creation or repurposing of high-cost connections to serve requests from the multiple tenants or tenant applications.

Abstract translation: 用于连接池的连接标签的系统和方法，包括使用连接标签支持基于云的多租户环境。 根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及连接池逻辑，用于标识标记为高成本连接的连接，并控制高成本连接的创建或重新使用，以提供来自多个租户或租户应用程序的请求。

公开(公告)号：US20140324910A1

公开(公告)日：2014-10-30

申请号：US13912086

申请日：2013-06-06

Applicant: Oracle International Corporation

Inventor： Jean de Lavarene ,  Tong Zhou ,  Douglas Surber ,  Stephen Felts ,  David Merrill

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F9/5011 ,  G06F17/30943 ,  G06F2209/5011

Abstract: A system and method for connection labeling for use with connection pools. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and avoids using those high-cost connections to serve requests when the total number of connections is below a particular threshold value.

Abstract translation: 用于连接池的连接标签的系统和方法。 根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及标识为高成本连接的连接标识的连接池逻辑，并且当连接总数低于特定阈值时，避免使用这些高成本连接来提供请求。

公开(公告)号：US12007941B2

公开(公告)日：2024-06-11

申请号：US16147314

申请日：2018-09-28

Applicant: Oracle International Corporation

Inventor： Kevin S. Neel ,  Carol L. Colrain ,  Tong Zhou ,  Arturo Ismael Quinto ,  Jonathan Giloni ,  Douglas Surber ,  Ravi Thammaiah

IPC: G06F16/14 ,  G06F11/20 ,  G06F16/11 ,  G06F16/21 ,  G06F16/25 ,  H04L67/141 ,  H04L67/142

CPC classification number: G06F16/122 ,  G06F11/2023 ,  G06F16/21 ,  G06F16/252 ,  H04L67/141 ,  H04L67/142 ,  G06F2201/80

Abstract: Techniques are disclosed herein for identifying, recording and restoring the state of a database session and various aspects thereof. A session template data structure is generated that includes session attribute values describing various aspects of the session that is established between a client system and a database management system (DBMS and enables the client system to issue to the DBMS commands for execution. Based on the session attribute values, DBMS may generate a template identifier corresponding to the session template data structure. The template identifier may be stored in an association with the session state that it partially (or in whole) represents. In an embodiment, when another state of a session is captured, if the template identifier for the state is the same, then rather than storing the attribute-value pairs for the other state, the template identifier is further associated with the other state. In an embodiment, a request boundary is detected where the session is known to be at a recoverable point. If recovery of the session is needed, the session state is restored, and replay of commands start from this point. Each command replayed is verified to produce the same session state as it produced by the original execution. If the session is determined to be a safe point, then all the commands recorded for replay prior to the safe point may be deleted. In an embodiment, the template is used to set the initial state when borrowing from a session pool. The state tracking is also used to identify that the session can be failed over safely during planned operation as the session is unlikely to drain by itself even when not used.