JP3175128B2 - Integrated management system for databases, files and programs - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to the use (definition) of data existing in databases, files and programs (data and programs stored in databases and files) by management information registered in dictionary files. The present invention relates to an integrated management system for databases, files, and programs for performing integrated management of data.

[0002]

2. Description of the Related Art Conventionally, in an integrated management system of this kind of database, file and program, management information registered in a dictionary file includes records (records) for each data existing in the database, file and program. The record name and record attribute information of each data item and the data item name and data 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 management information and the record configuration and data of the data in the managed databases, files and programs are required. It is necessary for a manager (human) or the like (human) to manually maintain consistency with the attribute of the item.

That is, when the management information in the dictionary file is updated, the record configuration of the data and the attributes of the data items in the database, file and program related to the update have been manually updated ( "Update record structure" includes adding or deleting data items.) When the record configuration of data or the attribute of a data item in a certain database, file or program is updated, the management information in the dictionary file and other databases and files related to the update are adjusted to match the update. Also, the record configuration of data and the attributes of data items in the program were manually updated.

The purpose of the above-mentioned "integrated management" is to make it possible to refer to existing data on the basis of management information in a dictionary file when newly creating a database or the like. This is to provide convenience for new creation.

[0006]

In the above-mentioned conventional integrated management system of databases, files and programs, the management information in the dictionary file and the record configuration and the attributes of the data items in the managed databases, files and programs are not described. Since the consistency is obtained manually, the man-hours required to achieve such consistency are enormous. Even if the management information is updated in the dictionary file, the update is immediately performed in the current database, file and program. In addition, the data cannot be automatically reflected, and there is a risk that the consistency may not be obtained due to human error (the consistency cannot be reliably guaranteed).

SUMMARY OF THE INVENTION In view of the foregoing, it is an object of the present invention to automate the updating of record configurations and data item attributes in databases, files and programs based on the updating of management information in a dictionary file, and to manage the management of the dictionary file. Consistency between information and data in databases, files and programs can be reliably ensured, and integrated (unified) management of data in databases, files and programs can be realized accurately and easily. An object of the present invention is to provide an integrated management system for databases, files and programs.

[0008]

[MEANS FOR SOLVING THE PROBLEMS] The database of the present invention,
The integrated management system of files and programs, a tube of the data that exist in the database, files and programs
Record name and record attribute of each record
Information and index information, and the data
A dictionary file that centrally manages data item names, data item attribute information, and index information, and record attribute information and data item attribute information in the management information in the dictionary file.
When a report is updated, the records and data related to the update
The database, file, and program in which the item exists are detected based on the index information in the management information, and the detected database, file, and program are updated.
Record attribute information and data for records and data items
While updating data item attribute information,
Attribute information in files and programs and
When updating the data item attribute information,
Record attribute information in the management information in the dictionary file and
And integrated management means for updating data item attribute information .

[0009]

According to the integrated management system for databases, files and programs of the present invention, dictionary files are used to manage data existing in the databases, files and programs.
Information includes the record name and record attribute information of each record
Information and index information, and the data
Data items, data item attribute information, and index information, and the integrated management means manages the management information in the dictionary file.
Record attribute information and the data item attribute information records and data items associated with the update when updating the in Son
Existing databases, files and programs are detected based on the index information in the management information, and the records related to the detected databases, files and programs are updated.
Attribute information and data items for data and data items
While updating attribute information, databases, files and
Attribute information and data terms in programs and programs
Dictionary file related to the update of eye attribute information
Attribute information and data item attribute in management information
Update gender information .

[0010]

Next, 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, the file and the program according to the present embodiment uses the dictionary file 1
, An integrated management means 2, a database 3 (a data set for storing individual data in a centralized manner), a file 4 (a data set for storing data existing outside the database 3), and a program 5. (A plurality of databases 3, files 4, or programs 5 may exist).

FIGS. 2 to 6 show a database of this embodiment.
FIG. 9 is a diagram for explaining a specific operation of the integrated management method of files and programs.

Next, the operation of the integrated management system for databases, files, and programs of the present embodiment configured as described above will be described.

The dictionary file 1 includes, as management information, the record name, record attribute information and index information of each record, and the record components, for the data existing in all the managed databases 3, files 4, and programs 5. It manages the data item name, data item attribute information (item length and item type (integer type, real number type, etc.), etc.) and index information of each data item. Here, the index information refers to information indicating 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 constituting the record also exists 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 related to the update (the database 3, the file 4, and the The program 5) is detected based on the index information of the record or data item in the management information. Then, the related database 3, file 4, and program 5 are updated to reflect the update. That is, the integrated management means 2 recognizes the position of the record or data item related to the update based on the index information, and updates the record configuration and the attribute of the data item related to the update.

