Patent ID: 11860871
Assignee: ROCKSET, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A computer-implemented method comprising:
storing, by a database system, a mapping associating names and query versions of database queries to execution plans of database queries, the mapping associating a name of a database query and a first query version of the database query to a first execution plan of the database query;
providing an endpoint for REST API requests for executing database queries, wherein a plurality of applications execute a particular execution plan of a particular database query by sending a REST API request, wherein each REST API request specifies a name of the particular database query and a particular query version;
receiving from an application, a first REST API request for executing the database query, the first REST API request specifying the name of the database query, the first query version, and one or more parameters for the database query;
accessing from the mapping, a first execution plan of the database query based on the name of the database query and the first query version received via the first REST API request;
processing the first execution plan of the database query in response to the first REST API request;
receiving a modification to the database query;
storing in the mapping, an association between the name of the database query and a second query version with a second execution plan of the database query;
receiving one or more REST API requests for testing the modified database query from one or more applications;
responsive to the modified database query passing a test criterion, promoting the modified database query for use with production instances of the application;
receiving a second REST API request from a production instance of the application, the second REST API request specifying the name of the database query, an second query version, and one or more parameters for the database query;
accessing the second execution plan based on the name of the database query and the second query version received via the second REST API request; and
processing the second execution plan of the database query in response to receiving the second REST API request.