公开(公告)号：US20200004838A9

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

申请号：US15266902

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Debaditya Chatterjee

IPC: G06F17/30 ,  G06F9/445

Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.

公开(公告)号：US20180075086A1

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

申请号：US15266917

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Philip Yam ,  Thomas Baby ,  Andre Kruglikov ,  Kumar Rajamani

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F16/2379 ,  G06F8/65 ,  G06F11/1474 ,  G06F2201/87

Abstract: Techniques are provided for diverting, to cloned metadata, live access to original metadata of an application container that is being concurrently upgraded. In an embodiment, a database server stores, within an application container of an application, original metadata that defines objects for use by pluggable databases of the application. The database server receives a maintenance request to adjust the original metadata. The database server creates, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata. The database server receives, during or after creating the reference container, a read request to read one of the objects. The database server concurrently performs both of: executing the maintenance request upon the original metadata, and executing the read request upon the cloned metadata of the reference container.

公开(公告)号：US20180075044A1

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

申请号：US15266902

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Debaditya Chatterjee

IPC: G06F17/30 ,  G06F9/445

Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.

公开(公告)号：US10606578B2

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

申请号：US15266902

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Debaditya Chatterjee

IPC: G06F17/30 ,  G06F8/61 ,  G06F16/21

Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.

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

公开(公告)号：US20190278856A9

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

申请号：US15266917

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Philip Yam ,  Thomas Baby ,  Andre Kruglikov ,  Kumar Rajamani

IPC: G06F17/30 ,  G06F11/14

Abstract: Techniques are provided for diverting, to cloned metadata, live access to original metadata of an application container that is being concurrently upgraded. In an embodiment, a database server stores, within an application container of an application, original metadata that defines objects for use by pluggable databases of the application. The database server receives a maintenance request to adjust the original metadata. The database server creates, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata. The database server receives, during or after creating the reference container, a read request to read one of the objects. The database server concurrently performs both of: executing the maintenance request upon the original metadata, and executing the read request upon the cloned metadata of the reference container.

公开(公告)号：US10191671B2

公开(公告)日：2019-01-29

申请号：US14835507

申请日：2015-08-25

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati

IPC: G06F17/30 ,  G06F3/06 ,  G06F11/14 ,  G06F21/62 ,  G06F12/084 ,  G06F13/16

Abstract: Techniques for common users and roles, and commonly-granted privileges and roles are described. In one approach, the DBMS of a container database allows for the creation of common roles and common users that are shared across the container database. Thus, when a common role or a common user is established, the common role or common user is propagated to each database of the container database. In another approach, the DBMS of a container database allows privileges and roles to be granted commonly or locally. When a privilege or role is granted commonly, the privilege applies in each of the databases of a container database. When a privilege or role is granted locally, the privilege applies only in the database to which the grantor of the privilege or role established a connection.

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

公开(公告)号：US10572551B2

公开(公告)日：2020-02-25

申请号：US15331525

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Thomas Baby ,  Philip Yam

IPC: G06F16/00 ,  G06F16/951 ,  G06F16/22

Abstract: In an approach, memory usage within a database management system is optimized by designating an application root which stores data and metadata for database objects that are common across pluggable databases which support the same application. In addition, the application root can be used to manage access to the pluggable databases by defining common users which are created at the application root, but can be used to access any of the member pluggable databases. Furthermore, different versions of the same application can be supported concurrently by maintaining separate application roots for each version. For instance, when an upgrade is applied to the application root, a clone can be created and the update can be applied to the clone. Then, the member pluggable databases which are to be upgraded can be synchronized to the clone, while leaving other pluggable databases servicing the previous version of the application.

公开(公告)号：US20170116334A1

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

申请号：US15331525

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Thomas Baby ,  Philip Yam

IPC: G06F17/30

CPC classification number: G06F16/951 ,  G06F16/21 ,  G06F16/22 ,  G06F16/25

Abstract: In an approach, memory usage within a database management system is optimized by designating an application root which stores data and metadata for database objects that are common across pluggable databases which support the same application. In addition, the application root can be used to manage access to the pluggable databases by defining common users which are created at the application root, but can be used to access any of the member pluggable databases. Furthermore, different versions of the same application can be supported concurrently by maintaining separate application roots for each version. For instance, when an upgrade is applied to the application root, a clone can be created and the update can be applied to the clone. Then, the member pluggable databases which are to be upgraded can be synchronized to the clone, while leaving other pluggable databases servicing the previous version of the application.