Patents Assigned to Looker Data Sciences Inc.
-
Patent number: 10698887Abstract: 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.Type: GrantFiled: November 20, 2017Date of Patent: June 30, 2020Assignee: LOOKER DATA SCIENCES INC.Inventors: Lloyd Tabb, Benjamin Porterfield
-
Patent number: 10191984Abstract: 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.Type: GrantFiled: October 23, 2013Date of Patent: January 29, 2019Assignee: LOOKER DATA SCIENCES INC.Inventor: Benjamin Porterfield
-
Patent number: 10176226Abstract: The present disclosure provides methods for performing a computation with an aggregate function using a database query, wherein the database query joins a plurality of database tables and includes a distinct aggregation function, which, when executed against one or more databases aggregates only values of database records corresponding to distinct keys by which the tables are joined, regardless of the cardinality of the joined tables. Related devices and systems are also provided.Type: GrantFiled: November 26, 2014Date of Patent: January 8, 2019Assignee: LOOKER DATA SCIENCES, INC.Inventors: Lloyd Tabb, Michael Toy, Scott Hoover
-
Patent number: 10114867Abstract: The present disclosure provides inclusive and exclusive approaches, including computer-implemented methods for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table. Also provided are related systems and non-transitory computer-readable recording media.Type: GrantFiled: May 29, 2015Date of Patent: October 30, 2018Assignee: LOOKER DATA SCIENCES, INC.Inventors: Daniel Marcotte, Lloyd Tabb
-
Patent number: 9824118Abstract: 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.Type: GrantFiled: March 15, 2013Date of Patent: November 21, 2017Assignee: Looker Data Sciences, Inc.Inventors: Lloyd Tabb, Benjamin Porterfield
-
Publication number: 20140280326Abstract: 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.Type: ApplicationFiled: March 15, 2013Publication date: September 18, 2014Applicant: Looker Data Sciences Inc.Inventors: Lloyd Tabb, Benjamin Porterfield
-
Publication number: 20140280332Abstract: 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.Type: ApplicationFiled: October 23, 2013Publication date: September 18, 2014Applicant: Looker Data Sciences, Inc.Inventor: Benjamin Porterfield