Compiling optimized database statements
Compiling optimized database statements including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface in response to a user manipulating the graphical user interface on the client computing system, wherein the state specification is in a standard file format and describes modifications to a plurality of visual elements of the graphical user interface; compiling, by the query compiler, a database statement from the state specification such that a limit clause within the database statement is processed by a database before at least one join clause; and sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.
1. A method of compiling optimized database statements, the method comprising:
receiving, by a query compiler from a client computing system, a state specification of a graphical user interface;
compiling, by the query compiler, an optimized database statement from the state specification such that a limit clause within the optimized database statement is processed by a database before at least one join clause, wherein the limit clause identifies a maximum number of records or rows for a result dataset; and
sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.
2. The method of claim 1 , wherein compiling the optimized database statement comprises lowering the limit clause within an operator query tree representation, and wherein the optimized database statement has a data format different from the received state specification.
3. The method of claim 1 , wherein compiling the optimized database statement comprises repositioning, within the optimized database statement, the limit clause such that the limit clause is processed by the database before the at least one join clause.
4. The method of claim 1 , wherein compiling the optimized database statement is in response to determining an expected number of record results.
5. The method of claim 1 , wherein the graphical user interface comprises a worksheet presenting a data set from the cloud-based data warehouse.
6. The method of claim 1 , wherein, upon receiving the optimized database statement, the database on the cloud-based data warehouse performs additional optimizations on the optimized database statement.
7. The method of claim 1 , wherein the optimized database statement is compiled on an intermediary computing system between the client computing system and the cloud-based data warehouse.
8. The method of claim 1 , wherein the optimized database statement is a structured query language statement.
9. An apparatus for compiling optimized database statements, 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 query compiler from a client computing system, a state specification of a graphical user interface;
compiling, by the query compiler, an optimized database statement from the state specification such that a limit clause within the optimized database statement is processed by a database before at least one join clause, wherein the limit clause identifies a maximum number of records or rows for a result dataset; and
sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.
10. The apparatus of claim 9 , wherein compiling the optimized database statement comprises lowering the limit clause within an operator query tree representation.
11. The apparatus of claim 9 , wherein compiling the optimized database statement comprises repositioning, within the optimized database statement, the limit clause such that the limit clause is processed by the database before the at least one join clause.
12. The apparatus of claim 9 , wherein compiling the optimized database statement is in response to determining an expected number of record results.
13. The apparatus of claim 9 , wherein the graphical user interface comprises a worksheet presenting a data set from the cloud-based data warehouse.
14. The apparatus of claim 9 , wherein, upon receiving the optimized database statement, the database on the cloud-based data warehouse performs additional optimizations on the optimized database statement.
15. The apparatus of claim 9 , wherein the optimized database statement is compiled on an intermediary computing system between the client computing system and the cloud-based data warehouse.
16. The apparatus of claim 9 , wherein the optimized database statement is a structured query language statement.
17. A computer program product for compiling optimized database statements, the computer program product disposed upon a non-transitory computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, by a query compiler from a client computing system, a state specification of a graphical user interface;
compiling, by the query compiler, an optimized database statement from the state specification such that a limit clause within the optimized database statement is processed by a database before at least one join clause, wherein the limit clause identifies a maximum number of records or rows for a result dataset; and
sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.
18. The computer program product of claim 17 , wherein compiling the optimized database statement comprises lowering the limit clause within an operator query tree representation.
19. The computer program product of claim 17 , wherein compiling the optimized database statement comprises repositioning, within the optimized database statement, the limit clause such that the limit clause is processed by the database before the at least one join clause.
20. The computer program product of claim 17 , wherein compiling the optimized database statement is in response to determining an expected number of record results.