Patents by Inventor Benjamin Porterfield

Benjamin Porterfield has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20230142632
    Abstract: 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.
    Type: Application
    Filed: January 4, 2023
    Publication date: May 11, 2023
    Applicant: Google LLC
    Inventor: Benjamin Porterfield
  • Patent number: 11556599
    Abstract: 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: Grant
    Filed: April 2, 2021
    Date of Patent: January 17, 2023
    Assignee: Google LLC
    Inventor: Benjamin Porterfield
  • Publication number: 20210294862
    Abstract: 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: Application
    Filed: April 2, 2021
    Publication date: September 23, 2021
    Applicant: Google LLC
    Inventor: Benjamin Porterfield
  • Patent number: 10977320
    Abstract: 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: Grant
    Filed: January 29, 2019
    Date of Patent: April 13, 2021
    Assignee: Google LLC
    Inventor: Benjamin Porterfield
  • Patent number: 10698887
    Abstract: 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: Grant
    Filed: November 20, 2017
    Date of Patent: June 30, 2020
    Assignee: LOOKER DATA SCIENCES INC.
    Inventors: Lloyd Tabb, Benjamin Porterfield
  • Publication number: 20190155855
    Abstract: 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: Application
    Filed: January 29, 2019
    Publication date: May 23, 2019
    Inventor: Benjamin Porterfield
  • Patent number: 10191984
    Abstract: 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: Grant
    Filed: October 23, 2013
    Date of Patent: January 29, 2019
    Assignee: LOOKER DATA SCIENCES INC.
    Inventor: Benjamin Porterfield
  • Publication number: 20180165329
    Abstract: 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: Application
    Filed: November 20, 2017
    Publication date: June 14, 2018
    Inventors: Lloyd Tabb, Benjamin Porterfield
  • Patent number: 9824118
    Abstract: 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: Grant
    Filed: March 15, 2013
    Date of Patent: November 21, 2017
    Assignee: Looker Data Sciences, Inc.
    Inventors: Lloyd Tabb, Benjamin Porterfield
  • Publication number: 20140280326
    Abstract: 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: Application
    Filed: March 15, 2013
    Publication date: September 18, 2014
    Applicant: Looker Data Sciences Inc.
    Inventors: Lloyd Tabb, Benjamin Porterfield
  • Publication number: 20140280332
    Abstract: 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: Application
    Filed: October 23, 2013
    Publication date: September 18, 2014
    Applicant: Looker Data Sciences, Inc.
    Inventor: Benjamin Porterfield