Method and system for information retrieval

Claim 3

A method according to claim 1 , wherein: the information resource dictionary further contains an information which shows correspondence of relationship of tables in each database, to a location and a database management system of each database; and the information retrieval statement is generated using the information related to the location and the database management system of the determined database system.

Claim 4

A method according to claim 2 , wherein: said information resource dictionary further contains an information related to a restriction of description of each database management system; and the information retrieval statement is generated by preparing a structured query language corresponding to the determined database system using the information related to the restriction of description of the database management system of the determined database system.

Claim 5

An information retrieval system comprising: a processor which retrieves requested information from different database systems connected to a communication network, by retrieving information to satisfy an information retrieval request, wherein the information retrieval request is constructed by a retrieval item that an information searcher wants to retrieve and a retrieved condition related to the retrieval item; a storage device which stores an information resource dictionary in which an information of relationship between retrieval items and data items, the data items which are column names in each database and tables in each database, and the table and the each database are contained; and wherein the processor performs the functions of: determining data items based on the retrieval item and the retrieval condition in the information retrieval request when receiving said information retrieval request; determining a database system to be searched by retrieving the information resource dictionary using the determined data items; generating an information retrieval statement which is a structured query language having a peculiar style of the determined database system; searching through said database system; and presenting retrieved information to the information searcher.

Claim 6

An information retrieval system comprising: a processor which retrieves requested information from different database systems connected to a communication network, by retrieving information to satisfy an information retrieval request, wherein the information retrieval request is constructed by a retrieval item that an information searcher wants to retrieve and a retrieved condition related to the retrieval item; a storage device which stores an information resource dictionary in which an information of relationship between retrieval items and data items, the data items which are column names in each database and tables in each database, and the table and the each database are contained; and wherein the processor performs the functions of: determining data items based on the retrieval item and the retrieval condition in the information retrieval request when receiving said information retrieval request; determining a database system to be searched by retrieving the information resource dictionary using the determined data items; generating an information retrieval statement which is a structured query language having a peculiar style of the determined database system; searching through said database system; and presenting retrieved information to the information searcher.

Claim 7

A method according to claim 4 , wherein: the information resource dictionary further contains an information which shows correspondence of tables, which are connected by the retrieval item in each database, to a location and a database management system of each database; and in the function of generating the information retrieval statement using the information related to the location and the database management system of the determined database system.

Claim 8

An information retrieval system according to claim 5 , wherein: said information resource dictionary further contains an information related to a restriction of description of each database management system; and in the function of generating an information retrieval statement, the processor performs the function of generating the information retrieval statement by preparing a structured query language corresponding to the determined database system using the information related to the restriction of description of the database management system of the determined database system.

Claim 9

A recording medium, readable by computer means, having information resource dictionary data recorded for use in retrieving information from a plurality of different database systems connected to a communication network, by generating an information retrieval request containing requested items; wherein, said information resource dictionary data are recorded in: a related data items file for managing similar data items; a column information file for managing column names which are the data items contained in each table; a table information file for managing tables contained in each database; a database information file for managing locations of each database; and a database management system file, known as a DBMS file, for managing dedicated information for methods of acquiring requested items from each database; and wherein said related data items file has an allocation for recording retrieval items, which are items an items an information searcher wants to retrieve, in relation to similar data items; said column information file has an allocation for recording column names contained in tables in relation to table titles so as to relate column names to requested items specified in said information retrieval request, and when the retrieval items are not contained in the related data items file, said column information file is retrieved using the retrieval items as column names; said table information file has an allocation for recording table titles contained in databases in relation to database titles so as to relate said column information file to said table information file through table titles; said database information file has an allocation, for each of databases connected to said communication network, for recording database titles, host names indicating locations of databases and DBMS names for each database being managed by a DBMS, so as to relate said table information file and said database information file through database titles; and said dedicated DBMS file has an allocation, for each of DBMSs, for recording DBMS names in relation to dedicated information for each DBMS, so as to relate said database information file and said dedicated DBMS file through database titles.

Claim 10

A recording medium, readable by computer means, having information resource dictionary data recorded for use in retrieving information from a plurality of different database systems connected to a communication network, by generating an information retrieval request containing requested items; wherein, said information resource dictionary data are recorded in: a related data items file for managing similar data items; a column information file for managing column names which are the data items contained in each table; a table information file for managing tables contained in each database; a database information file for managing locations of each database; and a database management system file, known as a DBMS file, for managing dedicated information for methods of acquiring requested items from each database; and wherein said related data items file has an allocation for recording retrieval items, which are items an items an information searcher wants to retrieve, in relation to similar data items; said column information file has an allocation for recording column names contained in tables in relation to table titles so as to relate column names to requested items specified in said information retrieval request, and when the retrieval items are not contained in the related data items file, said column information file is retrieved using the retrieval items as column names; said table information file has an allocation for recording table titles contained in databases in relation to database titles so as to relate said column information file to said table information file through table titles; said database information file has an allocation, for each of databases connected to said communication network, for recording database titles, host names indicating locations of databases and DBMS names for each database being managed by a DBMS, so as to relate said table information file and said database information file through database titles; and said dedicated DBMS file has an allocation, for each of DBMSs, for recording DBMS names in relation to dedicated information for each DBMS, so as to relate said database information file and said dedicated DBMS file through database titles.

Claim 11

