Field correlation method and system, and program thereof

• US 8,843,818 B2
• Filed: 03/04/2008
• Issued: 09/23/2014
• Est. Priority Date: 03/09/2007
• Status: Active Grant

• Current Assignee: NEC Corporation
• Original Assignee: NEC Corporation
• Inventors: Tateishi, Kenji, Kusui, Dai
• Primary Examiner(s): Mills, Frank D
• Application Number:
  US12/530,554
• Publication Number:
  US 20100100804A1
• Time in Patent Office: 2,394 Days
• Field of Search: 715/227, 715/225
• US Class Current: 715/225
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

A field pair as a combination of a definite field and an indefinite field is decided and a correlation value between the definite field and the indefinite field in each of the field pairs is calculated. Among the field pairs in which the correlation value is not smaller than a threshold value, indefinite fields having corresponding definite fields which belong to the same field group are made to be a new field group.

Claims

1. A field collation method for grouping fields corresponding to each other between different tables, comprising:

pre-storing a field group in which the fields corresponding to each other between different tables have been grouped;

making a pair of a definite field and an indefinite field within an identical table, in each table, and calculating a correlation value between the definite field and the indefinite field of said pair, wherein said definite field belong s to an field group and said indefinite field does not belong to an field group;

obtaining the pair in which the definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold in the tables; and

grouping the indefinite fields of said pairs in which said definite fields belong to the identical field group as a new field group.

2. A field collation method according to claim 1, further comprising employing calculation methods that differs responding to a combination of the field types of two fields when the correlation value of the two fields is calculated, wherein said calculation methods include a first calculation method when the field types are a category and a category, a second calculation method when the field types are a category and a numerical value, and a third calculation method when the field types area category and a character string.

3. A field collation method according to claim 1, further comprising displaying a correspondence relation of the fields grouped as a new field group.

4. A field collation method according to claim 1, further comprising displaying a correlation of the fields in which the correlation value with the field grouped as a new field group is equal to or more than a predetermined threshold.

5. A field collation method according to claim 1, comprising:

composing a pair from a plurality of definite fields and one indefinite field;

calculating the correlation value between said plurality of said definite fields and said one indefinite field;

obtaining the pair in which said plurality of said definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold; and

grouping the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group.

6. A field collation system for grouping fields corresponding to each other between different tables, comprising:

hardware, including a processor;

a field group storage in which a field group in which the fields corresponding to each other between different tables have been grouped has been stored;

a field correlation value calculator implemented at least by the hardware for making a pair of a definite field and an indefinite field within an identical table, in each table, and calculating a correlation value between the definite field and the indefinite field of said pair, wherein said definite field belongs to any field group and said indefinite field does not belong to any field group; and

a field group determining unit implemented at least by the hardware for, based upon the field group stored in said field group storage, obtaining the pair in which the definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold in the tables, grouping the indefinite fields of said pairs as a new field group, and registering it into said field group storage.

8. A field collation system according to claim 6, wherein said field correlation value calculator, when calculating the correlation value of the two fields, employs a calculation methods that differs responding to a combination of the field types of the two fields, wherein said calculation methods include a first calculation method when the field types are a category and a category, a second calculation method when the field types are a category and a numerical value, and a third calculation method when the field types are a category and a character string.

9. A field collation system according to claim 6, comprising a displaying controller for displaying a correspondence relation of the fields grouped as a new field group.

10. A field collation system according to claim 6, comprising a displaying controller for displaying a correlation of the fields in which the correlation value with the field grouped as a new field group is equal to or more than a predetermined threshold.

11. A field collation system according to claim 6,

wherein said field correlation value calculator calculates the correlation value between a plurality of the definite fields, and the one indefinite field;

and

wherein said field group determining unit obtains the pair in which said plurality of said definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold, and groups the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group.

12. A field collation system according to claim 6,

wherein said field correlation value calculator calculates the correlation value between a plurality of the definite fields and the one indefinite field;

and

wherein said field group determining unit, out of the indefinite field aggregation in which said correlation value is equal to or more than a predetermined threshold, determines the indefinite fields belonging to a field group identical to the field group, to which each of a plurality of the definite fields corresponding to the above indefinite field belongs, based upon said field group information, groups these indefinite fields as a new field group, and registers it into said field group storage.

7. A field collation system for grouping fields corresponding to each other between different tables, comprising:

hardware, including a processor;

a field group storing unit, implemented at least by the hardware, in which table information for identifying a table, field information for identifying fields in the above table, and field group information indicative of a definite field for which a correspondence has become definite between the tables, out of the fields in the above table, and a correspondence between said definite fields have been stored correspondingly to each other;

