Google Inc.

Looker Data Sciences Inc.

Benjamin Porterfield

Lloyd Tabb

Systems and methods for cancelling a query are disclosed. A method includes establishing a connection over a network with a user computing device associated with a user, receiving, from the user computing device via the connection, a query request requesting query results from a database and, based on the query request, instructing, via the network, a server to begin executing a database query against the database. The method also includes determining that the connection is disconnected and, in response to determining that the connection is disconnected, instructing, via the network, the server to stop executing the database query.

Systems and methods for cancelling a query

Systems and methods for querying a database are disclosed. A server computing device includes a processor and a memory storing instructions that, when executed by the processor, cause the server computing device to: receive a query input from a client device over a network connection; establish a non-blocking socket between the client computing device and the server computing device; generate a database query based on the query input; cause the database query to begin executing against one or more databases; perform a read request on the non-blocking socket; receive a code in response to the read request on the non-blocking socket; determine whether the network connection exists between the client device and the server device based on the received code; and cause the database query to be cancelled when the server determines that the network connection does not exist between the client device and the server device.

A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Growing community of inventors

San Francisco, CA, United States of America

Benjamin Porterfield