FIELD CORRELATION METHOD AND SYSTEM, AND PROGRAM THEREOF
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
62 Claims
-
1-31. -31. (canceled)
-
32. 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 the tables have been grouped; making a pair of a definite field that belongs to any field group, and an indefinite field that does not belong to any field group in each table, and calculating a correlation value between the definite field and the indefinite field of this pair; 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; and grouping the indefinite fields of the pair in which said definite fields belong to the identical field group as a new field group. - View Dependent Claims (33, 34, 35, 36)
-
-
37. A field collation system for grouping fields corresponding to each other between different tables, comprising:
-
a field group storage in which a field group in which the fields corresponding to each other between the tables have been grouped has been stored; a field correlation value calculator for making a pair of a definite field that belongs to any field group, and an indefinite field that does not belong to any field group in each table, and calculating a correlation value between the definite field and the indefinite field of this pair; and a field group determining unit 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, grouping the indefinite fields of this pair as a new field group, and registering it into said field group storage. - View Dependent Claims (39, 40, 41, 42, 43)
-
-
38. A field collation system for grouping fields corresponding to each other between different tables, 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; 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; 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. - View Dependent Claims (53, 54, 55, 56, 57)
-
-
44. A 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 that belongs to any field group, and an indefinite field that does not belong to any field group in each table, and calculating a correlation value between the definite field and the indefinite field of this pair; 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, grouping the indefinite fields of this pair as a new field group, and registering it into said field group storage.
-
-
45. A 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.
-
-
46. 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:
-
a field correlation value calculator for, in each table, making a pair of a definite field that belongs to any field group, and an indefinite field that does not belong to any field group, and calculating a correlation value between the definite field and the indefinite field of this pair; and a field group determining unit 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, grouping the indefinite fields of this pair as a new field group, and registering it into said field group storage. - View Dependent Claims (48, 49, 51, 52)
-
-
47. A field collating device for employing:
- 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, 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. - View Dependent Claims (58, 59, 60, 61, 62)
- 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
-
50. A field collating device according to claim, 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.
Specification