JP2000322442A - Data base retrieving device and data base retrieval program storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To flexibly retrieve a data base without applying great load to a system. SOLUTION: A data base retrieving device 40 is provided with a retrieval key creating means 41 for creating a retrieval key by accessing a journal 35, in which the updating history of a basic system data base 31 is preserved, extracting a word for retrieval from the updating history preserved in the journal 35 and converting the word on the basis of prescribed conversion rules, a table 42 for retrieval preserving the retrieval key created by the retrieval key creating means 41, a retrieval key input means 43 for accepting the input operation of the retrieval key and a retrieving means 44 for retrieving the table 42 for retrieval by generating a new retrieval key by converting the retrieval key accepted by the retrieval key input means 43 on the basis of the said prescribed conversion rules, and using that new retrieval key.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a database search device for searching a database and a database search program storage medium storing a database search program.

[0002]

2. Description of the Related Art Conventionally, in the field of database search on the Internet / intranet and information-based database search, flexible search using a technique of fuzzy search has been widely performed. In other words, in addition to the character string entered by the user as a search key, an item that is considered to correspond to the entered character string is extracted from a synonym dictionary or the like, and a search is performed using that item. A technique of using a synonym dictionary to search for a keyword that has been analyzed and decomposed so as to make it easier to hit using a technique called Japanese morphological analysis is widely used.

[0003] In the field of database search in a core computer system, there is a strong demand from users for search processing flexibly corresponding to a search range, a required search time, and the like. There is a demand for a search method that employs an ambiguous search technique that expands the search target range and ensures a hit when specifying a search term.

[0004]

However, in the backbone database, updates and references from the backbone business process frequently occur, and the processing time is required to be extremely short. If the fuzzy search is applied as it is, there is a problem that the performance of the core business processing is remarkably reduced and an excessive load is imposed on the system. In order to avoid performance degradation of mission-critical business processing when a search method for an information-based database is applied to a mission-critical database, it is necessary to make large-scale remodeling of the mission-critical business processing system. At present, ambiguous search is not realized in mission-critical databases.

In the field of information-based database search, there is a strong demand for minimizing the deterioration in processing performance for fuzzy search. In the field of personal computer database search, processing by fuzzy search is also required. There is a demand for a search method with a small decrease in performance.

The present invention has been made in view of the above circumstances, and has as its object to provide a database search device and a database search program storage medium capable of performing a flexible database search without imposing a large load on the system.

[0007]

A database search apparatus according to the present invention, which achieves the above object, accesses a journal in which an update history of a database is stored, and retrieves a search term from the update history stored in the journal. And a search key generating means for generating a search key by converting the term based on a predetermined conversion rule; a search table in which the search key generated by the search key generating means is stored; A search key input means for receiving a key input operation; and a search key received by the search key input means is converted based on the predetermined conversion rule to generate a new search key, and the new search key is generated. And a search means for searching the search table using the search table.

Here, the database search device of the present invention includes a synonym dictionary in which the synonym correspondence is described,
It is preferable that the search key generation means and the search means generate or generate a search key with reference to the synonym dictionary.

[0009] Further, the database search device of the present invention comprises:
The system further comprises: a term designating unit for designating another term defined as being synonymous with the search term input to the database for the search, wherein the search key generating means includes the search term and the other term. Are converted based on a predetermined conversion rule to generate a plurality of search keys for the same content search, and the search table is created by the search key generation means. It is also preferable that, when a plurality of search keys are created, the plurality of search keys be stored in association with each other.

The term designating means designates a term and a search level using the term, and the search table stores a search key in association with the search level. Wherein the search key input means receives a search key input operation and a search level input operation, and wherein the search means performs a new search by converting the search key received by the search key input means. It is also preferable that a search is performed based on a key and a search level received by the search key input means.

A database search program storage medium according to the present invention for achieving the above object accesses a journal in which update history of a database is stored, and extracts a search term from the update history stored in the journal. A search key generating means for generating a search key by converting the term based on a predetermined conversion rule; a search table in which the search key generated by the search key generating means is stored; A database search program comprising: a search unit that generates a new search key by converting an input search key based on the predetermined conversion rule and searches the search table using the new search key Is stored.

[0012]

Embodiments of the present invention will be described below.

