JP3255121B2 - Database search device, database search method, information processing device, recording medium storing program for causing computer to execute database search method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an interactive database search method for searching a database, and more particularly to a method for automatically correcting a search information file when item information data in a table definition information file of the database is changed. .

[0002]

2. Description of the Related Art FIG. 13 is a diagram showing a conventional interactive search process. The conventional conversational search processing device includes a conventional conversational search processing unit 101, a conventional database search unit 102,
It comprises a conventional search information file creation processing unit 103 and a conventional conversational search processing end unit 104. The conventional conversational search processing apparatus is a processing apparatus that sets a condition for interactively searching using the conventional table definition information file 112 and searches the conventional database 111. After the conventional conversational search processing unit 101 searches the conventional database 111, the conventional search information file creation processing unit 103 creates the conventional search information file 113 having condition data for searching the conventional database 111. Can be. The conventional table definition information file 112 is an information file for giving meaning to and distinguishing data in order to search the database, and is a file consistent with the conventional database 111.

FIG. 14 shows a conventional search information file 113.
It is a figure which shows the conversational search process using. By executing the conventional search information file 113, the conventional interactive search processing unit 101 is started, and the conventional database definition unit 102 sets the conventional table definition information file 112 and the conditions for interactively searching. Instead, the conventional database 111 is searched using the search condition data and item information data of the conventional search information file 113.

Japanese Patent Laid-Open Publication No. Hei 7-23097 discloses a "database control method and apparatus" in which the operation priority of various objects in a database is changed in response to an operation request issued by a database user. A database and apparatus are disclosed that can adjust the behavior of a request to reduce restrictions when developing an application that uses the database.

Japanese Unexamined Patent Publication No. Hei 9-16612, "Interactive Database Searching Apparatus" is provided with an SQL command memory for storing an input SQL command when a relational database is searched in an interactive manner. An interactive database search device that searches a database according to an SQL command stored in an SQL command memory in response to a command is disclosed.

[0006]

However, in the conventional interactive search processing device, when the item information data of the table definition information file is changed, the condition data and the table definition in the search information file created so far are changed. Since the item information data in the information file is different, it is not possible to search the database from the search information file, and there is a problem that a new search information file is required to perform the search.

In Japanese Patent Application Laid-Open No. Hei 7-23097, "Database Control Method and Apparatus" changes the operation priority of various objects in a database in response to an operation request issued from a database user, Can be adjusted, but the content and configuration of the data object cannot be changed.

Japanese Unexamined Patent Publication No. Hei 9-16612 discloses an "interactive database search device" which stores and retains an SQL command and reuses it next time, thereby reducing the number of times the searcher creates SQL commands and reducing the burden. However, there is a problem that when the item information data in the database is changed, a new SQL command must be created in order to execute a search.

[0009]

According to a first aspect of the present invention, there is provided an interactive database search apparatus for searching a database defined by a table definition information file using a search information file. When the item information data in the information file is changed, the search information file is automatically corrected.

[0010] The second database search device of the present invention is:
In a database search device for searching a database defined by a table definition information file using a search information file, first means for starting a database process based on a search information file, and the search started by the first means A second means for checking the consistency between the information file and the table definition information file; and a third means for searching data in the database using the search information file if the information is matched by the second means. Means, fourth means for creating a new search information file that matches the table definition information file if not matched by the second means, and searching data in the database with the new search information file It has a fifth means.

[0011] The third database search device of the present invention is:
In an interactive database search device for searching a database defined by a table definition information file using a search information file, the search information file includes start information, table information data, search information, the number of items and item names. A table definition information file having item data including an item attribute, an item position, and an item digit number, the table definition information file having the table information data and the item data, reading the activation information, and activating a database process. One means, a second means for checking the matching between the search information file and the table definition information file, and if the data is matched by the second means, the data in the database is used by using the search information. Creating a new search information file that matches the table definition information file if it does not match with the third means. Fourth means, and fifth means for searching the data in the database in the new search information file using the new search information, the second means, the search information file and A sixth means for checking whether the table information data in the table definition information file matches, and if the table information data does not match, the item name is deleted, and the item attribute, item position, and item are deleted. A seventh means for changing the number of digits is provided.

