Patent ID: 11947539
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 17:
18. A computer system for asynchronous query execution in a distributed environment, comprising:
a memory;
one or more processors coupled to the memory and configured for:
receiving an assignment to asynchronously executing a first query on a distributed database, the assignment being associated with a task and a state object;
performing a process having two phases to complete the task, comprising:
executing a first phase of the task comprising matching a first portion of the first query with data stored in a local portion of the distributed database,
identifying a second portion of the first query to be matched with data that is unavailable in the local portion of the distributed database,
executing a second phase of the task comprising matching the second portion of the first query with data stored in a remote portion of the distributed database,
recording in the state object a level of activity in executing the task and a status of the task,
checking a yield flag controlled by a server at one or more points within the process, including a point of being unable to further execute the task, and
in response to the checking, returning from executing the first query with the state object when the yield flag is set, and repeating the executing, recording, and checking steps when the yield flag is unset until execution of the first query is complete.