US 12,013,869 B2
Compiling a database query
Max H. Seiden, San Francisco, CA (US); Jason D. Frantz, San Francisco, CA (US); and Donald Huang, 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. 3, 2022, as Appl. No. 17/685,542.
Application 17/685,542 is a continuation of application No. 16/745,729, filed on Jan. 17, 2020, granted, now 11,281,687.
Prior Publication US 2022/0269690 A1, Aug. 25, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 17/00 (2019.01); G06F 16/2452 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 16/24522 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method of compiling a database query, the method comprising:
receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse;
converting, by the query compiler, the state specification into a database query including:
determining a first order of operations for elements within the state specification; and
converting the state specification into a hierarchy including inserting at least one intermediate expression into a source expression from the state specification; and
sending the database query to the data warehouse.