FIG. 1 is an external view (a) and an internal configuration diagram (b) of a computer to which a database search device of the present invention and a database search program storage medium of the present invention are applied.

As shown in FIGS. 1A and 1B, the computer 10 has a CPU 11, a CD-RO
M drive 12, memory 13, magnetic disk drive 14,
A mouse 15, a display device 16, a printer 17, a keyboard 18, a communication controller 19, and the like are connected to a system bus 20.
Are configured as connected systems.

[0015] The database search program of the present invention comprises:
For example, the database search device is stored in a storage medium such as a CD-ROM 21. The CD-ROM 21 is inserted into the CD-ROM drive 12, read by the computer 10, and installed. Formed.

The computer 10 is connected to another computer (not shown) via the communication control device 19 and the cable 22. A plurality of computers can perform a database search using the database search device. It is configured as follows.

FIG. 2 is a functional block diagram of the database search device according to the first embodiment of the present invention.

The first embodiment shows an example of a case where a database search device formed in the computer 10 shown in FIG. 1 performs an ambiguous search for a customer master in a backbone database.

As shown in FIG. 2, in the first embodiment, a backbone business processing system 30 that performs backbone business processing using a backbone database 31 including a customer master 32.
, A database search device 40 of the present invention is incorporated. That is, the core business processing system 30 includes a core database 31 including a customer master 32, a core business update / reference unit 33 that executes update / reference processing of the core database 31, and input / output of customer information by the customer.
Customer information update screen 3 where operations such as correction and deletion are performed
4. A journal 35 in which the update history of the core database 31 based on the operation of the customer information update screen 34 is stored.
And a database search device 40 of the present invention.

The database search device 40 accesses the journal 35, extracts a search term from the stored update history, and converts the term based on a predetermined conversion rule to generate a search key. Creation means 41, a search table 42 in which the search keys created by the search key creation means 41 are stored, a search key input means 43 for receiving a search key input operation, and a search key received by the search key input means 43. A new search key is generated by performing conversion based on a predetermined conversion rule, and the search table 4 is generated using the new search key.
2 is provided with a search means 44 for searching.

Further, the database search device 40 of the present embodiment uses the synonym dictionary 4 in which the synonym correspondence is described.
5, the search key creation means 41 and the search means 44 are configured to create or generate a search key with reference to the synonym dictionary 45. This synonym dictionary 4
Reference numeral 5 is not an essential component of the database search device of the present invention, but a search key creation means 41 and a search means 4
4 may create or generate a search key without referring to such a dictionary. However, when the database search device 40 is provided with the synonym dictionary 45, the processing load of the search key creation means 41 and the search means 44 can be reduced, and a dictionary that matches the needs of the user can be obtained. It is preferable to provide a synonym dictionary 45 since the search can be performed more flexibly by making it.

Although the present embodiment shows an example in which the database search device 40 is directly formed inside the core business processing system 30, the database search device is provided inside the core business processing system as described above. In addition to the direct formation, a core business processing system may be formed in a host computer, and a database search device may be formed on a terminal connected to this by a network, or on a server of a client and server type system. A core business processing system may be formed, and a database search device may be formed on a client connected to the core business processing system via a network.

Next, the operation of the database search device according to the present embodiment will be described.

When a customer inputs customer information "12345678" and name "Watanabe Daiichi kk" from the customer information update screen 34 of the core business processing system 30 shown in FIG. Update / Reference section 3
3 executes update processing of the customer master 32 in the backbone database 31. As a result, the customer master 32 stores the customer code "12" input from the customer information update screen 34.
345678 "and the name" Watanabe Daiichi kk "are updated, and the update history is stored in the journal 35.

The search key creation means 41 accesses the journal 35 at regular intervals, extracts a search term from the newly stored update history, and converts the term based on a predetermined conversion rule. Create a search key. In the present embodiment, the process of “uppercase lowercase letters” is performed by the logic provided in the search key creation means 41, and the customer code “12345678” in the update history stored in the journal 35 and the name “Watanabe No. One kk "
Are converted to uppercase letters "KK".

