Patent ID: 11874811
Assignee: TERADATA US, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 14:
15. A system, comprising:
a database management system;
at least one hardware processor;
a non-transitory computer-readable storage medium having executable instructions representing a version control manager;
the version control manager configured to execute on the at least one hardware processor from the non-transitory computer-readable storage medium and to perform processing to:
create a table with version-specific attributes defined on one or more columns of the table, wherein the version-specific attributes indicate whether data changes associated with data values for the one or more columns of the table are not to be versioned in new versions of rows in the table; and
process updates to the one or more columns of the table by either (1) creating the new versions of the rows in the table when the data changes are associated with the data values for the one or more columns of the table are to be versioned, or (2) updating existing versions of the rows in the table based on the version-specific attributes when the data changes are associated with the data values for the one or more columns of the table are not to be versioned in the new versions of the rows in the table, wherein:
when the version-specific attributes represent “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 versions of the rows in the table; and
when the version-specific attributes represent “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 versions of the rows in the table.