US 11,874,811 B2
Control versioning of temporal tables to reduce data redundancy
Stephen Molini, Omaha, NE (US); Bhashyam Ramesh, Secunderabad (IN); Jaiprakash Ganpatrao Chimanchode, PeeranCheruvu Hyderabad (IN); Sai Pavan Kumar Pakala, Hyderabad (IN); Pratik Patodi, Raipur C.G. (IN); Dhrubajyoti Roy, Kolkata (IN); and Todd Walter, Mississauga (CA)
Assigned to Teradata US, Inc., San Diego, CA (US)
Filed by Stephen Molini, Omaha, NE (US); Bhashyam Ramesh, Secunderabad (IN); Jaiprakash Ganpatrao Chimanchode, PeeranCheruvu Hyderabad (IN); Sai Pavan Kumar Pakala, Hyderabad (IN); Pratik Patodi, Raipur C.G. (IN); Dhrubajyoti Roy, Kolkata (IN); and Todd Walter, Mississauga (CA)
Filed on Dec. 28, 2018, as Appl. No. 16/235,830.
Prior Publication US 2020/0210395 A1, Jul. 2, 2020
Int. Cl. G06F 16/21 (2019.01); G06F 16/215 (2019.01)
CPC G06F 16/219 (2019.01) [G06F 16/215 (2019.01)] 17 Claims
OG exemplary drawing
 
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.