Further, the search key creation means 41 refers to the synonym dictionary 45, and refers to "new characters of old characters", "kanji numerals,
Processing such as conversion of Roman numerals to alphanumeric characters, and conversion of half-width characters to full-width characters. That is, the old character “be” is converted into the new character “beside”, and the Chinese character “one” is converted into the alphanumeric character “1”. In this way, the search key “Watanabe 1st KK” is created, and the created search key “Watanabe 1st KK” is the same primary key as the customer master 32 “12345678 / Watanabe 1st kk”.
Together with the search table 42.

As described above, the search key creation processing is executed at regular time intervals, and a new search key serving as a search condition at the time of fuzzy search corresponding to the update of the customer master 32 is gradually stored in the search table 42. It accumulates.

Next, the operation at the time of information retrieval will be described.

The search key input means 43 receives a customer information search request by a user operation or a customer information search request from another application.

The search means 44 generates a new search key by converting the search key based on the search request based on the same conversion rule as the conversion rule in the search key creation means 41, and generates the new search key. Is used to search the search table 42. That is, the search name “Watanabe Ik” accepted on the search key input screen 43a
The lowercase letter “k” is converted to uppercase letter “K” by the search means 44, and the synonym dictionary 45 is referred to to convert “old characters into new characters”, “kanji numerals, Roman numerals, etc.”. Processes such as "alphanumeric conversion" and "half-width character conversion to full-width character" are performed, and the old character "edge" is converted to the new character "side", and the Roman numeral "I" is converted to the alphanumeric character "1". Thus, a new search key “Watanabe first KK” is generated.

The search means 44 searches the search table 42 using the generated search key "Watanabe 1st KK".
The search key generation logic in the search means 44 is as follows.
Since the search key generation means 41 has the same logic as the search key generation logic, the search key "Watanabe 1st KK" generated by the search means 44 has been generated by the search key generation means 41 and has already been stored in the search table 42. Matches the search key "Watanabe 1st KK". Therefore, the search result “targeted. Customer code: 12345678” is output to the search result display screen 43b. This output information includes a key value for specifying a record (row) on the backbone database 31, and it is easy to transition to business processing after specifying a processing target.

As described above, the database search processing in this embodiment is performed without any influence on the operation of the core business update / reference unit 33 that executes the update / reference processing of the core database 31. As a result, the performance of mission-critical business processing is not reduced. Also, there is no need to modify the update / reference system. In addition, as an initial migration process when adding the database search device of the present embodiment to the core business system, all the core databases are unloaded, and only files prepared in the same format as the update journal are prepared. There is no need to create a dedicated application for migration.

Next, a second embodiment of the database search device of the present invention will be described.

This second embodiment is similar to the first embodiment shown in FIG.
Is an example in which a term designating means for designating another term defined as having the same meaning as a term for search input to the database is added to the database search device in the embodiment.

FIG. 3 is a functional block diagram of a database search device according to a second embodiment of the present invention.

As shown in FIG. 3, in the second embodiment, a backbone business processing system 50 that performs backbone business processing using a backbone database 51 including a customer master 52 is provided.
In addition, a database search device 60 of the present invention is incorporated. That is, the core business processing system 50 includes a core database 51 including a customer master 52, a core business update / reference unit 53 that executes update / reference processing of the core database 51, and input / output of customer information by the customer.
Customer information update system screen 5 where operations such as correction and deletion are performed
4. Term designation means 55 for designating another term defined as synonymous with the term for search input to the core system database 51, and other terms input by the term designation means 55 are saved Search information save file 57,
And a database search device 60 of the present invention.

The database search device 60 converts both the search term and the other terms based on a predetermined conversion rule, thereby generating a plurality of search keys for the same content search. Means 61, when a plurality of search keys for the same content search are created by the search key creation means 61, a search table 62 for storing the plurality of search keys in association with each other; A new search key is generated by converting the search key received by the search key input unit 63 and the search key received by the search key input unit 63 based on a predetermined conversion rule, and the search table 62 is generated using the new search key. Is provided.

Further, the database search device 60 of the present embodiment uses the synonym dictionary 6 in which the synonym correspondence is described.
5, and the search key creation means 61 and the search means 64 are configured to create or generate a search key with reference to the synonym dictionary 65.

Next, the operation of the database search device according to this embodiment will be described.

When the customer inputs customer information "12345678" and name "1st Watanabe KK" from the customer information update screen 54 of the core business processing system 50 shown in FIG. By 55
On the same screen, a term designation screen 56 for designating another term defined as synonymous with the term for search of the inputted customer information is displayed.

