JPH0652223A - Retrieving method for data base - Google Patents

Abstract

PURPOSE:To save setting of a keyword for retrieval to each document by entering data in a column which becomes an object, and extracting the document in which the data in the column in which this data is stored is the same. CONSTITUTION:A document command is inputted from a keyboard. A command control part interprets it, and a data retrieval processing part, first of all, fetches a column name and an article name from a data storage part table. Subsequently, in a column relation storage table, a coincidence relation of every column is fetched (S2), and a document name and a column name whose columns coincide with each other are obtained (S3). Next, by the document name and the column name obtained in S3, a document having the article name is fetched from a document B group and a document C group in a document storage device, and retrieval of the document is completed (S4). That is, the document in terms of column, data being a keyword of retrieval is put into the column which becomes an object, and subsequently, a column in which the same data as the column in which the data concerned is stored is retrieved, and thereafter, the document having the retrieved column is extracted.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database retrieval method in which a single group of information is treated as a standard document consisting of fields having a fixed format and a target document can be retrieved without re-setting a keyword. .

[0002]

2. Description of the Related Art There is a document database that systematically integrates a plurality of documents and retrieves a document for a certain purpose. FIG. 2 shows a system configuration diagram of a conventional document database. The system shown in the figure has a data storage unit 101 and a keyword storage unit 10.
2. Document search processing unit 103, document storage device 104, display unit 105, keyboard 106, pointing device 107, input / output control unit 108, and command control unit 109.

The data storage unit 101 is a memory for storing an input document, and the keyword storage unit 102 is a memory for storing a keyword assigned to each document. The document search processing unit 103 searches for a document using the keywords stored in the keyword storage unit 102. The document storage device 104 is a storage device for storing all documents. The display unit 105 includes a CRT or the like and is for displaying an input document or a retrieved document. The keyboard 106 is for inputting a document or a keyword. The pointing device 107 is composed of a mouse or the like, and is used together with the keyboard 106 to perform various input operations.

The input / output control unit 108 is for controlling the display unit 105, the keyboard 106, and the pointing device 107, and the command control unit 109 interprets / executes a command input by the keyboard 106 or the pointing device 107. It is for doing.

Next, the operation will be described. First, a plurality of documents, ... Are stored in the document storage device 104, and a keyword is assigned to each document ,.
No. 02 is stored.

FIG. 3 is a diagram showing the relationship between such a document and keywords. That is, “a”, “b”, and “y” are used as keywords in the document, and “y” and “p” are used in the document.
However, "a", "p", "q", and "r" are added to the document, respectively. In such a database, it is assumed that a document having the keyword "a" is searched for. In this case, first, enter the keyword "a" on the keyboard 1
Enter from 06. This is the command control unit 109
Then, the document search processing unit 103 executes the search. Here, since the documents to which the keyword “a” is added are documents and documents, the data of these documents are retrieved from the document storage device 104, and this is displayed on the display unit 1.
It is displayed as 05.

[0007]

However, in the above-mentioned conventional database searching method, it is necessary to input a keyword in advance. However, if there is an omission or an input error of this keyword, the target document cannot be searched. There was a problem. For example, if the keyword "a" of the document is input as "a '" in the example shown in FIG. 3, the document cannot be searched with the keyword "a".

Further, since the conventional database search method is managed in document units, there are some items in the document such as each document shown in the figure. From such a database, for example, items of character data, etc. However, even if I wanted to search only a specific item, such processing could not be performed. The present invention has been made to solve the above conventional problems, and an object of the present invention is to provide a database search method that does not require any particular keyword setting and can retrieve only document items. To do.

[0009]

A database search method according to the present invention is a database search method in which data is stored in a fixed form field to form a document, and a plurality of the documents exist. When managing documents by column and searching for any document, first enter the data as the search keyword in the target column, and then store the same data as the column in which the data is stored. The present invention is characterized in that the searched column is searched, and then the document having the searched column is extracted.

[0010]

In the database searching method of the present invention,
When searching for any of the documents, first, data that is a keyword for the search is entered in the target column. As a result, the column storing the same data as the column storing the data is searched. Then, if there is a column in which the same data is stored, the document having that column is extracted. After that, for example, the data stored in the extracted document column is taken out, and the data is put in the blank portion to complement each column of the search document.

