IP Library Granted Patent US 11,537,606
Granted Patent B2
US 11,537,606 · App. 16/796,088 · Granted Dec 27, 2022

Solution for implementing computing service based on structured query language statement

Inventors: Yi Wang (Hangzhou, CN); Yang Yang (Hangzhou, CN); Weiguo Zhu (Hangzhou, CN); Yongfeng Liu (Hangzhou, CN)
Assignee: Advanced New Technologies Co., Ltd.
G06F16/2445G06F16/2458G06F16/24575G06K9/6218G06N3/08
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,537,606
App. No.
16/796,088
Granted
Dec 27, 2022
Kind
B2
Abstract

Syntax parsing on a SQL statement is performed to determine whether an extended syntax identifier exists in the SQL statement, where the extended syntax identifier indicates a target computing service for the SQL statement. It is determined that the extended syntax identifier exists in the SQL statement. A computing service description statement in a first statement format is generated based on the SQL statement, where the first statement format is a statement format that can be recognized by a target computing framework. The computing service description statement is submitted to the target computing framework. Data queried by the SQL statement is invoked, in the target computing framework based on the computing service description statement, to perform target computation, where the SQL statement includes a computing element needed by the target computing service.

Claims (48)

1. A method for implementing a computing service based on a structured query language (SQL) statement, comprising:

performing syntax parsing on a SQL statement to determine whether an extended syntax identifier exists in the SQL statement, wherein the extended syntax identifier indicates a target computing service for the SQL statement, wherein the target computing service comprises a training service or a prediction service based on a machine learning model, wherein the SQL statement comprises a data query element for obtaining a training dataset to be used in the machine learning model;

determining that the extended syntax identifier exists in the SQL statement and that the SQL statement is an extended SQL statement;

determining that the extended SQL statement includes a computing element for configuring the machine learning model when executing the machine learning model based on the training dataset obtained, wherein the computing element comprises configuration parameters including a machine learning model name, a machine learning model parameter, a machine learning model feature, a machine learning model label, and a machine learning computation result storage address of the machine learning model;

generating a computing service description statement in a first statement format based on the extended SQL statement comprising:

generating data query program code in a first statement format based on the data query element in the extended SQL statement; and

generating machine learning program code in the first statement format based on the computing element in the extended SQL statement, wherein the first statement format is a statement format that can be recognized by a target computing framework; and

submitting the computing service description statement to the target computing framework, which i) executes the data query program code to obtain the training dataset queried by the data query element in the extended SQL statement for the machine learning model and ii) executes the machine learning program code with the training dataset obtained, using the configuration parameters included in the computing element in the extended SQL statement to perform the target computing service.

2. The method according to claim 1 , wherein the target computing service comprises a machine learning computing service or a cluster computing service.

3. The method according to claim 2 , wherein the machine learning computing service comprises machine learning model training or machine learning model prediction.

4. The method according to claim 1 , wherein generating the machine learning program code in the first statement format based on the computing element in the extended SQL statement comprises:

invoking a machine learning program code template corresponding to the machine learning model name; and

providing the machine learning model parameter, the machine learning model feature, and the machine learning model label to the machine learning program code template, to generate the machine learning program code in the first statement format.

5. The method according to claim 4 , wherein after the target computing framework invokes the training dataset queried by the extended SQL statement to perform the target computing service based on the machine learning program code, the target computing framework stores a target computation result in the machine learning computation result storage address in a SQL database.

6. The method according to claim 1 , wherein before generating the computing service description statement in the first statement format based on the extended SQL statement, the method further comprises:

performing semantic verification on the extended SQL statement.

7. A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations comprising:

performing syntax parsing on a SQL statement to determine whether an extended syntax identifier exists in the SQL statement, wherein the extended syntax identifier indicates a target computing service for the SQL statement, wherein the target computing service comprises a training service or a prediction service based on a machine learning model, wherein the SQL statement comprises a data query element for obtaining a training dataset to be used in the machine learning model;

determining that the extended syntax identifier exists in the SQL statement and that the SQL statement is an extended SQL statement;

determining that the extended SQL statement includes a computing element for configuring the machine learning model when executing the machine learning model based on the training dataset obtained, wherein the computing element comprises configuration parameters including a machine learning model name, a machine learning model parameter, a machine learning model feature, a machine learning model label, and a machine learning computation result storage address of the machine learning model;

generating a computing service description statement in a first statement format based on the extended SQL statement comprising:

generating data query program code in a first statement format based on the data query element in the extended SQL statement; and