As shown in FIG. 3, on the term specification screen 56, a user selects a button 56a for selecting whether or not to generate a kana-ized name as a search key, and a search for a similarly hiragana-named name. A button 56b for selecting whether or not to generate a key is provided, and an underline 56c indicating the input position of the search key is displayed. The user can freely input a search key at the position of the underline 56c. In the example shown in FIG.
The user selects both the kanaization button 56a and the kanaization button 56b, and the search key is “WATA
A state where two “NABE” and “Watanabe group” are input is shown.

By specifying terms in this way, it becomes easy to add an item for instructing the creation of an ambiguous search key, and a screen 56 dedicated to term specification is prepared to instruct the user to freely create search keys. By providing a function that can perform the search, the number of requests to the system operator can be reduced, and the user can create a unique search key for an arbitrary record in a timely manner.

The core business update / reference unit 53 executes a process of updating the customer master 52 of the core database 51.
As a result, the customer master 52 displays the customer information update screen 54
Is performed with the customer code “12345678” and the name “Watanabe Daiichi KK” input from the customer.

The term designation screen 56 by the term designation means 55
Are input to the search information saving file 57 in the present embodiment. This is to reduce the performance degradation of the core business process when the search key is created directly on the mission-critical database 51. If there is little risk of the performance degradation, the search information save file 57 is saved. A configuration may be adopted in which a search key is directly created on the backbone database 51 without being provided.

In the example shown in FIG. 3, the search information save file 57 contains “1” input from the customer information update screen 54.
2345678 / Watanabe Daiichi KK ”,“ Watana hetada ichi kei ”generated by the kana conversion search key and kana conversion search key generation function on the term specification screen 56, and“ Watanabe Ichikei ”, and the term specification screen 56 Search key "WATANABE" and "Watanabe group" are stored.

The database search device 60 of this embodiment
Search key generation means 61 generates a search key with reference to the search information save file 57 at regular time intervals. That is, as shown in FIG. 3, the old characters are converted to new characters based on the information created and instructed by the user and the synonym dictionary 65, and the “Watanabe group” is converted to the “Watanabe group” to obtain the search key “ Watanabe Group ". When a plurality of search keys for the same content search are created by the search key creation means 61, the plurality of search keys are stored in the search table 62 in association with each other. Thus, the search table 62 has the same primary key “12345678 / Watanabe 1st kk” as the customer master 52 and five search keys “Watanabe 1st KK” and “WATANA”.
"BE", "Watanabe Group", "Watanabeiichi Keikeikei", and "Watanabe Ichikei" are saved.

In the second embodiment, the information search is performed as follows.

The search key input means 63 accepts a customer information search request by a user operation or a customer information search request from another application.

The search means 64 generates a new search key by converting the search key based on the search request based on the same conversion rule as the conversion rule in the search key creation means 61, and generates the new search key. Is used to search the search table 62. That is, the search name “Watanabe group” received on the search key input screen 63a is referred to the synonym dictionary 65 to “convert old characters to new characters”, “convert Chinese characters and Roman numerals to alphanumeric characters”, and “ A process such as “half-width character conversion to full-width character” is performed, and the old character “side” is converted to the new character “side”. Thus, a new search key “Watanabe group” is generated.

The search means 64 searches the search table 62 using the generated search key “Watanabe group”.
Since the logic for generating the search key in the search means 64 is the same as the logic for generating the search key in the search key generation means 61, the search key “Watanabe group” generated by the search means 64 is generated by the search key generation means 61. This matches the search key “Watanabe group” already stored in the search table 62. Thus, the search result “targeted. Customer code: 12345678” is output to the search result display screen 63b.

As described above, the database search process in the present embodiment does not slightly affect the operation of the core business operation update / reference unit 53 that executes the update / reference process of the core database 51. However, the processing subject to the performance degradation of the core business processing is limited to only the screen processing of the user's instruction to create an ambiguous search key on the customer information updating screen 54, and the search information save file 57 Since only a small amount of information is added, the effect of performance degradation can be kept within an allowable range.

Next, a third embodiment of the database search device of the present invention will be described.

