US 12,277,110 B2
Prefetching query results using expanded queries
Jason D. Frantz, San Francisco, CA (US); and Dmitri Bronnikov, Foster City, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Nov. 18, 2021, as Appl. No. 17/529,748.
Prior Publication US 2023/0153295 A1, May 18, 2023
Int. Cl. G06F 16/242 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2425 (2019.01) [G06F 16/2423 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
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.