Atlassian Corporation Pty Ltd.

Atlassian Us, Inc.

Other

Atlassian Inc.

Matthew Robert Knox

Andre Van Der Schyff

Viktor Krisztian Adam

Guido Rota

Thiago Tasca Nunes

Adam Canceri

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.

A display device () includes a screen (), at least one sensor, and a processing unit () configured to manage content displayed on the screen () based on information received from the at least one sensor. The device () is configured to detect the presence of one or more user in the vicinity of the device () and display content, such as advertisements, on the screen based on information received from the sensors. A plurality of display devices may be interconnected to form a composite display system. The device/system may further use sensors to determine information/advertising content relevant to the demographic of the user(s).

Display device and content display system

Growing community of inventors

St. Leonards, Australia

Matthew Robert Knox