JPH08235032A - Logical check system for data base updating - Google Patents

Abstract

PURPOSE: To improve the productivity for development of programs by providing a function to check the updating request given from a program based on the definition language having an optional logical check instruction function and also on the logical check instruction information designated by the definition language. CONSTITUTION: A data base management system 3 consists of an error check function 4 which checks the updating request of a data part 7 given from a program 1 and a check instruction register function 5 which registers the table definition information 2 including the error check instruction information at a table definition part 6. The contents of the error check carried out by the function 4 are not especially defined. However, the system 3 checks whether the same keys are included in other tables when the records are added and whether each item value of a record is kept in the range of a certain constant. Furthermore, the system 3 checks the correctness of the date data and the relation between other items and records and also performs a composite check, etc.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database update logic check method, and more particularly to a database update logic check method for efficiently performing program development work in the development of a computer system using a relational database system.

[0002]

2. Description of the Related Art When a database is updated by a program, a logical error check description for ensuring the correctness of the updated contents is essential. Conventionally, when updating a database from a program, a logical error check method was designed for each program, and the error check logic was described according to the programming language.

[0003]

In the above-mentioned conventional program development method, even if the same database table is updated, the error check must be designed and described for each program, which is a drawback of low productivity. is there. In addition, there is a risk that an interface error will occur or a program will be missed when the table design is changed.

[0004]

The database update logic check method of the present invention sends an update request from a program based on a definition language having an arbitrary logic check instruction function and logic check instruction information instructed in the definition language. It has a check function.

[0005]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the database update logic check method of the present invention.

In the database update logic check method of this embodiment, as shown in FIG. 1, the database management system 3 stores an error check function 4 for checking an update request of the data section 7 from the program 1 and error check instruction information. It is configured by a check instruction information registration function 5 that registers the included table definition information 2 in the table definition unit 6.

The contents of the error check performed by the error check function 4 are not particularly specified, but the following may be prepared in advance by the database management system 3.

(1) Conditions for adding / deleting / replacement of records Checking whether other tables have the same key when adding records, etc. (2) Specifying the range of each item in a record Check if there is any Validity check of date data Check related to other items or other records (3) Combined check of (1) and (2) Other than this, user-defined error check procedure If it also has the function to be quoted as a function, the versatility will be further enhanced. (The contents and definition method of the function depend on the specifications of the database management system 3) The result of the error check by the error check function 4 is notified to the program 1. The format of the error notification depends on the programming language specifications, but generally the following contents should be notified.

(1) Type of error No error Violates the conditions for record addition / deletion / replacement Violates the range specification of items, etc. (2) Error table name / item name When an error check determines that there is no error Is provisionally updated. (The program uses the program exclusively until the actual update request is made.) As a method for performing the tentative update, the following method is generally considered although it depends on the specifications of the database management system.

(1) Method to be performed on main storage device: Actual update is not performed until a real update request is made from a program, but only on the main storage device.

(2) Method of restoring pre-update record by pre-update journal Actual update is performed based on a temporary update request from the program, but the pre-update information is output to the journal file to invalidate the update. If there is a request to do so, the state before the update is restored.

(3) Method of using (1) and (2) in combination In any of the above cases (1), (2) and (3), the record or block being temporarily updated is used by another program. Prohibit

The processing after the program 1 receives the error notification depends on the specifications of the program 1. Generally, if the error check result at the completion of one transaction is normal, the processing of one transaction is enabled. Conversely, if the error check result is abnormal, the processing within one transaction is invalidated. The method of validating / invalidating one transaction depends on the programming language specifications. Generally, it is validated by issuing a COMMIT (acknowledge) command, and invalidated by issuing a ROLLBACK (return) command. Check instruction information registration function 5
Has a table definition language that can instruct the contents of the error check described above, and a function of translating the table definition language and registering it in the table definition unit 6.

FIG. 2 is an image diagram showing an example of a table definition language registration function in the database update logic check method of this embodiment. The table definition information is described in a dedicated table definition language as shown in FIGS. 2A and 2B, translated by the database management system 3, and registered in the table definition unit 6.