a field correlation storing unit, implemented at least by the hardware, in which said table information, indefinite field information for identifying an indefinite field for which a correspondence is indefinite between the tables, out of the fields in the table of said table information, the definite field information of the definite field, out of the fields in the table of said table information, and a correlation value between said indefinite field and said definite field are stored correspondingly to each other;

a field correlation value calculator, implemented at least by the hardware, for, based upon said table information, said field information, and said field group information stored in said field group storing unit, calculating a correlation value between the indefinite field and the definite field information within the identical table, and storing a result in said field correlation storing unit; and

a field group determining unit, implemented at least by the hardware, for, out of an indefinite field aggregation in which the correlation value stored in said field correlation storing unit is equal to or more than a predetermined threshold, determining the indefinite field belonging to a field group identical to the field group, to which the definite field corresponding to the above indefinite field belongs together with the definite field of the different table, based upon said field group information, grouping the indefinite fields belonging to a field group identical to the field group, to which the corresponding definite field belongs, as a new field group, and registering the field group information of the above group into said field group storage so that it corresponds to the field information of the indefinite fields of the new field group.

22. A field collation system according to claim 7, wherein said field correlation value calculator, when calculating the correlation value of the two fields, employs calculation methods that differs responding to a combination of the field types of two fields, wherein said calculation methods include a first calculation method when the field types are a category and a category, a second calculation method when the field types are a category and a numerical value, and a third calculation method when the field types are a category and a character string.

23. A field collation system according to claim 7, comprising a displaying controller for displaying a correspondence relation of the fields grouped as a new field group.

24. A field collation system according to claim 7, comprising a displaying controller for displaying a correlation of the fields in which the correlation value with the field grouped as a new field group is equal to or more than a predetermined threshold.

25. A field collation system according to claim 7,

wherein said field correlation value calculator calculates the correlation value between a plurality of the definite fields, and the one indefinite field;

and

wherein said field group determining unit obtains the pair in which said plurality of said definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold, and groups the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group.

26. A field collation system according to claim 7,

wherein said field correlation value calculator calculates the correlation value between a plurality of the definite fields and the one indefinite field;

and

wherein said field group determining unit, out of the indefinite field aggregation in which said correlation value is equal to or more than a predetermined threshold, determines the indefinite fields belonging to a field group identical to the field group, to which each of a plurality of the definite fields corresponding to the above indefinite field belongs, based upon said field group information, groups these indefinite fields as a new field group, and registers it into said field group storage.

13. A non-transitory recording medium stored a program of a field collation for causing an information processing device comprising a field group storage in which a field group in which fields corresponding to each other between tables have been grouped has been stored to group the fields corresponding to each other between different tables, said program causing said information processing device to execute the processes of:

making a pair of a definite field and an indefinite field within an identical table, in each table, and calculating a correlation value between the definite field and the indefinite field of said pair, wherein said definite field belongs to an field group and said indefinite field does not belong to an field group; and

based upon the field group stored in said field group storage, obtaining the pair in which the definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold in the tables, grouping the indefinite fields of said pairs as a new field group, and registering it into said field group storage.

14. A non-transitory recording medium stored a program of a field collation for causing an information processing device comprising:

a field group storing unit in which table information for identifying a table, field information for identifying fields in the above table, and field group information indicative of a definite field for which a correspondence has become definite between the tables, out of the fields in the above table, and a correspondence between said definite fields have been stored correspondingly to each other; and

a field correlation storing unit in which said table information, indefinite field information for identifying an indefinite field for which a correspondence is indefinite between the tables, out of the fields in the table of said table information, the definite field information of the definite field, out of the fields in the table of said table information, and a correlation value between said indefinite field and said definite field are stored correspondingly to each other to group the fields corresponding to each other between the different tables, said program causing said information processing device to execute the processes of;

based upon said table information, said field information, and said field group information stored in said field group storing unit, calculating a correlation value between the indefinite field and the definite field information within the identical table, and storing a result in said field correlation storing unit; and

out of an indefinite field aggregation in which the correlation value stored in said field correlation storing unit is equal to or more than a predetermined threshold, determining the indefinite field belonging to a field group identical to the field group, to which the definite field corresponding to the above indefinite field belongs together with the definite field of the different table, based upon said field group information, grouping the indefinite fields belonging to a field group identical to the field group, to which the corresponding definite field belongs, as a new field group, and registering the field group information of the above group into said field group storage so that it corresponds to the field information of the indefinite fields of the new field group.

15. A field collating device for employing a field group storage in which a field group in which fields corresponding to each other between tables have been grouped has been stored, thereby to group the fields corresponding to each other between the different tables, said field collating device comprising:

hardware, including a processor;

