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

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

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

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

公开(公告)号：US10282437B2

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

申请号：US14255425

申请日：2014-04-17

Applicant: Oracle International Corporation

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

IPC: G06F17/30

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.

公开(公告)号：US20150347401A1

公开(公告)日：2015-12-03

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

Abstract translation: 提供了在分区之间移动数据的技术。 可以执行这样的过程，而不需要阻止目标分区的事务被执行的任何锁。 相反，这样的事务可以在执行移动操作时进行。 移动操作涉及将数据从目标分区复制到另一个从（或“不可见”）隐藏到分区尝试读取或写入的那些事务的分区。 在移动操作期间，对分区进行的更改也会反映在日志中。 最终，日志中反映的变化被排除并应用于隐藏的分区。 一旦分区和隐藏的分区被同步，分区的标识被交换，以便将来的事务将针对先前隐藏的分区，而不是以前可视的分区。

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

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