The third embodiment is different from the second embodiment shown in FIG.
The term designating means of the database search device in the embodiment specifies the term and the level of the search using the term, and the search table stores the search key in association with the search level. The search key input means receives a search key input operation and a search level input operation, and the search means is a new search key obtained by converting the search key received by the search key input means. This is an example in which a search is performed based on and a search level received by the search key input means.

FIG. 4 is a functional block diagram of a database search device according to a third embodiment of the present invention.

As shown in FIG. 4, in the third embodiment, a backbone business processing system 70 for performing backbone business processing by using a backbone database 71 including a customer master 72.
In addition, a database search device 80 of the present invention is incorporated. That is, the core business processing system 70 includes a core database 71 including a customer master 72, a core business update / reference unit 73 for executing update / reference processing of the core database 71, and input / output of customer information by the customer.
Customer information update system screen 7 where operations such as correction and deletion are performed
4. A term designating means 75 for designating another term defined as synonymous with the term for search input to the backbone database 71 for search and for specifying a search level using the term, term designation A search information save file 77 for saving other terms and search levels input by the means 75, a journal 78 for storing the update history of the core database 71 based on the operation of the customer information update screen 74, and a book. A database search device 80 of the invention is provided.

The database search device 80 converts both the above-mentioned search term and the above-mentioned other terms based on a predetermined conversion rule, thereby creating a plurality of search keys for the same content search. Second search key generation means 81a, 81b, search key generation means 81a, 8
When a plurality of search keys for the same content search are created by 1b, the plurality of search keys are associated with each other and stored in association with the above-described search level. And a search key input means 83 for receiving a search level input operation, a new search key obtained by converting the search key received by the search key input means 83, and a search level received by the search key input means. And a search unit 84 for performing a search based on.

Further, the database search device 80 of the present embodiment uses the synonym dictionary 8 in which the synonym correspondence is described.
5, and the search key creation means 81 and the search means 84 are configured to create or generate a search key with reference to the synonym dictionary 85.

Next, the operation of the database search device according to the present embodiment will be described.

When the customer inputs customer information "12345678" and name "First Watanabe KK" from the customer information update screen 74 of the core business processing system 70 shown in FIG. By 75
On the same screen, a term / level designation screen 76 is displayed for designating another term defined as being synonymous with the term for search of the inputted customer information and for designating the search level. .

As shown in FIG. 4, a term / level designation screen 76 includes a button 76a for the user to select whether or not to generate a kana-ized name as a search key, and a name that has been similarly hiragana-named. A button 76b for selecting whether or not to generate a search key as a search key is provided, and underlines 76c and 76d indicating input positions of the search key and the search level thereof are displayed. The user can freely enter a search key at this position. In the example shown in FIG. 4, both the kana conversion button 76a and the kana conversion button 76b are selected by the user, and two search keys "WATANABE" and "Watanabe Group" and their search levels "4""And" 5 "
Is entered. When the kana conversion button 76a and the kana conversion button 76b are selected, a search level 6 is automatically added to the search keys created based on the buttons.

The core business operation update / reference unit 73 executes the update processing of the customer master 72 of the business core database 71, and also searches for other terms input from the term / level designation screen 76 by the term designating means 75 and their search. The level is output to the search information save file 77. In the example shown in FIG. 4, the search information save file 77 contains "12345678 / Watanabe Daiichi K" input from the customer information update screen 74.
K ”and four search keys and a search level“ WATAN ”input from the term / level designation screen 76.
"ABE", "4", "Watanabe Group", "5", "Watanabei ichi Keikkei", "6", and "Watanabe Ikekei", "6" are stored.

As a result of the update processing of the customer master 72, the customer master 72 has the customer code “12345678” and the name “Watanabe Daiichi KK” input from the customer information update screen 74.
And the update history is stored in the journal 78.

The first search key generating means 81a accesses the journal 78 at regular intervals, extracts a search term from the stored update history, and converts the term based on a predetermined conversion rule. By doing so, a search key is created. In the present embodiment, the first search key creation means 81a
Is performed by the logic provided in the journal, but the lower case exists in the name "Watanabe Daiichi KK" of the customer code "12345678" in the update history stored in the journal 78. Therefore, it is output to the search table 82 as it is.