The fourth database search device of the present invention is:
The first to fifth means of the second database search device of the present invention are program processing.

The fifth database search device of the present invention is:
The first to seventh means of the third database search device of the present invention are program processing.

The first database search method of the present invention is as follows.
In a database search method for searching a database defined by a table definition information file using a search information file, a first procedure for starting processing of a database based on a search information file, the search information file and the table definition information file A second procedure for checking for consistency with the third procedure, and a third procedure for searching for data in the database using the search information file if the second procedure is consistent with the second procedure, and the second procedure A fourth procedure for creating a new search information file that is consistent with the table definition information file if they do not match, and a fifth procedure for searching data in the database using the new search information file.

[0015] The second database search method of the present invention is:
In an interactive database search method for searching a database defined by a table definition information file using a search information file, the search information file includes startup information, table information data, search information, the number of items and item names. A table definition information file having item data including an item attribute, an item position, and an item digit number, the table definition information file having the table information data and the item data, reading the activation information, and activating a database process. One procedure, a second procedure for checking the consistency between the search information file and the table definition information file, and if the data is consistent by the second procedure, the data in the database is used using the search information. Create a new search information file that matches the table definition information file if it does not match the third step of searching by the second step A fourth procedure, and a fifth procedure of searching for data in the database in the new search information file using the new search information, wherein the second procedure comprises: A sixth procedure for checking whether the table information data in the table definition information file matches, and if the table information data does not match according to the sixth procedure, delete the item name and delete the item attribute, item position, and item. There is a seventh procedure for changing the number of digits.

The first information processing apparatus of the present invention is a first database search apparatus of the present invention, a second database search apparatus of the present invention, a third database search apparatus of the present invention,
It has a fourth database search device of the present invention or a fifth database search device of the present invention, a central processing unit, an input / output control device, and a main storage device.

The first recording medium of the present invention records a program for causing a computer to execute the first to fifth procedures of the first database search method of the present invention.

The second recording medium of the present invention has recorded thereon a program for causing a computer to execute the first to seventh procedures of the second database search method of the present invention.

[0019]

FIG. 1 is a block diagram of a conversational search processing apparatus according to an embodiment of the present invention. The conversational search processing device includes a conversational search processing start unit 301, a search information file check processing unit 302, and a database search processing unit 3.
03, a new search information file creation unit 304, and an end unit 305 for interactive search processing. Each unit proceeds with reference to the search information file 311, the table definition information file 312, the database 313, the new search information file 314, and the table definition maintenance file 331. First, the search information file 311 is executed, and the program start data 501 is executed.
, The conversational search process activation unit 301 activates the process. The activated conversational search processing is performed by the search information file 3 before the database search processing unit 303 performs the search processing.
11 and the table definition information file 312, the search information file check processing unit 302 performs a check, and creates search information data 324 based on the checked difference.
Next, the database search processing unit 303, which has used the search information file 311 until now,
The search of the database 313 is performed using the search information data 324 created instead of 1. As a result, the database 313 can be searched, but the search information data 324 created by the creation unit 304 of the new search information file 314 is used so that the process by the search information file check processing unit 302 does not have to be performed each time. To create a new search information file 314. New search information file 314 created
Is executed, the new search information file 314 matches the table information data 401 of the table definition maintenance file 331, so that the same database 313 can be searched without performing the search information file check processing unit 302.

FIG. 2 is a diagram showing a configuration of the search information file 311 according to the embodiment of the present invention. Program start data 501 for starting the conversational search processing device, table name 408 and table number 40 of database 313 to be searched
Table information data 401 having a 9 and a search information file 311
The number of items, which is the item information data 510 of the database 313 that was searched by the interactive search processing device at the time of creating
02, item name 403, item attribute 404, item position 40
5, item digit number 406, and search condition data 508, which is a condition for searching the database 313. From the item name 403, the number of item digits 406 is defined by the number of items 402, and the item name 403 is defined by an arbitrary name.

