Patent ID: 11886404
Assignee: OPTUM SERVICES (IRELAND) LIMITED
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. The method of claim 9, wherein determining the target set of columns based on the CS scores for the columns of the first table of the current model of the database comprises:
for each respective column of the first table, determining, by the computing system, a Table Selectivity (TS) score for the respective column based on a number of distinct values in the respective column of the first table and a number of rows in the respective column of the first table;
determining, by the computing system, a set of one or more joint groups of columns, wherein the CS score for each column in each of the joint groups of columns is below a predefined selectivity threshold; and
determining, by the computing system, a TS score for each of one or more joint groups of columns, and
determining, by the computing system, the target set of columns as being one of the joint groups of columns having a lowest TS score.