JP2641402B2 - DML object management method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a DML object management system, and more particularly, to a relational database technology of an information processing system, a part related to a table access request in an application program is executed in a runtime format.
The present invention relates to a DML object management method for a system in which L objects are stored in a directory file of a database.

[0002]

2. Description of the Related Art Conventionally, in a relational database technology for providing a user with a set of unordered rows as a table with a minimum unit of input data as a column, a table access request in an application program created by the user is known. Is converted into an executable DML object in a database operation language at the time of compilation and stored in a directory file together with table definition information and the like. In this case, DML
If the table definition information of the base table (base table storing data) or VIEW table (introduction table created using the base table) used in the object is changed, the DML object is changed. Becomes unusable as it is.
This is because version information (such as last update date) of the table definition information generally referred to at the time of compilation is added to the DML object as additional information, and unintended table access is performed due to a change in the table definition information after compilation. This is because, in order to prevent this from happening, the consistency is checked at the time of execution, and management is performed so that the execution is performed only when the version information of both the DML object and the table definition information match. Therefore, when the table definition information of the base table and the VIEW table is changed, not only the DML objects that are directly affected by the changed contents but require the change of the source program, but also the source program without the direct influence are changed. The DML object that does not need to be changed is also searched, and in the former case, the relevant part of the source program is corrected, and in the latter case, the relevant application program is re-read in order to make the version information consistent without correction. It is necessary to compile and store the DML object again. These measures are individually performed by the users who have been notified of the update of the table definition information.

[0003]

As described above, in the conventional DML object management method, a base table and a VIEW are used.
The management of the DML object required when the table definition information of the table is changed is left to the user who created the program, and the user searches for the related DML object registered in the directory file, Since the corresponding application program must be recompiled, there is a problem in terms of processing efficiency.

[0004] An object of the present invention is to automatically associate a DML when the table definition information of a base table and a VIEW table is changed.
Another object of the present invention is to provide a DML object management method in which objects are updated and the operability and processing efficiency of the system can be improved.

[0005]

According to the DML object management method of the present invention, an unordered set of rows is provided as a table with a minimum unit of data as a column, and a table access related table in an application program created by a user is provided. In a DML object management method of a relational database system in which a part is stored in a directory file together with table definition information as a DML object, the method is started when an update is made to existing table definition information or the like stored in the directory file. A related DML object searching means for searching and extracting additional information for a DML object accessing a base table and a VIEW table to be updated, and analyzing the contents of the DML object extracted by the related DML object searching means to make a change. What to do Is related DML object regenerating means for regenerating and executing a new DML object by making a possible change with reference to the executed update contents such as table definition information, and regenerating by the related DML object reproducing means. A related DML object storage unit for storing the updated DML object in the directory file again, and executing an update when an update of existing table definition information or the like is instructed and temporarily storing the updated content to obtain the related DML object search unit. A directory file update control means for controlling the related DML object regenerating means and the related DML object storage means and collecting and editing necessary contact information.

[0006]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of one embodiment of the present invention.

In the DML object management system of this embodiment, as shown in FIG. 1, a directory file 5 storing table definition information and an index of a relational database and a directory file 5 in accordance with an instruction from a terminal device 6 are stored. A directory file update control unit 1 that updates table definition information and an index and performs a control necessary for management of a DML object, and a DML object that accesses a table activated and updated according to an instruction of the directory file update control unit 1. The related DML object searching means 2 to be searched and the contents of the searched DML object are analyzed, necessary changes are made by referring to the updated contents of the directory file 5, the version information is updated, and the executable DML object is regenerated. Related DML As-object re-generating means 3, regenerated again directory file a DML object 5
And a printer 7 for outputting necessary contact information edited by the directory file update control means 1.

The directory file 5 includes table definition information of a base table in which real data is stored in a database file (not shown), and a VIE created based on these base tables.
Along with the table definition information of the W table and directory information such as an index (the table definition information and the index are collectively referred to as directory information), the D of the portion related to the table access request in the application program created by the user is included.
The ML object is stored. Version information such as the update date and time is included in the table definition information of these base tables.
In the table definition information of the table, table identification information (table name and the like) of the related base table together with version information such as update date and time are included in each DML.
In the object, in addition to the compile date and time as version information, a program name, an access target table name, and the like are registered as additional information.

[0010] The directory file update control means 1
It supervises the control for updating the directory file 5. When an instruction to update directory information stored in the directory file 5 is issued from the terminal device 6, the update information (information before and after the update) is stored and updated, and the updated base table and VIEW are updated. The table identification information of the table is passed to the related DML object search means 2 to search for the related DML object. Further, the stored update information is passed to the associated DML object regenerating means 3 to execute the analysis, and the results are collected to edit necessary contact information.
Output to

