Prefetching query results using expanded queries
Prefetching query results using expanded queries including generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve initial results from a cloud-based data warehouse; determining that the database query is expandable; modifying the database query to retrieve expanded results from the cloud-based data warehouse, wherein the expanded results include the initial results; and fetching, from the cloud-based data warehouse, the expanded results using the modified database query.
1. A method for prefetching query results using expanded queries, the method comprising:
generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve initial results from a table within a cloud-based data warehouse;
determining that the database query is expandable;
modifying the database query to retrieve expanded results from the cloud-based data warehouse, wherein the expanded results include the initial results, and wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises one selected from a group consisting of expanding the database query to retrieve additional columns from the table and expanding the database query to retrieve additional rows from the table; and
fetching, from the cloud-based data warehouse, the expanded results using the modified database query.
2. The method of claim 1 , further comprising:
storing, in a cache, the expanded results including the initial results targeted by the database query and additional results not included in the initial results; and
providing the initial results via the graphical user interface.
3. The method of claim 2 , further comprising:
generating, using a subsequent state specification, a subsequent database query targeting subsequent database query results, wherein the expanded results include the subsequent database query results, and wherein the initial results do not include the subsequent database query results; and
servicing the subsequent database query using the expanded results.
4. The method of claim 1 , wherein the graphical user interface comprises a presentation of a data set from the cloud-based data warehouse.
5. The method of claim 1 , wherein determining that the database query is expandable comprises determining that the database query includes at least one element that is modifiable to expand the initial results to retrieve additional results.
6. The method of claim 1 , wherein determining that the database query is expandable comprises determining that the expanded results do not exceed a threshold.
7. The method of claim 1 , wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises removing a filter applied to the initial results.
8. The method of claim 1 , wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises expanding the database query to retrieve additional columns.
9. The method of claim 1 , wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises expanding limits within the database query.
10. The method of claim 1 , wherein the database query is a structured query language statement.
11. An apparatus for prefetching query results using expanded queries, 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:
generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve initial results from a table within a cloud-based data warehouse;
determining that the database query is expandable;
modifying the database query to retrieve expanded results from the cloud-based data warehouse, wherein the expanded results include the initial results, and wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises one selected from a group consisting of expanding the database query to retrieve additional columns from the table and expanding the database query to retrieve additional rows from the table; and
fetching, from the cloud-based data warehouse, the expanded results using the modified database query.
12. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
storing, in a cache, the expanded results including the initial results targeted by the database query and additional results not included in the initial results; and
providing the initial results via the graphical user interface, wherein the initial results are extracted from the expanded results.
13. The apparatus of claim 12 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
generating, using a subsequent state specification, a subsequent database query targeting subsequent database query results, wherein the expanded results include the subsequent database query results, and wherein the initial results do not include the subsequent database query results; and
servicing the subsequent database query using the expanded results.
14. The apparatus of claim 11 , wherein the graphical user interface comprises a presentation of a data set from the cloud-based data warehouse.
15. The apparatus of claim 11 , wherein determining that the database query is expandable comprises determining that the database query includes at least one element that is modifiable to expand the initial results to retrieve additional results.
16. The apparatus of claim 11 , wherein determining that the database query is expandable comprises determining that the expanded results do not exceed a threshold.
17. The apparatus of claim 11 , wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises removing a filter applied to the initial results.
18. The apparatus of claim 11 , wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises expanding the database query to retrieve additional columns.
19. The apparatus of claim 11 , wherein the database query is a structured query language statement.
20. A computer program product for prefetching query results using expanded queries, the computer program product comprising a non-transitory computer readable medium and computer program instructions stored therein that, when executed, cause a computer to carry out:
generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve initial results from a table within a cloud-based data warehouse;
determining that the database query is expandable;
modifying the database query to retrieve expanded results from the cloud-based data warehouse, wherein the expanded results include the initial results, and wherein modifying the database query to retrieve the expanded results from the cloud-based data warehouse comprises one selected from a group consisting of expanding the database query to retrieve additional columns from the table and expanding the database query to retrieve additional rows from the table; and
fetching, from the cloud-based data warehouse, the expanded results using the modified database query.