Granted Patent B2

US 12,481,671 · App. 18/170,232 · Granted Nov 25, 2025

Inventors: Gregory G. Owen (San Mateo, CA); Luke Paulsen (Mountain View, CA); Stipo Josipovic (San Francisco, CA); Siyuan Fan (San Francisco, CA); Max H. Seiden (San Francisco, CA)

Assignee: SIGMA COMPUTING, INC.

G06F16/254G06F16/2282

Abstract

Claims (55)

1 . A method for editing data-warehouse tables using managed input tables, the method comprising:

presenting, by a table manager via a client computing system, a base table from a cloud-based data warehouse;

receiving, by the table manager, an instruction to modify the base table, wherein the instruction comprises a table edit;

creating, by the table manager, an input table on the cloud-based data warehouse to store edits to the base table,

wherein the input table is stored separately from the base table and identified via a mapping maintained by the table manager, and

wherein a change to the base table is subsequently reflected in query results;

applying, by the table manager to the input table on the cloud-based data warehouse, the table edit targeting the base table; and

presenting, by the table manager, as a modified base table, query results of a database statement composed to combine the base table with the input table,

wherein the input table is maintained as a separate database object in the cloud-based data warehouse,

wherein the table manager presents a merged view generated by the database statement that combines the input table and the base table without persisting changes to the base table,

wherein the input table comprises a calculation column that references a column in the base table, and

wherein the database statement is composed on an intermediary computing system.

2 . The method of claim 1 , further comprising:

receiving a request to present the modified base table on the client computing system;

retrieving, from the cloud-based data warehouse, query results comprising the base table merged with the input table; and

presenting, on the client computing system, the query results comprising the base table merged with the input table.

3 . The method of claim 1 , wherein receiving the instruction to modify the base table comprises:

receiving data copied from a source external to a table manager client on the client computing system; and

identifying a type associated with the data copied from the source.

4 . The method of claim 1 , wherein the modified base table comprises a column comprising at least one cell from the base table and at least one cell from the input table.

5 . The method of claim 1 , wherein the table manager is on an intermediary computing system.

6 . The method of claim 1 , wherein the database statement is a structured query language statement.

7 . An apparatus for editing data-warehouse tables using managed input tables, 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:

presenting, via a client computing system, a base table from a cloud-based data warehouse;

receiving an instruction to modify the base table, wherein the instruction comprises a table edit;

creating an input table on the cloud-based data warehouse to store edits to the base table,

wherein the input table is stored separately from the base table and identified via a mapping maintained by a table manager, and

wherein a change to the base table is subsequently reflected in query results;

applying, to the input table on the cloud-based data warehouse, the table edit targeting the base table; and

presenting, as a modified base table, query results of a database statement composed to combine the base table with the input table,

wherein the input table is maintained as a separate database object in the cloud-based data warehouse,

wherein the table manager presents a merged view generated by the database statement that combines the input table and the base table without persisting changes to the base table,

wherein the input table comprises a calculation column that references a column in the base table, and

wherein the database statement is composed on an intermediary computing system.

8 . The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out the steps of:

receiving a request to present the modified base table on the client computing system;

retrieving, from the cloud-based data warehouse, query results comprising the base table merged with the input table; and

presenting, on the client computing system, the query results comprising the base table merged with the input table.

9 . The apparatus of claim 7 , wherein the table edit overwrites a cell on a column within the base table.

10 . The apparatus of claim 7 , wherein receiving the instruction to modify the base table comprises:

receiving data copied from a source external to a table manager client on the client computing system; and

identifying a type associated with the data copied from the source.

11 . The apparatus of claim 7 , wherein the modified base table comprises a column comprising at least one cell from the base table and at least one cell from the input table.

12 . The apparatus of claim 7 , wherein the table manager is on an intermediary computing system.

13 . A computer program product for editing data-warehouse tables using managed input tables, the computer program product disposed upon a computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:

presenting, via a client computing system, a base table from a cloud-based data warehouse;

receiving an instruction to modify the base table, wherein the instruction comprises a table edit;

creating an input table on the cloud-based data warehouse to store edits to the base table,

wherein the input table is stored separately from the base table and identified via a mapping maintained by a table manager, and

wherein a change to the base table is subsequently reflected in query results applying, to the input table on the cloud-based data warehouse, the table edit targeting the base table; and

presenting, as a modified base table, query results of a database statement composed to combine the base table with the input table,

wherein the input table is maintained as a separate database object in the cloud-based data warehouse,

wherein the table manager presents a merged view generated by the database statement that combines the input table and the base table without persisting changes to the base table,

wherein the input table comprises a calculation column that references a column in the base table, and

wherein the database statement is composed on an intermediary computing system.

Assignments (2)

Continuity (3)

References Cited (77)