US 12,248,459 B2
Versioning in editable tables
Max H. Seiden, San Francisco, CA (US); Rodolphe Gagneron, San Diego, CA (US); and Gregory G. Owen, San Mateo, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Dec. 22, 2021, as Appl. No. 17/559,711.
Claims priority of provisional application 63/278,356, filed on Nov. 11, 2021.
Prior Publication US 2023/0143272 A1, May 11, 2023
Int. Cl. G06F 16/23 (2019.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/2458 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01); G06F 21/62 (2013.01)
CPC G06F 16/2379 (2019.01) [G06F 16/219 (2019.01); G06F 16/2282 (2019.01); G06F 16/2474 (2019.01); G06F 16/254 (2019.01); G06F 16/283 (2019.01); G06F 21/6227 (2013.01); G06F 21/6245 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A method for versioning in editable tables, the method comprising:
receiving, by a table manager from 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 an indication that a location of the first row within the editable table has changed, and wherein the first row in the editable table on the cloud-based data warehouse comprises a current sequence number and a current version value;
determining, by the table manager, an updated 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 updated version value and an updated sequence value indicating the changed location of the first row in the editable table,
wherein the table manager is hosted by an intermediary computing system separate from the client computing system and the cloud-based data warehouse, and
wherein the cloud-based data warehouse creates the second row in response to receiving the database statement.