JPH0573379A - Data base control system - Google Patents

Abstract

PURPOSE:To improve the degree of freedom of data processing by controlling a procedure, generated by a user by using an optional high-level language, for respective records in a data base. CONSTITUTION:A data base defining means 11 analyzes a procedure type data attribute described in a data base definition language source 3 and calls a procedure type data attribute defining means 12 to generate a data base definition object 4. A record registering means 22 and a record retrieving means 23 which are called by AP21 call a library retrieving means 24 and a procedure developing means 25 to perform the retrieval of an execution type program library 5 and the development on a main storage, thereby registering, retrieving, and executing the procedure type data attribute.

Description

Detailed Description of the Invention

[0001]

TECHNICAL FIELD The present invention relates to a database management system, and more particularly to a data management system for data having a procedural attribute.

[0002]

2. Description of the Related Art In a conventional database management system, whether static attributes such as numbers and characters are handled as data attributes,
Alternatively, even if the procedure can be registered, the procedure described in the database-specific language can only be registered in the record definition. It is not possible to register a procedure created by the user in any language for each entity of the stored record.

In such a conventional database management system, when accessing the actual condition of the record registered in the database, it is impossible to execute a different procedure for each record entity. Furthermore, even when creating a procedure that can be registered for a record definition, there is a drawback that knowledge of the language unique to the database management system is required.

[0004]

SUMMARY OF THE INVENTION Therefore, the present invention has been made to solve the above-mentioned drawbacks of the prior art. The object of the present invention is to create a procedure created by a user in an arbitrary language for each record in a database. It is to provide a database management system that manages and improves the degree of freedom of data processing.

[0005]

According to the present invention, there is provided a database management system for operating a procedure defined for each record when operating a record registered in a database, which translates the database definition to create an object. And a procedural-type data attribute defining unit that is called from the database defining unit and translates a data item that is declared as an attribute in the record when the record is defined and creates an object The procedure name created by the person himself using an arbitrary high-level language and the parameters used in the procedure,
Record registration means for referring to the record definition information of the object and registering it as data having a procedural data attribute, an executable program library in which the procedure is registered, and a library for confirming the existence of the procedure in the executable program library A searching means, a procedure expanding means for expanding a procedure from the execution format program library into a main memory, and a means for calling a library searching means for confirming the existence of the procedure in the execution format program library when a record registration request is made from an application program. When a record search request is issued from an application program, when a record is searched and a data item having a procedural data attribute exists, the library search means and the procedure expansion means are called to provide the data item. Database management system is obtained, characterized in that it comprises a record retrieval means for calling the procedure.

[0006]

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

FIG. 1 is a block diagram showing the configuration of a procedural data management system according to an embodiment of the present invention. In the embodiment of the present invention, the database definition unit 1 that translates the definition of procedural data and registers it in the database definition object
And a procedure name called from the application program (AP) to register the procedure name in the procedure type data and searching for the registered procedure type data, the procedure name set in the procedure type data from the existing executable program library 5 And a database operation unit 2 for reading and executing a corresponding program on a main memory (not shown).

The database defining section 1 has a database defining means 11 which inputs a database definition language source 3 containing procedural data, and a procedural data attribute defining means 12 in the database defining means 11. ing. Then, the database definition unit 1 generates the database definition object 4 according to the database definition language source 3.

The database operating unit 2 is composed of an application program (AP) 21, a record registration means 22, a record search means 23, a library search means 24, a procedure expansion means 25 and an executable program library 5 created by a normal means. Has been done.

Here, procedural data will be described.
The data that has existed in the past is characters (JIS characters, etc.) and numbers (2
The data used in the present invention is different from the conventional data, but has information indicating a procedure in the data (storage structure in database shown in FIG. 4). Has a procedure name and the address of a parameter used in the procedure), which is called procedural data.

