DECLARATIVE METHOD OF GROUPING, MIGRATING AND EXECUTING UNITS OF WORK FOR AUTONOMOUS HIERARCHICAL DATABASE SYSTEMS

    公开(公告)号:US20230297593A1

    公开(公告)日:2023-09-21

    申请号:US17699740

    申请日:2022-03-21

    CPC classification number: G06F16/282 G06F16/21

    Abstract: Herein is database administration workflow automation with source annotations and intelligent scheduling techniques for applying a hierarchy of interdependent administrative tasks to distributed and/or nested databases. In an embodiment, a source language compiler analyzes annotations to identify a hierarchy of administrative tasks that administers pluggable databases in container databases. From the annotations, a runtime codebase is generated that implements and invokes the administrative task hierarchy. At runtime, a container database management system (CDBMS) autonomously identifies and instantiates the administrative tasks, including identifying a dependency of a first administrative task on a second administrative task and a lack of dependency of a third administrative task on the second administrative task. The CDBMS contains an intelligent scheduler that concurrently executes the second and third administrative tasks and defers execution of the first administrative task until after completion of the second administrative task. For example, the administrative tasks may be distributed to different databases for parallelism or instead sequenced for phased execution based on dependencies between administrative tasks or phases.

    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

    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.

    REPRESENTATION AND MANAGEMENT OF INFRASTRUCTURE STATE OF A DISTRIBUTED DATABASE CLOUD SERVICE

    公开(公告)号:US20250021542A1

    公开(公告)日:2025-01-16

    申请号:US18220451

    申请日:2023-07-11

    Abstract: Techniques are provided for maintaining snapshots of state information for a plurality of resource entities, within a distributed cloud service. A first snapshot of state information for the plurality of resource entities is maintained at an endpoint in persistent storage. A request to modify resources allocated to resource entities is received. A virtual lock on the state information reflected in the first snapshot is obtained. Upon obtaining the virtual lock, a service determines, based on the first snapshot, that there are available resources to perform the request to modify resources. A second snapshot of the state information, reflecting the modification of resources allocated to resource entities, is then generated and stored at the endpoint in persistent storage. The virtual lock on the state information is released and the resources allocated to the resource entities are modified according to the request.

    Data structure generation system for analyzing logs

    公开(公告)号:US11914563B2

    公开(公告)日:2024-02-27

    申请号:US17703269

    申请日:2022-03-24

    CPC classification number: G06F16/2246 G06F16/282

    Abstract: New data structures for analyzing a log are generated. A hierarchical data structure includes a plurality of hierarchical nodes. Each node is associated with data and metadata. Each node may also be associated with analysis data. Information (data, metadata, and/or analysis data) of an ancestor node is imputed to a descendant node; a descendant node inherits the information of an ancestor node. When determining analysis data for a particular hierarchical node, information from any ancestor node to the particular hierarchical node may be used; however, information from non-ancestor nodes is not necessarily used. A timeline data structure includes a reference to a hierarchical node within a hierarchical data structure and a reference to an event type. The timeline data structure is thereby associated with the information of the referenced hierarchical node and information of any ancestor nodes to the referenced hierarchical node.

Patent Agency Ranking