Teradata’s patented system and method extend compression-aware aggregation logic to column partitioned databases, enabling efficient processing of complex aggregate queries. The technique leverages compression information for fields within aggregate expressions, applicable to various compression techniques on columnar source tables like Column Partitioned or Parquet tables. GlobalData’s report on Teradata gives a 360-degree view of the company including its patenting strategy. Buy the report here.
Smarter leaders trust GlobalData
Access deeper industry intelligence
Experience unmatched clarity with a single platform that combines unique data, AI, and human expertise.
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 February 2024 was 81%. Grant share is based on the ratio of number of grants to total number of patents.
Extending compression-aware aggregation logic to column partitioned databases
A recently granted patent (Publication Number: US11899662B1) discloses a computer-implemented method for executing a relational database management system (RDBMS) in a computer system. The method involves managing a relational database with column-partitioned base tables and executing aggregation queries containing SELECT statements with aggregation expressions referencing multiple columns within the table. The RDBMS generates executable code for the queries, evaluates aggregation expressions, and performs aggregation using push-down aggregation techniques on intermediate result sets within the data storage facility. The method aims to efficiently handle aggregation queries in a database environment.
Furthermore, the patent claims cover various aspects of the method, including the use of Parquet tables, compressed columns, and GROUP-BY clauses in aggregation queries. The executable code generated by the RDBMS evaluates aggregation expressions, handles multiple SELECT statements, and utilizes push-down aggregation techniques for efficient processing. Additionally, the method involves reading column values, evaluating expressions, and generating intermediate result sets using system memory. The patent highlights the use of different aggregation functions like AVG, COUNT, MIN, MAX, and SUM within the SELECT statements. Overall, the patented method offers a comprehensive approach to executing aggregation queries in a relational database system, enhancing performance and scalability in data processing operations.
To know more about GlobalData’s detailed insights on Teradata, buy the report here.
Data Insights
From
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.
