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

Claim 7:
8. A method, comprising:
parsing a Data Manipulation Language (DML) statement that modifies an existing table in the database by applying data values to one or more columns of the existing table;
identifying one or more rows in the existing table that are associated with the data values to be applied to the one or more columns; and
determining, based on user-defined column attributes for the one or more columns in the existing table, whether to:
create new versions of the rows of the existing table when the data values of the one or more columns of the existing table are versioned, and
selectively update existing versions of the rows of the existing table without creating the new versions of the rows when the data values for the one or more columns of the existing table are not versioned, wherein the selectively update operates to:
1) when the user-defined column attributes represent “VERSION LAST ONLY,” then update the existing versions of the rows of the existing table with the data values to be applied to the one or more columns without creating the new versions of the rows, or
2) when the user-defined column attributes represent “VERSION FIRST ONLY,” then not update the existing versions of the rows of the existing table with the data values to be applied to the one or more columns without creating the new versions of the rows,
wherein the user-defined column attributes indicate that data changes associated with the data values for the one or more columns are not versioned in the existing table.