a field correlation value calculator implemented at least by the hardware for, in each table, making a pair of a definite field, and an indefinite field within an identical table, and calculating a correlation value between the definite field and the indefinite field of said pair, wherein said definite field belongs to any field group and said indefinite field does not belong to any field group; and

a field group determining unit implemented at least by the hardware for, based upon the field group stored in said field group storage, obtaining the pair in which the definite fields belongs to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold in the tables, grouping the indefinite fields of said pairs as a new field group, and registering it into said field group storage.

17. A field collating device according to claim 15, wherein said field correlation value calculator, when calculating the correlation value between the two fields, employs calculations method that differs responding to a combination of the field types of two fields, wherein said calculation methods include a first calculation method when the field types are a category and a category, a second calculation method when the field types are a category and a numerical value, and a third calculation method when the field types are a category and a character string.

18. A field collating device according to claim 15, comprising a displaying controller for displaying a correspondence relation of the fields grouped as a new field group.

19. A field collating device according to claim 15, comprising a displaying controller for displaying a correlation of the fields in which the correlation value with the field grouped as a new field group is equal to or more than a predetermined threshold.

20. A field collating device according to claim 15,

wherein said field correlation value calculator calculates a correlation value between a plurality of definite fields, and one indefinite field;

and

wherein said field group determining unit obtains the pair in which said plurality of said definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold, and groups the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group.

21. A field collating device according to claim 15,

wherein said field correlation value calculator calculates a correlation value between a plurality of the definite fields and the one indefinite field;

and

wherein said field group determining unit, out of the indefinite field aggregation in which said correlation value is equal to or more than a predetermined threshold, determines the indefinite fields belonging to a field group identical to the field group, to which each of a plurality of the definite fields corresponding to the above indefinite field belongs, based upon said field group information, groups these indefinite fields as a new field group, and registers it into said field group storage.

16. A field collating device for employing:

hardware, including a processor;

a field group storing unit implemented at least by the hardware in which table information for identifying a table, field information for identifying fields in the above table, and field group information indicative of a definite field for which a correspondence has become definite between the tables, out of the fields in the above table, and a correspondence between said definite fields have been stored correspondingly to each other; and

a field correlation storing unit implemented at least by the hardware in which said table information, indefinite field information for identifying an indefinite field for which a correspondence is indefinite between the tables, out of the fields in the table of said table information, the definite field information of the definite field, out of the fields in the table of said table information, and a correlation value between said indefinite field and said definite field are stored correspondingly to each other, thereby to group the fields corresponding to each other between the different tables, said field collating device comprising;

a field correlation value calculator for, based upon said table information, said field information, and said field group information stored in said field group storing unit, calculating a correlation value between the indefinite field and the definite field information within the identical table, and storing a result in said field correlation storing unit; and

a field group determining unit for, out of an indefinite field aggregation in which the correlation value stored in said field correlation storing unit is equal to or more than a predetermined threshold, determining the indefinite field belonging to a field group identical to the field group, to which the definite field corresponding to the above indefinite field belongs together with the definite field of the different table, based upon said field group information, grouping the indefinite fields belonging to a field group identical to the field group, to which the corresponding definite field belongs, as a new field group, and registering the field group information of the above group into said field group storage so that it corresponds to the field information of the indefinite fields of the new field group.

27. A field collation device according to claim 16, wherein said field correlation value calculator, when calculating the correlation value between the two fields, employs calculation methods that differs responding to a combination of the field types of two fields, wherein said calculation methods include a first calculation method when the field types are a category and a category, a second calculation method when the field types are a category and a numerical value, and a third calculation method when the field types are a category and a character string.

28. A field collating device according to claim 16, comprising a displaying controller for displaying a correspondence relation of the fields grouped as a new field group.

29. A field collating device according to claim 16, comprising a displaying controller for displaying a correlation of the fields in which the correlation value with the field grouped as a new field group is equal to or more than a predetermined threshold.

30. A field collating device according to claim 16,

wherein said field correlation value calculator calculates a correlation value between a plurality of definite fields, and one indefinite field;

and

wherein said field group determining unit obtains the pair in which said plurality of said definite fields belong to the identical field group, out of the pairs in which said correlation value exceeds a predetermined threshold, and groups the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group.

31. A field collating device according to claim 16,

wherein said field correlation value calculator calculates a correlation value between a plurality of the definite fields and the one indefinite field;

and

wherein said field group determining unit, out of the indefinite field aggregation in which said correlation value is equal to or more than a predetermined threshold, determines the indefinite fields belonging to a field group identical to the field group, to which each of a plurality of the definite fields corresponding to the above indefinite field belongs, based upon said field group information, groups these indefinite fields as a new field group, and registers it into said field group storage.