JPH05241800A - Total control system for data base, file, and program - Google Patents

Abstract

PURPOSE:To securely guarantee the consistency between control information in a dictionary file and data present in the data base, file, and program by automating the update of the data base, file, and program based upon the update of the control information in the dictionary file. CONSTITUTION:The dictionary file 1 performs centralized control over the data in the data base 3, file 4, and program 5 according to the control information having index information. A total control means 2 detects the data base 3, file 4, and program 5 relating the update of the control information in the dictionary file according to the index information in the control information when the control information is updated, and updates the detected data base 3, file 4, and program 4 so that the update of the control information is reflected.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to data existing in a database, a file and a program (used (defined) in the data and the program stored in the database and the file) according to management information registered in a dictionary file. Data management system for integrated management of databases, files and programs.

[0002]

2. Description of the Related Art Conventionally, in this kind of integrated management system for databases, files and programs, the management information registered in the dictionary file contains records (data The record name and record attribute information (which is composed of one or more data items) and the data item name and data item attribute information of each data item are managed.

Here, in order to realize the integrated management of all databases, files and programs by such management information, the record configuration and data of the data in the management information and management target databases, files and programs It was necessary for an administrator (human) to manually match the attributes of the items.

That is, when the management information in the dictionary file is updated, the record structure of data and the attributes of data items in the databases, files and programs related to the update are manually updated ( "Update record structure" includes addition and deletion of data items). When the record structure of data or the attribute of a data item in a database, file or program is updated, the management information in the dictionary file and other databases and files related to the update are matched so as to match the update. Also, the record structure of data and the attributes of data items in the program were manually updated.

The purpose of "integrated management" as described above is to allow existing data to be quoted based on the management information in the dictionary file when a new database or the like is created. It is to provide a flight for new creation.

[0006]

In the above-described conventional integrated management system for databases, files and programs, the management information in the dictionary file and the record structure and data item attributes in the managed databases, files and programs are described. Since the consistency is maintained by hand, the number of man-hours for achieving such consistency is great, and even if the management information is updated in the dictionary file, the update will be immediately performed on the current database, file and program. In addition, there is a drawback in that it cannot be reflected automatically and there is a risk that consistency will not be achieved due to human error (the consistency cannot be reliably guaranteed).

In view of the above points, an object of the present invention is to automate the update of record structures and data item attributes in databases, files and programs based on the update of management information in dictionary files, and to manage the dictionary files. The consistency between information and data existing in databases, files and programs can be assured reliably, and integrated (centralized) management of data existing in databases, files and programs can be realized accurately and easily. It is to provide an integrated management method for databases, files, and programs.

[0008]

A database according to the present invention,
The integrated management method for files and programs is a dictionary file that centrally manages data existing in databases, files, and programs based on management information having index information, and updates the management information in this dictionary file when updating the management information. It has an integrated management means for detecting related databases, files and programs based on index information in the management information and updating the detected databases, files and programs by reflecting the update of the management information.

[0009]

In the database, file and program integrated management system of the present invention, the dictionary file centrally manages the data existing in the database, file and program based on the management information having index information, and the integrated management means creates a dictionary. When the management information in the file is updated, the database, file, and program related to the update are detected based on the index information in the management information, and the detected database, file, and program are updated to reflect the update of the management information.

[0010]

The present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of an integrated management system for databases, files and programs according to the present invention. The integrated management method of the database, files and programs of this embodiment is the dictionary file 1
And an integrated management unit 2, a database 3 (a data set for collectively storing individual data), a file 4 (a data set for storing data existing other than the database 3), and a program 5. (There may be multiple databases 3, files 4 or programs 5).

2 to 6 show the database of this embodiment,
It is a figure for demonstrating the concrete operation | movement of the integrated management system of a file and a program.

Next, the operation of the database, file and program integrated management system of this embodiment having the above-described configuration will be described.

The dictionary file 1 includes, as management information, the record name of each record, the record attribute information, and the index information for the data existing in all the databases 3, files 4 and programs 5 to be managed, and the constituent elements of the record. It manages the data item name, data item attribute information (item length and item type (integer type, real number type, etc.)) and index information of each data item. Here, the index information refers to information indicating at which position in which database 3, file 4 and program 5 the record or data item exists. Here, it is assumed that one piece of management information exists for each record (the index information of the data items that make up the record, etc. also exist in the management information for that record).

When the management information in the dictionary file 1 is updated, the integrated management means 2 updates the database 3, the file 4 and the program 5 (the database 3, the file 4 having the record or the data item related to the update, and the program 5). The program 5) is detected based on the index information of the record or data item in the management information. Then, the relevant database 3, file 4 and program 5 are updated to reflect the update. That is, the integrated management unit 2 recognizes the position of the record or the data item related to the update by the index information, and updates the record structure and the attribute of the data item related to the update.

In addition, the integrated management means 2 updates the record structure or the attribute of the data item in any of the database 3, the file 4 and the program 5,
The management information in the dictionary file 1 is updated by reflecting the update so as to have consistency with the update. The integrated management means 2 reflects this update and updates the other related databases 3, files 4 and programs 5 by the processing described above.

Next, with reference to FIGS. 2 to 6, a concrete operation of the integrated management system for the database, files and programs of this embodiment will be described.

First, "name", "address" and "TE"
The operation when the data item “age” is added to the personnel information record having the data item “L” (the record having the record name “personnel information”) will be described.

The integrated management means 2 adds information (data item name of the data item, data item attribute information, index information, etc.) about the data item "age" to the management information related to the personnel information record in the dictionary file 1. In addition (see FIGS. 2, 4 and 5).

