Invention Grant
- Patent Title: Database table column annotation
-
Application No.: US14785744Application Date: 2013-04-30
-
Publication No.: US10248620B2Publication Date: 2019-04-02
- Inventor: Hoa Binh Nga Tran , Lakshmikant Shrinivas , Kanti Marita Mann
- Applicant: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
- Applicant Address: US CA Sunnyvale
- Assignee: ENTIT SOFTWARE LLC
- Current Assignee: ENTIT SOFTWARE LLC
- Current Assignee Address: US CA Sunnyvale
- International Application: PCT/US2013/038842 WO 20130430
- International Announcement: WO2014/178843 WO 20141106
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/21 ; G06F16/28 ; G06F16/23 ; G06F17/30 ; G06F16/2455

Abstract:
According to an example, database constraint generation may include receiving data related to a table in a database, analyzing the data to determine a row count for a column of the table, and analyzing the data to determine a number of distinct values for the column of the table. A comparison value may be determined by comparing the row count to the number of distinct values. The database constraint generation may further include determining if the comparison value is within a threshold. If the comparison value is within the threshold, an annotation may be added to the column of the table such that the column is considered unique during a cardinality estimation process involving the table.
Public/Granted literature
- US20160078070A1 DATABASE TABLE COLUMN ANNOTATION Public/Granted day:2016-03-17
Information query