View source for 17806549. AN EFFICIENT METHOD TO FIND COLUMNS OF A TABLE WHICH ARE UNIQUE simplified abstract (Dell Products L.P.)

=AN EFFICIENT METHOD TO FIND COLUMNS OF A TABLE WHICH ARE UNIQUE=


==Organization Name==

[[:Category:Dell Products L.P.|Dell Products L.P.]]


[[Category:Dell Products L.P.]]

==Inventor(s)==

[[:Category:Seth Jacob Rothschild of Littleton MA (US)|Seth Jacob Rothschild of Littleton MA (US)]][[Category:Seth Jacob Rothschild of Littleton MA (US)]]

[[:Category:Brendan Burns Healy of Whitefish Bay WI (US)|Brendan Burns Healy of Whitefish Bay WI (US)]][[Category:Brendan Burns Healy of Whitefish Bay WI (US)]]

[[:Category:Akshaya Khare of Medford MA (US)|Akshaya Khare of Medford MA (US)]][[Category:Akshaya Khare of Medford MA (US)]]

[[:Category:Kranti Uppala of Milford MA (US)|Kranti Uppala of Milford MA (US)]][[Category:Kranti Uppala of Milford MA (US)]]

==AN EFFICIENT METHOD TO FIND COLUMNS OF A TABLE WHICH ARE UNIQUE - A simplified explanation of the abstract==


This abstract first appeared for US patent application 17806549 titled 'AN EFFICIENT METHOD TO FIND COLUMNS OF A TABLE WHICH ARE UNIQUE

==Simplified Explanation==

The abstract of this patent application describes a method for determining whether a column in a table can be considered as a primary key. Here is a simplified explanation:

* The method starts by identifying a column in a table that contains multiple entries.
* A proposed uniqueness is set for the column, which means determining how unique the values in the column should be.
* A confidence tolerance is set for the proposed uniqueness, which determines the level of certainty required for considering the column as a primary key.
* Based on the proposed uniqueness and confidence tolerance, an estimated sub-sample size is calculated for the column. This determines the number of entries that need to be sampled.
* Using the sub-sample size, a subset of entries is randomly sampled from the column.
* Based on the sampled subset, it is determined whether the column can be considered as a primary key for the table.

Potential applications of this technology:

* Database management systems can use this method to automatically determine primary keys for tables, saving time and effort for database administrators.
* Data analysis and data mining applications can benefit from this method to identify unique identifiers in large datasets.

Problems solved by this technology:

* Manual identification of primary keys in large tables can be time-consuming and prone to errors. This method automates the process and provides a reliable way to determine primary keys.
* Ensuring the uniqueness of values in a column is crucial for maintaining data integrity. This method helps in verifying the uniqueness of a column and identifying potential primary keys.

Benefits of this technology:

* Saves time and effort by automating the process of determining primary keys.
* Provides a reliable and systematic approach to ensure the uniqueness of values in a column.
* Reduces the risk of errors in identifying primary keys, leading to improved data integrity.


==Original Abstract Submitted==

One example method includes identifying a column of a table, and the column includes multiple entries, setting a proposed uniqueness for the column, setting a confidence tolerance for the proposed uniqueness, estimating a sub-sample size for the column based on the proposed uniqueness and the confidence tolerance, based on the sub-sample size, sampling a subset of the entries in the column and, based on the sampling, determining whether or not the column is a primary key for the table.



[[Category:G06F16/22]]