FIELD CORRELATION METHOD AND SYSTEM, AND PROGRAM THEREOF

• US 20100100804A1
• Filed: 03/04/2008
• Published: 04/22/2010
• Est. Priority Date: 03/09/2007
• Status: Active Grant

• Current Assignee: NEC Corporation
• Original Assignee: NEC Corporation
• Inventors: Kusui, Dai, Tateishi, Kenji
• Granted Patent: US 8,843,818 B2
• Time in Patent Office: Days
• 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-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.

33. A field collation method according to claim 32, further comprising employing a calculation method that differs responding to a field type when the correlation value of the two fields is calculated.

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

35. A field collation method according to claim 32, 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.

36. A field collation method according to claim 32, 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.

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.

39. A field collation system according to claim 37, wherein said field correlation value calculator, when calculating the correlation value of the two fields, employs a calculation method that differs responding to a field type.

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

41. A field collation system according to claim 37, 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.

42. A field collation system according to claim 37,

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.

43. A field collation system according to claim 37,

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.

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.

53. A field collation system according to claim 38, wherein said field correlation value calculator, when calculating the correlation value of the two fields, employs a calculation method that differs responding to a field type.

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

55. A field collation system according to claim 38, 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.

56. A field collation system according to claim 38,

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.

57. A field collation system according to claim 38,

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.

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.

48. A field collating device according to claim 46, wherein said field correlation value calculator, when calculating the correlation value between the two fields, employs a calculation method that differs responding to a field type.

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

51. A field collating device according to claim 46,

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.

52. A field collating device according to claim 46,

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.

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.

58. A field collating device according to claim 47, wherein said field correlation value calculator, when calculating the correlation value between the two fields, employs a calculation method that differs responding to a field type.

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

60. A field collating device according to claim 47, 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.

61. A field collating device according to claim 47,

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.

62. A field collating device according to claim 47,

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.

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.