US 11,741,088 B2
Nested query analysis 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 Sep. 30, 2021, as Appl. No. 17/449,632.
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 2022/0253438 A1, Aug. 11, 2022
Int. Cl. G06F 16/242 (2019.01); G06F 16/2458 (2019.01); G06F 16/25 (2019.01); G06F 16/248 (2019.01); G06F 16/2453 (2019.01); G06F 3/0486 (2013.01)
CPC G06F 16/2428 (2019.01) [G06F 3/0486 (2013.01); G06F 16/248 (2019.01); G06F 16/2458 (2019.01); G06F 16/24535 (2019.01); G06F 16/258 (2019.01)] 21 Claims
OG exemplary drawing
 
21. A system comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the system to perform:
displaying, in a nested-query display region of a graphical user interface (GUI), a plurality of visual representations corresponding respectively to a plurality of nested queries of a composite query, the plurality of visual representations comprising:
a first visual representation representing a first query of the composite query; and
a second visual representation representing a second query of the composite query, wherein the second query is a child query of the first query;
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;
receiving a first input command to identify an origin query for a first attribute associated with the first query, wherein the first attribute corresponds to a first set of records identified by the origin query;
responsive to receiving the first input command:
determining that the second query is the origin query of the first attribute in response to determining that the first attribute is output from the second query to the first query;
identifying the second query as the origin query of the first attribute by determining that the second query does not receive the first attribute from a child query of the second query; and
based on identifying the second query as the origin query of the first attribute, displaying a visual indicator associated with the second query.