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

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

公开(公告)号：US20190102411A1

公开(公告)日：2019-04-04

申请号：US16135769

申请日：2018-09-19

Applicant: Oracle International Corporation

Inventor： Hochak Hung ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati ,  John McHugh ,  Churn Don Lee ,  Alexander Chen ,  Jen-Cheng Huang

IPC: G06F17/30 ,  H04L12/24 ,  H04L29/08 ,  G06F15/18

Abstract: Provided herein are data cloud administration techniques that achieve autonomy by using a rules engine that reacts to a database system event by autonomously submitting an asynchronous job to reconfigure a database. In an embodiment, a rules engine receives an event from a DBMS. Based on the event, the rules engine executes a rule to generate a request that indicates configuration details for a database. The rules engine sends the request to a request broker. The request broker dispatches an asynchronous job based on the request. The asynchronous job configures the database based on the configuration details. Thus, databases in a cloud, data grid, or data center may be administered autonomously (without human intervention) base on dynamic conditions that are foreseen and unforeseen.

公开(公告)号：US09684566B2

公开(公告)日：2017-06-20

申请号：US14135202

申请日：2013-12-19

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Chi Cao Minh ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati ,  Jonghyun Lee

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: A container database stores redo records and logical timestamps for multiple pluggable databases. When it is detected that a first read-write instance of the pluggable database is opened and no other read-write instances of the pluggable database are open, offline range data associated with the pluggable database is updated. When it is detected that a second read-write instance of the pluggable database is closed, and the second read-write instance is the last open read-write instance, the offline range data associated with the pluggable database is updated. The pluggable database is restored to a logical timestamp associated with a restore request based on the offline range data.

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

公开(公告)号：US20170116321A1

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

申请号：US15331534

申请日：2016-10-21

Applicant: Oracle International Corporation

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

IPC: G06F17/30

Abstract: In an approach, a database management system is configured in a manner that allows all pluggable databases within a cluster to be treated, from the perspective of a user, as though stored on a single container database, even when the pluggable databases are distributed across a plurality of container databases. When a command is received by a database server that is to be executed on all or a subset of the pluggable databases within the cluster, the database inspects mapping information replicated on all container databases within the cluster by a cluster synchronization server to determine which container databases store pluggable databases implicated by the command. The command is then forwarded to the database servers responsible for the determined container databases for execution. As a result, the commands issued by the user can be agnostic in regard to the actual location of the pluggable databases within the cluster.

公开(公告)号：US20160210201A9

公开(公告)日：2016-07-21

申请号：US14135202

申请日：2013-12-19

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Chi Cao Minh ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati ,  Jonghyun Lee

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: A container database stores redo records and logical timestamps for multiple pluggable databases. When it is detected that a first read-write instance of the pluggable database is opened and no other read-write instances of the pluggable database are open, offline range data associated with the pluggable database is updated. When it is detected that a second read-write instance of the pluggable database is closed, and the second read-write instance is the last open read-write instance, the offline range data associated with the pluggable database is updated. The pluggable database is restored to a logical timestamp associated with a restore request based on the offline range data.

Abstract translation: 容器数据库存储多个可插拔数据库的重做记录和逻辑时间戳。 当检测到可插拔数据库的第一个读写实例被打开，并且没有可插拔数据库的其他读写实例被打开时，与可插拔数据库关联的脱机范围数据被更新。 当检测到可插拔数据库的第二读写实例被关闭，并且第二读写实例是最后打开的读写实例时，更新与可插拔数据库相关联的脱机范围数据。 基于离线范围数据，可插拔数据库恢复到与恢复请求相关联的逻辑时间戳。

公开(公告)号：US09239763B2

公开(公告)日：2016-01-19

申请号：US13631815

申请日：2012-09-28

Applicant: Oracle International Corporation

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Giridhar Ravipati ,  Andre Kruglikov ,  Sanket Jain ,  Chandrasekharan Iyer ,  Philip Yam ,  Yunrui Li

IPC: G06F17/30 ,  G06F11/14 ,  G06F21/62

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: A container database may contain multiple database dictionaries, each database dictionary defining a pluggable database. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by establishing the respective database dictionary of the pluggable database as the database dictionary for that database session. Database commands issued through database session can only access the database objects defined in the database dictionary established for the database session.

Abstract translation: 容器数据库可以包含多个数据库字典，每个数据库字典定义可插入数据库。 当在容器DBMS上建立数据库会话时，通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典，为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。

公开(公告)号：US09122644B2

公开(公告)日：2015-09-01

申请号：US13841272

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

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

IPC: G06F17/30 ,  G06F11/14 ,  G06F21/62

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

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.

Abstract translation: 描述了普通用户和角色的技术以及常用权限和角色。 在一种方法中，容器数据库的DBMS允许创建跨容器数据库共享的常见角色和通用用户。 因此，当建立常见角色或公共用户时，常见角色或普通用户将被传播到容器数据库的每个数据库。 在另一种方法中，容器数据库的DBMS允许通常或本地授予权限和角色。 通常授予特权或角色时，特权将应用于容器数据库的每个数据库。 当本地授予特权或角色时，权限仅适用于权限或角色的授予人建立连接的数据库。

公开(公告)号：US20140095530A1

公开(公告)日：2014-04-03

申请号：US13631815

申请日：2012-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Giridhar Ravipati ,  Andre Kruglikov ,  Sanket Jain ,  Chandrasekharan Iyer ,  Philip Yam ,  Yunrui Li

IPC: G06F17/30

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: A container database may contain multiple database dictionaries, each database dictionary defining a pluggable database. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by establishing the respective database dictionary of the pluggable database as the database dictionary for that database session. Database commands issued through database session can only access the database objects defined in the database dictionary established for the database session.

Abstract translation: 容器数据库可以包含多个数据库字典，每个数据库字典定义可插入数据库。 当在容器DBMS上建立数据库会话时，通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典，为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。