FIG. 3 is a block diagram showing an example of a table definition section in the database update logic check method of this embodiment.

The table definition section 6 is composed of table definition information as shown in FIG. 3A and error check instruction information as shown in FIG. 3B.

As shown in FIG. 3 (a), the table definition information is created for each item of the table, and the item name, attribute, classification of whether it is a key item, and whether it is an item to be checked. It is composed of categories.

As shown in FIG. 3B, the error check instruction information is created for the item designated to be checked by the table definition information as shown in FIG. 3A. The input / output classification defines which input / output command is issued by the user AP to perform the check. The check function defines the function (subroutine) name to be executed when performing an error check. The function parameter defines the parameter (argument) when calling the function. The check function is called in the following format. User-created functions must also follow the format below. (The language to be created is not specified if it has a subprogram calling function.) Call format (description format conforms to the COBOL language) CALL function name USING data item Status function parameter 1 function parameter 2 ... where The data item is an item instructed to be checked, and the status is an item for storing the check result.

FIG. 3 is a flow chart showing an example of the operation in the database update logic check method of this embodiment.

When there is an update request from the program (step 201), the database management system 3 refers to the table definition information to be updated and obtains error check instruction information (step 202). From the acquired error check instruction information, the database management system 3
Perform the corresponding error check. First, with respect to the error check instruction information of each item, the input / output classification and the check condition are referred to, and it is determined whether or not the item is an error check item. If it is an item for which an error check should be performed, call the function specified by the error check instruction information. If there is no abnormality in the result status from the function, the same processing is repeated until the last item, and if there is no error, temporary update is performed. When the result status is abnormal, the process ends without performing the temporary update (step 203). The result of the error check is notified to the program 1 (step 204). As a result of the error check notification, when the processing of one transaction is approved by the program 1, actual update is performed (step 205). On the contrary, if the update invalidation request is issued from the program 1, the update of one transaction is invalidated (step 206).

[0022]

As described above, the database update logic check method of the present invention has the following advantages.

1) By omitting the error check description when updating the database from each program, the productivity of program development can be improved.

Particularly in the fourth generation programming language and the like, a fixed procedure is provided in advance on the language side, and most of the procedure description is an error check procedure, so it is considered to be effective.

2) Since the error check procedure that does not depend on each program is defined on the database, it is possible to prevent the database from being destroyed due to an error in the program.

3) When the contents of the database table are changed, it is sufficient to change the definition of the database table without modifying each program, so that the correction leak of the program can be prevented.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a database update logic check method of the present invention.

FIG. 2 is an image diagram showing an example of a table definition language registration function in the database update logic check method of the present embodiment.

FIG. 3 is a configuration diagram showing an example of a table definition unit in the database update logic check method of this embodiment.

FIG. 4 is a flowchart showing an example of operation in the database update logic check method of the present embodiment.

[Explanation of symbols]

 1 Program 2 Table definition information 3 Database management system 4 Error check function 5 Check instruction information registration function 6 Table definition section 7 Data section

Claims (2)

[Claims] 1. A database update logic check comprising a definition language having an arbitrary logic check instruction function and a function of checking an update request from a program based on logic check instruction information instructed in the definition language. method. 2. When there is an update request from the program, the database management system refers to the table definition information to be updated and obtains error check instruction information,
Perform the corresponding error check from the acquired error check instruction information, refer to the input / output classification and check conditions for the error check instruction information of each item, determine whether it is an item that should be error checked, and perform the error check If it is, call the function specified by the error check instruction information, and if the result status from the function is not abnormal, repeat the same processing until the last item,
If there is no error, tentative update is performed. If the result status is abnormal, the process ends without performing tentative update, the error check result is notified to the program, and the error check notification result indicates that one transaction is processed by the program. 2. The database update logic check method according to claim 1, wherein when the program is approved, the actual update is performed, and conversely, when the update invalidation request is issued from the program, the update of one transaction is invalidated.