公开(公告)号：US10180973B2

公开(公告)日：2019-01-15

申请号：US14864788

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Garret Swart ,  Kuassi Mensah

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.

公开(公告)号：US09880938B2

公开(公告)日：2018-01-30

申请号：US14864192

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F12/08 ,  G06F12/0871 ,  G06F17/30

CPC classification number: G06F12/0871 ,  G06F17/30132 ,  G06F17/30492 ,  G06F2212/1044 ,  G06F2212/465

Abstract: In accordance with an embodiment, described herein is a system and method for compacting a pseudo linear byte array, for use with supporting access to a database. A database driver (e.g., a Java Database Connectivity (JDBC) driver) provides access by software application clients to a database. When a result set (e.g., ResultSet) is returned for storage in a dynamic byte array (DBA), in response to a database query (e.g., a SELECT), the database driver determines if the DBA is underfilled and, if so, calculates the data size of the DBA, creates a static byte array (SBA) in a cache at the client, compacts the returned data into the SBA, and stores the data size as part of the metadata associated with the cache. In accordance with an embodiment, the DBA and the SBA can use a same interface for access by client applications.

公开(公告)号：US09785687B2

公开(公告)日：2017-10-10

申请号：US14202348

申请日：2014-03-10

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Jean De Lavarene ,  Tong Zhou

IPC: G06F17/30

CPC classification number: G06F17/3056

Abstract: A system and method for transparent multi key-value weighted attributed connection using uni-tag connection pools. In accordance with an embodiment, a connection pool enables labeling of connections that software applications can use to access a database. A connection pool associated with a database enables tagging of connection pools at the database and allows applications to selectively obtain connections based on tags. A request is received from an application to query data from the database using a labeled connection or low-cost alternative. If a low-cost connection is found, but requires configuration, the system returns unmatched labels for use by the application in configuring its environment to use the connection. The system can also generate a tag for the connection. Upon subsequent release of the database session, the tag can be made available for subsequent use of the tag, or a tagged connection, by the same or by other applications.

公开(公告)号：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，组件）可以配置为允许客户端应用程序在连接检验期间或稍后提供分片密钥 时间; 识别客户端应用程序指定的分片密钥; 并启用客户端应用程序连接到特定的分片或块。 该方法可以有效地重新使用连接资源，并能更快地访问适当的分片。

公开(公告)号：US12248476B2

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

申请号：US18400568

申请日：2023-12-29

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah

IPC: G06F16/24 ,  G06F16/2455 ,  G06F16/27

Abstract: A system and method is described for database split generation in a massively parallel or other 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.

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

公开(公告)号：US10528596B2

公开(公告)日：2020-01-07

申请号：US14864792

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Garret Swart ,  Jean De Lavarene

IPC: G06F16/00 ,  G06F16/28 ,  G06F16/84 ,  G06F16/245

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.

公开(公告)号：US10394818B2

公开(公告)日：2019-08-27

申请号：US14864765

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah

IPC: G06F17/00 ,  G06F17/30 ,  G06F16/2455 ,  G06F16/27

Abstract: A system and method is described for database split generation in a massively parallel or other 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.

公开(公告)号：US10387421B2

公开(公告)日：2019-08-20

申请号：US14864769

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah

IPC: G06F17/00 ,  G06F17/30 ,  G06F16/2455 ,  G06F16/27

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.