CPC G06F 16/219 (2019.01) [G06F 16/215 (2019.01)] | 17 Claims |
1. A method, comprising:
parsing a Data Definition Language (DDL) statement to obtain a version control data construct for one or more columns of a table defined by the DDL statement, wherein the parsing further includes recognizing the version control data construct as a command indicating whether data changes associated with data values for the one or more columns of the table are not to be versioned;
creating the table based on the DDL statement with a version control attribute set on the one or more columns that reflects the version control data construct; and
managing versioning for rows of the table based on the version control attribute for the one or more columns of the table, by:
creating a new row version when the data changes are associated with the data values of the one or more columns of the table that are to be versioned, and
selectively updating an existing row version without creating the new row version when the data changes are associated with the data values for the one or more columns of the table that are not to be versioned, wherein:
when the version control attribute represents “VERSION LAST ONLY”, then the data changes associated with the data values for the one or more columns of the table that are not to be versioned update the existing row version of the table; and
when the version control attribute represents “VERSION FIRST ONLY”, then the data changes associated with the data values for the one or more columns of the table that are not to be versioned do not update the existing row version of the table.
|