公开(公告)号：US12229572B2

公开(公告)日：2025-02-18

申请号：US18492673

申请日：2023-10-23

Applicant: Oracle International Corporation

Inventor： Rohan Ankalikar ,  Nagarajan Muthukrishnan ,  Ravi Shankar Thammaiah ,  Sandeep Kumar Samudrala

IPC: G06F9/44 ,  G06F9/445 ,  G06F16/23

Abstract: A computer program product, system, and computer implemented method for scalable specification and self-governance for autonomous databases, cluster databases, and multi-tenant databases in cloud and on-prem environments. The approach disclosed herein enables management of a consolidated databases using a template-based process that allows for the consolidated databases (CDBs) and pluggable databases (PBDs) to be reconfigured automatically. In some embodiments, the approach instantiates one or more monitoring modules and one or more CDB/PDB configuration managers. These elements can detect relevant changes in the conditions in which CDB instances and open PDBs operate and adjust the configurations thereof in response. The configurations are specified in and adjusted using one or more corresponding templates, where the template comprise a set of rules that may have various interdependencies and specify how to determine what value a particular configuration setting should be to automatically configuration and reconfigure CDB instances and open PDBs.

公开(公告)号：US11829779B2

公开(公告)日：2023-11-28

申请号：US17365577

申请日：2021-07-01

Applicant: Oracle International Corporation

Inventor： Rohan Ankalikar ,  Nagarajan Muthukrishnan ,  Ravi Shankar Thammaiah ,  Sandeep Kumar Samudrala

IPC: G06F9/44 ,  G06F9/445 ,  G06F16/23

CPC classification number: G06F9/44505 ,  G06F16/2365

Abstract: A computer program product, system, and computer implemented method for scalable specification and self-governance for autonomous databases, cluster databases, and multi-tenant databases in cloud and on-prem environments. The approach disclosed herein enables management of a consolidated databases using a template-based process that allows for the consolidated databases (CDBs) and pluggable databases (PBDs) to be reconfigured automatically. In some embodiments, the approach instantiates one or more monitoring modules and one or more CDB/PDB configuration managers. These elements can detect relevant changes in the conditions in which CDB instances and open PDBs operate and adjust the configurations thereof in response. The configurations are specified in and adjusted using one or more corresponding templates, where the template comprise a set of rules that may have various interdependencies and specify how to determine what value a particular configuration setting should be to automatically configuration and reconfigure CDB instances and open PDBs.