Next, the integrated management means 2 uses the above "age".
Information related to the data item is added to the dictionary file 1, the information indicating the addition (information including the data item "age") is passed to the database 3, the file 4 having the personnel information record and the program 5. In addition, the integrated management means 2 "in which database 3, file 4 and program 5 the personnel information record exists"
Is recognized based on the index information of the personnel information record in the management information related to the personnel information record.

In the following, the processing after the information indicating the addition of the data item including the data item "age" is passed to the database 3, the file 4 and the program 5 will be described.
This will be described in detail with reference to FIGS.

FIG. 2 is a diagram showing the relationship between the update relating to the dictionary file 1 and the update relating to the database 3.

As shown in this figure, the integrated management means 2 is
The data item "age" is passed to the personnel information record in the database 3, and the data item "age" is automatically added to the personnel information record. Further, the integrated management means 2 reflects the addition of the data item "age" in the personnel information record in the database 3 to reflect the data "age" in the management information related to the personnel information record in the dictionary file 1. Update item index information ("age")
The information indicating that the data item is present in the database 3 is set in the index information).

Before the above update, the data items "name" and "address" in the personnel information record having the data items "name", "address" and "TEL" and the family information record ( The data items "name", "wife" and "child" and the record name "family information" in the data item "name", "wife" and "child" are "name". When combined as a common data item (key) (“Name”,
Consider a case where a new family information record having data items "wife", "child" and "address" (a record having a record name "new family information") is created in the database 3 (see FIG. 3). ).

In this case, when the integrated management means 2 adds the information about the data item "name" to the management information related to the personnel information record in the dictionary file 1, the database 3 based on the personnel information record is added. The data item "age" is passed to the new family information record, and the data item "age" is automatically added to the new family information record in the database 3 (see FIG. 3).

FIG. 4 is a diagram showing the relationship between the update relating to the dictionary file 1 and the update relating to the file 4.

As shown in this figure, the integrated management means 2
The data item "age" is passed to the personnel information record in the file 4, and the data item "age" is automatically added to the personnel information record. Further, the integrated management means 2 reflects the addition of the data item “age” in the personnel information record in the file 4 to reflect the data “age” in the management information related to the personnel information record in the dictionary file 1. Update item index information.

FIG. 5 is a diagram showing the relationship between the update relating to the dictionary file 1 and the update relating to the program 5.

As shown in this figure, the integrated management means 2
Program 5 that uses (defines) personnel information records
The data item "age" is passed to the personnel information record in the item, and the data item "age" is automatically added to the personnel information record. Further, the integrated management means 2 reflects the addition of the data item "age" in the personnel information record in the program 5 to reflect the data "age" in the management information related to the personnel information record in the dictionary file 1. Update item index information.

Secondly, the operation when the item length of the data item "age" in the personnel information record (the personnel information record to which the data item "age" is added) is changed will be described.

The integrated management means 2 updates the information indicating the item length which is one of the data item attribute information relating to the data item "age" in the management information related to the personnel information record in the dictionary file 1 (Fig. 6).

Next, the integrated management means 2 uses the dictionary file 1
When the data item attribute information relating to the data item "age" is updated as described above, the database 3 and the file in which there is a record (personnel information record etc.) having the data item "age" for the information indicating the update 4 and program 5. The integrated management means 2
Recognizes "in which database 3, file 4 and program 5 the data item" age "exists" based on the index information of the data item "age" in the management information related to the personnel information record. To do.

That is, as shown in FIG. 6, the integrated management means 2 stores the information indicating the change of the item length in the database 3, the file 4 and the program 5 (the database 3 in FIG. 6).
), The item length of the data item “age” in the personnel information records and the like existing in the database 3, file 4 and program 5 is automatically changed.

As described above, based on the update of the management information in the dictionary file 1, the update of records and data items in the database 3, file 4 and program 5 related to the update (record structure and data item All the attributes can be updated automatically.

The integrated management means 2 has an additional function of updating the management information in the dictionary file 1 such as records and data items (related to all the databases 3, files 4 and programs 5) related to the update. Each record (data item or data item) to be updated is provided with a function of automatically selecting a record that can be updated and a record that is left without updating. With this function, it is possible to exclude records and data items that are not desired to be automatically updated from the above-mentioned processing targets.

[0036]

As described above, according to the present invention, by providing index information to the management information in the dictionary file, all the databases and files related to the update when the management information registered in the dictionary file is updated. And updates to programs (updates of record structure and data item attributes) can be performed automatically, and the consistency between the management information in the dictionary file and the data existing in the database, files and programs is guaranteed. Therefore, there is an effect that integrated management of data existing in a database, a file and a program can be realized accurately and easily.

[Brief description of drawings]

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

FIG. 2 is a diagram for explaining a specific operation of the integrated management system for databases, files, and programs shown in FIG.

FIG. 3 is a diagram for explaining a specific operation of the integrated management system for databases, files, and programs shown in FIG.

FIG. 4 is a diagram for explaining a specific operation of the integrated management system for the database, files, and programs shown in FIG.

FIG. 5 is a diagram for explaining a specific operation of the integrated management system for the database, files, and programs shown in FIG.

FIG. 6 is a diagram for explaining a specific operation of the integrated management system for the database, files and programs shown in FIG.

[Explanation of symbols]

 1 dictionary file 2 integrated management means 3 database 4 file 5 program

Claims (1)

[Claims] 1. A dictionary file for centrally managing data existing in databases, files and programs based on management information having index information, and a database related to the update when the management information in the dictionary file is updated, A database, a file, and a program, which have integrated management means for detecting a file and a program based on index information in the management information and updating the detected database, file, and program by reflecting the update of the management information. Integrated management method.