公开(公告)号：US12271372B2

公开(公告)日：2025-04-08

申请号：US18633209

申请日：2024-04-11

Applicant: Oracle International Corporation

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

IPC: G06F16/23 ,  G06F16/28

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.

公开(公告)号：US20250094399A1

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

申请号：US18885639

申请日：2024-09-14

Applicant: Oracle International Corporation

Inventor： Aurosish Mishra ,  Shasank Kisan Chavan ,  Tirthankar Lahiri ,  Agnivo Saha ,  Rohan Aggarwal ,  Weiwei Gong ,  Juan R. Loaiza

IPC: G06F16/22

Abstract: Techniques for automatically selecting a type of vector index are provided. In one technique, in response to determining to generate a vector index based on a base table that stores a plurality of vectors, a number of the plurality of vectors is identified. Based at least on the number of the plurality of vectors, a particular type of vector index is identified from among a plurality of types of vector indexes. Examples of the plurality of types include an HNSW index and an IVF index. A vector index of the particular type is generated for the base table. Another criterion in identifying a type of vector index to generate is the number of neighbors that is a parameter in generating a certain type of vector index.

公开(公告)号：US20240126763A1

公开(公告)日：2024-04-18

申请号：US18099034

申请日：2023-01-19

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Juan R. Loaiza ,  Beda Christoph Hammerschmidt ,  Andrew Witkowski ,  Sankar Subramanian ,  Sabina Petride ,  Ajit Mylavarapu ,  Gerald Venzl

IPC: G06F16/2455 ,  G06F16/22

CPC classification number: G06F16/24565 ,  G06F16/221 ,  G06F16/24554

Abstract: Disclosed herein are techniques for storing, within a database system, metadata that indicates an intended usage (IU). Once created, an IU may be assigned to a column to (a) indicate how the column is intended to be used, and (b) affect how the database server behaves when database operations involve values from the column. The IU assigned to a column supplements, but does not replace, the datatype definition for the column. Each IU may have an IU-bundle. The IU-bundle of an IU indicates how the database server behaves with respect to any column that is assigned the IU. For example, the IU-bundle may indicate constraints that the database server must validate during operations on values from columns assigned to the IU. Techniques are also described for implementing multi-column IUs and flexible IUs.

公开(公告)号：US20240111790A1

公开(公告)日：2024-04-04

申请号：US18373082

申请日：2023-09-26

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Hariharan Lakshmanan ,  Sujatha Muthulingam ,  Andrew Witkowski ,  Shasank Kisan Chavan ,  You Jung Kim ,  Sooyeon Jo ,  Yu Chieh Fu ,  Vicente Hernandez Jimenez ,  Tirthankar Lahiri

IPC: G06F16/28 ,  G06F16/22 ,  G06F16/25

CPC classification number: G06F16/285 ,  G06F16/2219 ,  G06F16/258

Abstract: Techniques are provided for optimizing storage of database records in segments using sub-segments. A base segment is a container used for storing records that belong to a database object. A database management system receives a request to load, into the database object, a first set of records that are in a first state. In response to receiving the request, the system generates a new sub-segment, which is a container that is separate from the base segment. The system stores the first set of records, in their first state, within the sub-segment. The system then monitors one or more characteristics of the database system. In response to the one or more characteristics satisfying criteria, the system performs a migration of one or more records of the first set of records from the sub-segment to the base segment. During the migration, the system converts the one or more records from the first state to a second state and stores the one or more records, in their second state, in the base segment.

公开(公告)号：US11675761B2

公开(公告)日：2023-06-13

申请号：US16135748

申请日：2018-09-19

Applicant: Oracle International Corporation

Inventor： Roger Dermot Macnicol ,  Xia Hua ,  Allison Holloway ,  Shasank Kisan Chavan ,  Jesse Kamp ,  Maria Colgan ,  Tirthankar Lahiri

IPC: G06F16/22 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/21 ,  G06F16/248

CPC classification number: G06F16/221 ,  G06F16/219 ,  G06F16/2237 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/256

Abstract: Techniques herein use in-memory column vectors to process data that is external to a database management system (DBMS) and logically join the external data with data that is native to the DBMS. In an embodiment, a computer maintains a data dictionary for native data that is durably stored in an DBMS and external data that is not durably stored in the DBMS. From a client through a connection to the DBMS, the computer receives a query. The computer loads the external data into an in-memory column vector that resides in random access memory of the DBMS. Based on the query and the data dictionary, the DBMS executes a data join of the in-memory column vector with the native data. To the client through said connection, the computer returns results of the query based on the data join.

公开(公告)号：US11550771B2

公开(公告)日：2023-01-10

申请号：US17070277

申请日：2020-10-14

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.

公开(公告)号：US11514029B2

公开(公告)日：2022-11-29

申请号：US17136568

申请日：2020-12-29

Applicant: Oracle International Corporation

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

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/21

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.

公开(公告)号：US20200042489A1

公开(公告)日：2020-02-06

申请号：US16055978

申请日：2018-08-06

Applicant: Oracle International Corporation

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

IPC: G06F15/167 ,  G06F15/173 ,  G06F9/54 ,  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.

公开(公告)号：US10528580B2

公开(公告)日：2020-01-07

申请号：US15008297

申请日：2016-01-27

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Kartik Kulkarni ,  Tirthankar Lahiri ,  Vineet Marwah ,  Juan Loaiza

IPC: G06F17/30 ,  H04L12/24 ,  G06F16/2458 ,  H04L12/26

Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve redistributing the in-memory database object portions on changes to the clustered database system. Each node may maintain a mapping indicating which nodes in the clustered database system store which chunks, and timestamps indicating when each mapping entry was created or updated. A query coordinator may use the timestamps to select a database server instance with local in memory access to data required by a portion of a query to process that portion of the query.

公开(公告)号：US10372699B2

公开(公告)日：2019-08-06

申请号：US15264978

申请日：2016-09-14

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Solmaz Kolahi ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Vasudha Krishnaswamy ,  Sanket Hase

IPC: G06F16/23

Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.