公开(公告)号：US11983197B2

公开(公告)日：2024-05-14

申请号：US17699740

申请日：2022-03-21

Applicant: Oracle International Corporation

Inventor： Rajagopalan Duraisamy ,  Ravi Shankar Thammaiah ,  Nagarajan Muthukrishnan ,  Sajithkumar Santhamma Sasikumar

IPC: G06F16/28 ,  G06F16/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.

公开(公告)号：US20230297593A1

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

申请号：US17699740

申请日：2022-03-21

Applicant: Oracle International Corporation

Inventor： Rajagopalan Duraisamy ,  Ravi Shankar Thammaiah ,  Nagarajan Muthukrishnan ,  Sajithkumar Santhamma Sasikumar

IPC: G06F16/28 ,  G06F16/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.