JPH06187372A - Data entry system - Google Patents

Abstract

PURPOSE:To enter data into a data base from an external file without writing a sentence in specified format for the entry only by inputting necessary information through a user interface and to confirm the contents of the data before the data are actually entered into the data base. CONSTITUTION:External file information and data base entry information are obtained by an external file information specifying means 15 and a DB entry information specifying means 16. A data table generating means 18 generates an entry data table as a list of data to be entered into the data base on the basis of the information and a display means 17 displays it on a display screen. When the data base of the external file are entered after a user confirms the contents, an entry sentence generating means 19 generates sentences in specified format for the data base entry as to individual specified information.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system in which data to be processed is stored in a plurality of tables, and more particularly to entry of data from an external file into the database.

[0002]

2. Description of the Related Art Generally, when a large amount of data is entered into a database at once, a method of entering data from an external file is used. At this time, the external file name, the read format, the database table name, the column name, the data type, etc. are specified by the statement of the predetermined format. Regarding this, for example, ORACLE Utility User's Guide "Part 2 SQL * Load" issued by Oracle Corporation.
r ").

[0003]

In the conventional entry method, since the data to be entered must be specified by the statement of the specified format, a certain amount of knowledge is required and the entry also takes time. was there.
Further, the contents of the entry could not be confirmed without actually searching the database after actually entering the database. For this reason, if incorrect data was entered, the conversion format had to be changed again, the wrongly entered data had to be deleted, and the entry had to be redone.

As a technique related to this type of database system, Japanese Patent Application Laid-Open No. 2-144671 discloses a command creating device which automatically creates a database search command. However, no consideration is given to data entry,
The problems mentioned above have not been solved.

The present invention enables entry by simply entering the necessary information through the user interface without writing a text for entry, and confirming the contents of data before actually entering the database. It is an object of the present invention to provide a data entry method that enables

[0006]

In order to solve the above problems, in the data entry method according to the present invention, external file information designation for designating external file information necessary for reading an external file such as external file name and file format Means, DB entry information designating means for designating database entry information necessary for entry into the database such as database name and table name, and information storage for storing external file information and database entry information designated by the respective designating means Means, an entry data table creating means for creating an entry data table which is a list of data to be entered into the database based on the information stored in the information storing means, and a display means for displaying the entry data table. , Each of the above specified information The entry statement creating means for creating a statement of a specified format for entry into the database, and displaying a list of data to be entered before entering data into the database from an external file. Is characterized by.

[0007]

When the user designates the external file information which is the file conversion information and the database entry information through each designation means and instructs the table display, the entry data table which is a list of the data to be entered into the database by the data table creation means is created. It is created and displayed on the display screen by the display means. Here, the user confirms whether or not there is an error in the data to be entered, and if there is an error, the external file or the file conversion information is changed, and after confirmation, the data in the external file is entered. At this time, the entry statement creating means creates a statement in the specified format for entry into the database for each of the specified information.

According to this, it is possible to confirm whether or not there is an error in the data before actually making an entry in the database, so that entry of incorrect data can be prevented. Further, since entry is possible only by inputting necessary information from the input means, it is not necessary to write a statement for entry in the database.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the data entry method according to the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a block diagram showing the functional configuration of a database system to which the data entry method according to the present invention is applied. This system is composed of a workstation 10 having a file entry function and a database 11 in which data for processing such as search and registration is stored in a plurality of tables.

In the workstation 10, the user interface section 12 has an external file information designating means 15 for designating external file information such as an external file name and a file format, and database entry information such as a database name and a table name (hereinafter, DB). Entry information)
It is composed of a DB entry information designating means 16 for designating and a display means 17 for displaying an entry data table described later.

The file entry processing unit 13 includes an entry data table creating means 18 for creating an entry data table which is a list of data to be entered into the database, based on information stored in an exchange format file 21 described later, External file information designating means 15 and DB
For each of the information designated by the entry information designating means 16, an entry sentence creating means 19 for creating a sentence in a designated format for entry into the database, the external file information designating means 15 and the DB entry information designating means 16 The entry activating means 20 makes an entry in the database in accordance with the information defined in 1.

The data storage unit 14 stores an exchange format file 21 for storing the external file information and the database entry information designated by the external file information designating means 15 and the DB entry information designating means 16, and the data to be entered. It is composed of an external file 22. If the designated information is not saved, the exchange format file 21 need not be provided.

FIG. 2 is a block diagram showing a hardware configuration for realizing the database system shown in FIG.

In the figure, the display device 1 has a display screen such as a CRT, and displays various windows and entry data tables on the screen. The display on the display device 1 is controlled by the display device control unit 2. The display device 1 and the display device control unit 2 realize the function of the display unit 17 of FIG.

The keyboard 3 is an input device for inputting data such as commands and character strings, and is connected to a mouse 4 for selecting instructions on the screen. Various data and instructions input from the keyboard 3 and the mouse 4 are sent to the central processing unit 9 through the keyboard / mouse control unit 5.

