System and method for retrieval of data from related databases based upon database association model

• US 6,212,518 B1
• Filed: 08/31/1998
• Issued: 04/03/2001
• Est. Priority Date: 02/02/1998
• Status: Expired due to Term

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Yoshino, Toshiaki, Yoshida, Taketoshi, Sato, Hiroyuki
• Primary Examiner(s): Breene, John E.
• Assistant Examiner(s): Wassum, Luke S
• Application Number:
  US09/144,646
• Time in Patent Office: 946 Days
• Field of Search: 707/5, 707/10, 707/4, 709/218
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A relevant-information retrieval system manages a model which describes a relevancy among a plurality of databases in accordance with associative values or a tree structure. Besides, when the retrieval system has received a search request for a certain database from a searcher, it specifies one of the databases administering information relevant to the certain database, in accordance with the model, and it presents information of the specified database to the searcher.

Claims

1. A relevant-information retrieval system which governs a plurality of independent databases, and which presents information on a database administering information relevant to information of a search request, to a source having issued the search request for the plurality of databases, comprising:

a management unit managing an association model which describes a relevancy among said plurality of databases in accordance with an associative value defined between two of said databases and representing a degree of association between the two of the databases;

a specification unit operating in a search process for a certain one of said plurality of databases, and specifying one of said databases administering information relevant to the certain database, in accordance with the association model managed by said management unit; and

a presentation unit presenting the search request issuing source with information of the database specified by said specification unit.

2. A relevant-information retrieval system as defined in claim 1, further comprising:

a generation unit generating said association model by calculating the associative value from information of keywords employed in the two databases.

3. A relevant-information retrieval system as defined in claim 2, wherein:

said generation unit calculates said associative value from the number of keyword categories contained in an association destination, and the number of keyword categories agreeing between an association source and said association destination.

4. A relevant-information retrieval system as defined in claim 2, wherein:

said generation unit calculates said associative value in consideration of a weight which depends upon a combination of a mandatory keyword category and an optional keyword category.

5. A relevant-information retrieval system as defined in claim 1, further comprising:

a learning unit for updating said associative value so that a degree of association may enlarge with an increase in the number of times of reference by said search request issuing source.

6. A relevant-information retrieval system as defined in claim 1, wherein:

said specification unit supposes a plurality of associative routes which depend upon a depth of association, each of the associative routes including a plurality of databases, and estimates the respective associative routes on the basis of an associative value between two databases included in said respective associative routes and a distance between said two databases included in said respective associative routes, thereby to specify a database to serve as an association destination, as said database administering the relevant information.

7. A relevant-information retrieval system comprising:

a management unit managing an association model which describes a relevancy among a plurality of databases in accordance with an associative value defined among the plurality of databases and representing a degree of association among the databases;

a specification unit operating upon receiving a search request for a certain database, and specifying a database administering information relevant to the certain database, in accordance with the association model; and

a presentation unit presenting information of the specified database.

8. A relevant-information retrieval system which governs a plurality of independent databases, and which presents information on a database administering information relevant to information of a search request, to a source having issued the search request for the plurality of databases, comprising:

a management unit managing a database model which describes a relevancy among said plurality of databases in accordance with a tree structure having nodes corresponding to the databases;

a specification unit operating in a search process for a certain one of said plurality of databases, and specifying one of said databases administering information relevant to the certain database, in accordance with the database model managed by said management unit; and

a presentation unit presenting the search request issuing source with information of the database specified by said specification unit.

9. A relevant-information retrieval system as defmed in claim 8, further comprising:

a generation unit generating said database model from information of keywords employed in said plurality of databases.

10. A relevant-information retrieval system as defined in claim 8, wherein:

said database model which is managed by said management unit is constructed of the tree structure including database management segments which are disposed in correspondence with the respective databases and which manage a keyword category employed for said respective databases, and a category management segment which lies at a higher level than the database management segments and which manages a keyword category managed by lower level management segments.

11. A relevant-information retrieval system as defined in claim 10, wherein:

said database management segments also manage search sequences of said respective databases.

12. A relevant-information retrieval system as defined in claim 10, wherein:

said specification unit traces said tree structure of said database model, thereby to specify a database containing a designated keyword category, as said database administering the relevant information.

13. A relevant-information retrieval system comprising:

a management unit managing a database model which describes a relevancy among a plurality of databases in accordance with a tree structure having nodes corresponding to the databases;

a specification unit operating upon receiving a search request for a certain database, and specifying a database administering information relevant to the certain database, in accordance with the database model; and

a presentation unit presenting information of the specified database.

14. A program recording medium storing therein a program for a computer which governs a plurality of independent databases, and which presents information on a database administering information relevant to information of a search request, to a source having issued the search request for the plurality of databases, the stored program causing the computer to execute:

a specification process occurring in a search process for a certain one of said plurality of databases, for specifying one of said databases administering information relevant to the certain database, in accordance with an association model which describes a relevancy among said plurality of databases on the basis of an associative value defined between two of said databases and representing a degree of association between the two of the databases; and

a presentation process for presenting the search request issuing source with information of the database specified by said specification process.

15. A program recording medium storing therein a program for a computer which governs a plurality of independent databases, and which presents information on a database administering information relevant to information of a search request, to a source having issued the search request for the plurality of databases, the stored program causing the computer to execute:

a specification process occurring in a search process for a certain one of said plurality of databases, for specifying one of said databases administering information relevant to the certain database, in accordance with a database model which describes a relevancy among said plurality of databases on the basis of a tree structure having nodes corresponding to the databases; and

a presentation process for presenting the search request issuing source with information of the database specified by said specification process.

16. A relevant-information retrieval method comprising:

generating an association model which describes a relevancy among a plurality of databases in accordance with an associative value defined among the plurality of databases and representing a degree of association among the databases;

receiving a search request for a certain database;

specifying a database administering information relevant to the certain database, in accordance with the association model; and

presenting information of the specified database.

17. A relevant-information retrieval method comprising:

generating a database model which describes a relevancy among a plurality of databases in accordance with a tree structure having nodes corresponding to the databases;

receiving a search request for a certain database;

specifying a database administering information relevant to the certain database, in accordance with the database model; and

presenting information of the specified database.

18. A method comprising:

generating an association structure including nodes representing databases, selected nodes being linked with associative values representing a degree of association between the linked databases represented by the linked nodes; and

upon receiving a search request for a particular database, identifying an associated database associated with the particular database by searching the association structure.

19. A computer readable storage medium, storing a program instructing a computer to perform:

generating an association structure including nodes representing databases, selected nodes being linked with associative values representing a degree of association between the linked databases represented by the linked nodes; and

upon receiving a search request for a particular database, identifying an associated database associated with the particular database by searching the association structure.

20. An apparatus comprising:

a management unit managing an association structure including nodes representing databases, selected nodes being linked with associative values representing a degree of association between the linked databases represented by the linked nodes; and

a specifying unit identifying an associated database associated with a requested database by searching the association structure stored in the management unit.