-
公开(公告)号:US20190278856A9
公开(公告)日:2019-09-12
申请号:US15266917
申请日:2016-09-15
Applicant: Oracle International Corporation
Inventor: Philip Yam , Thomas Baby , Andre Kruglikov , Kumar Rajamani
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.
-
公开(公告)号:US20180075086A1
公开(公告)日:2018-03-15
申请号:US15266917
申请日:2016-09-15
Applicant: Oracle International Corporation
Inventor: Philip Yam , Thomas Baby , Andre Kruglikov , Kumar Rajamani
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.
-
公开(公告)号:US20170116235A1
公开(公告)日:2017-04-27
申请号:US15266030
申请日:2016-09-15
Applicant: Oracle International Corporation
Inventor: Philip Yam , Kumar Rajamani , Jaebock Lee
IPC: G06F17/30
CPC classification number: G06F16/24566 , G06F16/172 , G06F16/214 , G06F16/258
Abstract: A database server instance automatically detects configuration issues when a pluggable database (PDB) is plugged into a new destination container database (CDB). The database server instance identifies one or more update templates, within the destination CDB, that, when run over the relocated PDB, will update the configuration of the PDB to conform to the configuration of the destination CDB. Instead of requiring an administrator to initiate update scripts from a DBMS kernel to reconfigure a PDB, the DBMS creates the update templates by recording commands run within PDBs in connection with system updates. These recorded update templates may then be run over relocated PDBs, to configure the PDBs according to the configuration of the destination CDB. Further, the update templates may be pre-recorded update templates, which record commands to perform configuration updates, to PDBs, that have never before been performed within the CDB.
-
公开(公告)号: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.
-
公开(公告)号: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
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上建立数据库会话时,通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典,为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。
-
公开(公告)号: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上建立数据库会话时,通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典,为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。
-
-
-
-
-
-