Querying databases with machine learning model references
AssigneeAmazon Technologies, Inc.
InventorStefano Stefani
Life of this patent
Estimating the term…
Abstract
Querying databases may be performed with references to machine learning models. A database query may be received that references a machine learning model and database. In response to the query, the machine learning model may provide information which may be returned as part of a result of the query or may be used to generate a result of the query. The machine learning model may be generated in response to a request to generate a machine learning model that includes a database query that identifies the data upon which a machine learning technique may be applied to generate the machine learning model.
Claims20
A system, comprising:
- a plurality of computing devices, respectively implement a processor and a memory, configured to implement a provider network service, the provider network service configured to:
- receive, via an interface of the provider network service, a query statement that is stated in Structured Query Language (SQL), wherein the interface supports queries stated in the query language, and wherein the query statement specifies a column in a table of a data warehouse and a machine learning model;
- cause an evaluation of respective data in the specified column to determine one or more records in the table of the data warehouse to add inferred data values determined from the machine learning model referenced in the query;
- cause the evaluation of the machine learning model referenced in the query to determine the inferred data values for the one or more records in the table;
- return, via the interface of the provider network service, a result of the query statement based on the inferred data values from the evaluation of the machine learning model determined for the one or more records.
A method, comprising:
- receiving, via an interface of provider network service, a query statement that is stated in Structured Query Language (SQL), wherein the interface supports queries stated in the query language, and wherein the query statement specifies a column in a table of a data warehouse and a machine learning model;
- causing, by the provider network service, an evaluation of respective data in the specified column to determine one or more records in the table of the data warehouse to add inferred data values determined from the machine learning model referenced in the query;
- causing, by the provider network service, the evaluation of the machine learning model referenced in the query to determine the inferred data values for the one or more records in the table;
- returning, via the interface of the provider network service, a result of the query statement based on the inferred data values from the evaluation of the machine learning model determined for the one or more records.
One or more non-transitory, computer-readable storage media, storing program instructions that when executed on or across one or more computing devices, cause the one or more computing devices to implement:
- receiving, via an interface of provider network service, a query statement that is stated in Structured Query Language (SQL), wherein the interface supports queries stated in the query language, and wherein the query statement specifies a column in a table of a data warehouse and a machine learning model;
- causing, by the provider network service, an evaluation of respective data in the specified column to determine one or more records in the table of the data warehouse to add inferred data values determined from the machine learning model referenced in the query;
- causing, by the provider network service, the evaluation of the machine learning model referenced in the query to determine the inferred data values for the one or more records in the table;
- returning, via the interface of the provider network service, a result of the query statement based on the inferred data values from the evaluation of the machine learning model determined for the one or more records.
Dependencies are inferred from the claim text.