-
公开(公告)号:US20210200765A1
公开(公告)日:2021-07-01
申请号:US16731100
申请日:2019-12-31
Applicant: Oracle International Corporation
IPC: G06F16/2453 , G06F16/27 , G06F9/52 , G06F9/48
Abstract: 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.
-
公开(公告)号:US12197443B2
公开(公告)日:2025-01-14
申请号:US18128914
申请日:2023-03-30
Applicant: Oracle International Corporation
Inventor: Sumit Sahu , Srinath Krishnaswamy , Krishna Mohan Itikarlapalli , Rajesh Kumar , Anoop J S
IPC: G06F16/00 , G06F16/2455
Abstract: 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.
-
3.
公开(公告)号:US20240330297A1
公开(公告)日:2024-10-03
申请号:US18128914
申请日:2023-03-30
Applicant: Oracle International Corporation
Inventor: Sumit Sahu , Srinath Krishnaswamy , Krishna Mohan Itikarlapalli , Rajesh Kumar , Anoop J S
IPC: G06F16/2455
CPC classification number: G06F16/24552
Abstract: 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.
-
公开(公告)号:US11947534B2
公开(公告)日:2024-04-02
申请号:US16731100
申请日:2019-12-31
Applicant: Oracle International Corporation
IPC: G06F16/2453 , G06F9/48 , G06F9/52 , G06F16/27
CPC classification number: G06F16/24532 , G06F9/485 , G06F9/52 , G06F16/27
Abstract: 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.
-
公开(公告)号:US11277435B2
公开(公告)日:2022-03-15
申请号:US15705113
申请日:2017-09-14
Applicant: Oracle International Corporation
Inventor: Krishna Mohan Itikarlapalli , Santanu Datta , Srinath Krishnaswamy , Lakshminarayanan Chidambaran , Rajesh Kumar , Sumit Sahu , Rajendra Pingte
Abstract: 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.
-
公开(公告)号:US20180077196A1
公开(公告)日:2018-03-15
申请号:US15705113
申请日:2017-09-14
Applicant: Oracle International Corporation
Inventor: Krishna Mohan Itikarlapalli , Santanu Datta , Srinath Krishnaswamy , Lakshminarayanan Chidambaran , Rajesh Kumar , Sumit Sahu , Rajendra Pingte
IPC: H04L29/06
CPC classification number: H04L63/1441 , G06F9/547 , G06F16/00 , H04L63/0245 , H04L63/102
Abstract: 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.
-
-
-
-
-