CORRELATION RULE ANALYSIS DEVICE AND CORRELATION RULE ANALYSIS METHOD

摘要

PROBLEM TO BE SOLVED: To score a correlation rule extracted from data from a viewpoint of specification of an RDB (Relational Database), and thereby providing additional information for checking the correlation rule serving as information indicative of specifications of the RDB (Relational Database) while appropriately ranking or filtering the correlation rule indicative thereof.SOLUTION: A correlation rule analysis device 100 extracting a data reliance relationship, restriction condition or the like of a DB column of a database from data stored in the database comprises: correlation rule extraction means 116 that extracts information on simultaneous appearance of data between a plurality of columns as a correlation rule from input DB table data; correlation rule aggregation means 118 that aggregates the extracted correlation rules on the basis of specific commonality; and aggregation result validity determination means 119 that calculates a usefulness index as the data reliance or restriction condition from appearance frequency of each aggregated correlation rule and a combination thereof.