公开(公告)号：US12298946B2

公开(公告)日：2025-05-13

申请号：US17966736

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Juan R. Loaiza ,  Sundeep Abraham ,  Shubha Bose ,  Hui Joe Chang ,  Shashank Gugnani ,  Beda Christoph Hammerschmidt ,  Tirthankar Lahiri ,  Ying Lu ,  Douglas James McMahon ,  Aurosish Mishra ,  Ajit Mylavarapu ,  Sukhada Pendse ,  Ananth Raghavan

IPC: G06F16/20 ,  G06F16/21 ,  G06F16/2453 ,  G06F16/84

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20250094412A1

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

申请号：US18885635

申请日：2024-09-14

Applicant: Oracle International Corporation

Inventor： Aurosish Mishra ,  Sukhada Shashank Pendse ,  Agnivo Saha ,  Rohan Aggarwal ,  Xianqi Wang ,  Shasank Kisan Chavan ,  Tirthankar Lahiri

IPC: G06F16/23 ,  G06F16/22

Abstract: Techniques for providing a transactionally-consistent Hierarchical Navigable Small Worlds (HNSW) index are described. In one technique, a HNSW index for a plurality of vectors is stored. In response to receiving a set of changes to the plurality of vectors, storing the set of changes in a shared journal table instead of applying the set of changes to the HNSW index. in response to receiving a vector query that includes a query vector, a subset of the set of changes in the shared journal table is identified based on the query vector. Also, based on the query vector and the HNSW index, a subset of the plurality of vectors is identified. A result of the vector query is generated based on the subset of the set of changes and the subset of the plurality of vectors.

公开(公告)号：US20240289318A1

公开(公告)日：2024-08-29

申请号：US18115663

申请日：2023-02-28

Applicant: Oracle International Corporation

Inventor： Sarat Inuguri ,  Kishy Kumar ,  Ajit Mylavarapu ,  Sue Kyong Lee ,  Manoj Dhanapal ,  Subrata Sen ,  Tirthankar Lahiri ,  Sanjay Singh ,  Mukul Pandey

IPC: G06F16/23 ,  G06F9/48

CPC classification number: G06F16/2343 ,  G06F9/4881

Abstract: Disclosed is an approach to autonomously abort a lower priority transaction that is blocking a higher priority transaction, where the lower priority transaction is holding a lock on a resource for which there is contention. Some approaches also provide an efficient way to implement identification of a blocker transaction, which drastically reduces the response time to abort the blocker transaction.

公开(公告)号：US11899651B2

公开(公告)日：2024-02-13

申请号：US17818271

申请日：2022-08-08

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Tirthankar Lahiri ,  Yunrui Li

IPC: G06F16/23 ,  G06F16/22

CPC classification number: G06F16/2365 ,  G06F16/22

Abstract: An approach is described to provide a method, a computer program product, and a computer system to implement hole punching. The described approach provides an automated way to free up space without requiring manual intervention by a DBA to manually reorganize database objects to free up space.

公开(公告)号：US20230281190A1

公开(公告)日：2023-09-07

申请号：US18117810

申请日：2023-03-06

Applicant: Oracle International Corporation

Inventor： Ajit Mylavarapu ,  Vasudha Krishnaswamy ,  Sukhada Pendse ,  Solmaz Kolahi ,  Ankita Kumar ,  Garret F. Swart ,  Juan R. Loaiza ,  Tirthankar Lahiri

IPC: G06F16/23 ,  G06F16/28

CPC classification number: G06F16/2379 ,  G06F16/285

Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.

公开(公告)号：US11657037B2

公开(公告)日：2023-05-23

申请号：US15253780

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Vasudha Krishnaswamy ,  Yunrui Li ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Mahesh B. Girkar ,  Sukhada Pendse ,  Kartik Kulkarni ,  Jing Zheng ,  Shruti Gautam ,  Henry Chau

IPC: G06F16/23 ,  G06F16/25 ,  G06F16/27

CPC classification number: G06F16/2379 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/258 ,  G06F16/27 ,  G06F16/275

Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

公开(公告)号：US20230050727A1

公开(公告)日：2023-02-16

申请号：US17974152

申请日：2022-10-26

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Allison L. Holloway ,  Meichun Hsu ,  Hideaki Kimura ,  Boris Klots ,  Vasudha Krishnaswamy ,  Kartik Kulkarni ,  Teck Hua Lee ,  Yunrui Li ,  Aurosish Mishra ,  Ajit Mylavarapu ,  Sukhada Pendse ,  Garret F. Swart ,  Shasank K. Chavan ,  Tirthankar Lahiri ,  Juan R. Loaiza

IPC: G06F16/22 ,  G06F16/27 ,  G06F16/21 ,  G06F16/174 ,  G06F16/18 ,  G06F16/23 ,  G06F16/11

Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.

公开(公告)号：US11347678B2

公开(公告)日：2022-05-31

申请号：US16055978

申请日：2018-08-06

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Juan R. Loaiza ,  Garret F. Swart ,  Jesse Kamp ,  Avneesh Pant ,  Hideaki Kimura

IPC: G06F9/54 ,  G06F15/173 ,  G06F15/167 ,  G06F9/455

Abstract: Techniques are provided to allow more sophisticated operations to be performed remotely by machines that are not fully functional. Operations that can be performed reliably by a machine that has experienced a hardware and/or software error are referred to herein as Remote Direct Memory Operations or “RDMOs”. Unlike RDMAs, which typically involve trivially simple operations such as the retrieval of a single value from the memory of a remote machine, RDMOs may be arbitrarily complex. The techniques described herein can help applications run without interruption when there are software faults or glitches on a remote system with which they interact.

公开(公告)号：US20220114192A1

公开(公告)日：2022-04-14

申请号：US17123405

申请日：2020-12-16

Applicant: Oracle International Corporation

Inventor： William H. Bridge, JR. ,  David Brower ,  Meichun Hsu ,  Boris Klots ,  Neil J S Macnaughton, JR. ,  Ajit Mylavarapu ,  Umesh Panchaksharaiah ,  Garret F. Swart ,  Tirthankar Lahiri ,  Juan R. Loaiza

IPC: G06F16/27 ,  G06F16/901 ,  G06F15/173

Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.

公开(公告)号：US20220114058A1

公开(公告)日：2022-04-14

申请号：US17137745

申请日：2020-12-30

Applicant: Oracle International Corporation

Inventor： Ajit Mylavarapu ,  Vasudha Krishnaswamy ,  Sukhada Pendse ,  Solmaz Kolahi ,  Ankita Kumar ,  Garret F. Swart ,  Tirthankar Lahiri ,  Juan R. Loaiza

IPC: G06F11/14 ,  G06F16/22

Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.