FIG. 3 is a diagram showing the configuration of the table definition information file 312 according to the embodiment of this invention. Database 3
In order to identify 13 as one table, table information data 401 having a table name 408 and a table number 409, and item information data 510 for meaning the data, item number 402, item name 403, item attribute 404, item position 405, the number of item digits 406. Item name 403 to item digits 40
6 is defined by the number of items 402 and the item name 403
Is defined by any name. Search information file 3
Reference numeral 11 denotes an execution file having search condition data 508 searched by the interactive search processing device and capable of searching the database 313 with the same search condition data 508 many times.

FIG. 4 shows search information data 32 by search information file check processing unit 302 according to the embodiment of the present invention.
FIG. 4 is a diagram illustrating a configuration of a process for creating a No. 4; The search information file check processing unit 302 includes a table information data check processing 601, a work area securing processing 602, an item name / number of items check processing 603, an item attribute / position / number of digits check processing 604, a search condition check processing 605, a search information It comprises a data creation process 606. The detailed flow of each process will be described below.

FIG. 5 is a flowchart showing the operation of the table information data check processing 601 according to the embodiment of the present invention. Search information file 311 and table definition information file 31
Then, the table name 408 and the number of plate versions 409 are compared (step 701), and if the value of the number of plate versions 409 in the table definition information file 312 is large, the database 313 is considered to be updated, and the work area securing processing 602 is performed.

FIG. 6 is a flowchart showing the operation of the work area securing process 602 according to the embodiment of the present invention. The size of the search information file 311 is acquired, a work area 322 for editing the item information data 510 and the search condition data 508 is secured in the memory 329, and the search information file 311 is copied (step 801). When the item information data 510 in the search information file 311 and the item information data 510 in the table definition information file 312 are different,
A stack area 321 for saving the item name 403 for which the eleven search condition data 508 needs to be edited is secured (step 802). The storage of the item name 403 in the stack area 321 is performed by an item name / item number check process 603, an item attribute / digit number check process 604, and a search condition check process 605.

FIG. 7 is a flowchart showing the operation of the item name / item number check processing 603 according to the embodiment of the present invention.

The number of items 402 in the search information file 311 is acquired, and the number of items 402 is counted down every time the item name 403 is checked. If the number of items 402 is 0 or more, it is considered that there is an item to be checked ( Step 90
1). If there is item information data 510 to check,
Item name 4 same as item name 403 of search information file 311
03 exists in the table definition information file 312 or not.
Confirm by branch search (step 902). Item name 4
If there is no 03, it is necessary to remove data from the item information data 510 and the search condition data 508 to be searched. Therefore, the item name 403 is stored in the stack area 321 (step 903), and the work area 322 in which the search information file 311 is copied. Item name 4 from item information data 510 in
03 is sequentially searched, and if it exists, that part is deleted (step 904). If there is an item name 403 checked in step 902, the database 313
The number of items 402 is used as item information data 510 to be further searched.
Is counted up (step 905). Step 9
If there is no item information data 510 to be checked in step 01, the number of items 402 in the work area 322 is set to step 905
(Step 9)
06).

FIG. 8 is a diagram showing item attributes and attributes according to the embodiment of the present invention.
9 is a flowchart illustrating the operation of a position / digit number check process 604. The number of items 402 of the search information file 311 is acquired, and the number of items 402 is counted down each time the item name 403 is checked. If the number of items 402 is 0 or more, it is considered that there is item information data 510 to be checked ( Step 1001). Item information data 5 to be checked
When there is 10, the item name 403 of the search information file 311 and the table definition information file 312 is collated with the item attribute 404, the item position 405, and the item digit number 406, and
4, it is checked whether the item position 405 and the item digit number 406 match (step 1002). Item attribute 40
4, if any of the item position 405 and the item digit number 406 is different, the work area 3 where the search information file 311 is copied
Then, an item name 403 is sequentially searched from among the items 22 and the item attribute 404, the item position 405, and the item digit number 406 are changed to the item attribute 404, the item position 405, and the item digit number 406 of the table definition information file 312 (step 1003). Then, to edit the search condition data 508, the item name 403 is stored in the stack area 321 (step 1004).

