Patent · US Active

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

US12197443B2 · kind B2 · utility

0Cited by

2References

21Claims

0Family size

Assignee

Oracle International Corporation · US

Inventors

Sumit Sahu · Kanchinakote, IN
Srinath Krishnaswamy · Redwood City, US
Krishna Mohan Itikarlapalli · Bengaluru, IN
Rajesh Kumar · Palo Alto, US
Anoop J S · Bengaluru, IN

Key dates

Filing date	Mar 30, 2023
Grant date	Jan 14, 2025
Priority date	—
Expiry date	Mar 30, 2043

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24553
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.