The database defining means 11 receives the database definition language source 3 (see the example of procedural data definition in the database definition language of FIG. 9) as input, and when the procedural data attribute is defined, the procedural data attribute is defined. The procedural data attribute definition means 12 which develops as a record in-database format is called, the database definition content is analyzed, and a database definition object (see the implementation example of the database definition object in FIG. 10) 4 is created.

Since the record registration means 22 is called from the application program (AP) 21 and confirms the existence of the procedure name given to the data having the procedural data attribute, the library search means 24 is called and the existence can be confirmed. A record is registered in a database (not shown).

The record search means 23 is called by the AP 21, reads the requested record from the database, and if there is data having a procedural data attribute, the existence of the procedure name is confirmed by calling the library search means 24. Then, the procedure expanding means 25 is called,
The procedure is expanded in the main memory and called.

The library search means 24 receives the procedure name as a parameter, and executes the executable program library 5
Confirm that the given procedure is registered by searching.

The procedure expanding means 25 expands the program corresponding to the procedure name given as a parameter from the execution format program library 5 into the main memory, and solves the calling relationship with the record searching means in the main memory ( Link).

FIG. 2 shows an outline of processing of the database defining means 11. The database definition language source 3 is sequentially read (201), and if the source is not completed (202), it is checked whether it is a procedural data attribute definition (203). If it is a procedural data attribute definition, procedural data definition (103)
Is called and reflected as the record format in the database (205).

If it is not a procedural data attribute definition in the check at 203, normal syntax analysis is performed (204). Then, it is converted into a database definition object and registered (206). When the source is finished, the process is finished (207
).

FIG. 3 shows a processing flow of the procedural data attribute defining means 12. The position in the record of the item having the procedural data attribute is calculated (301), and the area length of the procedure name and the address area size in the database are calculated and added to the record size (302). As a result, the in-record management status of the data item having the procedural data attribute is determined, and the processing ends (303).

FIG. 4 shows how to hold procedural data attribute information in the database. In the record 401, the procedural data attribute indicates that it has a procedure name and an in-database address for managing parameters whose number varies depending on the procedure.

The parameter information is linked in a chain on the database as a parameter information record 402 composed of an in-record offset indicating the data item name given as a parameter and an in-database address indicating the next parameter. It means that it is managed.

FIG. 5 shows an outline of processing of the record registration means 22 executed when called from the application program AP21 according to the source program description example (procedural data registration syntax example) shown in FIG.

In the case of registering the record body (501), the record registration means 22 determines the database definition object 4
To obtain record definition information (502). After that, the data having each procedural attribute in the record is initialized (503) and the record is stored in the database (50).
Four ).

If it is judged by the comparison of 501 that procedural data is registered, the parameter representing the data item name passed from the AP 21 is acquired (505), and the record in which the data item name of the registration request is registered most recently. Check if you belong to (506). At this time, if the record is not the latest registered record, an error code is returned and the processing ends (509). If it is correct, the library search means 24 is called (507), the parameter indicating the procedure name is acquired, and it is confirmed whether the procedure name passed from the AP 21 has been registered in the executable program library 5. If it is not registered (508), an error code is returned and the processing ends (509).

If registered, the procedure name is set as the content of the data item of the most recently processed record (51
0). After that, the parameter information record is registered in the database (512) until the parameter indicating the parameter to be passed to the procedure ends (512), and when all the parameter information is registered, the record is updated (513) and the processing ends (514). ..

FIG. 6 shows a processing flow of the record search means 23. A record is retrieved from the database according to the instruction from the AP (601). It is checked whether the retrieved record has a procedural attribute defined (602). The following processing is performed until the procedural data attribute is completed (603).

Obtain the procedure name from the procedural data (60
4) Call the library search means 24 with the procedure name as a parameter (605). The parameter information record is retrieved from the database (606) and the following processing is repeated until the parameter is completed (607).