FIG. 9 is a flowchart showing the operation of the search condition check processing 605 according to the embodiment of the present invention.
It is checked whether or not the item name 403 is stored in the stack area 321 by the item name / item number check processing 603 and the item attribute / digit number 604 (step 1101). The item name 403 is sequentially searched using the search condition data 508 in the work area 322, and the search condition data 508 including the existing item name 403 is obtained.
06 and the item attribute 404 are compared, and if they are different, it is determined that there is inconsistency in the search condition data 508 (step 1102). If there is a contradiction in the search condition data 508, the search condition data 508 in the work area 322 is deleted so as not to be used as the search condition data 508 (step 1103). Item name 403 in step 1101
As a result, the item name 40 is stored in the stack area 321.
If there is no “3”, it is checked whether or not all the stack areas 321 have been confirmed, and if confirmation is in progress, the item name 403 is acquired from the next stack area 321 (step 110).
4).

FIG. 10 is a flowchart showing the operation of the search information data creation processing 606 according to the embodiment of the present invention. A search information data 324 area used in the search processing of the database 313 is secured, and the table definition maintenance file 331 is reserved.
From the table information data, the previous item name / number of items check processing 603 and the item attribute / position / digit number check processing 60 are performed.
4. Work area 3 edited in search condition check processing 605
Search information data 3 together with the 22 search information data 324
Copy to 24 areas (step 1201). Where the database definition process refers to the normal table definition information file 312, the reference destination of the search information is changed so as to use the search information data 324 created in step 1201. (Step 1202).

Each of the above steps can be processed by a program of the computer 60.

FIG. 11 shows a computer 60 for executing the database search method according to the embodiment of the present invention and a recording medium 61 storing the processing.

FIG. 12 is a block diagram showing an information processing apparatus according to the embodiment of the present invention.

Reference numeral 71 denotes the database search device 7 described above.
5, a central processing unit for connecting 5, a memory device 72,
Reference numeral 73 denotes an input / output control unit, and reference numeral 74 denotes a bus connecting each of them. The central processing unit 71 is connected to an input / output control unit 73 and a second memory device 72 via a bus 74. Also,
The memory device 72 is connected to the central processing unit 71 and the input / output control unit 73 via a bus 74. Central processing unit 71
Reads a control program stored in the memory device 72, issues an instruction to the input / output control unit 73 or the database search device 75 according to the instruction, and transmits information from the input / output control unit 73 via the bus 74 to the memory device. The information is stored in the memory 72 or the information in the memory device 72 is read and written to the input / output control unit 73.

[0034]

According to the present invention, a self-correction is performed in a processing device when searching for a necessary database without re-creating a search information file that can execute the conventional interactive search processing device. It can be replaced with a search information file. Therefore, there is an effect that the database can be searched in a timely manner without re-creating the search information file. The second effect is that the new search information file can search the same database as before, and the search performance does not deteriorate. A third effect is that search conditions can be confirmed even when a search information file is re-created.

[Brief description of the drawings]

FIG. 1 is a block diagram of a conversational search processing device according to an embodiment of the present invention.

FIG. 2 shows a search information file 311 according to the embodiment of this invention.
FIG. 3 is a diagram showing the configuration of FIG.

FIG. 3 is a table definition information file 31 according to the embodiment of the present invention.
FIG. 2 is a diagram illustrating a configuration of a second embodiment.

FIG. 4 is a diagram illustrating a configuration of a process of creating search information data 324 by a search information file check processing unit 302 according to the embodiment of this invention.

FIG. 5 is a flowchart showing an operation of a table information data check process 601 according to the embodiment of the present invention.

FIG. 6 is a work area securing process 602 according to the embodiment of this invention.
6 is a flowchart showing the operation of the embodiment.

FIG. 7 is a flowchart illustrating an operation of an item name / item number check process 603 according to the embodiment of this invention.

FIG. 8 is a flowchart illustrating an operation of an item attribute / position / digits check process 604 according to the embodiment of this invention.

FIG. 9 is a search condition check process 6 according to the embodiment of the present invention.
5 is a flowchart showing the operation of the second embodiment.

FIG. 10 is a flowchart showing an operation of a search information data creation process 606 according to the embodiment of the present invention.

FIG. 11 shows a computer 60 that executes a method of searching the database 313 according to the embodiment of this invention and a recording medium 61 that stores the processing.

FIG. 12 is a block diagram illustrating an information processing apparatus according to an embodiment of the present invention.

