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

公开(公告)号：US10360209B2

公开(公告)日：2019-07-23

申请号：US15267118

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： George Eadon ,  Ananth Raghavan ,  Ramesh Kumar

IPC: G06F16/00 ,  G06F16/2452 ,  G06F16/2453

Abstract: A method commences upon receiving a database language statement pertaining to a database comprising database objects that are accessed by computing processes. The method analyzes the database language statement to form or identify a cursor object that has dependencies on one or more referenced data objects. The cursor object is associated with a set of cursor attributes that are stored in a cursor metadata data structure. By analyzing a subsequently-received database language statement, the method determines one or more operations to operate over at least one of the data objects. Rules are applied to the cursor attributes and/or to the operations and/or to objects referenced in the cursor so as to determine whether or not to invalidate the cursor object. The cursor may be considered at a later time for possible later invalidation or revalidation based on processing of later received database language statements and/or based on a later event.

公开(公告)号：US20180253425A1

公开(公告)日：2018-09-06

申请号：US15967207

申请日：2018-04-30

Applicant: Oracle International Corporation

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

IPC: G06F17/30

CPC classification number: G06F16/214

Abstract: Techniques are provided for moving data between partitions. Such a process may be performed without requiring any locks that block transactions that target a partition from being executed. Instead, such transactions may proceed while a move operation is being performed. The move operation involves copying data from the targeted partition to another partition that is hidden from (or “invisible” to) those transactions that attempt to read from or write to the partition. During the move operation, changes that are made to the partition are also reflected in a journal. Eventually, the changes reflected in the journal are drained and applied to the hidden partition. Once the partition and the hidden partition are synchronized, the identities of the partitions are swapped so that future transactions will target the previously-hidden partition instead of the previously-viewable partition.

公开(公告)号：US20150302035A1

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

申请号：US14255425

申请日：2014-04-17

Applicant: Oracle International Corporation

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

IPC: G06F17/30

CPC classification number: G06F17/30321 ,  G06F17/30312 ,  G06F17/30613

Abstract: Techniques for creating and using partial indexes are provided. A partial index is an index that indexes one or more partitions of a partitioned table and does not index one or more other partitions of the partitioned table. Thus, if a partition of a partitioned table is rarely used, then an index may index all other partitions of the partitioned table or at least only those partitions that are written to or read from relatively frequently. Also, in preparation for loading data into a partition, indexing for the partition may be “turned off”, effectively making a full index a partial index. While the data is loaded into the partition, the partial index is still available for query processing. After the data is loaded into the partition, indexing for the partition is “turned on”, which causes the data in the partition to be indexed by the partial index.

Abstract translation: 提供了创建和使用部分索引的技术。 部分索引是对分区表的一个或多个分区进行索引并且不对分区表的一个或多个其他分区进行索引的索引。 因此，如果分区表的分区很少被使用，则索引可能会对分区表的所有其他分区或至少只对那些被相对频繁地写入或读取的分区进行索引。 另外，在准备将数据加载到分区中时，分区的索引可能被“关闭”，有效地使完整索引成为部分索引。 当数据加载到分区中时，部分索引仍然可用于查询处理。 在将数据加载到分区之后，分区的索引被“打开”，这导致分区中的数据被部分索引索引。

公开(公告)号：US11360802B2

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

申请号：US16887980

申请日：2020-05-29

Applicant: Oracle International Corporation

Inventor： Ramesh Kumar ,  Ananth Raghavan ,  George Eadon

IPC: G06F16/22 ,  G06F9/46 ,  G06F16/23

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.

公开(公告)号：US20210103569A1

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

申请号：US17125777

申请日：2020-12-17

Applicant: Oracle International Corporation

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

IPC: G06F16/21

Abstract: Techniques are provided for moving data between partitions. Such a process may be performed without requiring any locks that block transactions that target a partition from being executed. Instead, such transactions may proceed while a move operation is being performed. The move operation involves copying data from the targeted partition to another partition that is hidden from (or “invisible” to) those transactions that attempt to read from or write to the partition. During the move operation, changes that are made to the partition are also reflected in a journal. Eventually, the changes reflected in the journal are drained and applied to the hidden partition. Once the partition and the hidden partition are synchronized, the identities of the partitions are swapped so that future transactions will target the previously-hidden partition instead of the previously-viewable partition.

