Method and system for information retrieval
First Claim
1. A method for retrieving 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; and
wherein the method comprises the steps of storing 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 items of the tables and the each database are contained;
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 based on the information retrieval statement; and
presenting retrieved information to the information searcher.
1 Assignment
0 Petitions
Accused Products
Abstract
The method and system for retrieving information allow the user to retrieve desired information from database systems by simply specifying retrieval content and retrieval conditions using languages familiar to the user, without having to know the names for the relevant database systems or their structures or without having to interact with the platform of the meta-information, i.e., information concerning the use of database systems and accessing method. The present method allows retrieval of information from different database systems connected to a communication network, by using reference information stored beforehand to access different database systems; consulting the reference information to determine database systems which contains data to satisfy the information retrieval request by converting requested items to equivalent related words that the system can recognize. The storage locations of the data and instructions on how to acquire the data are determined using relational items to link various tables so that an information retrieval statement can be prepared by the system program on user'"'"'s behalf. The databases are searched according to the acquiring method and the information retrieval content described in the system prepared statement, and the retrieved information is presented for viewing in a format that is used by the information searcher.
334 Citations
11 Claims
-
1. A method for retrieving 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; and
wherein the method comprises the steps ofstoring 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 items of the tables and the each database are contained;
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 based on the information retrieval statement; and
presenting retrieved information to the information searcher. - View Dependent Claims (2, 3)
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.
-
-
3. 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.
-
-
4. 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
whereinthe 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. - View Dependent Claims (5, 6)
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.
-
-
6. 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.
-
-
7. 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
whereinsaid 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.
- wherein,
-
8. 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;
whereinsaid 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.
- wherein,
-
9. 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
whereinthe 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. - View Dependent Claims (10, 11)
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.
-
-
11. 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.
-
Specification