Atlassian Corporation Pty Ltd.

Atlassian Us, Inc.

Atlassian Inc.

Guido Rota

Andre Van Der Schyff

Matthew Robert Knox

Viktor Krisztian Adam

Thiago Tasca Nunes

Described herein is a computer implemented method. The method comprises generating a subscription identifier based on an original SQL query and determining if a set of first stage query results is associated with the subscription identifier in a cache. If so, the method further comprises generating a second stage SQL query based on a second subset of the plurality of clauses and the set of first stage query results, causing execution of the second stage SQL query to obtain a set of second stage query results from a database, and returning the set of second stage query results.

Data retrieval systems and methods

Described herein is a computer implemented method. The method comprises processing clauses included in an original SQL query to add each clause to either a set of caching clauses or a set of non-caching clauses and determining whether a subscription should be created. In response to determining the subscription should be created, the method comprises creating the subscription by generating a first stage SQL query based on the set of caching clauses, causing execution of the first stage SQL query to obtain a set of first stage query results from a database; and storing the set of first stage query results in a cache.

Growing community of inventors

Woolloomooloo, Australia

Guido Rota