Information retrieval system having consistent search results across different operating systems and data base management systems

• US 6,738,763 B1
• Filed: 06/26/2000
• Issued: 05/18/2004
• Est. Priority Date: 10/28/1999
• Status: Expired due to Fees

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Ogawa, Akihiko, Fujibe, Hirotoshi, Itakura, Masayoshi, Mitani, Masaaki, Suzuki, Hiroyuki
• Primary Examiner(s): PARDO, THUY N
• Application Number:
  US09/603,772
• Time in Patent Office: 1,422 Days
• Field of Search: 707/3, 707/5, 707/6, 707/7, 707/531, 707/536, 707/542, 704/8, 704/260, 704/2, 704/9, 715/540, 717/6, 345/474
• US Class Current: 1/1
• CPC Class Codes: G06F 16/3335 Syntactic pre-processing, e.g. stopword elimination, stemming
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99937 Sorting

Abstract

An information retrieval system whereby identical search results can be derived irrespective of the kind of DBMS or OS. A keyword normalizing device normalizes a keyword transmitted from a client through a network. A normalized data searching device then searches normalized data in a data storage section for data corresponding to the normalized keyword, and supplies the data to source data acquiring device. The source data acquiring device acquires source data associated with the normalized data supplied thereto, from among source data in the data storage section, and supplies the acquired source data to a sorting device. The sorting device first sorts the normalized data and then the source data in order of the sorted normalized data, and supplies the resulting source data to a source data supply device. The source data supply device transmits the source data to the client through the network.

Claims

1. An information retrieval system for searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, comprising:

keyword normalizing means for normalizing the keyword supplied thereto;

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of said keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by said keyword normalizing means;

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by said normalized data searching means;

sorting means for sorting the source data acquired by said source data acquiring means by looking up the corresponding normalized data;

source data supply means for supplying the source data sorted by said sorting means to a device which has requested search;

source data normalizing means for normalizing source data which is original data when new data is to be registered in the data storage section; and

storing means for storing the normalized data obtained by said source data normalizing means and the source data not subjected to the normalization in the data storage section in a manner associated with each other.

2. The information retrieval system according to claim 1, further comprising source data acquiring means for acquiring unnormalized source data if the unnormalized source data alone is registered in the data storage section,

source data normalizing means for normalizing the acquired source data, and

storing means for storing the normalized data obtained by said source data normalizing means and the source data not subjected to the normalization in the data storage section in a manner associated with each other.

3. The information retrieval system according to claim 1, wherein said normalizing means converts an alphabetic character and a numeric character to corresponding half-size characters.

4. The information retrieval system according to claim 1, wherein said normalizing means converts an uppercase character to a corresponding lowercase character.

5. The information retrieval system according to claim 1, wherein said normalizing means converts an extended character to a corresponding full-size character if the corresponding full-size character exists.

6. The information retrieval system according to claim 1, wherein said normalizing means converts a full-size katakana character and a half-size katakana character to corresponding full-size hiragana characters.

7. The information retrieval system according to claim 1, wherein a character other than alphabetic characters and a symbol are converted to corresponding full-size uppercase characters.

8. A computer-readable recording medium recording a program for causing a computer to perform a process of searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, wherein the program causes the computer to function as

keyword normalizing means for normalizing the keyword supplied thereto,

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of the keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by the keyword normalizing means,

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by the normalized data searching means,

sorting means for sorting the source data acquired by the source data acquiring means by looking up the corresponding normalized data,

source data supply means for supplying the source data sorted by the sorting means to a device which has requested search,

source data normalizing means for normalizing source data which is original data when new data is to be registered in the data storage section, and

storing means for storing the normalized data obtained by said source data normalizing means and the source data not subjected to the normalization in the data storage section in a manner associated with each other.

9. An information retrieval system for searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, comprising:

keyword normalizing means for normalizing the keyword supplied thereto;

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of said keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by said keyword normalizing means;

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by said normalized data searching means;

sorting means for sorting the source data acquired by said source data acquiring means by looking up the corresponding normalized data;

source data supply means for supplying the source data sorted by said sorting means to a device which has requested search;

source data acquiring means for acquiring unnormalized source data if the unnormalized source data alone is registered in the data storage section;

source data normalizing means for normalizing the acquired source data; and

storing means for storing the normalized data obtained by said source data normalizing means and the source data not subjected to the normalization in the data storage section in a manner associated with each other.

10. An information retrieval system for searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, comprising:

keyword normalizing means for normalizing the keyword supplied thereto;

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of said keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by said keyword normalizing means;

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by said normalized data searching means;

sorting means for sorting the source data acquired by said source data acquiring means by looking up the corresponding normalized data;

source data supply means for supplying the source data sorted by said sorting means to a device which has requested search;

wherein said normalizing means converts a full-size katakana character and a half-size katakana character to corresponding full-size hiragana characters.

11. A computer-readable recording medium recording a program for causing a computer to perform a process of searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, wherein the program causes the computer to function as

keyword normalizing means for normalizing the keyword supplied thereto,

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of the keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by the keyword normalizing means,

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by the normalized data searching means,

sorting means for sorting the source data acquired by the source data acquiring means by looking up the corresponding normalized data,

source data supply means for supplying the source data sorted by the sorting means to a device which has requested search,

source data acquiring means for acquiring unnormalized source data if the unnormalized source data alone is registered in the data storage section,

source data normalizing means for normalizing the acquired source data, and

storing means for storing the normalized data obtained by said source data normalizing means and the source data not subjected to the normalization in the data storage section in a manner associated with each other.

12. A computer-readable recording medium recording a program for causing a computer to perform a process of searching a data storage section for data corresponding to a keyword supplied thereto and outputting the data, wherein the program causes the computer to function as

keyword normalizing means for normalizing the keyword supplied thereto,

normalized data searching means for searching a normalized data group generated by normalizing original data by a process similar to that of the keyword normalizing means, from among data stored in the data storage section, to find normalized data corresponding to the keyword normalized by the keyword normalizing means,

source data acquiring means for acquiring, from the data storage section, source data which is original data stored in association with the normalized data acquired by the normalized data searching means,

sorting means for sorting the source data acquired by the source data acquiring means by looking up the corresponding normalized data,

source data supply means for supplying the source data sorted by the sorting means to a device which has requested search,

wherein said normalizing means converts a full-size katakana character and a half-size katakana character to corresponding full-size hiragana characters.