JPS62254246A - Control system for data base having data dictionary directory - Google Patents

Abstract

PURPOSE:To facilitate the change of a metadirectory (MD) by producing the MD by referring to a dictionary (DIC) that defines the structure of the DIC itself. CONSTITUTION:An operation command defining information 502 is used as the input to start a definition operating program 503. An MD 508 is loaded from a directory data set DDS 505 and an access is given to a DIC set 504 for production of a directory. This directory is stored in the DDS 505. When a meta MDIC is produced, an MDIC structure definition sentence 507 is stored in the set 504. Based on the sentence 507, an MDIC directory 509 is produced and stored in the DDS 505. The directory 509 is used for allocation of an MDIC data set 506. When the MD is produced, the program 503 is started with input of a control sentence 501 and the information 502. Then the directory 509 is loaded from the DDS and accessed to the MDIC and the MD 508 is produced and stored in the DDS 505.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to changing the structure of a data dictionary in a data dictionary/directory system using a structured database, and particularly to data suitable for updating the data dictionary structure. This invention relates to an update method for a dictionary structure.

[Conventional technology]

In the data dictionary directory system of structured databases, the structure control information of the dictionary, which defines the structure of the dictionary itself and determines the physical storage area of the corresponding records, is set in the dataset. This is called a metadirectory.

In this metadirectory, the structure of the dictionary itself and the metadirectory must match, and in order to prevent a mismatch between the two, a protection function is provided to prohibit rewriting only the metadirectory. Common.

Therefore, in the conventional technology, if it is necessary to change the structure of the dictionary itself, it is necessary to create a metadirectory separately by hand or with a similar dedicated tool, and this generated metadirectory can be changed. Then, it was necessary to define a new dictionary structure and update the dictionary with the new structure by updating the metadirectory.

The concepts of dictionaries and metadirectories are introduced in Data Dictionary 1/Directory System, Ohmsha (1986, Belkis,
(Co-authored by Davlier, Leonhon, Pernat, K., and Pragman, translated by Ryosuke Hotaka, translated by Mitsuaki Narita), pages 63 to 76.
Page (Data 1) ictionary /L)ira
ctory Systems Bglkiz W, L
aony-Hang and Bernard K, P
lα! IrILan 1982 by John Wi
lay & bone.

Inc.), but there is no mention of a method for easily generating a metadirectory and updating the structure of the dictionary itself.

[Problem that the invention seeks to solve]

Traditionally, it was necessary to newly define the structure of the metadirectory by hand or using specialized tools, etc., and changes to the metadirectory database structure required modifications to both the definition statement and the tool. It was not easy to do because it was necessary.

An object of the present invention is to generate and manipulate the definition information of the structure of the database registered in the dictionary into a directory, so that the structure of the dictionary itself can be modified with the same ease as adding and changing the logical structure of the database. The purpose of this invention is to provide a dictionary structure update method that improves the operability and maintainability of dictionary structure updates.

[Means for solving problems]

The above purpose is to register the definition information of the structure of the dictionary itself in the dictionary in the same way as registering the definition information of the logical structure of a general database.

A directory is generated by referring to the dictionary that defines the structure of this dictionary itself (this is called a meta-dictionary directory).

Furthermore, the structure of the dictionary is regarded as the logical structure of the database, and the structure of the dictionary is defined, which is called a meta-dictionary3). Next, a directory is generated by referring to the meta-dictionary [this is called a meta-directory]. ), this is achieved by manipulating this metadirectory to update the structure of the dictionary.

[Effect]

The dictionary structure update method of the present invention is a definition operation program that refers to a data dictionary that describes definition information that defines the structure of a database, and converts it into a table-format directory that makes it easier for users to use the database. , register the definition information of the structure of the dictionary itself in the dictionary, and generate a directory from the dictionary in which the definition information of the structure of the dictionary itself was registered (generate a directory for the meta dictionary). Assign this to a dataset, define the structure of the dictionary itself in the dataset, and generate a metadictionary).
The structure of the dictionary can be easily updated by performing operations such as creating a directory from this meta dictionary 1) using a definition operation program and making changes to this meta dictionary.

