Managing database queries using a deconstructed cloud database
AssigneeSigma Computing, Inc.
InventorsJason D. Frantz, Robert C. Woollen, Max H. Seiden, James L. Gale, Kenneth Truong
Life of this patent
Estimating the term…
Abstract
Managing database queries using a deconstructed cloud database including receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system; converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising a database query targeting an offloaded execution engine; retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query; and presenting, by the communications manager, the query results to the client computing system.
Claims20
A method of managing database queries using a deconstructed cloud database comprising:
- receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system, wherein the state specification comprises user manipulations of one or more graphical user interface (GUI) elements of a GUI of the client computing system;
- converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising instructions to access data stored on the deconstructed cloud database and a database query targeting an offloaded execution engine within a cloud-based data warehouse;
- retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions;
- and
- presenting, by the communications manager, the query results on the client computing system.
A deconstructed cloud database comprising:
- a communications manager configured to receive a state specification from a client computing system and present query results to the client computing system, wherein the state specification comprises user manipulations of one or more graphical user interface (GUI) elements of a GUI of the client computing system;
- a query optimizer configured to convert the state specification into a query plan comprising instructions to access data stored on the deconstructed cloud database and a database query targeting an offloaded execution engine within a cloud-based data warehouse;
- and
- a dispatcher configured to retrieve the query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions.
An apparatus for managing database queries using a deconstructed cloud database, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
- receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system, wherein the state specification comprises user manipulations of one or more graphical user interface (GUI) elements of a GUI of the client computing system;
- converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising instructions to access data stored on the deconstructed cloud database and a database query targeting an offloaded execution engine within a cloud-based data warehouse;
- retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions;
- and
- presenting, by the communications manager, the query results on the client computing system.
Dependencies are inferred from the claim text.