Teradata‘s patent involves a method for controlling versioning of records in a temporal table to reduce data redundancy. New DDL syntax allows columns to be sensitive or insensitive to generating new row versions. The system manages versioning without additional programming, optimizing data storage and management efficiency. GlobalData’s report on Teradata gives a 360-degree view of the company including its patenting strategy. Buy the report here.

According to GlobalData’s company profile on Teradata, Zero Knowledge Proof was a key innovation area identified from patents. Teradata's grant share as of January 2024 was 76%. Grant share is based on the ratio of number of grants to total number of patents.

Control versioning of records in a temporal table

Source: United States Patent and Trademark Office (USPTO). Credit: Teradata Corp

A recently granted patent (Publication Number: US11874811B2) outlines a method for managing versioning in a database system. The method involves parsing a Data Definition Language (DDL) statement to identify version control data constructs for columns in a table, creating the table with version control attributes, and managing versioning based on these attributes. The system can create new row versions or selectively update existing versions depending on whether data changes are to be versioned or not. The method also includes recognizing specific attributes like "VERSION LAST ONLY" or "VERSION FIRST ONLY" to determine how data changes should be handled for non-versioned columns.

Furthermore, the patent describes a system that includes a database management system, hardware processor, and a version control manager. This manager is designed to create tables with version-specific attributes indicating whether data changes for certain columns should be versioned or not. It processes updates by either creating new versions of rows or updating existing versions based on these attributes. The system also includes features like "do not version" and "always version" attributes to control the versioning process, providing flexibility in managing data changes within the database system. Additionally, the version control manager can execute on a massively parallel backend data storage processor, enhancing performance and scalability in handling versioning operations within the database system.

To know more about GlobalData’s detailed insights on Teradata, buy the report here.

Premium Insights


The gold standard of business intelligence.

Blending expert knowledge with cutting-edge technology, GlobalData’s unrivalled proprietary data will enable you to decode what’s happening in your market. You can make better informed decisions and gain a future-proof advantage over your competitors.


GlobalData, the leading provider of industry intelligence, provided the underlying data, research, and analysis used to produce this article.

GlobalData Patent Analytics tracks bibliographic data, legal events data, point in time patent ownerships, and backward and forward citations from global patenting offices. Textual analysis and official patent classifications are used to group patents into key thematic areas and link them to specific companies across the world’s largest industries.