公开(公告)号：US12072854B2

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

申请号：US17125777

申请日：2020-12-17

Applicant: Oracle International Corporation

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

IPC: G06F16/21

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.

公开(公告)号：US10657116B2

公开(公告)日：2020-05-19

申请号：US15228831

申请日：2016-08-04

Applicant: Oracle International Corporation

Inventor： Hermann Baer ,  Ramesh Kumar ,  Ananth Raghavan

IPC: G06F17/30 ,  G06F16/22 ,  G06F16/2455

Abstract: Techniques are described herein for creating a new database table for an exchange operation with a table partition of another table. A database management system (DBMS) is configured to receive a query such as “CREATE TABLE new_table FOR EXCHANGE FROM partition_P1”. The DBMS then identifies properties of the source partition (e.g., partition P1) and creates a new database table based on the properties identified. Some of these properties (e.g., hidden columns, data modeling frameworks, and table statistics) may not otherwise be directly accessible by the external entity that sent the query. The newly created table then has all of the necessary properties to be part of the other table if swapped with the source partition in an exchange operation.

公开(公告)号：US09965497B2

公开(公告)日：2018-05-08

申请号：US14289926

申请日：2014-05-29

Applicant: Oracle International Corporation

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

IPC: G06F17/30

CPC classification number: G06F17/303

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.

公开(公告)号：US09489413B2

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

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

公开(公告)号：US20150286681A1

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

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