US 12,118,000 B2
Data retrieval systems and methods
Andre van der Schyff, Sydney (AU); Guido Rota, Woolloomooloo (AU); Matthew Robert Knox, St. Leonards (AU); Thiago Tasca Nunes, St. Leonards (AU); and Viktor Krisztian Adam, Sydney (AU)
Assigned to ATLASSIAN PTY LTD., Sydney (AU); and ATLASSIAN US, INC., San Francisco, CA (US)
Filed by Atlassian Pty Ltd., Sydney (AU); and Atlassian US, Inc., San Francisco, CA (US)
Filed on May 1, 2023, as Appl. No. 18/141,966.
Application 18/141,966 is a continuation of application No. 17/037,660, filed on Sep. 29, 2020, granted, now 11,663,211.
Prior Publication US 2023/0267119 A1, Aug. 24, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/24537 (2019.01) [G06F 16/2433 (2019.01); G06F 16/24539 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for retrieving issue data from an issue tracking system, the method comprising:
causing display, at an application of an issue tracking system, a set of issue objects;
receiving a request for updated information regarding the set of issue objects, the request formatted in accordance with a structured query language, the request including a plurality of clauses;
analyzing the request and identifying, a non-caching type clause from the plurality of clauses, the non-caching clause including, a dynamic clause, an ordering clause, or a sensitive clause, the non-caching type clause identified based on at least one keyword of the non-caching clause included in a non-caching keyword list;
identifying, a caching type clause from the plurality of clauses, the caching type clause different from the non-caching type clause;
executing a first stage query using the caching type clause to obtain a first stage query result from a computer memory;
executing a second stage query using the non-caching clause on a data store of issue data managed by the issue tracking system to obtain a second stage query result; and
updating display, at the application of the issue tracking system, the set of issue objects based on the first stage query result and the second stage query result.