The second search key generation means 81b refers to the search information save file 57 at regular time intervals and reads the name "Watanabe Daiichi K" stored in the search information save file 77.
K "and a search key based on the four search keys. That is, for each of these five keys, referring to the synonym dictionary 85, processing such as "converting old characters to new characters", "converting Kanji numerals and Roman numerals to alphanumeric characters", and "converting half-width characters to full-width characters" is performed. Then, the processed search key is output to the search table 82 together with the search level.
Note that the search level of the search key based on the name “Watanabe Daiichi KK” is “1”.

Thus, the same primary key “12345678” as that of the customer master 72 is stored in the search table 82.
/ Watanabe Daiichi KK "and five search keys and their search levels" Watanabe Daiichi KK "," 1 "," WATANAB "
"E", "4", "Watanabe Group", "5", "Watanabeiichi Keikkei", "6", and "Watanabe Ichikei", "6" are stored.

In the present embodiment, both the search table 82 and the synonym dictionary 85 are used for information search.

The synonym dictionary 85 is maintained by the system operator using the maintenance screen 86. In addition, the external information taking-in means 87 can take in external information 88 such as a commercially available dictionary. . Contents registered in the synonym dictionary 85 include a new / old correspondence table of kanji,
Number / Kanji correspondence table, Number / Romaji correspondence table, individual synonyms (common names such as NTT, JR, JT and unique names used in company / department), new / old customer name correspondence table, etc. .

As shown in FIG. 4, in the present embodiment, the priorities of search are assigned to the registered contents of the search table 82 and the synonym dictionary 85 in advance, and the search is performed on the application side that performs the search. By specifying a level, a flexible search can be performed in consideration of a search range and a search time. Further, by specifying a search level when a user inputs a search key, it is possible to flexibly cope with narrowing of the search range and expansion of the search range.

Search key input means 83_1, 83_2, 8
3_3 and 83_4 accept a customer information search request by a user operation or a customer information search request from another application. The search means 84 generates a new search key by converting the search key based on the search request based on the same conversion rule as the conversion rule in the search key creation means 61, and uses the new search key. The search table 82 and the synonym dictionary 85 are searched.

That is, as for the search name “WATANABE” and the search level “up to 3” accepted on the search key input screen 83_1a, the search name “WATANABE” is changed by the search means 84 into the synonym dictionary 85 at the specified search level. Converted to content. In this case, no conversion is performed. Next, a search is performed to determine whether or not the search name exists in the search key of the search table 82 at the specified search level. In this case, the search result is “No target!”. Output to the display screen 83_1b.

The search name “WATANABE” and the search level “up to 4” accepted on the search key input screen 83_2a are converted by the search means 84 into the search name “WA”.
TANABE "is converted into the contents of the synonym dictionary 85 at the designated search level. In this case, no conversion is performed. Next, a search is performed to determine whether or not the search name exists in the search key of the search table 82 at the specified search level. In this case, the search name is present, and the search result is “subject. Customer code: 12345678 "is output to the search result display screen 83_2b.

The search name “Watanabe Group” received on the search key input screen 83_3, and the search level are:
For “up to 4”, the search unit 84 converts the search name “Watanabe group” into the contents of the synonym dictionary 85 at the specified search level. Next, the converted search name “Watanabe group” is stored in the search table 82 at the specified search level.
A search is performed as to whether or not the search key exists in the search key. In this case, the search result is “No” and the search result is output to the search result display screen 83_3b.

The search name “Watanabe group” and the search level: “up to 5” received on the search key input screen 83_4a are equivalent to the search name “Watanabe group” by the search means 84 at the designated search level. Dictionary 85
Is converted to Next, a search is performed to determine whether or not the converted search name “Watanabe group” exists in the search key of the search table 82 at the specified search level. In this case, the search result is present. “Target. Customer code: 12345678” is displayed on the search result display screen 83_4.
b.

As described above, the database search process in this embodiment does not slightly affect the operation of the core business update / reference unit 83 that executes the update / reference process of the core database 81. However, the processing subject to the performance degradation of the core business processing is limited to only the screen processing for instructing the user to create an ambiguous search key on the customer information updating screen 74 and instructing the search level, and Since only a small amount of information is added to the search information save file 77, the effect of the performance degradation can be kept within an allowable range.

[0075]

