知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

3 records (took 0.014 seconds)

    Scalable specification and self-governance for autonomous databases, cluster databases and multi-tenant databases in cloud and on-prem environment
    1.
    发明授权
    Scalable specification and self-governance for autonomous databases, cluster databases and multi-tenant databases in cloud and on-prem environment 有权

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

    Safe release of database sessions for planned maintenance operations
    3.
    发明授权
    Safe release of database sessions for planned maintenance operations 有权

    公开(公告)号：US10942907B2

    公开(公告)日：2021-03-09

    申请号：US15803644

    申请日：2017-11-03

    Applicant: Oracle International Corporation

    Inventor： Carol L. Colrain ,  Kevin S. Neel ,  Douglas N. Surber ,  Tong Zhou ,  Nancy R. Ikeda ,  Jean De Lavarene ,  Rohan Ankalikar

    IPC: G06F16/27 ,  G06F16/21 ,  H04L29/08

    Abstract: Techniques are described for closing one or more connections with a database management system (DBMS) as part of a planned operation such as maintenance and load balancing. In an embodiment, a request is received for a planned operation of a database server of a DBMS that requires releasing and migrating database sessions. Over a database connection with the database server, the DBMS or a Client-Driver on the client system that interfaces with the DBMS, may receive request(s) from the client system. Based on the request(s), a safe point, for the database connection with the database server, at which the database connection of the client system with the database server can be closed without affecting the success of execution of next one or more command that the client system intended to request the DBMS to execute on the database server, is determined. In an embodiment, in response to the request(s), the DBMS and/or Client-Driver, while the connection is valid, provide to the client system an invalid status for a connection test request. Such a response may cause the client system to use a different database connection to connect with the DBMS. After returning the response to the client system, the DBMS and/or Client-Driver causes the database session with the DBMS to close. In an embodiment, for database sessions to be released, the DBMS identifies a safe point in a database session by a detected request boundary or where the session states are determined to be recoverable or the failover is determined to be expected to succeed. At such a safe point, all database session states are known, and failing the session over to another database instance offering the requested service can be performed safely and transparent to applications.

Patent Agency Ranking