Oracle International Corporation

Krishna Mohan Itikarlapalli

Srinath Krishnaswamy

Sumit Sahu

Lakshminarayanan Luxi Chidambaran

Amit Bande

Sreekumar K Seshadri

Debashish Chatterjee

Rajesh Kumar

Kevin S Neel

Ravi Shankar Thammaiah

Rajendra Pingte

Jonathan Giloni

Santanu Datta

Anoop J S

Scot McKinley

Varun Kumar Arora

Lakshminarayanan Chidambaran

Disclosed is an improved approach to implement cursor sharing in database systems, where a server-side mapping of cursor identifiers to SQL is maintained to allow for continued use of client-side statement caches even after connections and database sessions are returned to shared pools and then subsequently re-assigned. This avoids the need to clear the statement cache across session releases to the database session pools. Instead, applications can retain their statement cache while still leveraging the benefits of server based pooling solutions.

Using statement caching when implementing server based or proxy based pooling solutions

A server system provided according to an aspect of the present disclosure provides a shared connection pool to parallel execution entities accessing database instances of a distributed database when processing requests. A shared connection pool implies that each pool connection of the connection pool may be used for serving different execution entities requiring access to different database instances. In an embodiment, the database instances correspond to shards together implementing a distributed database, and the parallel execution entities correspond to threads.

Connection pools for parallel processing applications accessing distributed databases

Techniques described herein improve database security by reducing network attack surface area in conjunction with deep input validation. In an embodiment, a database session receives one or more network packets sent via a network, the database session including a database session state that specifies one or more database privileges. The database session reads said one or more network packets into one or more request-packet-buffers, wherein said one or more request-packet-buffers include an RPC op code for a database operation. Based on the one or more database privileges associated with the user associated with the database session, the database session determines whether the RPC op code may be executed. In response to determining that the RPC op code may be executed by said database session, the RPC op code is executed. In response to determining that the op code may not be executed by said database session, the execution of the RPC op code is prevented.

Reducing network attack surface area for a database using deep input validation

An aspect of the present invention simplifies the implementation of custom atomic transactions. A program logic (implementing a custom atomic transaction) may request a unique transaction identifier from a programming environment. The program logic may then specify a task procedure, corresponding roll-back procedures, and the transaction identifier using an interface provided by the programming environment. The programming environment keeps track of the specified roll-back procedures. The information maintained by the programming environment may be used to execute the roll-back procedures if the atomic transaction is to be aborted. As the programming environment keeps track of the roll-back procedures to be executed, the implementation of atomic transactions may be simplified.

Simplifying implementation of custom atomic transactions in a programming environment

A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.

Server-side connection resource pooling

A net traffic optimization method provides for clients and servers to communicate with each other over a busy network. Each client process will make an Oracle database service request that is recognized by a listener process in the servers. As each database instance comes up, it generates a globally unique instance identifier ('UII'). Each UII remains valid as long as the database instance that generated it is running. The same UII identifier is given to every client needing a connection to that particular instance. Client processes can simultaneously or sequentially connect to database instances, and must never see the same UII being used to identify two different instances.

Globally unique instance identification

In transferring data from/to a database server, the size of a network buffer used by a network layer is dynamically adjusted according to the call type and expected size of data to be transferred for the call. Due to such use of appropriate buffer size, throughput performance of the transfer may be enhanced.

Growing community of inventors

Bengaluru, India

Krishna Mohan Itikarlapalli