The related DML object search means 2 searches the directory file 5 for additional information of the DML object based on the passed table identification information, and obtains the DML object accessing the updated base table and VIEW table. And notifies the related DML object regeneration means 3. In general, it is not possible to change the table definition information of a base table when a related VIEW table exists, so that a search for a related DML object may be performed separately for the base table and the VIEW table. .

The related DML object regeneration means 3 stores the retrieved DML object in a directory file 5
The directory file update control means 1 checks whether the contents need to be changed or not by comparing the contents with the update information stored by the directory file update control means 1. as a result,
After the change is made, the compile date and time are updated as they are, and the executable DML object consistent with the directory file 5 after updating the table definition information is updated. Regenerate. It should be noted that some of the searched DML objects include, according to the relationship between the access request content and the update content of the table definition information,
(A) The DML object itself does not need to be changed and only the version information needs to be matched, and (b) the same access request can be executed by making necessary changes by replacement or conversion with reference to the update information. In some cases, the same access request contents cannot be realized by (c) replacement or conversion, and the application program needs to be reconstructed. As those belonging to the above (a),
For example, there are addition of data items (columns) in a table, a change in an array associated with the addition, and a modification of an index. Execution is possible only by updating version information, and generally no action is required on the source program side. As an example belonging to (b), there is a change in a table name or a data item name, which can be executed by regenerating the DML object. However, when the application program is recompiled for some reason at a later date, the source program needs to be modified. Required. or,
As an example of (c), there is a deletion of the table itself and the data item, and the access request itself becomes meaningless, so that the DML object is invalidated without updating the version information.

The related DML object storing means 4 stores the DM regenerated by the related DML object regenerating means 3.
The L object is received and replaced with the old DML object before regeneration stored in the directory file 5 and updated.

FIG. 2 is a flowchart showing the flow of the processing in the embodiment of FIG. Hereinafter, the operation of this embodiment will be comprehensively described with reference to FIG.

When an update of the directory file 5 is instructed from the terminal device 6, the directory file update control means 1 stores the instructed update information (step S1).
The directory file 5 is updated according to the contents (step S2), and the related DML object search means 2 is activated. Related DML object search means 2
Searches for additional information of the DML object based on the table identification information passed from the directory file update control means 1, extracts the corresponding DML object, and substitutes the identification information (program name) for the related DML object regeneration means 3 (Step S3). The related DML object regenerating means 3 reads out these DML objects one by one from the directory file 5 and analyzes the contents thereof (step S4), and refers to the update information stored in the directory file update control means 1. Then, it is determined whether or not re-generation is possible (step S5). As a result of the determination, if re-creation is possible, the process proceeds to step S6. If the re-creation is necessary, the version information is updated after the modification is performed, and the executable DML object is re-generated. Next, the related DML object storage means 4 replaces the old DML object and re-stores it in the directory file 5 (step S8).
If unprocessed DML objects remain, step S
4 and the process proceeds to the next DML object (step S9). As a result of the determination in step S5, if the reproduction is not possible, the identification information is reported to the directory file update control means 1 (step S7), and then step S4
To return to the processing of the next DML object. When the processing of all the DML objects is completed, the directory file update control means 1 edits necessary information and outputs it to the terminal device 6 or the printer 7, and the entire processing ends (step 10).

[0016]

As described in detail above, the D of the present invention
In the ML object management method, when the table definition information of the base table and the VIEW table is updated, the related DM
Since L objects can be searched and modified, those that can be modified are updated, version information is updated, and executable DML objects are automatically regenerated and stored again, so that users need to modify or recompile DML objects. Disappears. In addition, since it becomes possible to update table definition information and the like without being aware of DML objects, there is an effect that operability and processing efficiency of the system are improved.

[Brief description of the drawings]

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

FIG. 2 is a flowchart illustrating an operation procedure of the embodiment.

[Explanation of symbols]

 1 directory file update control means 2 related DML object search means 3 related DML object regenerating means 4 related DML object storage means 5 directory file 6 terminal device 7 printer

Claims (1)

(57) [Claims] An unordered set of rows is provided as a table with a minimum unit of data as a column, and a table access related portion in an application program created by a user is stored as a DML object in a directory file together with table definition information and the like. In the DML object management method of the relational database system to be stored in
A related DML object which is activated when an update is made to existing table definition information or the like stored in the directory file and which searches for additional information and extracts a DML object that accesses a base table and a VIEW table to be updated by extracting additional information The search means and the contents of the DML object extracted by the related DML object search means are analyzed, and those which need to be changed are updated by making possible changes with reference to the updated contents such as the table definition information. Related DML object regenerating means for regenerating and executing a suitable DML object, related DML object storing means for storing the DML object regenerated by the related DML object reproducing means in a directory file again, and existing table definition When an update of information etc. is instructed, The temporarily stores the updates associated D
A DML object management system, comprising: a directory file update control unit that controls an ML object search unit, a related DML object regenerating unit, and a related DML object storage unit to collect and edit necessary contact information.