公开(公告)号：US20220100759A1

公开(公告)日：2022-03-31

申请号：US17037660

申请日：2020-09-29

申请人： Atlassian Pty Ltd. ,  Atlassian Inc.

发明人： Andre van der Schyff ,  Guido Rota ,  Matthew Robert Knox ,  Thiago Tasca Nunes ,  Viktor Krisztian Adam, JR.

IPC分类号： G06F16/2453 ,  G06F16/242

摘要： 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.

公开(公告)号：US20220100745A1

公开(公告)日：2022-03-31

申请号：US17037637

申请日：2020-09-29

申请人： Atlassian Pty Ltd. ,  Atlassian Inc.

发明人： Andre van der Schyff ,  Guido Rota ,  Matthew Robert Knox ,  Thiago Tasca Nunes ,  Viktor Krisztian Adam, JR.

IPC分类号： G06F16/242

摘要： 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.

公开(公告)号：US20230267119A1

公开(公告)日：2023-08-24

申请号：US18141966

申请日：2023-05-01

申请人： Atlassian Pty Ltd. ,  Atlassian US, Inc.

发明人： Andre van der Schyff ,  Guido Rota ,  Matthew Robert Knox ,  Thiago Tasca Nunes ,  Viktor Krisztian Adam, JR.

IPC分类号： G06F16/2453 ,  G06F16/242

CPC分类号： G06F16/24537 ,  G06F16/2433 ,  G06F16/24539

摘要： 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.