JPH05257775A - Data processing device - Google Patents

Abstract

(57) [Summary] [Purpose] To provide a data processing device capable of automatically selecting an appropriate format program when verifying or updating data. [Configuration] A control byte is provided at a predetermined position in each record of the database file 2, and data (01, 02, 03 ...) Which identifies the format program used for inputting the record is stored as the control byte.
In the verification and update processing, this format program identification data (01, 02, 03
...), the same format program that was used to input the record is automatically selected, and the verify and update processes are performed to prevent invalid data generation or data corruption due to a format program selection error. Safe and reliable data processing operations can be performed without any problems.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device, and more particularly to a data processing device for controlling data input to a database file in record units based on a format program describing a record data format.

[0002]

2. Description of the Related Art Conventionally, a database system using a computer has been known. Among such systems, particularly in a system that adopts fixed-length records, the file format for data input / output is in some form. It is necessary to describe it.

Usually, the file format for such data input / output is created in the form of an input format program (file) or an output format (file).

For example, at the time of data entry (input),
If an input format program is prepared in advance, by specifying the format program you want to use and starting input, screen format and key control at the time of record input, selection of data storage format on disk, etc. Is done automatically.

[0005]

The format program as described above is used not only for new input of data but also for verifying or updating (updating or correcting) data in a database file already input by another person. It is also used when you do.

Conventionally, at the time of verifying or updating data, a user specifies a format program to be used for the work, and
Alternatively, control such as screen format and key control during updating or selection of data storage format on the disk is performed.

Therefore, when verifying or updating the data, for example, when the user selects an incorrect format program different from that at the time of entry,
Since completely different input control is performed, there is a problem that invalid data is generated or the data itself is destroyed.

Particularly, in a system in which different format programs can be used for each record in one database file, the above-mentioned mistakes are likely to occur.

An object of the present invention is to solve the above problems and to provide a data processing device capable of automatically selecting an appropriate format program when verifying or updating data.

[0010]

In order to solve the above problems, the present invention provides a data processing device for controlling data input to a database file on a record-by-record basis on the basis of a format program describing a record data format. , Data for identifying a format program used when inputting data of a certain record is recorded in the database file as a part of the data of the record, and is recorded in the record when the already input database file is accessed. The format program used when the data of the record is input is specified from the data for identifying the format program, and the configuration having the control means for controlling the access using the format program is adopted.

[0011]

According to the above construction, since the data for identifying the format program used when inputting the data of the record is recorded as a part of the data of the record, it is possible to verify or update the data in the database file. At the time of access, by referring to the format program identification data, the access can be controlled by using an appropriate format program.

[0012]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described in detail below with reference to the embodiments shown in the drawings.

FIG. 1 shows the structure of a data processing apparatus adopting the present invention. In FIG. 1, reference numeral 11 is a control unit that is the core of the database system, and is a workstation,
It consists of a personal computer and other computers. Reference numeral 14 is an input device including a keyboard, a mouse and the like connected to the control unit 11.

Reference numeral 12 is a storage device, which comprises a storage medium such as a hard disk and stores the data file 2. The data entry (input) of the data file 2 using the input device 14 and the display unit 16 including a CRT display is performed by a known operation procedure according to the software of the control unit 11.

In this case, an appropriate one is selected from the format programs 1 prepared in advance, and the key input control of the keyboard 14 and the screen control of the display unit 16 and the storage are performed according to the description contents of the format program 1. The data storage format in the database file 2 of the device 12 is controlled.

In the case of the present embodiment, the format program 1 describes the data format of each field, the data length, the display and the storage format in a predetermined format in units of one record.

Further, in the case of this embodiment, different format programs can be used for each record in one database file. That is, in the case of data entry, the user is allowed to select a desired format program 1 by an appropriate operating procedure from the keyboard 14, and the key input control of the keyboard 14 and the screen control of the display unit 16 are performed by the format program 1 as usual. , And the data storage format in the database file 2 of the storage device 12 and the like.

The format program 1 is described in a well-known appropriate program format, and the user or system administrator can describe desired contents and can edit an existing format program.