[0011]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a flow chart showing a database search method of the present invention. Prior to this, the system configuration of the present invention will be described. FIG. 4 is a system configuration diagram thereof. The system shown in the figure includes a data storage unit 1, a data format storage unit 2, a column relation storage unit 3, a data storage processing unit 4, a data search processing unit 5, a document storage device 6, a display unit 7, a keyboard 8, a pointing device 9, The input / output control unit 10, the command control unit 11, and the print control unit 12 are included. The data storage unit 1 is a memory that stores input information (data) for each column, and stores data such as an address of character data, an address of image data, and an address of graphic data.

FIG. 5 shows a table of the data storage unit 1. Further, FIG. 6 shows an example of a document stored in the table. In the table of the data storage unit 1, the character data start address, the image data start address, and the figure data start address are stored, and the column name and the data in the column are stored. That is, in the document A shown in FIG. 6, columns 1 to 4 (management section reception, section manager, section chief, charge) are image data, and columns 5 to 8 (item name, drawing number, price, delivery date) are character data. Is. Further, in the column 9 (appearance), such as graphic data, one document contains character data, image data, and graphic data.

The data format storage unit 2 is a storage unit for storing a table that defines the expression format (characters, figures, images, etc.) of the data stored in the data storage unit 1. Figure 7
Shows the table. That is, the relationship between the column name of each column and its expression form is shown.

The column relation storage unit 3 is a storage unit for storing a table that defines the matching relation between columns. Figure 8
Shows the table. Here, for example, A5, B
5 and C5 refer to the contents of column 5 of document A, document B, and document C. Therefore, it is understood that the contents described in the column 5 of the document A are also described in the documents B and C.

The data storage processing unit 4 sorts the data input in the field into characters, figures, and images, and stores the data in the data storage unit 1.
It has a function to store in. In addition, the data search processing unit 5 has a function of searching for a match in the column contents. Further, the document storage device 6, the display unit 7, the keyboard 8, the pointing device 9, the input / output control unit 10, and the command control unit 11 are the conventional document storage device 104, the display unit 105, the keyboard 106, and the pointing device shown in FIG. Since it is the same as the device 107, the input / output control unit 108, and the command control unit 109, description thereof is omitted here. The print processing unit 12 is for printing the document.

Next, the operation of the system having the above configuration will be described. Here, as an example of document retrieval, product name PC-00
Suppose you want to search for documents with 1. First, the document A shown in FIG. 6 is read on the screen, and PC-001 is entered in the item name field. As a result, the processing moves to the data storage processing unit 4.

FIG. 9 is a processing flowchart of the data storage processing unit 4. That is, when PC-001 is entered in the product name column, the data storage processing unit 4 acquires the product name (= column 5) (step S1), and from this column 5 to the data format storage unit 2 shown in FIG. The table 205 is referred to obtain the expression form (step S2). Then, the head address of the table of the data storage unit 1 and its data are stored based on the acquired expression format, and the input address is counted up.

FIG. 10 shows a table of the data storage unit 1 after the product name is input. That is, the column 5 is the expression format determination in step S3, and since it is character data, that data is stored in the address a (step S4), and the character data start address a is counted up (step S5). on the other hand,
If it is image data in the expression format determination in step S3, it is stored in the address b, and the image data start address b is counted up (steps S6 and S7). If it is graphic data, it is stored in the c address, and the graphic data start address c is counted up (step S
8, S9).

Next, a document search command is input from the keyboard 8. The command control unit 11 interprets this and passes the processing to the data search processing unit 5. The data search processing unit 5 performs the search processing shown in FIG. First, from the table of the data storage unit 1 described above, the column name (= column 5) and the product name (= P
C-001) is taken out (step S1). Next, the matching relation for each column is extracted to the table 301 (FIG. 8) of the column relation storage unit 3 (step S2), and the document name and the column name of the matching column are acquired (step S3). Then, based on the document name and the column name acquired in step S3, the document B in the document storage device 6
The document having the product name (PC-001) is taken out from the group and the document C group, and the document search is completed (step S4). FIG. 11 shows documents of the product name PC-001 of the document B group and the document C group.