generating machine learning program code in the first statement format based on the computing element in the extended SQL statement, wherein the first statement format is a statement format that can be recognized by a target computing framework; and

submitting the computing service description statement to the target computing framework, which i) executes the data query program code to obtain the training dataset queried by the data query element in the extended SQL statement for the machine learning model and ii) executes the machine learning program code with the training dataset obtained, using the configuration parameters included in the computing element in the extended SQL statement to perform the target computing service.

8. The non-transitory, computer-readable medium according to claim 7 , wherein the target computing service comprises a machine learning computing service or a cluster computing service.

9. The non-transitory, computer-readable medium according to claim 8 , wherein the machine learning computing service comprises machine learning model training or machine learning model prediction.

10. The non-transitory, computer-readable medium according to claim 7 , wherein generating the machine learning program code in the first statement format based on the computing element in the extended SQL statement comprises:

invoking a machine learning program code template corresponding to the machine learning model name; and

providing the machine learning model parameter, the machine learning model feature, and the machine learning model label to the machine learning program code template, to generate the machine learning program code in the first statement format.

11. The non-transitory, computer-readable medium according to claim 10 , wherein after the target computing framework invokes the training dataset queried by the extended SQL statement to perform the target computing service based on the machine learning program code, the target computing framework stores a target computation result in the machine learning computation result storage address in a SQL database.

12. The non-transitory, computer-readable medium according to claim 7 , wherein before generating the computing service description statement in the first statement format based on the SQL statement, the operations further comprise:

performing semantic verification on the extended SQL statement.

13. A computer-implemented system, comprising:

one or more computers; and

one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform one or more operations comprising:

performing syntax parsing on a SQL statement to determine whether an extended syntax identifier exists in the SQL statement, wherein the extended syntax identifier indicates a target computing service for the SQL statement, wherein the target computing service comprises a training service or a prediction service based on a machine learning model, wherein the SQL statement comprises a data query element for obtaining a training dataset to be used in the machine learning model;

determining that the extended syntax identifier exists in the SQL statement and that the SQL statement is an extended SQL statement;

determining that the extended SQL statement includes a computing element for configuring the machine learning model when executing the machine learning model based on the training dataset obtained, wherein the computing element comprises configuration parameters including a machine learning model name, a machine learning model parameter, a machine learning model feature, a machine learning model label, and a machine learning computation result storage address of the machine learning model;

generating a computing service description statement in a first statement format based on the extended SQL statement comprising:

generating data query program code in a first statement format based on the data query element in the extended SQL statement; and

generating machine learning program code in the first statement format based on the computing element in the extended SQL statement, wherein the first statement format is a statement format that can be recognized by a target computing framework; and

submitting the computing service description statement to the target computing framework, which i) executes the data query program code to obtain the training dataset queried by the data query element in the extended SQL statement for the machine learning model and ii) executes the machine learning program code with the training dataset obtained, using the configuration parameters included in the computing element in the extended SQL statement to perform the target computing service.

14. The computer-implemented system according to claim 13 , wherein the target computing service comprises a machine learning computing service or a cluster computing service.

15. The computer-implemented system according to claim 14 , wherein the machine learning computing service comprises machine learning model training or machine learning model prediction.

16. The computer-implemented system according to claim 13 , wherein generating the machine learning program code in the first statement format based on the computing element in the extended SQL statement comprises:

invoking a machine learning program code template corresponding to the machine learning model name; and

providing the machine learning model parameter, the machine learning model feature, and the machine learning model label to the machine learning program code template, to generate the machine learning program code in the first statement format.

17. The computer-implemented system according to claim 16 , wherein after the target computing framework invokes the training dataset queried by the extended SQL statement to perform the target computing service based on the machine learning program code, the target computing framework stores a target computation result in the machine learning computation result storage address in a SQL database.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 10, 2020
From: ADVANTAGEOUS NEW TECHNOLOGIES CO., LTD.
To: ADVANCED NEW TECHNOLOGIES CO., LTD.
Reel/Frame 053754/0625 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 31, 2020
From: ALIBABA GROUP HOLDING LIMITED
To: ADVANTAGEOUS NEW TECHNOLOGIES CO., LTD.
Reel/Frame 053743/0464 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 2, 2020
From: WANG, YI; YANG, YANG; ZHU, WEIGUO; LIU, YONGFENG
To: ALIBABA GROUP HOLDING LIMITED
Reel/Frame 051979/0907 →
Priority Claims (1)
CN 201910183056.8 · Mar 12, 2019 · national
Continuity (1)
Related Publication 20200293519A1 · Sep 17, 2020
Cited By (1)
US 12,387,140