公开(公告)号：US09720970B2

公开(公告)日：2017-08-01

申请号：US14259499

申请日：2014-04-23

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Douglas Surber ,  Jean De Lavarene ,  Ashok Shivarudraiah ,  Edward Shirk ,  Mark Jungerman

IPC: G06F12/00 ,  G06F13/00 ,  G06F17/30

CPC classification number: G06F17/30492

Abstract: A system and method for efficient storage and retrieval of fragmented data using a pseudo linear dynamic byte array is provided. In accordance with an embodiment, the system comprises a database driver which provides access by a software application to a database. The database driver uses a dynamic byte array to enable access by the application to data in the database, including determining a size of a required data to be stored in memory, and successively allocating and copying the required data into the dynamic byte array as a succession of blocks. The data stored within the succession of blocks can then be accessed and provided to the application.

公开(公告)号：US20160306854A1

公开(公告)日：2016-10-20

申请号：US15133972

申请日：2016-04-20

Applicant: Oracle International Corporation

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Douglas Surber ,  Mark Dilman ,  Leonid Novak ,  Wei Ming Hu ,  Ashok Shivarudraiah ,  Tong Zhou ,  Ilya Taranov

IPC: G06F17/30

Abstract: In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.

Abstract translation: 根据一个实施例，这里描述了用于提供对分片数据库的直接访问的系统和方法。 分片主任提供软件客户端应用程序访问数据库分片。 连接池（例如通用连接池，UCP）和数据库驱动程序（例如，Java数据库连接，JDBC，组件）可以配置为允许客户端应用程序在连接检验期间或稍后提供分片密钥 时间; 识别客户端应用程序指定的分片密钥; 并启用客户端应用程序连接到特定的分片或块。 该方法可以有效地重新使用连接资源，并能更快地访问适当的分片。

公开(公告)号：US09268798B2

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

申请号：US13912098

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

公开(公告)号：US20210034437A1

公开(公告)日：2021-02-04

申请号：US17068555

申请日：2020-10-12

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.

公开(公告)号：US10909088B2

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

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Carol Colrain ,  Kevin Neel ,  Pablo Silberkasten ,  Michael McMahon ,  Saurabh Verma ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/958 ,  G06F1/30 ,  H04L29/08 ,  G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US10776378B2

公开(公告)日：2020-09-15

申请号：US14794642

申请日：2015-07-08

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for use of immutable accessors with dynamic byte arrays. In accordance with an embodiment, a database driver provides access by software applications executing at an application server to data at a database, including associating a result set cache manager with a pool of result set caches. Each result set cache can be associated with one or more immutable accessors. In response to receiving a request from an application, to access a set of data, the set of data from the database is received into a particular result set cache. In response to receiving a subsequent request for a same set of data, from a same or another application using a same or another database connection, access is provided to the immutable accessor associated with the particular result set cache, for use in accessing the data therein.

公开(公告)号：US10089377B2

公开(公告)日：2018-10-02

申请号：US14864782

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Garret Swart ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F17/30

Abstract: A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

公开(公告)号：US20180150337A1

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

申请号：US15878606

申请日：2018-01-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Yuri Dolgov ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F9/52 ,  G06F9/50 ,  G06F17/30

CPC classification number: G06F9/526 ,  G06F9/5011 ,  G06F9/5016 ,  G06F16/2246 ,  G06F16/2264 ,  G06F16/245 ,  G06F16/283 ,  G06F2209/5011 ,  G06F2209/5014

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.

公开(公告)号：US20160306832A1

公开(公告)日：2016-10-20

申请号：US15133979

申请日：2016-04-20

Applicant: Oracle International Corporation

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Douglas Surber ,  Mark Dilman ,  Leonid Novak ,  Wei Ming Hu ,  Ashok Shivarudraiah ,  Tong Zhou ,  Ilya Taranov

IPC: G06F17/30

Abstract: In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.

Abstract translation: 根据实施例，该系统使得能够使用高速缓存和分片拓扑来访问分片数据库。 连接到分片数据库的分片识别客户端应用程序可以使用连接池（例如，通用连接池，UCP）来存储或访问到共享池内的分片数据库的不同碎片或块的连接。 当创建新连接时，可以在数据库驱动程序层构建分片拓扑图层，数据库驱动程序层可以将分片键范围学习并缓存到分片的位置。 分片拓扑层使来自客户端应用程序的后续连接请求能够使用快速键路径访问适当的分片或块。

公开(公告)号：US20140380004A1

公开(公告)日：2014-12-25

申请号：US14259499

申请日：2014-04-23

Applicant: Oracle International Corporation

Inventor： Douglas Surber ,  Jean De Lavarene ,  Ashok Shivarudraiah ,  Edward Shirk ,  Mark Jungerman

IPC: G06F3/06

CPC classification number: G06F17/30492

Abstract: A system and method for efficient storage and retrieval of fragmented data using a pseudo linear dynamic byte array is provided. In accordance with an embodiment, the system comprises a database driver which provides access by a software application to a database. The database driver uses a dynamic byte array to enable access by the application to data in the database, including determining a size of a required data to be stored in memory, and successively allocating and copying the required data into the dynamic byte array as a succession of blocks. The data stored within the succession of blocks can then be accessed and provided to the application.

Abstract translation: 提供了一种使用伪线性动态字节阵列有效地存储和检索分段数据的系统和方法。 根据实施例，该系统包括数据库驱动器，其提供软件应用程序对数据库的访问。 数据库驱动程序使用动态字节数组来使应用程序能够访问数据库中的数据，包括确定要存储在存储器中的所需数据的大小，并将所需数据连续分配并复制到动态字节数组中作为继承 的块。 存储在连续块内的数据可以被访问并提供给应用程序。