公开(公告)号：US20180060177A1

公开(公告)日：2018-03-01

申请号：US15244867

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F11/14 ,  G06F17/30

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.

公开(公告)号：US20200183792A1

公开(公告)日：2020-06-11

申请号：US16791091

申请日：2020-02-14

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F11/14 ,  G06F16/11 ,  G06F16/21

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.

公开(公告)号：US10733316B2

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

申请号：US15244395

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Sanket Jain ,  Kumar Rajamani ,  Andre Kruglikov

IPC: G06F16/21 ,  G06F21/62 ,  G06F16/22 ,  G06F16/2455 ,  G06F21/00 ,  G06F16/25

Abstract: Techniques are described herein for allowing a container DBMS to impose restrictions, on a per-pluggable-database basis, on operations based on the pluggable database to which the users that request the operations belong. In one embodiment, lockdown profiles can be created and mapped to pluggable databases. Lockdown profiles specify PDB-wide restrictions on operations. The restrictions may apply to all operations of a given type, may apply to specific features, may require use of specific parameter values, etc. All users that belong to a pluggable database are restricted by the restrictions specified in the lockdown profile to which their pluggable database is mapped, unless the lockdown profile has a user-specific exemption for them. Bitmaps and/or hash tables may be used to more quickly determine, at query runtime, whether a query violates any profile-specified restrictions. Execution of queries that violate any profile-specified restrictions is prevented.

公开(公告)号：US20170116435A1

公开(公告)日：2017-04-27

申请号：US15244395

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Sanket Jain ,  Kumar Rajamani ,  Andre Kruglikov

IPC: G06F21/62 ,  G06F17/30

CPC classification number: G06F21/6227 ,  G06F16/21 ,  G06F16/2255 ,  G06F16/24552 ,  G06F16/256 ,  G06F21/00 ,  G06F21/62

Abstract: Techniques are described herein for allowing a container DBMS to impose restrictions, on a per-pluggable-database basis, on operations based on the pluggable database to which the users that request the operations belong. In one embodiment, lockdown profiles can be created and mapped to pluggable databases. Lockdown profiles specify PDB-wide restrictions on operations. The restrictions may apply to all operations of a given type, may apply to specific features, may require use of specific parameter values, etc. All users that belong to a pluggable database are restricted by the restrictions specified in the lockdown profile to which their pluggable database is mapped, unless the lockdown profile has a user-specific exemption for them. Bitmaps and/or hash tables may be used to more quickly determine, at query runtime, whether a query violates any profile-specified restrictions. Execution of queries that violate any profile-specified restrictions is prevented.

公开(公告)号：US11550667B2

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

申请号：US16791091

申请日：2020-02-14

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/21 ,  G06F16/11

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.

公开(公告)号：US10579478B2

公开(公告)日：2020-03-03

申请号：US15244867

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F17/30 ,  G06F11/14 ,  G06F16/21 ,  G06F16/11

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.

公开(公告)号：US20200026608A9

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

申请号：US15244867

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F11/14 ,  G06F17/30

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.