A recording medium, readable by computer means, having information resource dictionary data recorded for use in retrieving information from a plurality of different database systems connected to a communication network, by generating an information retrieval request containing requested items; wherein, said information resource dictionary data are recorded in: a related data items file for managing similar requested items in groups; a column information file for managing requested items located in columns comprising tables; a relation information file for managing column names for linking tables; a table information file for managing tables contained in each database; a database information file for managing locations of each database; a database management system file, known as a DBMS file, for managing dedicated information for methods of acquiring requested items from databases; and a results display file for managing display methods for retrieved results; wherein said related data items file has an allocation for recording retrieval items, which are items an information searcher wants to retrieve, in relation to groups of similar data items; said column information file has an allocation for recording column names comprising tables in relation to table titles so as to relate said related data items file to said column information file through related data items in said related data items file and columns in said column information file, and when the retrieval items are not contained in the related data items file, said column information file is retrieved using the retrieval items as column names; said relation information file has an allocation for recording each table name in relation to column names, in order to manage column names which link relevant tables, so as to relate said column information file to said relation information file through table titles; said table information file has an allocation for recording table titles contained in databases in relation to database titles so as to relate said column information file to said table information file through table titles; said database information file has an allocation, for each of databases connected to said communication network, for recording database titles, host names indicating locations of databases and DBMS names for each database being managed by a DBMS, so as to relate said table information file and said database information file through database titles; and said dedicated DBMS file has an allocation, for each of DBMSs, for recording DBMS names in relation to dedicated information for each DBMS, so as to relate said database information file and said dedicated DBMS file through database titles; and said results display file has an allocation for recording application software information in relation to format information for reading said application softwares, and said application software information includes an application software being used in said information retrieval request.

Claim 12

A recording medium, readable by computer means, having information resource dictionary data recorded for use in retrieving information from a plurality of different database systems connected to a communication network, by generating an information retrieval request containing requested items; wherein, said information resource dictionary data are recorded in: a related data items file for managing similar requested items in groups; a column information file for managing requested items located in columns comprising tables; a relation information file for managing column names for linking tables; a table information file for managing tables contained in each database; a database information file for managing locations of each database; a database management system file, known as a DBMS file, for managing dedicated information for methods of acquiring requested items from databases; and a results display file for managing display methods for retrieved results; wherein said related data items file has an allocation for recording retrieval items, which are items an information searcher wants to retrieve, in relation to groups of similar data items; said column information file has an allocation for recording column names comprising tables in relation to table titles so as to relate said related data items file to said column information file through related data items in said related data items file and columns in said column information file, and when the retrieval items are not contained in the related data items file, said column information file is retrieved using the retrieval items as column names; said relation information file has an allocation for recording each table name in relation to column names, in order to manage column names which link relevant tables, so as to relate said column information file to said relation information file through table titles; said table information file has an allocation for recording table titles contained in databases in relation to database titles so as to relate said column information file to said table information file through table titles; said database information file has an allocation, for each of databases connected to said communication network, for recording database titles, host names indicating locations of databases and DBMS names for each database being managed by a DBMS, so as to relate said table information file and said database information file through database titles; and said dedicated DBMS file has an allocation, for each of DBMSs, for recording DBMS names in relation to dedicated information for each DBMS, so as to relate said database information file and said dedicated DBMS file through database titles; and said results display file has an allocation for recording application software information in relation to format information for reading said application softwares, and said application software information includes an application software being used in said information retrieval request.

Claim 13

A computer program product containing a computer readable program for causing a computer to retrieve requested information from different database systems connected to a communication network, by retrieving information to satisfy an information retrieval request, wherein: the information retrieval request is constructed by a retrieval item that an information searcher wants to retrieve and a retrieval condition related to the retrieval item; the computer stores an information resource dictionary beforehand, in which an information of relationship between retrieval items and data items, the data items which are column names in each database and tables in each database, and the tables and the each database are contained; and wherein the computer program effects the process of: determining data items based on the retrieval item and the retrieval condition in the information retrieval request when receiving said information retrieval request; determining a database system to be searched by retrieving the information resource dictionary using the determined data items; generating an information retrieval statement which is a structured query language having a peculiar style of the determined database system; searching through said database system; and presenting retrieved information to the information searcher.

Claim 14

A computer program product containing a computer readable program for causing a computer to retrieve requested information from different database systems connected to a communication network, by retrieving information to satisfy an information retrieval request, wherein: the information retrieval request is constructed by a retrieval item that an information searcher wants to retrieve and a retrieval condition related to the retrieval item; the computer stores an information resource dictionary beforehand, in which an information of relationship between retrieval items and data items, the data items which are column names in each database and tables in each database, and the tables and the each database are contained; and wherein the computer program effects the process of: determining data items based on the retrieval item and the retrieval condition in the information retrieval request when receiving said information retrieval request; determining a database system to be searched by retrieving the information resource dictionary using the determined data items; generating an information retrieval statement which is a structured query language having a peculiar style of the determined database system; searching through said database system; and presenting retrieved information to the information searcher.

Claim 15

A computer program product according to claim 9 , wherein: the information resource dictionary further contains an information which shows correspondence of relationship of tables, which are connected by the retrieval item in each database, to a location and a database management system of each database; and in the process of generating an information retrieval statement, the computer program effects the process of generating the information retrieval statement using the information related to the location and the database management system of the determined database system.

Claim 16

A computer program product according to claim 10 , wherein: said information resource dictionary further contains an information related to a restriction of description of each database management system; and in the process of generating an information retrieval statement, the computer program effects the process of generating the information retrieval statement by preparing a structure query language corresponding to the determined database system using the information related to the restriction of description of the database management system of the determined database system.