US 11,995,072 B2
Nested query execution tool
Prashant Singh, Lexington, MA (US); Rasika Vaidya Kaura, Dublin, CA (US); and Henrik Michael Ammer, Auburn, WA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Mar. 9, 2023, as Appl. No. 18/181,468.
Application 18/181,468 is a continuation of application No. 17/449,631, filed on Sep. 30, 2021, granted, now 11,636,101.
Claims priority of provisional application 63/200,474, filed on Mar. 9, 2021.
Claims priority of provisional application 63/155,817, filed on Mar. 3, 2021.
Claims priority of provisional application 63/148,864, filed on Feb. 12, 2021.
Claims priority of provisional application 63/147,564, filed on Feb. 9, 2021.
Prior Publication US 2023/0214381 A1, Jul. 6, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/242 (2019.01); G06F 3/0482 (2013.01); G06F 3/0486 (2013.01); G06F 16/2453 (2019.01); G06F 16/2458 (2019.01); G06F 16/248 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2428 (2019.01) [G06F 3/0482 (2013.01); G06F 3/0486 (2013.01); G06F 16/24535 (2019.01); G06F 16/2458 (2019.01); G06F 16/248 (2019.01); G06F 16/258 (2019.01); G06F 2203/04803 (2013.01)] 22 Claims
OG exemplary drawing
 
1. A non-transitory computer readable medium comprising instructions which, when executed by one or more hardware processors, causes performance of operations comprising:
identifying a first composite query comprising a first plurality of nested queries;
displaying, in a first region of a graphical user interface (GUI), a plurality of visual representations corresponding respectively to the first plurality of nested queries, the plurality of visual representations comprising:
a first visual representation representing a first query of the first plurality of nested queries, wherein the first query is associated with first query information including a first data object from which the first query is configured to retrieve a first set of one or more records based on a first set of one or more attribute values; and
a second visual representation representing a second query of the first plurality of nested queries, wherein the second query is a child query of the first query, wherein the first query is executed based on results from the second query, wherein the second query is associated with second query information including a second data object from which the second query is configured to retrieve a second set of one or more records based on a second set of one or more attribute values;
wherein the second visual representation is displayed relative to the first visual representation to depict the second query being the child query of the first query;
wherein the first query is configured to use a result from an execution of the second query based on the second query being the child query of the first query,
receiving a first input associated with the second visual representation to export the second query;
responsive to receiving the first input:
generating, by copying metadata associated with the second query, a third query that is external to, and independent of, the first composite query, wherein the first composite query is not configured to use results of the third query based on the third query being independent of the first composite query, wherein the metadata includes the second query information.