Sigma Computing, Inc.

Rodolphe Gagneron

Max H Seiden

Gregory George Owen

Stipo Josipovic

Luke Paulsen

Generating edited input tables for low-latency presentation including receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems; generating, by the workbook manager, a database statement comprising an uncommitted edit, wherein the database statement configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and providing, by the workbook manager, the input table comprising the uncommitted edit to the first workbook client on the first client computing system.

Generating edited input tables for low-latency presentation

Editing and updating database tables on a cloud-based data warehouse including receiving, by a table manager via a client computing system, an instruction to edit a modified base table on the cloud-based data warehouse, wherein the instruction comprises a table edit targeting the modified base table; locating, by the table manager, a modifications table on the cloud-based data warehouse associated with the modified base table, wherein the modified base table comprises a base table and the modifications table; and servicing the instruction to edit the modified base table by generating a database statement targeting the cloud-based data warehouse to apply the table edit to the modifications table associated with the modified base table.

Editing and updating database tables on a cloud-based data warehouse

Assigning sequence numbers in editable tables including receiving, by a table manager via a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value and a row identifier of an adjacent row; calculating, by the table manager, a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to add the new row, including the column value and sequence value, to the editable table on the cloud-based data warehouse.

Assigning sequence numbers in editable tables

Live editing editable tables including receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse; determining, by the table manager, that the requested editable table includes an uncommitted edit, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse; redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system, wherein the edit queue comprises the uncommitted edit; and servicing, by the table manager, the request for the editable table using the edit queue on the intermediary computing system.

Live editing editable tables

Remote storage of sensitive data for editable tables including receiving, via a client computing system, an instruction to add client data to an editable table in a cloud-based data warehouse, wherein the instruction comprises the client data and a table edit to the editable table; sending the client data to a client data log on the cloud-based data warehouse; storing, in an edit queue on an intermediary computing system, the table edit with a reference to the client data in the client data log on the cloud-based data warehouse; and generating a database statement to add the client data to the editable table in the cloud-based data warehouse, wherein the database statement lacks the client data and comprises the reference to the client data in the client data log on the cloud-based data warehouse.

Remote storage of sensitive data for editable tables

Versioning in editable tables including receiving, by a table manager via a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value; determining, by the table manager, a version value for the edit to the first row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the version value and the column value.

Versioning in editable tables

Generating edited input tables for low-latency presentation including receiving, by the workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on the cloud-based data warehouse; generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises: determining that a cache on the intermediary computing system includes an uncommitted input table edit; and inserting the uncommitted input table edit into the database statement; retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and providing, by the workbook manager, the query results to the first workbook client on the first client computing system.

Growing community of inventors

SAN DIEGO, CA, United States of America

Rodolphe Gagneron