公开(公告)号：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.

公开(公告)号：US11531704B2

公开(公告)日：2022-12-20

申请号：US16948303

申请日：2020-09-11

Applicant: Oracle International Corporation

Inventor： George Eadon ,  Ramesh Kumar ,  Ananth Raghavan

IPC: G06F16/901 ,  G06F16/903

Abstract: What is disclosed is an improved approach to perform automatic partitioning, without requiring any expertise on the part of the user. A three stage processing pipeline is provided to generate candidate partition schemes, to evaluate the candidate using real table structures that are empty, and to then implement a selected scheme with production data for evaluation. In addition, an improved approach is described to perform automatic interval partitioning, where the inventive concept implements interval partitioning that does not impose these implicit constraints on the partition key column.

公开(公告)号：US11334445B2

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

申请号：US16232860

申请日：2018-12-26

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin Reames ,  Kao Makino ,  Ananth Raghavan ,  Chih-Ping Wang ,  Mutsumi Kogawa ,  Jorge Luis Issa Garcia

IPC: G06F16/23 ,  G06F11/14

Abstract: In an in-memory database management system, non-volatile random access memories (NVRAMs) are used to store database data and control data. Because this data is stored in NVRAM, the data survives system failures. Recovery from a system failure may be accomplished more quickly by, at least in part, modifying the surviving data in NVRAM, rather than loading an entire checkpoint image and applying uncheckpointed transactions needed to synchronize the database. Because in this form of recovery the database state that serves as the starting point for applying change records is the database as stored in the NVRAM, this form of recovery is referred to herein as in-memory-based recovery. Recovery, where the database state that serves as the starting point for applying change records is a checkpoint image, is referred to herein as checkpointed-based recovery. In-memory-based recovery eliminates or reduces the need to perform certain operations that are performed for checkpointed-based recovery.

公开(公告)号：US20150278327A1

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

申请号：US14231438

申请日：2014-03-31

Applicant: Oracle International Corporation

Inventor： Ananth Raghavan ,  George Eadon ,  Ramesh Kumar ,  Hermann Baer ,  Suresh Sridharan

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30339 ,  G06F9/466

Abstract: Techniques for maintaining a global index in response to a partition being dropped are provided. In response to an instruction to drop a partition, partition identification data that identifies the partition is stored. Index entries, in the global index, that correspond to the dropped partition become “orphaned” entries. Later, an execution plan for a query is processed, where the execution plan targets a global index. During execution of the execution plan, one or more index entries are accessed. For each accessed index entry, the partition identification data is analyzed to determine if the index entry is an orphaned entry. If so, then the index entry is ignored for purposes of the query. Later, the global index may be updated to delete each orphaned entry. Such deletion may occur much later, such as during a time when the database is not queried or updated frequently.

Abstract translation: 提供了用于维护响应于正在丢弃的分区的全局索引的技术。 响应于删除分区的指令，存储识别分区的分区标识数据。 在全局索引中，对应于删除的分区的索引条目将成为“孤立”条目。 之后，处理查询的执行计划，其中执行计划定位到全局索引。 在执行计划的执行期间，访问一个或多个索引条目。 对于每个访问的索引条目，分析分区标识数据以确定索引条目是否是孤立条目。 如果是这样，则为了查询的目的，忽略索引条目。 之后，可能会更新全局索引以删除每个孤立的条目。 这种删除可能发生得更晚，例如在数据库未被查询或频繁更新的时间内。

公开(公告)号：US20150278275A1

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

申请号：US14231416

申请日：2014-03-31

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ramesh Kumar ,  Ananth Raghavan ,  George Eadon

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F9/466 ,  G06F16/22 ,  G06F16/2308

Abstract: Techniques for processing “destructive” database statements are provided. Destructive database statements, when processed, cause metadata of a database object to be changed. Examples of such database statements include ones that delete an index, that set a column as unused, and that drop a constraint on a column. When such a statement is received, a change is made to metadata of a database object. Such a metadata change may involve setting an index as unusable, disabling a constraint, or invalidating a cursor. After the metadata change, a first time is determined. Then, it is determined when one or more database transactions that were pending at the first time have committed. After those database transaction(s) have committed, one or more operations are performed, such as dropping an index or dropping a constraint.

Abstract translation: 提供了处理“破坏性”数据库语句的技术。 破坏性数据库语句在处理时会导致要更改数据库对象的元数据。 这样的数据库语句的示例包括删除索引，将列设置为未使用的列，并删除列上的约束。 当收到这样的语句时，会对数据库对象的元数据进行更改。 这样的元数据改变可能涉及将索引设置为不可用，禁用约束或使游标无效。 元数据更改后，首次确定。 然后，确定在第一次挂起的一个或多个数据库事务已经提交。 在这些数据库事务已经提交之后，执行一个或多个操作，例如删除索引或删除约束。