Further, in this embodiment, the type of the format program 1 selected at the time of entry is stored in the database file 2 as a part of the data. Figure 2
The structure of the database file 2 in a present Example is shown.

As shown in the drawing, a predetermined position (first byte in the illustrated example) in each record of the database file 2
Is provided with a control byte, and as the control byte, data for identifying the format program 1 used for inputting the record (01, 02, 0 in the illustrated example).
3 ...) is stored.

FIG. 3 shows the procedure of data entry, verification and update processing by the control unit 11 in the above-mentioned configuration. Here, the entry, verify and update processing loop for one record is shown.

Steps S1 to S3 in FIG. 3 are the keyboard 1
Step S4, S7, or S depending on the input from
8 shows a process of selecting the entry, verify and update processes in FIG.

When the data entry is selected in step S1, entry processing is performed in the same manner as in the conventional case in step S4. Here, as described above, prior to the actual entry operation, the user is made to select the desired format program 1 by an appropriate operation procedure, and the input, display, and storage of each record are performed using the selected format program 1. Controlled.

When the verify or update process is selected in steps S2 to S3, the verify or update process is executed in steps S5 and S6, respectively, before the corresponding verify or update process is executed in steps S7 and S8. Automatically select the format program to use.

Actually, in steps S5 to S6, the control byte of the record of the database file 2 currently being accessed (see FIG. 2) is referred to, and the format program to be used in the verify or update process is automatically selected. Then, based on this format program, the process proceeds to steps S7 and S8 to control the display, input or data storage in the verification or update process.

If the contents of the control byte of the database file 2 are explicitly displayed on the keyboard 14 during the record verifying or updating process in an appropriate display format, the user can display the record currently handled. You can check the format, which is convenient.

Further, the format program 1 different from that at the time of entry can be selected by an appropriate operation procedure, and when the format program 1 different from that at the time of entry is selected, the data format is automatically converted and displayed, input or. You may make it control (reformat processing) which changes data storage. In that case, when a conversion error occurs such as when the changed field length is too short, a warning may be issued and a different format program 1 may be selected.

According to the above embodiment, the data for identifying the format program used at the time of data input is stored in the database file 2 as the control byte, and the control byte is referred at the time of verifying or updating the record to verify the record. Also, since the format program that should be used for the update process is automatically selected, there is no problem of invalid data generation or data destruction due to the mistake of selecting the format program as in the past, and safe and reliable data processing business. It has the excellent effect that

[0029]

As is apparent from the above, according to the present invention, in a data processing device for controlling data input to a database file on a record-by-record basis, based on a format program describing a record data format, the data of a certain record is recorded. Data for identifying the format program used at the time of input is recorded in the database file as a part of the data of the record, and when the database file already input is accessed, the format program recorded in the record is identified. Since the format program used when inputting the data of the record is specified from the data to be recorded and the control means for controlling the access is used by using the format program, the format program is used when inputting the data of the record. Since the data for identifying the formatted program is recorded as a part of the data of the record, an appropriate format can be obtained by referring to the format program identification data when verifying or updating the data in the database file. It is possible to provide an excellent data processing apparatus which can control access using a program and which does not cause an accident that invalid data is generated by selecting an incorrect format program as in the conventional case or data itself is destroyed.

[Brief description of drawings]

FIG. 1 is a block diagram of a data processing device adopting the present invention.

FIG. 2 is an explanatory diagram showing a storage format of a database file of the apparatus of FIG.

3 is a flowchart showing a control procedure of entry, verify and update processing in the apparatus of FIG.

[Explanation of symbols]

 1 format program 2 database file 11 control unit 12 storage device 14 keyboard 16 display unit

Claims (1)

[Claims] 1. A data processing device for controlling data input to a database file on a record-by-record basis based on a format program describing a record data format, and data for identifying a format program used for data input of a record. The format used when inputting the data of the record from the data identifying the format program recorded in the record when the data is recorded in the database file as a part of the data of the record and the database file already input is accessed. A data processing device comprising a control means for specifying a program and controlling the access using the format program.