〔Example〕

An embodiment of the present invention will be described below with reference to FIGS. 1 to 8.

FIG. 1 shows a hardware configuration for realizing the present invention.

Reference numeral 1 denotes a processor, which performs processing of searching for necessary information. 2 is a definition information storage memory for storing definition information; 3 is a dictionary file storage memory for storing a dictionary.

Reference numeral 4 denotes a meta dictionary file storage memory for storing a meta dictionary entry; 5 a directory file storage memory for storing directories; and 6 a definition operation program storage for storing a definition operation program that realizes the present invention. memory.

7 indicates a work area in which searched information is stored.

In this system, the dictionary in the dictionary file storage memory 3 determines the structure of the entire database, and the directory in the directory file storage memory 5 is a dictionary converted into a structure that is easy for the user to use.

The present invention targets a structural database, and its basis is a network data model.

In particular, it is a left system that has this structure.

A network data model is a one-level data structure in which there is a relationship between branched fields of logical records, and the only way to identify fields in a logical record and find out where they are is by determining their relative positions. This can be done by knowledge, by indicators included in records, and by pointers and lists. Next, access to dictionary registration will be explained.

FIG. 7 shows an example of the structure of a dictionary that determines the logical structure of the database. Definition information is registered by writing the name 9 number, information, etc. in this dictionary f9. After this, a dictionary is generated.

An example is shown in which access to register definition information regarding the structure of the database in the dictionary is performed by the definition operation program.

The user of the data dictionary/directory provides the definition operation program with operation commands and definition information as illustrated in the first example.

To register definition information in the dictionary, for example, use ENTR,
Using the Y operation command, specify * ENTRY DICTIONAR, Y entry member type, definition information.

Here, what is dictionary member type?

This is a symbol specified to identify the definition unit when the definition information registered in the dictionary is divided into several definition units. Also, what is "definition information"?

This is a definition source that is registered in a dictionary.

FIG. 8 shows an example of a directory generated in table format by referring to the dictionary. Also.

A method for creating a directory may be based on a definition operation program. For example, using the ENTRY manipulation command.

*gNTf (, Y DIRECTO) Specify IJ member type〉definition information name〉.

Here, the directory member type is an identification symbol of the directory table to be generated.

In more detail, the IJ generation process will be explained based on the flowchart of FIG.

When a directory generation request is made, the dictionary member with the name for which the generation request has been requested is first searched from among the dictionary entries. Set member information (202). Next, based on this dictionary member, a search is made for a related dictionary member necessary for directory generation (203), and if a related dictionary member exists (204), a directory generation request is entered in the dictionary member table for directory generation. Set member information. If the process is performed for the number of related members and the related Dixie member no longer exists (2
0a) Search the already created directories to see if a directory member with the name requested for creation exists, and if it does not exist (203)
, stores the directory generation dictionary member table in the dictionary (1908), and further stores the directory generation dictionary member table in the directory (1909).

If a directory member with the name requested for generation exists (203).

Search the directory generation dictionary member table stored in the directory (20t3).

It is checked whether the contents are the same as the directory generation dictionary member table created in step 202. If it is found that they are the same (207), an IJ member with the same content will be created in accordance with the generation request, and the directory generation process will be terminated.

If the contents of the two tables are different (207), store the dictionary member table for directory generation created in the process of 202 in the dictionary < 208
) with.

A similar table is also stored in the directory (209).

As a result, the dictionary and the directory can have history information at the time of directory creation, and when creating a directory, it is also possible to prevent the creation of members with the same content.

Next, the processing contents of the definition operation program when a metadirectory is generated using the definition operation program in the same manner as the method used to generate a directory from a dictionary will be explained with reference to the flowchart of FIG.

When the definition operation program is given a control statement at startup (101), it analyzes the control statement (102'').

