公开(公告)号：US20170344593A1

公开(公告)日：2017-11-30

申请号：US15169013

申请日：2016-05-31

Applicant: Oracle International Corporation

Inventor： Atrayee Mullick ,  Niloy Mukherjee ,  Sanket Hase ,  Tirthankar Lahiri ,  Juan Loaiza

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F16/2329 ,  G06F11/1446 ,  G06F11/1451 ,  G06F16/128 ,  G06F16/1873 ,  G06F16/2358 ,  G06F16/24552 ,  G06F16/258 ,  G06F16/273 ,  G06F2201/80 ,  G06F2201/84

Abstract: Techniques for non-disruptive versioning of in-memory units in a database are provided. A database server generates and maintains a first IMU that reflects changes made to a mirrored-data-set up to a first snapshot time, and a second IMU that reflects changes made to the mirrored-data-set up to a second snapshot time. During a first period, the database server responds to updates to first data items in the mirrored data by storing first staleness metadata that indicates that the copies of the first data items in the first IMU are stale. During a second period, the database server responds to updates to second data items in the mirrored data by storing second staleness metadata that indicates that the copies of the second data items in the second IMU are stale. The database server responds to a request by accessing the first IMU or the second IMU.

公开(公告)号：US20170255675A1

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

申请号：US15602009

申请日：2017-05-22

Applicant: Oracle International Corporation

Inventor： Shasank K. Chavan ,  Dina Thomas ,  Ajit Mylavarapu ,  Prashant Gaharwar ,  Tirthankar Lahiri ,  Jesse Kamp

IPC: G06F17/30

Abstract: Techniques are described for encoding join columns that belong to the same domain with a common dictionary. The tables are encoded with dictionary indexes that make the comparison operation of a join query a quick equality check of two integers and there is no need to compute any hashes during execution. Additionally, the techniques described herein minimize the bloom filter creation and evaluation cost as well because the dictionary indexes serve as hash values into the bloom filter. If the bloom filter is as large as the range of dictionary indexes, then the filter is no longer a probabilistic structure and can be used to filter rows in the probe phase with full certainty without any significant overhead.

公开(公告)号：US20170031975A1

公开(公告)日：2017-02-02

申请号：US15146799

申请日：2016-05-04

Applicant: Oracle International Corporation

Inventor： Aurosish Mishra ,  Shasank K. Chavan ,  Allison L. Holloway ,  Jesse Kamp ,  Ramesh Kumar ,  Zhen Hua Liu ,  Niloy Mukherjee ,  Amit Ganesh ,  Tirthankar Lahiri ,  Vineet Marwah

IPC: G06F17/30

CPC classification number: G06F17/30383 ,  G06F17/30339 ,  G06F17/3046 ,  G06F17/30477

Abstract: Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.

Abstract translation: 描述了用于实现预先计算的表达式结果的技术。 在一个实施例中，一组一个或多个列单元存储在易失性或非易失性存储器中。 每个列单元对应于属于由数据库服务器实例管理的数据库中的磁盘表上的列，并包括来自相应列的数据项。 一组一个或多个虚拟列单元以及将一个或多个列单元的集合与一个或多个虚拟列单元的集合相关联的数据也存储在存储器中。 一个或多个虚拟列单元的集合包括存储通过评估磁盘表的至少一列上的表达而导出的结果的特定虚拟列单元。

公开(公告)号：US20130046731A1

公开(公告)日：2013-02-21

申请号：US13627370

申请日：2012-09-26

Applicant: Oracle International Corporation

Inventor： Sourav Ghosh ,  Ashish Motivala ,  Charles Hoch ,  Rohan Aranha ,  Ben Fulton ,  Andrey Gusev ,  Tirthankar Lahiri ,  Juan Tellez

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F11/2025 ,  G06F11/2028 ,  G06F11/2038 ,  G06F11/2097 ,  G06F2201/80