Next, the process of completing the document A by filling in the blanks of the document A shown in FIG. 6 will be described. As described above, FIG. 7 shows that document A is composed of four character entry fields (article name, drawing number, price, delivery date), one figure entry field, and four image entry fields. It is stored in the tables 201 to 209. Further, in the table of the column relation storage unit 3, as shown in FIG. 8, the correspondence relations between the documents A and the documents B and C for each column are shown in tables 301 to 30.
It is stored in 5.

In the case of completing the document A with such a configuration, first, the entry item automatic complement command is input from the keyboard. The command control unit 11 interprets this and passes the processing to the data search processing unit 5. The data search processing unit 5 performs a search process similar to the above-described document search, and selects a column name (column 5) from the document B group and the document C group in the document storage device 6.
The document with the product name (PC-001) is taken out. That is, FIG.
In the flowchart of FIG. 5, in step S1, the column name (column 5), the product name (PC-00
1) is taken out, and in Steps S2 and S3, the column relation storage unit 3
On the basis of the matching relation for each column of the table of the above table, "column 5" and "PC-0" are selected from the document B group and the document C group in the document storage device 6.
The document with "01" is taken out.

Then, from the retrieved documents B and C, the table numbers 301 to 305 of the column relation storage unit 3 are used for drawing numbers,
The price, delivery date, and appearance are taken out and stored in the table of the data storage unit 1 by the method shown in FIG. 9 (step S5).
Then, it is determined whether or not all columns have been completed (step S
6) If not completed, the process returns to step S2 to perform the complementing process for each column. FIG. 12 shows a table of the data storage unit after the entry items are automatically complemented. In addition, document A in FIG.
Shows the automatic completion processing for. As shown in (a) of FIG. 13, by only entering the product name in the product name column of document A and instructing the automatic completion of the entry items, the entry items in each column are complemented as shown in (b). You can get the document.

In the above embodiment, the case where the data is entered in the article name column of the document A to perform the document search has been described, but the present invention is not limited to this, and in addition to this, the drawing number in the column 6 or It is also possible to perform a document search by inputting the image data in columns 1 to 4. Further, the format of the document may be only characters or figures, and if one document is composed of a data group stored in a fixed field, the same effect as that of the above-described embodiment can be obtained.

[0024]

As described above, according to the database search method of the present invention, documents are managed in column units, and when a search request for any document is made, data is entered in the target column. However, since the documents in which the data in the column in which this data is stored are the same, it is not necessary to set a keyword for searching for each document again, improving operability and You can search and retrieve only specific items inside.

[Brief description of drawings]

FIG. 1 is a flowchart showing a database search method of the present invention.

FIG. 2 is a system configuration diagram of a conventional document database.

FIG. 3 is an explanatory diagram of a conventional database search method.

FIG. 4 is a configuration diagram of a system for implementing the database search method of the present invention.

FIG. 5 is an explanatory diagram of a table of a data storage unit in the database search method of the present invention.

FIG. 6 is a diagram showing an example of a document in the database search method of the present invention.

FIG. 7 is an explanatory diagram of a table of a data format storage unit in the database search method of the present invention.

FIG. 8 is an explanatory diagram of a table of a column relation storage unit in the database search method of the present invention.

FIG. 9 is a flowchart of a data storage method in a data storage unit in the database search method of the present invention.

FIG. 10 is a diagram showing a table of a data storage unit after inputting a product name in the database search method of the present invention.

FIG. 11 is an explanatory diagram of a related fixed form document in the database search method of the present invention.

FIG. 12 is a diagram showing a table of a data storage unit after completion of entry items in the database search method of the present invention.

FIG. 13 is an explanatory diagram of automatic entry completion in the database search method of the present invention.

[Explanation of symbols]

 1 data storage unit 2 data format storage unit 3 column relation storage unit 4 data storage processing unit 5 data search processing unit 6 document storage device

Claims (1)

[Claims] 1. A method of searching a database in which data is stored in fixed-size fields, a document is configured, and a plurality of the documents exist, wherein the documents are managed on a column-by-column basis to search for any document. To do so, first enter the data as the search keyword in the target field, then search the field that stores the same data as the field that stores the data, and then search the field that you searched for. A method for searching a database, which is characterized by extracting a document having a.