In the control statement, it is determined whether the name of the meta dictionary is specified (103). If the name of the meta-dictionary is specified, a meta-dictionary file is assigned as a dictionary in this program since the meta-dictionary was previously generated when the meta-directory was generated (103).

If no control statement is specified or if no meta dictionary is specified, a dictionary file is assigned as the target dictionary for this program (1
04). The process up to now involves identifying a dictionary and allocating it to a file in order to generate a meta-dictionary from the dictionary using a definition operation program.

Describe meta dictionary generation after file allocation.

Definition information is input from the definition information storage memory 2 for each operation command and stored in the work area (1o6).

If no operation command is input (107), the process ends. When an operation command is input, it is analyzed (clos), and if it is an operation command that instructs dictionary registration (109).

Performed dictionary registration process (110) fl
k.

Operation command manual (106) Return to previous page. If it is an operation command that instructs directory generation (111).

Directory generation processing is performed (112).

An example of a control statement is shown below.The name of the logical schema that defines the logical structure of the meta dictionary is
al, the name of the logical schema that defines the logical structure of the dictionary is DICal, and when registering the definition statement of the dictionary in the meta-dictionary, the definition is written as follows.

*0PTION SCMID METADICa1*
ENTRY DICTIONAR, YSCL (HMA
DIC f(, BCORD R, ECA ITEM COMPAL CHARACTER (8) In other words, a definition statement that defines the structure of the dictionary itself is registered in the dictionary as definition information regarding the structure of a general database.

The information defining the structure of the dictionary is information regarding which data set and in which area the logical schema and record name are stored.

It is also possible to specify a new storage area in this structure definition information. This makes it possible to change the structure of the dictionary from the stage of registering definition information of the dictionary structure in the dictionary. Generate a directory using the structure definition information registered in the dictionary. This directory has a table type that is easy for users to use, and is called the metadictionary directory. To create this metadictionary directory to create a general user database, use the same method as assigning records to datasets.
Allocate records to the dataset, write out and register the dictionary structure definition information, and create a metadictionary.

When creating a general directory, the definition operation program is started with the definition statement shown in FIG. 4 as input. Furthermore, based on this meta-dictionary.

A directory is generated using a definition operation program in the same way as the directory was generated from the dictionary described above.

This definition operation program uses a directory generation method to generate a metadirectory, targeting a metadictionary instead of a dictionary. Here, the directory generated from the meta dictionary is a meta directory. The metadirectory is a table type that is easy for users to use, and the meta dictionary is generated based on the structure definition of the dictionary and converted to a table type, so the logical structure of the dictionary is defined, This is control information that determines the physical storage area of the corresponding record.

The reason why we created the directory twice: the metadictionary directory and the metadirectory, is because the metadictionary directory is generated while referring to the dictionary, so the process of changing and updating the metadictionary directory is necessary. cannot use the meta-dictionary directory because a protection function is activated to prevent a mismatch between the structure of the dictionary and the directory in which that structure is defined in table format. Therefore, a meta-dictionary separate from the dictionary
The structure of one dictionary can be updated by generating a metadirectory, which is a directory of this metadictionary, and performing an update operation on this metadirectory.

In this embodiment, a case is shown in which the same structure as the dictionary structure is registered in the dictionary and processed.

The definition statement to be specified is the same as the dictionary structure definition statement shown in Figure 3, and the database name (401)
Use only the modified version. That is, create another database with the same structure as the dictionary.

When creating a directory using the meta dictionary, a definition operation program is started with a definition statement in the format shown in FIG. 5 as input, and the directory is created.

The specified definition statement uses a control statement specifying the database name (501) used as a dictionary and a database definition statement. When creating a metadirectory, specify the dictionary database name as the schema name (3O2), and use the following definition statement that defines the structure of the dictionary.

FIG. 5 shows files used by the definition operation program. When generating a general directory, when the definition operation program (503) is started with the operation command and definition information C502) as input, a metadirectory (508) is created from the directory data set (503).
is loaded, accesses the dictionary data set (504), generates a directory, and stores it in the directory data set (503).

When generating a meta-dictionary, store a meta-dictionary structure definition statement (507) in a dictionaries data set (504), generate a meta-dictionary directory (509) based on the definition statement, and create a directory data set. (503). Using this meta-dictionary directory (509), a meta-dictionary data set (506) is allocated. Next, when creating a metadirectory, use the control statement (5
01), an operation command, and definition information (502) to start the definition operation program (SOS), it loads the meta dictionary directory (509) from the directory data set (505) and accesses the meta dictionary. , generate a metadirectory (508), and create a directory dataset (
503).

In the above example, we explained that the structure of the dictionary is registered in the dictionary as is, a metadirectory is generated, and the structure of the directory is updated by adding and changing the metadirectory. However, the structure of the dictionary is defined in the dictionary. It is also possible to change the structure at the stage of creating the meta dictionary, or to change the structure of the dictionary at the stage of allocating datasets and writing structure definition information based on the meta dictionary directory, that is, at the stage of generating the meta dictionary. Change the structure and generate it.

It is also possible to update the structure of the dictionary.

According to the present invention, by using two libraries, a dictionary and a metadictionary, a metadirectory can be easily generated with one program.

This meta dictionary, once created, does not need to be recreated each time a meta directory is generated, making it easier to chain up dictionaries.

〔Effect of the invention〕

According to the present invention, when it becomes necessary to regenerate a metadirectory such as adding management information to a dictionary or changing the storage structure, it is possible to allocate a metadictionary file and create a job without using a special program. By changing the control statements, changing the definition operation program control statements, and modifying the dictionary definition statements, you can generate a metadirectory with the same ease as manipulating user-defined information, which is effective in improving operability and maintainability. There is.

[Brief explanation of drawings]

Figure 1 is a hardware configuration diagram of an embodiment of the present invention, Figure 2 is a hardware configuration diagram of an embodiment of the present invention.
The figure shows an example of the overall processing overview of the definition operation program.
Figure 5 is an example of a definition for registering a dictionary structure definition statement in a meta dictionary and generating a metadirectory. Figure 4 is an example of a definition for registering a user database definition in a dictionary and generating a directory. Figure 5 6 is a flowchart of directory generation processing, FIG. 7 is a dictionary, and FIG. 8 is a directory. 1... Processor, 2... Definition information storage memory, 3
... Dictionary file storage memory, 4... Meta dictionary file storage memory, 5... Directory file storage memory, 6... Definition operation program storage memory, 7... Work area, 501... Control statement , 502... definition information/operation command, 5o5.
...Definition operation program, 5o4...Dictionary data set, 505...Directory data set, 506...Meta dictionary data set, 50
7...Meta dictionary, 508...Meta directory, 509...Meta dictionary directory, 510...Dictionary dictionary.

Claims (3)

[Claims] (1) a data dictionary that stores definition information that defines the logical structure of a structural database; a directory in which all or part of the definition information is converted into a table format that is referred to for accessing the database; In a database system having a metadirectory that is referred to in order to access a data dictionary, writing dictionary definition information, which is definition information indicating the structure of the data dictionary itself, into the data dictionary, converting the dictionary definition information, and converting the dictionary definition information into a first generate a directory, write the dictionary definition information to one database that is accessed based on the generated first directory, convert the dictionary definition information written to the one database, and write the dictionary definition information to one database that is accessed based on the generated first directory. A control method for a database having a data dictionary/directory, which is characterized by generating a data dictionary/directory. (2) The database further includes a generation means for generating the directory from the data dictionary, and the conversion is performed on the directory definition information stored in the one database by the generation means. A control method for a database having a data dictionary/directory as described in item 1. (3) In the process of converting the dictionary definition information and generating the metadirectory, convert the dictionary definition information to obtain a table in the directory format, and generate an updated metadirectory by making changes to the table. A control method for a database having a data dictionary/directory as claimed in claim 1.