Managing database queries using a deconstructed cloud database
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.
1. 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.
2. The method of claim 1 , wherein the cloud-based data warehouse is in a group of computing systems separate from the deconstructed cloud database, and wherein the state specification is a JavaScript Object Notation specification.
3. The method of claim 1 , wherein the query plan further comprises instructions to access data stored in a local storage system of the deconstructed cloud database.
4. The method of claim 1 , wherein the query results comprise a data set from the offloaded execution engine and a worksheet from a catalog of the deconstructed cloud database.
5. The method of claim 1 ,
wherein receiving, by the communications manager of the deconstructed cloud database, the state specification from the client computing system comprises authenticating the client computing system using first credentials, and
wherein retrieving, by the dispatcher of the deconstructed cloud database, the query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions comprises accessing the offloaded execution engine using second credentials.
6. The method of claim 1 , wherein converting, by the query optimizer of the deconstructed cloud database, the state specification into the query plan comprises selecting a database query language based on a protocol of the offloaded execution engine.
7. The method of claim 1 , further comprising modifying, by the query optimizer, the query results based on the query plan, and wherein the query plan further comprises instructions to access data stored in a local storage system of the deconstructed cloud database.
8. 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.
9. The deconstructed cloud database of claim 8 , wherein the cloud-based data warehouse is in a group of computing systems separate from the deconstructed cloud database.
10. The deconstructed cloud database of claim 8 , wherein the query plan further comprises instructions to access data stored in a local storage system of the deconstructed cloud database.
11. The deconstructed cloud database of claim 8 , wherein the query results comprise a data set from the offloaded execution engine and a worksheet from a catalog of the deconstructed cloud database.
12. The deconstructed cloud database of claim 8 ,
wherein receiving the state specification from the client computing system comprises authenticating the client computing system using first credentials, and
wherein retrieving the query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions comprises accessing the offloaded execution engine using second credentials.
13. The deconstructed cloud database of claim 8 , wherein converting the state specification into the query plan comprises selecting a database query language based on a protocol of the offloaded execution engine.
14. The deconstructed cloud database of claim 8 , wherein the query optimizer is further configured to modify the query results based on the query plan.
15. 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.
16. The apparatus of claim 15 , wherein the cloud-based data warehouse is in a group of computing systems separate from the deconstructed cloud database.
17. The apparatus of claim 15 , wherein the query plan further comprises instructions to access data stored in a local storage system of the deconstructed cloud database.
18. The apparatus of claim 15 , wherein the query results comprise a data set from the offloaded execution engine and a worksheet from a catalog of the deconstructed cloud database.
19. The apparatus of claim 15 ,
wherein receiving, by the communications manager of the deconstructed cloud database, the state specification from the client computing system comprises authenticating the client computing system using first credentials, and
wherein retrieving, by the dispatcher of the deconstructed cloud database, the query results from the offloaded execution engine using the database query and from the deconstructed cloud database using the instructions comprises accessing the offloaded execution engine using second credentials.
20. The apparatus of claim 15 , wherein converting, by the query optimizer of the deconstructed cloud database, the state specification into the query plan comprises selecting a database query language based on a protocol of the offloaded execution engine.