DETECTION AND CREATION OF APPROPRIATE ROW CONCEPT DURING AUTOMATED MODEL GENERATION

• US 20160224656A1
• Filed: 02/26/2016
• Published: 08/04/2016
• Est. Priority Date: 01/30/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Rais-Ghasem, Mohsen, Watts, Graham A., Wei, Qing
• Granted Patent: US 10,019,507 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/285 Clustering or classification

Abstract

A system and method for assigning concepts to sets of values. Data is received, wherein the data is organized as a plurality of named fields and as two or more sets of values associated with the named fields, wherein each named field is assigned to a category. For each category, determine whether there is at least one identifier field for that category, wherein each identifier field is a named field that acts as an identifier for that category, and identify identifier fields, if any, for each category that have a unique value in the identifier field for that category for each set of values. Then select one of the categories as a concept representing the sets of values. In some embodiments, the data is organized as a table, wherein the named fields are columns and the sets of values are rows.

Claims

1. A method comprising:

receiving data, wherein the data is organized as a plurality of named fields and as two or more sets of values associated with the named fields, wherein each named field is assigned to a category;

determining, for each category, whether there is at least one identifier field for that category, wherein each identifier field is a named field that acts as an identifier for that category;

identifying, for each category, identifier fields, if any, for that category that have a unique value in the identifier field for that category for each set of values; and

selecting one of the categories as a concept representing the sets of values.

2. The method of claim 1, wherein the data is organized as a table, wherein the named fields are columns and the sets of values are rows.

3. The method of claim 1, wherein selecting includes selecting two or more fields that, when combined, have a unique value across the two or more fields for each set of values.

4. The method of claim 1, wherein selecting includes selecting a category that includes an identifier field with a unique value in the identifier field for that category for each set of values.

5. The method of claim 1, wherein selecting includes selecting a category that includes two or more identifier fields that, when combined, have a unique value across the two or more identifier fields for that category for each set of values.

6. The method of claim 1, wherein selecting includes:

selecting two or more categories, wherein the categories include an identifier field with a unique value in the identifier field for each category for each set of values;

grouping the selected categories; and

using the grouped selected categories as the concept representing the sets of values.

7. The method of claim 1, wherein selecting includes:

selecting an identifier field in each of two or more categories that, when combined, has a unique value across the two or more identifier fields for each set of values; and

combining the two or more categories with the selected identifier fields as the concept representing the sets of values.

8. The method of claim 7, wherein combining the two or more categories adding a new named field associated with the identified concept and inserting a unique value in that field for each set of values.

9. The method of claim 1, wherein selecting includes selecting, as a concept, a category that does not include an identifier field and creating a new identifier field representing that concept.

10. The method of claim 1, wherein selecting includes adding a new named field and inserting a unique value in that field for each set of values.

11. The method of claim 1, wherein selecting one of the categories includes identifying the category, adding a new named field associated with the identified category and inserting a unique value in that field for each set of values.