FIG. 13 is a block diagram showing a conventional interactive database search process.

FIG. 14 is a block diagram showing a conventional interactive search process using a search information file 113.

[Explanation of symbols]

 Reference Signs List 60 computer 61 recording medium 71 central processing unit 72 memory device 73 input / output control device 74 bus 75 database search device 101 conventional conversational search processing unit 102 conventional database search unit 103 conventional search information file creation processing unit 104 conventional conversation End part of type search processing 111 Conventional database 112 Conventional table definition information file 113 Conventional search information file 301 Starting part of interactive search processing 302 Search information file check processing part 303 Database search processing part 304 New search information file creation part 305 End part of interactive search processing 311 Search information file 312 Table definition information file 313 Database 314 New search information file 321 Stack area 322 Work area 324 Search information data 329 Memory 331 Table Definition maintenance file 401 Table information data 402 Number of items 403 Item name 404 Item attributes 405 Item position 406 Item digits 408 Table name 409 Table number 501 Program start data 508 Search condition data 510 Item information data

──────────────────────────────────────────────────の Continued on the front page (58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 17/30 JICST file (JOIS)

Claims (10)

(57) [Claims] 1. An interactive database search device for searching a database defined by a table definition information file using a search information file, wherein the item information data in the table definition information file of the database is changed. A database search device which automatically corrects a search information file. 2. A database search apparatus for searching a database defined by a table definition information file using a search information file, wherein first means for starting database processing based on the search information file; Second means for checking the consistency between the search information file and the table definition information file started by, and if the data is matched by the second means, the data in the database is used by using the search information file. Third means for searching, and fourth means for creating a new search information file that matches the table definition information file if not matched by the second means,
A database search device comprising: a fifth unit for searching data in the database using the new search information file. 3. A database search method for searching a database defined by a table definition information file using a search information file, wherein a first procedure for starting a database process based on the search information file; A second procedure for checking consistency with the table definition information file, and a third procedure for searching for data in the database using the search information file if consistent with the second procedure, A fourth procedure for creating a new search information file consistent with the table definition information file if not consistent with the second procedure, and a fifth procedure for retrieving data in the database with the new search information file. A database search method having a procedure. 4. An interactive database search device for searching a database defined by a table definition information file using a search information file, wherein the search information file includes start information, table information data, search information, The table definition information file has the table information data and the item data, and has the table information data, the item information including the number, the item name, the item attribute, the item position, and the item digit number. First means for initiating processing, second means for checking consistency between the search information file and the table definition information file, and data in the database if matched by the second means. Third means for searching using the search information, and new search information matching with the table definition information file if not matched by the second means A fourth means for creating a file, and a fifth means for searching data in the database in the new search information file using the new search information, wherein the second means A sixth means for checking whether the information file and the table information data of the table definition information file match, and if the information does not match by the sixth means, delete the item name and delete the item attribute and the item. A database search device having a seventh means for changing the position and the number of item digits. 5. An interactive database search method for searching a database defined by a table definition information file using a search information file, wherein the search information file includes startup information, table information data, search information, The table definition information file has the table information data and the item data, and has the table information data, the item information including the number, the item name, the item attribute, the item position, and the item digit number. A first procedure for initiating processing, a second procedure for checking consistency between the search information file and the table definition information file, and data in the database if consistent by the second procedure. A third step of searching using the search information, and new search information matching with the table definition information file if not matched by the second step A fourth step of creating a file, and a fifth step of searching for data in the database in the new search information file using the new search information. A sixth procedure for checking whether the information file and the table information data of the table definition information file match; and if the information does not match by the sixth procedure, the item name is deleted, and the item attribute and the item are deleted. A database search method having a seventh procedure for changing the position and the number of item digits. 6. The database search device according to claim 2, wherein said first to fifth means are program processing. 7. The database search device according to claim 4, wherein said first to seventh means are program processing. 8. An information processing apparatus comprising: the database search device according to claim 1, a central processing unit, an input / output control device, and a main storage device. 9. A recording medium storing a program for causing a computer to execute the first to fifth procedures according to claim 3. 10. A recording medium on which a program for causing a computer to execute the first to seventh procedures according to claim 5 is recorded.