US 11,989,177 B1
Compiling optimized database statements
Max H. Seiden, San Francisco, CA (US); and Deepanshu Utkarsh, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Mar. 17, 2023, as Appl. No. 18/186,066.
Application 18/186,066 is a continuation of application No. 17/061,148, filed on Oct. 1, 2020, granted, now 11,663,203.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/242 (2019.01); G06F 16/245 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/2428 (2019.01) [G06F 16/2423 (2019.01); G06F 16/2454 (2019.01)] 18 Claims
OG exemplary drawing
 
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 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.