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

From WikiPatents
Jump to navigation Jump to search

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

Organization Name

Dell Products L.P.

Inventor(s)

Seth Jacob Rothschild of Littleton MA (US)

Brendan Burns Healy of Whitefish Bay WI (US)

Akshaya Khare of Medford MA (US)

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.

Retrieved from "http://wikipatents.org/index.php?title=17806549._AN_EFFICIENT_METHOD_TO_FIND_COLUMNS_OF_A_TABLE_WHICH_ARE_UNIQUE_simplified_abstract_(Dell_Products_L.P.)&oldid=17920"