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

公开(公告)号：US20170302673A1

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

申请号：US15635418

申请日：2017-06-28

Applicant: Oracle International Corporation

Inventor： Vadim Makhervaks ,  Richard Mousseau ,  Bjørn Dag Johnsen ,  Sumanta Chatterjee ,  Avneesh Pant ,  Jean De Lavarene ,  Kant C. Patel ,  Bhaskar Mathur ,  Feroz Alam Khan ,  Sudeep Vatsanath Reguna

IPC: H04L29/06

CPC classification number: H04L63/101 ,  H04L63/0236 ,  H04L63/0254 ,  H04L63/1458 ,  H04L63/20

Abstract: An integrated firewall provides security in a multi-tenant environment having a connection-based switched fabric directly connecting database servers which provide a plurality of database services with application servers hosting database service consumers each having a different database service consumer identity. The firewall functionality integrated into each database server provides access control by discarding communication packets which do not include a database service consumer identity and using the database service consumer identity in combination with an access control list to control access from the database service consumers to the database services. The access control includes address resolution access control, connection establishment access control, and data exchange access control based on said access control list. The integrated firewall enables direct connection of database servers and application servers via an InfiniBand network providing without requiring a separate intermediary firewall appliance or security node.

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

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

IPC: G06F16/27 ,  G06F16/21 ,  H04L29/08

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.

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

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

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