Assigning sequence numbers in editable tables
AssigneeSigma Computing, Inc.
InventorsMAX H. SEIDEN, RODOLPHE GAGNERON, GREGORY G. OWEN
Life of this patent
Estimating the term…
Abstract
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.
Claims20
A method for assigning sequence numbers in editable tables, the method comprising:
- 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.
An apparatus for assigning sequence numbers in editable 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:
- receiving, 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 a sequence value for a sequence column of the new row based on the row identifier of the adjacent row;
- and
- generating 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.
A computer program product for assigning sequence numbers in editable tables, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
- receiving, 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 a sequence value for a sequence column of the new row based on the row identifier of the adjacent row;
- and
- generating 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.
Dependencies are inferred from the claim text.