CDW has been granted a patent for a selective database rollback method and system, along with a method for identifying database keys. The technology involves comparing data types and values to identify foreign keys in a database, aiding in efficient data management and recovery. GlobalData’s report on CDW 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 CDW, was a key innovation area identified from patents. CDW's grant share as of February 2024 was 45%. Grant share is based on the ratio of number of grants to total number of patents.
Database rollback and key identification method
A recently granted patent (Publication Number: US11868217B2) discloses a computer-implemented method for identifying a key of a database. The method involves comparing data types and values of columns in different tables to compute similarity scores. When these scores surpass a certain threshold, the method identifies a column in one table as a foreign key of a column in another table. The database key can be either a foreign key or a primary key, with the foreign key being classified as intentional or natural. The method is specifically designed for relational databases but can also handle unstructured tabular data, spreadsheet files, or comma-separated value data.
Moreover, the patent includes a computing system and a computer-readable medium with similar functionalities. The computing system comprises processors and memories storing computer-executable instructions to carry out the key identification process. It can analyze hints files for key indications, utilize machine learning models to compare column data types, and assess existing indexes in tables. Similarly, the computer-readable medium contains instructions for identifying foreign keys based on column and value similarity scores, along with utilizing machine learning models for data type analysis. These innovations aim to streamline the process of identifying database keys, especially in complex relational databases or unstructured data formats, enhancing data management efficiency and accuracy.
To know more about GlobalData’s detailed insights on CDW, 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.
