Amdocs has been granted a patent for a system, method, and computer program that identifies foreign keys between tables through statistical analysis of table values. The technology involves determining candidate field combinations, performing statistical analysis, and identifying foreign keys based on the analysis results. GlobalData’s report on Amdocs gives a 360-degree view of the company including its patenting strategy. Buy the report here.

Access deeper industry intelligence

Experience unmatched clarity with a single platform that combines unique data, AI, and human expertise.

Find out more

According to GlobalData’s company profile on Amdocs, Hybrid cloud mgmt was a key innovation area identified from patents. Amdocs's grant share as of May 2024 was 44%. Grant share is based on the ratio of number of grants to total number of patents.

Identifying foreign keys between tables based on statistical analysis

Source: United States Patent and Trademark Office (USPTO). Credit: Amdocs Ltd

A recently granted patent (Publication Number: US12007975B1) discloses a method stored on a non-transitory computer-readable medium that involves determining candidate field combinations between two tables. The method includes generating all possible field combinations between the tables, assigning scores based on specific parameters, and selecting candidate field combinations based on these scores. A statistical analysis of the values in each candidate field combination is then performed to identify foreign keys between the tables based on the analysis results. The parameters for scoring include data entropy and data characteristics between fields, with the identification of foreign keys further refined based on cardinality between fields.

Furthermore, the patent also covers a system comprising a non-transitory memory storing instructions and one or more processors executing these instructions to determine candidate field combinations between tables. The system generates scores for field combinations based on parameters, selects candidate field combinations, performs statistical analysis on values within these combinations, and identifies foreign keys based on the analysis results. The method aims to accurately identify foreign keys between tables by utilizing statistical analysis and specific parameters to score field combinations, ultimately improving data management and relational database operations.

To know more about GlobalData’s detailed insights on Amdocs, 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

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.