Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2006-11-01
2010-10-19
Fleurantin, Jean B. (Department: 2162)
Data processing: database and file management or data structures
Database design
Database and data structure management
C707S790000, C707S808000
Reexamination Certificate
active
07818351
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.
REFERENCES:
patent: 5615367 (1997-03-01), Bennett et al.
patent: 6631380 (2003-10-01), Cason et al.
patent: 2001/0000536 (2001-04-01), Tarin
patent: 2003/0158850 (2003-08-01), Lawrence et al.
patent: 2003/0167275 (2003-09-01), Rjaibi
patent: 2005-115494 (2005-04-01), None
Okada et al.; “An Algorithm to Count the Number of Repeated Patient Data Entries with B Tree”; Computers and Biomedical Research, Academic Press; vol. 18, No. 2; Apr. 1985; pp. 121-124.
Mehovic et al.; “generation of Short Unique Key Values for Database Tables”; IP Com Journal; Jun. 1, 1993; pp. 477-480.
Kanai Tsuyoshi
Nomura Yoshihide
Fleurantin Jean B.
Fujitsu Limited
Greer Burns & Crain Ltd.
Le Thu-Nguyet
LandOfFree
Apparatus and method for detecting a relation between fields... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus and method for detecting a relation between fields..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for detecting a relation between fields... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4197915