The parameter information is set as the parameter format of the subroutine call (608), and the next parameter information record is retrieved (609). When the parameter information record is completed, the procedure expanding means 25 is called (610).
), The procedure is linked as a subroutine and the procedure is called (611). At this time, if a development error occurs, an error code is returned to the AP and the process ends. When all the procedural data attribute processing has been performed, the processing ends (612).

FIG. 7 shows a processing flow of the procedure expanding means 25. The executable program library 5 is searched (701) and it is confirmed whether the procedure name given by the AP exists in the library. Verify if it exists (702
), If it does not exist, an error code is returned and the process ends (707).

If it exists, the memory size for expanding the executable program on the main memory is calculated (703).
). An area is secured in the main memory according to the calculated memory size (704), and the procedure is read into the main memory and linked as a subroutine (705). After performing this amount of processing, the processing ends.

FIG. 8 shows the processing flow of the library search means. The executable program having the procedure name given by the AP is searched in the executable program library 5 (801). If the procedure does not exist (802), the error code is returned and the processing is terminated (804). If it exists, it returns normally (805).

In FIG. 9, a procedural data definition statement (903) is newly added to the conventional record definition statement (901) and data definition statement (902), and the procedural data definition is defined as an attribute of the data item. Indicates that it is possible.

FIG. 10 shows how to hold object information when the procedural data item of FIG. 9 is defined. Ten
01 represents a conventional record definition object, and 1002 newly represents a procedural data object.

FIG. 11 shows the syntax of a database operation command when registering procedural data in the database. 1101 is a conventional record registration command, and 1102 represents the syntax of a procedural data registration command. 1102 indicates that the registration of the procedural data is completed by giving the procedure name and the parameter for calling the program corresponding to the procedure name to the data item name which is the procedural data.

[0034]

According to the present invention, since the user can individually register the procedure created in any high-level language for each record stored in the database, the user can learn the data manipulation language unique to the database. This has the effect of enabling a more data-oriented database operation without consuming the man-hours of

[Brief description of drawings]

FIG. 1 is a system block diagram of an embodiment of the present invention.

FIG. 2 is a processing flow chart of a database defining means.

FIG. 3 is a processing flow chart of a procedural data attribute definition means.

FIG. 4 is a diagram showing a database internal structure of a code in which a data item having a procedural data attribute is defined.

FIG. 5 is a processing flow chart of a record registration unit.

FIG. 6 is a processing flow chart of a record search means.

FIG. 7 is a process flow diagram of a procedure expanding unit.

FIG. 8 is a process flow diagram of a library search means.

FIG. 9 is a diagram showing an example of a procedure type definition in a database definition language.

FIG. 10 is a diagram showing an implementation example of a database definition object.

FIG. 11 is a diagram showing an example of a syntax for registration of procedural data.

[Explanation of symbols]

 1 database definition part 2 database operation part 3 database definition language source 4 database definition object 5 execution format program library 11 database definition means 12 procedural data attribute definition means 21 application program 22 record registration means 23 record search means 24 library search means 25 procedure Deployment means

Claims (1)

[Claims] 1. A database management system for operating a procedure defined for each record when operating a record registered in the database, wherein the database definition means translates the database definition to generate an object. And a procedural data attribute definition unit that is called from the database definition unit and that translates a data item in which the attribute is declared to be a procedure in the record definition and creates an object, and an arbitrary high-grade data by the user himself. Record registration means for registering a procedure name created using a language and parameters used in the procedure as data having a procedural data attribute by referring to the record definition information of the object, and the procedure is registered. Executable program library and the executable program A library searching means for confirming the existence of the procedure in the library, a procedure expanding means for expanding the procedure from the execution format program library into the main memory, and a existence confirmation of the procedure in the execution format program library when a record registration request is made from the application program. And a library search means for calling the library search means and a procedure expansion means when the record is searched and a data item having a procedural data attribute exists at the time of a record search request from the application program. And a record search means for calling a procedure given by a person.