Further, the integrated management means 2 is adapted to update the record configuration or the attribute of the data item in any one 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. In addition, the integrated management means 2 updates the other related databases 3, files 4, and programs 5 by the above-described processing, reflecting this update.

Next, a specific operation of the integrated management system for databases, files and programs according to the present embodiment will be described with reference to FIGS.

First, "name", "address" and "TE"
The operation in the case where 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, data item attribute information, index information, etc. of the data item) relating to the data item "age" to the management information relating to the personnel information record in the dictionary file 1. Addition (see FIGS. 2, 4 and 5).

Next, the integrated management means 2 executes the “age” described above.
Is added to the dictionary file 1, information indicating the addition (information including the data item “age”) is passed to the database 3, the file 4, and the program 5 having the personnel information record. Note that the integrated management means 2 determines which database 3, file 4, and program 5 have the personnel information record.
Is recognized based on the index information of the personnel information record in the management information relating to the personnel information record.

Hereinafter, 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 on the dictionary file 1 and the update on the database 3.

As shown in this figure, the integrated management means 2
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 the index information of the item ("age")
Information indicating that the data item exists in the database 3 is set in the index information).

Here, before the update, the data items "name" and "address" in the personnel information record having data items "name", "address" and "TEL" and the family information record ( The data items "Name", "Wife" and "Child" and the data items "Family Information" and the data items "Name", "Wife" and "Child" When combined as a common data item (key) ("Name",
Consider a new family information record having data items of "wife", "child" and "address" (a record having a record name of "new family information") created in the database 3 (see FIG. 3). ).

In this case, the integrated management means 2 adds the information on the data item “name” to the management information relating to the personnel information record in the dictionary file 1, and stores the information in the database 3 based on the personnel information record. 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 on the dictionary file 1 and the update on 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 relating to the personnel information record in the dictionary file 1. Update the index information for an item.

FIG. 5 is a diagram showing the relationship between the update related to the dictionary file 1 and the update related 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 HR information record 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 relating to the personnel information record in the dictionary file 1. Update the index information for an item.

Second, 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 information indicating the item length, which is one of the data item attribute information relating to the data item "age" in the management information relating to the personnel information record in the dictionary file 1 (FIG. 6).

Next, the integrated management means 2 stores the dictionary file 1
As described above, when the data item attribute information relating to the data item "age" is updated, the information indicating the update is stored in the database 3 where the record (the personnel information record or the like) having the data item "age" exists. 4 and to program 5. In addition, the integrated management means 2
Recognizes which database 3, file 4 and program 5 has the data item "age" based on the index information of the data item "age" in the management information related to the personnel information record. I do.

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

As described above, based on the update of the management information in the dictionary file 1, the update relating to the record or data item in the database 3, the file 4 and the program 5 related to the update (record configuration or data item Attribute updating) can be automatically performed.

The integrated management means 2 has, as an additional function, records and data items related to the update of the management information in the dictionary file 1 (all databases 3, files 4 and related information in the program 5). (Records and data items to be updated) are automatically classified into those that can be automatically updated and those that are not updated. With this function, records and data items that are not desired to be automatically updated can be excluded from the above-described processing.

[0036]

As described above, according to the present invention, when the management information in the dictionary file is provided with the index information, when the management information registered in the dictionary file is updated, all the databases and files related to the update are updated. Updates to programs and programs (updating record configuration and data item attributes) can be performed automatically, ensuring the consistency between management information in dictionary files and data in databases, files and programs Thus, 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 the 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. 1;

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

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

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

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

[Explanation of symbols]

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

──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-3-278250 (JP, A) JP-A-3-48342 (JP, A) JP-A-62-1151925 (JP, A) JP-A-3-151 116228 (JP, A) JP-A-1-140333 (JP, A) "FUJITSU" Vol. 41, No. 5 (1990-9) p. 410-411 "OS IV IV Second Edition for CAPE User's Guide V11" (1990-10-31) P. 240-241 (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 9/06

Claims (1)

(57) [Claims] 1. A record of each record as management information of data existing in a database, a file, and a program.
Code name, record attribute information and index information, and record
Data item names and data item attribute information
Information and index information, and record attribute information and management information in the management information in this dictionary file .
And update of data item attribute information
Databases, files, and programs in which records and data items exist are detected based on the index information in the management information, and records and records of records and data items related to the update of the detected databases, files, and programs are detected.
Update the attribute information and data item attribute information
In databases, files and programs
When updating record attribute information and data item attribute information
In the management information in the dictionary file related to the update,
An integrated management system for a database, a file, and a program, comprising: integrated management means for updating record attribute information and data item attribute information .