The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 19, 2010
Filed:
Nov. 01, 2006
Yoshihide Nomura, Kawasaki, JP;
Tsuyoshi Kanai, Kawasaki, JP;
Yoshihide Nomura, Kawasaki, JP;
Tsuyoshi Kanai, Kawasaki, JP;
Fujitsu Limited, Kawasaki, JP;
Abstract
There is provided a database analysis program, a database analysis apparatus, and a database analysis method capable of detecting a relation between fields in a plurality of tables. The database analysis program allows a computer to execute: a field evaluation step that calculates, for each field of the table, a field score which is a value based on the appearance frequency of each value in the field; a relation generation step that selects tables different from each other as a relation source table and relation destination table from the plurality of tables, selects a relation source field which is a field in the relation source table and a relation destination table which is a field in the relation destination table, and generates a combination of the relation source field and relation destination field as a relation; and a relation evaluation step that calculates, for each relation generated by the relation generation step, a relation score which is a value based on the appearance frequency of each value in the relation destination field counted for each relation source field, field score of the relation source field, and field score of the relation destination field.