公开(公告)号：US10929360B2

公开(公告)日：2021-02-23

申请号：US15266863

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Hermann Baer ,  Ananth Raghavan

IPC: G06F16/215 ,  G06F16/9535 ,  G06F16/2455 ,  G06F16/335

Abstract: A database engine performs row filtering operations concurrently with performing database object partition maintenance operations. The filtering operations do not incur the high processing costs of database delete or purge operations that would incur per row costs for logging, locking, etc. The partitioning and filtering operations are specified in multiple clauses of a single database language statement. The clauses of the statement are executed concurrently. A method implementation receives a database language statement that comprises a partitioning operation specification as well as a filtering operation specification that includes a logical predicate for determining whether or not to filter-out predicate-matching entries when forming the resulting partitioned target database object. While processing the partitioning operations, the method discards entries taken from the source database object whenever the entry corresponds to the logical predicate. The target database object contains some entries that derive from the source, but does not contain the discarded entries.

公开(公告)号：US10417257B2

公开(公告)日：2019-09-17

申请号：US15267540

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Ramesh Kumar ,  Ananth Raghavan ,  George Eadon

IPC: G06F16/27 ,  G06F16/21

Abstract: Systems for managing large database systems. Storage devices hold a set of one or more subject database tables that hold subject data accessed by one or more users. A data definition statement to perform a table alteration operation (e.g., a table partition operation) over a particular table in the subject database is received, parsed, and the table alteration operation over the particular table is initiated. During the processing of the data definition statement to complete the table alteration operation, a data manipulation statement to perform a table access operation over the same table is received and parsed. The data manipulation statement is not blocked, even while the table alteration operations are ongoing. Rather, during the time that the table alteration operations are ongoing, the data manipulation statement is processed using hidden tables. After the table alteration operations have completed, incoming data manipulation statements are performed over the altered database tables.

公开(公告)号：US09507825B2

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

申请号：US14245909

申请日：2014-04-04

Applicant: Oracle International Corporation

Inventor： Hermann Baer ,  Mohamed Ziauddin ,  Ananth Raghavan

IPC: G06F17/30

CPC classification number: G06F17/30486 ,  G06F17/30339 ,  G06F17/30463

Abstract: Techniques for partition pruning based on aggregated zone map information. In one embodiment, for example, a method for pruning partitions based on aggregated zone map information comprises: receiving a query statement comprising a filter predicate on a column of a database table; and pruning one or more partitions of the database table from access paths for processing the query statement based on determining, based on aggregated zone map information associated with the one or more partitions, that the filter predicate cannot be satisfied by data stored in the one or more partitions.

Abstract translation: 基于聚合区域地图信息的分割修剪技术。 在一个实施例中，例如，基于聚合的区域映射信息来修剪分区的方法包括：在数据库表的列上接收包括过滤谓词的查询语句; 以及基于根据与所述一个或多个分区相关联的聚合区域映射信息确定所述过滤谓词不能由存储在所述一个或多个分区中的数据来满足所述数据库表的一个或多个分区，以从所述访问路径修剪所述数据库表的一个或多个分区，以处理所述查询语句 更多的分区。

公开(公告)号：US10970260B2

公开(公告)日：2021-04-06

申请号：US15967207

申请日：2018-04-30

Applicant: Oracle International Corporation

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

IPC: G06F16/21

Abstract: Techniques are provided for moving data between partitions. Such a process may be performed without requiring any locks that block transactions that target a partition from being executed. Instead, such transactions may proceed while a move operation is being performed. The move operation involves copying data from the targeted partition to another partition that is hidden from (or “invisible” to) those transactions that attempt to read from or write to the partition. During the move operation, changes that are made to the partition are also reflected in a journal. Eventually, the changes reflected in the journal are drained and applied to the hidden partition. Once the partition and the hidden partition are synchronized, the identities of the partitions are swapped so that future transactions will target the previously-hidden partition instead of the previously-viewable partition.