JPH05314191A - Data base registration system - Google Patents

Abstract

PURPOSE:To register a large amount of data in a relational data base in a batch many number of times by providing an information extraction processing means which extracts information to be registered in the data base from the information converted by a document conversion processing means, and a load means which registers the extracted information in the data base. CONSTITUTION:An input and output terminal 1 prepares a text file 2 of a word processor obtained by inputting the information by using the function of a word processor by a user. The text is converted into the information to be recognized by a host side 12 through a word processor text conversion processing means 3. The entire functions are processed by a terminal side 11. Then, only the necessary information is extracted by an information extraction processing part 4, and finally loaded in a relational type data base 5. Those functions are processed by a host side 12.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database, and more particularly to a database registration system for registering a sentence created by using a word processor in a relational database.

[0002]

2. Description of the Related Art Conventionally, sentences created by a word processor were only text materials. Even if the information in the sentence is the information input to the relational database, use the tool to use the database again,
Only the required information had to be entered via the support tool.

[0003]

In the above-mentioned conventional method, since the database support tool is used to register information in the database, the operation method must be learned. Moreover, it requires an excessive amount of labor to register a large amount of information. Further, since the support tool operates under the control of the host computer, the terminal for inputting information is limited and the time zone for input processing work is also limited.

Therefore, the work efficiency of inputting information is low, and also in terms of creating a material, duplication of information input occurs separately by using a word processor.

[0005]

The database registration method of the present invention is a means for inputting information created in a fixed format, and a document conversion processing means for converting the information into a format that can be recognized by the host computer. And an information extraction processing means for extracting information to be registered in the database from the information converted by the document conversion processing means, and a loading means for registering the information extracted by the information extraction processing means in the database.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the drawings.

FIG. 1 is an explanatory view showing an embodiment of the present invention. In the figure, the database registration method according to the present invention has a terminal device 1, a word processor 2, a word processor sentence conversion processing unit 3, an information extraction processing unit 4, and a relational database 5.

The input / output terminal 1 creates a word processor text file 2 in which the user inputs information by using the function of the word processor, and the host side 12 can recognize the text through the word processor text conversion processing unit 3. Convert to information. All the functions up to this point are functions that are processed by the terminal side 11.

The above information is further processed by the information extraction processing unit 4
Only necessary information is extracted by way of, and finally loaded into the relational database 5. These are the functions of the host type 12.

FIG. 2 is a flow chart showing the operation of the above database registration method.

First, step 21 creates the fixed format 31 illustrated in FIG. Input information item is A,
B, C, D, E, and F, A, C, E, and F are alphanumeric items, and BD is a Japanese item.

Next, the data in the fixed format 31 is converted into the sequential organization data 32 by using a utility which is one of the functions of the word processor (step 22).
Then, it is further converted into data for recognition by the host computer (step 23). The operation up to this point is the operation on the terminal side.

The following is the operation on the host side. If the finally required items are now A, C, E and F, the items B and D are removed, the items A, C, E and F are extracted, and the extracted data 33 is created (step 24). Since this processing uses one program, the extraction items can be changed sequentially. Finally, the extracted data 33 is registered in the relational database using the database support tool (step 25).

[0014]

As described above, according to the present invention, a large amount of data can be collectively registered in a relational database many times by a simple operation of a word processor, work efficiency can be improved, and a word processor document can be used as a material. There is an effect that it can be fully utilized.

[Brief description of drawings]

FIG. 1 is an explanatory view showing an embodiment of the present invention.

FIG. 2 is a flowchart showing the operation of the present invention.

FIG. 3 is an explanatory diagram showing a data format example.

[Explanation of symbols]

 1 Input / output terminal 2 Word processor text file 3 Word processor Text conversion processing unit 4 Information extraction processing unit 5 Relational database

Claims (1)

[Claims] 1. A means for inputting information created in a fixed format, a document conversion processing means for converting the information into a format that can be recognized by a computer on the host side, and information converted by the document conversion processing means. A database registration method comprising: an information extraction processing means for extracting information to be registered in the database from the inside; and a loading means for registering the information extracted by the information extraction processing means in the database.