As described above, according to the database search device of the present invention, a search key generating means for generating a search key, a search table in which the search key is stored, and a search key input operation are received. Search key input means, and a search means for converting a search key received by the search key input means based on a predetermined conversion rule, generating a new search key, and searching a search table using the new search key. , A database search device is configured, and this database search device can be operated separately from the core business update / collation system, enabling flexible database search without imposing a heavy load on the system. A simple database search device can be realized.

Further, according to the database search program storage medium of the present invention, a database search device capable of performing a flexible database search on a desired computer system without imposing a large load on the above system is provided. It can be easily formed.

[Brief description of the drawings]

FIG. 1 is an external view (a) and an internal configuration diagram (b) of a computer to which a database search device of the present invention and a database search program storage medium of the present invention are applied.

FIG. 2 is a functional block diagram of the database search device according to the first embodiment of the present invention.

FIG. 3 is a functional block diagram of a database search device according to a second embodiment of the present invention.

FIG. 4 is a functional block diagram of a database search device according to a third embodiment of the present invention.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 10 Computer 11 CPU 12 CD-ROM drive 13 Memory 14 Magnetic disk device 15 Mouse 16 Display device 17 Printer 18 Keyboard 19 Communication control device 20 System bus 21 CD-ROM 22 Cable 30 Core business processing system 31 Core database 32 Customer master 33 Core business update / reference section 34 Customer information update screen 35 Journal 40 Database search device 41 Search key creation means 42 Search table 43 Search key input means 43a Search key input screen 43b Search result display screen 44 Search means 45 Synonyms Dictionary 50 core business processing system 51 core business database 52 customer master 53 core business update / reference unit 54 customer information update system screen 55 term designation means 56 term designation screen 56a, 56b Ton 56c Underline 57 Search information save file 60 Database search device 61 Search key creation means 62 Search table 63 Search key input means 63a Search key input screen 63b Search result display screen 64 Search means 65 Synonym dictionary 70 Basic business processing system 71 core system database 72 customer master 73 core system business update / reference unit 74 customer information update system screen 75 term specification means 76 term / level specification screen 76a, 76b buttons 76c, 76d underline 77 search information save file 78 journal 80 database search Apparatus 81a, 81b Search key generation means 82 Search table 83_1, 83_2, 83_3, 83_4 Search key input means 83_1a, 83_2a, 83_3a, 83_4a
Search key input screen 83_1b, 83_2b, 83_3b, 83_4b
Search result display screen 84 Search means 85 Synonym dictionary 86 Maintenance screen 87 External information import means 88 External information

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 5B075 ND20 NK02 NK35 NK54 NR06 NR20 PP02 PP03 PP12 PP22 PQ02 PQ03 PR10 UU40

Claims (5)

[Claims] 1. Accessing a journal in which an update history of a database is stored, extracting a search term from the update history stored in the journal, and converting the term based on a predetermined conversion rule. A search key generating means for generating a search key; a search table in which the search key generated by the search key generating means is stored; a search key input means for receiving a search key input operation; A search unit configured to generate a new search key by converting the received search key based on the predetermined conversion rule, and to search the search table using the new search key. Database search device. 2. A synonym dictionary in which correspondences between synonyms are described, wherein the search key creation means and the search means create or generate a search key with reference to the synonym dictionary. The database search device according to claim 1, wherein: 3. A search method according to claim 2, further comprising: a term designation unit for designating another term defined as a synonym for the search term input to the database for the search, wherein the search key creation unit includes the search term. And the other terms are respectively converted based on a predetermined conversion rule to create a plurality of search keys for the same content search, wherein the search table is created by the search key creation means. 2. The database search device according to claim 1, wherein when a plurality of search keys for searching for the same content are created, the plurality of search keys are stored in association with each other. 4. The term designating means designates a term and a search level using the term, and the search table stores a search key in association with the search level. Wherein the search key input means receives a search key input operation together with a search key input, and wherein the search means performs a new search by converting the search key received by the search key input means. 4. The database search device according to claim 3, wherein a search is performed based on a key and a search level received by the search key input means. 5. Accessing a journal in which an update history of a database is stored, extracting a search term from the update history stored in the journal, and converting the term based on a predetermined conversion rule Search key generation means for generating a search key; a search table in which the search key generated by the search key generation means is stored; and a search key input for search converted based on the predetermined conversion rule. A database search program comprising a search means for generating a new search key and searching the search table using the new search key.