US 12,411,819 B2
Creating accessible model data sets
Jason D. Frantz, San Francisco, CA (US); Max H. Seiden, San Francisco, CA (US); Donald Huang, San Francisco, CA (US); and Stipo Josipovic, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Jul. 7, 2020, as Appl. No. 16/922,213.
Claims priority of provisional application 62/978,084, filed on Feb. 18, 2020.
Prior Publication US 2021/0256001 A1, Aug. 19, 2021
Int. Cl. G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/2457 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/212 (2019.01) [G06F 16/2282 (2019.01); G06F 16/24573 (2019.01); G06F 16/283 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A method of creating accessible model data set worksheets, the method comprising:
receiving, by a query manager via a spreadsheet interface, an instruction to create a model data set worksheet using a data source from a database within a data warehouse, wherein the query manager is included in a computing system separate from the data warehouse and the query manager is not authorized to make changes to the data source of the data warehouse, and wherein the model data set worksheet is a reusable modeling layer comprising at least a portion of the data source from the data warehouse;
building, by the query manager using the instruction to create the model data set worksheet, a first query statement comprising instructions to generate the model data set worksheet from the portion of the data source from the data warehouse, wherein building the first query statement includes converting the received instruction into model data set worksheet metadata and storing the model data set worksheet metadata local to the query manager;
storing, by the query manager, the first query statement in a schema storage location within the data warehouse, wherein the schema storage location is within the data warehouse and external to the data source from the database;
storing, by the query manager, the model data set worksheet as a table in the schema storage location within the data warehouse in which the first query statement is stored;
servicing a request to create a new worksheet dependent upon the model data set worksheet, including:
retrieving the model data set worksheet from the schema storage location within the data warehouse;
creating, using the model data set worksheet, the new worksheet configured to perform analysis on the portion of the data source from the model data set worksheet, wherein the new worksheet comprises elements that use the portion of the data source from model data set worksheet as input for analysis, and wherein the new worksheet accesses the model data set worksheet as a read-only artifact; and
presenting, on a client computing system, the new worksheet in a view mode that prevents destructive edits and changes to the model data set worksheet and allows additive edits to the model data set worksheet within the new worksheet;
receiving, by the query manager via the spreadsheet interface, an instruction to modify the model data set worksheet;
building, by the query manager using the instruction to modify the model data set worksheet, a second query statement comprising instructions to generate the modified model data set worksheet; and
replacing, by the query manager, the first query statement in the schema storage location within the data warehouse with the second query statement.