US 11,983,197 B2
Declarative method of grouping, migrating and executing units of work for autonomous hierarchical database systems
Rajagopalan Duraisamy, Bengaluru (IN); Ravi Shankar Thammaiah, Redwood Shores, CA (US); Nagarajan Muthukrishnan, Foster City, CA (US); and Sajithkumar Santhamma Sasikumar, Bangalore (IN)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Mar. 21, 2022, as Appl. No. 17/699,740.
Prior Publication US 2023/0297593 A1, Sep. 21, 2023
Int. Cl. G06F 16/28 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/282 (2019.01) [G06F 16/21 (2019.01)] 25 Claims
OG exemplary drawing
 
1. A method comprising:
analyzing, by a container database management system (CDBMS), an administration request;
identifying and generating, by the CDBMS and based on said analyzing the administration request, a plurality of administrative tasks that administer one or more pluggable databases in a container database, wherein the plurality of administrative tasks comprises a first subset plurality of administrative tasks and a second subset plurality of administrative tasks;
identifying a dependency of a first administrative task of the first subset plurality of administrative tasks on a second administrative task of the first subset plurality of administrative tasks;
detecting a lack of dependency of the second subset plurality of administrative tasks on the first subset plurality of administrative tasks;
enqueuing as ready to execute, based on said detecting said lack of dependency, the second administrative task on a first queue of a first thread or core and the second subset plurality of the administrative tasks on a second queue of a second thread or core;
deferring, based on said identifying said dependency, enqueuing the first administrative task until after completion of the second administrative task; and
executing, by said first thread or core, the second administrative task concurrent to executing, by said second thread or core, the second subset plurality of the administrative tasks.