Patents by Inventor Jonathan MENZIES-SMITH

Jonathan MENZIES-SMITH 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).

  • Compiling a relational datastore query from a user input
    Patent number: 10824620
    Abstract: In an example, a database system may be configured to receive configuration data including a mapping of objects of a relational database to query generation parameters; compare values in a received first query to the mapping to identify column definition data of the query generation parameters; ascertain whether to identify table definition data of the configuration data based on the column definition data; determine whether to create one or more subqueries for one or more tables based on the table definition data; in response to determining to create the one or more subqueries, join a table of the one or more tables to a root table based on table relationship data of the configuration data; and build a second relational datastore query using the one or more subqueries.
    Type: Grant
    Filed: October 21, 2016
    Date of Patent: November 3, 2020
    Assignee: SALESFORCE.COM, INC.
    Inventor: Jonathan Menzies-Smith
  • COMPILING A RELATIONAL DATASTORE QUERY FROM A USER INPUT
    Publication number: 20180113901
    Abstract: In an example, a database system may be configured to receive configuration data including a mapping of objects of a relational database to query generation parameters; compare values in a received first query to the mapping to identify column definition data of the query generation parameters; ascertain whether to identify table definition data of the configuration data based on the column definition data; determine whether to create one or more subqueries for one or more tables based on the table definition data; in response to determining to create the one or more subqueries, join a table of the one or more tables to a root table based on table relationship data of the configuration data; and build a second relational datastore query using the one or more subqueries.
    Type: Application
    Filed: October 21, 2016
    Publication date: April 26, 2018
    Applicant: salesforce.com, inc.
    Inventor: Jonathan MENZIES-SMITH