Abstract: A cluster manager manages copies of a mid-tier database as a mid-tier database cluster. The cluster manager may concurrently manage a backend database system. The cluster manager is configured to monitor for and react to failures of mid-tier database nodes. The cluster manager may react to a mid-tier database failure by, for example, assigning a new active node, creating a new standby node, creating new copies of the mid-tier databases, implementing new replication or backup schemes, reassigning the node's virtual address to another node, or relocating applications that were directly linked to the mid-tier database to another host. Each node or an associated agent may configure the cluster manager during initialization, based on common cluster configuration information. Each copy of the mid-tier database may be, for example, a memory resident database. Thus, a node must reload the entire database into memory to recover a copy of the database.

Abstract translation: 集群管理器将中间层数据库的副本作为中间层数据库集群管理。 集群管理器可以同时管理后端数据库系统。 集群管理器配置为监视中层数据库节点的故障并对其做出反应。 集群管理器可以通过例如分配新的活动节点，创建新的备用节点，创建中间层数据库的新副本，实现新的复制或备份方案来对中间层数据库故障作出反应，重新分配节点的虚拟 地址到另一个节点，或将直接链接到中间层数据库的应用程序重新定位到另一个主机。 每个节点或相关联的代理可以基于常见的集群配置信息在初始化期间配置集群管理器。 中间层数据库的每个副本可以是例如内存驻留数据库。 因此，节点必须将整个数据库重新加载到内存中以恢复数据库的副本。

公开(公告)号：US12287777B2

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

申请号：US17966730

申请日：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/00 ,  G06F16/23 ,  G06F16/2455

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.

公开(公告)号：US20250094400A1

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

申请号：US18885640

申请日：2024-09-14

Applicant: Oracle International Corporation

Inventor： Aurosish Mishra ,  Shasank Kisan Chavan ,  Agnivo Saha ,  Shubha Bose ,  Chinmayi Krishnappa ,  Tirthankar Lahiri

IPC: G06F16/22

Abstract: Techniques for deploying a vector index on multiple nodes of a cluster are provided. In one technique, an instruction is received to create a vector index on a set of vectors that is stored in a vector database that is connected to the multiple nodes. In response, an HNSW index is created based on the set of vectors and the HNSW index is stored on each node. In response to receiving a vector query, a node processes the vector query against its copy of the HNSW index. In another technique, each node retrieves, from a vector database, a respective subset of a set of vectors and generates, based on the respective subset, a respective HNSW index. A vector query is transmitted to each node, which traverses its HNSW index to generate results of the vector query. The results from each node are combined to generate final results.

公开(公告)号：US20250094294A1

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

申请号：US18884628

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Natesh Kedlaya ,  Sukhada Pendse ,  Ajit Mylavarapu ,  Tirthankar Lahiri ,  Carol Lyndall Colrain ,  Xiaoli Qi ,  Juan R. Loaiza

IPC: G06F11/14 ,  G06F16/23

Abstract: Techniques are described for Transaction Guard to impose at-most-once execution by generating and using the database's native transaction identifier, DB XID. In an implementation, DB XID is unique within a (pluggable) database instance (with local undo) and uniquely identifies a transaction in the database. The Transaction Guard that is extended to use native transaction information determines the commit outcome using the native transaction identifier of the transaction instead of relying on the persistence of the Logical Transaction Identifier (LTXID) in a separate table. Using the native transaction identifier, the Transaction Guard significantly improves performance by eliminating the extra write(s) incurred during commit operations.

公开(公告)号：US12147398B2

公开(公告)日：2024-11-19

申请号：US18115629

申请日：2023-02-28

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Srikrishnan Suresh ,  Beda Christoph Hammerschmidt ,  Adrian Daniel Popescu ,  Jesse Kamp ,  Zhen Hua Liu

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/23 ,  G06F16/25

Abstract: A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.

公开(公告)号：US20240273087A1

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

申请号：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

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.

公开(公告)号：US11983170B2

公开(公告)日：2024-05-14

申请号：US18117810

申请日：2023-03-06

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

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.