公开(公告)号：WO2021051138A1

公开(公告)日：2021-03-18

申请号：PCT/US2020/070533

申请日：2020-09-11

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： EADON, George ,  KUMAR, Ramesh ,  RAGHAVAN, Ananth

IPC: G06F7/00 ,  G06F17/30

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.

公开(公告)号：WO2020082008A1

公开(公告)日：2020-04-23

申请号：PCT/US2019/057046

申请日：2019-10-18

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LAHIRI, Tirthankar ,  REAMES, Martin ,  MAKINO, Kao ,  RAGHAVAN, Ananth ,  WANG, Chih-Ping ,  KOGAWA, Mutsumi ,  GARCIA, Jorge Luis Issa

IPC: G06F16/23

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 modifying the surviving data in NVRAM, rather than loading a checkpoint 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 stored in the NVRAM, this form of recovery is referred to herein as in-memory-based recovery.

公开(公告)号：EP3365812A1

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

申请号：EP16790823.5

申请日：2016-10-19

Applicant: Oracle International Corporation

Inventor： BAER, Hermann ,  KUMAR, Ramesh ,  RAGHAVAN, Ananth

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30486

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.

公开(公告)号：EP4028870A1

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

申请号：EP20862332.2

申请日：2020-09-11

Applicant: Oracle International Corporation

Inventor： EADON, George ,  KUMAR, Ramesh ,  RAGHAVAN, Ananth

IPC: G06F7/00