The disk device 6 is a disk such as a magnetic disk.
It is composed of the following storage device and stores the data to be entered in a file format. The input / output of data in the disk device 6 is controlled by the disk device controller 7. The disk device 6 realizes the function of the data storage unit 14 of FIG.

The main storage device 8 is a buffer storage composed of a memory device such as a RAM, and temporarily stores various programs and various data and commands input from the keyboard 3 and the mouse 4.

The central processing unit 9 is a processor unit composed of a CPU, operates the above-mentioned units according to a program, controls the entire system, and performs arithmetic processing on predetermined data. The central processing unit 9 realizes the function of the file entry processing unit 13 of FIG. 1, for example.

Next, the operation of the above-mentioned database system when an entry is made from an external file into the database will be described.

The user uses the external file information designating means 15
Specify external file information (external file name, file format, etc.) through. Similarly, DB entry information (database name, table name, commit method, column name for each column, type, entry / no entry, default value, position designation of external file) is designated through the DB entry information designating means 16. The designation of these pieces of information can be designated through a property sheet displayed on the display screen of the display means 17. An example of the specified contents of the external file information is shown in FIG. 3, and an example of the specified contents of the DB entry information is shown in FIG.

Subsequently, when the user gives an instruction to display the table, the entry data table creating means 18 lists the data to be entered into the database based on the above-specified information before actually entering the database. Entry data table is created. Then, the created entry data table is displayed on the display screen of the display means 17. A display example of the entry data table is shown in FIG. The display of the entry data table allows the user to confirm whether or not the entered data is correct. At this time, if the displayed data is incorrect, the external file or file conversion information is changed. And after confirming the content again,
The entry starting means 20 enters the data of the external file into the database. When making an entry, it is possible to make an entry simply by specifying the location of the external file or the default value. At this time, the entry statement creating means 19 creates a statement in the specified format for entry into the database for each of the specified information.

Next, the flow of the operation in the case of making an entry in the database from the above-mentioned external file will be described with reference to the flowchart of FIG.

First, designation of external file information and designation of DB entry information are accepted (steps 101, 10).
2) Display a message asking whether to save the specified information and wait for an instruction from the user (step 10).
3). Here, when saving the information, the specified information is saved in the exchange format file 21 (step 10).
4). Then, a message asking whether or not to display a table is displayed, and an instruction from the user is waited for (step 10).
5). If the table is not displayed, the process is terminated, and if the table is instructed, the entry data table is created and displayed on the display screen (step 106). Next, it is determined whether or not there is a data change instruction from the user (step 107),
If there is an instruction to change, the process returns to step 101 and the designation of external file information and DB entry information is accepted. Further, when there is an instruction of no change, a message asking whether or not to specify the entry is displayed and the instruction from the user is waited (step 108). If there is an instruction to specify an entry, the entry to the database is activated (step 109), a log file is created (step 110), and the process ends.

It should be noted that the method and processing procedure of the user interface in the above flow chart is merely an example, and the present invention is not limited to this.

[0026]

As described above, in the data entry method according to the present invention, an entry data table which is a list of data to be entered into the database is created based on the designated external file information and DB entry information. In addition to displaying the information, a sentence of the specified format for entering the information in the database is created, so that the user can enter the information according to the specified condition before actually entering the database. Since it is possible to confirm whether there is any error, it is possible to prevent erroneous data entry. In addition, since it is not necessary to write a statement of a specified format for entry, entry can be easily performed by designating necessary information from a user interface without knowledge of a database query language. further,
Since the format of the external file to be read can be specified, for example, when the length is variable, the delimiter or the like can be supported even if it is not predetermined.

[Brief description of drawings]

FIG. 1 is a block diagram showing a functional configuration of a database system to which a data entry method according to the present invention is applied.

FIG. 2 is a block diagram showing a hardware configuration for realizing the database system of FIG.

FIG. 3 is a diagram showing an example of designation contents of external file information.

FIG. 4 is a diagram showing an example of designated contents of DB entry information.

FIG. 5 is a diagram showing a display example of an entry data table.

FIG. 6 is a flowchart showing a flow of operations when an entry is made from an external file into a database.

[Explanation of symbols]

10 ... workstation, 11 ... database, 12
... user interface section, 13 ... file entry processing section, 14 ... data storage section, 15 ... external file information designating means, 16 ... DB entry information designating means, 17 ... display means, 18 ... entry data table creating means, 19 ...
Entry sentence creating means, 20 ... Entry starting means, 21 ...
Conversion format file, 22 ... External file

Claims (1)

[Claims] 1. A database system in which data to be processed is stored in a plurality of tables, input means for designating external file information, input means for designating information of a database to be entered, and the designated information. And an entry data table creating means for creating data to be entered into the database as an entry data table based on the information stored in the information storing means, and displaying the entry data table. A list of data to be entered before entry of data from an external file into the database, comprising: display means; and entry statement creation means for creating a statement for entry into the database for each of the specified information. Is displayed. Entry method.