JPH04245549A - Dynamically customized data transfer system between dictionary/dictionary - Google Patents

Abstract

PURPOSE:To attain the transfer of a dictionary data (DD) between the customized data dictionaries/dictionaries (DD/D) by checking the scheme data on the DD/D that can be dynamically customized. CONSTITUTION:The schema data, i.e., the defining information on a DD/D 1 is held by a schema intermediate data holding part 21 together with the DD held by a dictionary intermediate data holding part 22 respectively. A schema data output means 41 outputs the schema data received from a schema data holding part 11 to the part 21. A DD output means 42 outputs the DD to the part 22 from a DD holding part 12. A DD input means 43 transfers and inputs the DD to a DD holding part 32 from the part 22. A schema data check means 44 checks the schema data when the DD is inputted through the means 43 and decides whether the transfer of the DD is possible or not.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data dictionary/dictionary system transfer method that can be dynamically customized in a database or the like.

0002

2. Description of the Related Art A database is a collection of mutually related data that can be processed by a plurality of applications without duplication. In particular, an information storage file for centrally managing operational environment information of an online database system is called a data dictionary/dictionary (hereinafter referred to as DD).
/D) It is called a system.

[0003] The DD/D information includes the operating environment of the system, the structure of the database, the online environment, the operating environment of the application program, etc. A database is defined as a logical structure, storage structure, or physical structure, and is registered as a schema in the DD/D.

[0004] Since the system provider provides standard information to users, and the schema, which is the structure definition of the dictionary, is changed for each user, dynamic customization between DD/D in the database is possible. Transfer of dictionary data was not possible.

[0005]

[Object of the Invention] An object of the present invention is to provide a transfer method that enables the transfer of dictionary data between customized DD/Ds by checking the schema data of the DD/Ds that can be dynamically customized. It's about doing.

[0006]

[Structure of the Invention] A DD/D transfer system according to the present invention has a dictionary data holding unit that holds information resource data, and a schema data holding unit that holds schema data that is definition information of a data dictionary/dictionary. a dictionary/dictionary means, a schema intermediate data holding section for temporarily storing schema data and a dictionary intermediate data holding section for temporarily storing dictionary data when transferring the data dictionary/dictionary; data dictionary/
The method is characterized in that it includes schema data output means for outputting dictionary data from the dictionary means to intermediate file means, and dictionary data output means for outputting dictionary data from the data dictionary/dictionary means to intermediate file means.

Another DD/D transfer system according to the present invention includes a dictionary data holding unit that holds information resource data to be transferred, and a schema data holding unit that holds schema data that is definition information of the data dictionary/dictionary. a data dictionary/dictionary means having a data dictionary/dictionary means; a data dictionary/dictionary data input means for transferring dictionary data from an intermediate file to the dictionary/dictionary; and a dictionary data input means for checking schema data when inputting dictionary data with the dictionary data input means; The method is characterized by including a schema data check means for checking whether data can be transferred.

[0008]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of the present invention will be described in detail with reference to the drawings.

Referring to FIG. 1, one embodiment of the present invention includes:
DD/D1, DD/D is a type of database that stores dictionary data and is constructed using a relational expression method.
Intermediate file 2 that temporarily holds dictionary data and schema data during migration, DD/D3 that transfers dictionary data from DD/D1, and transfer processing unit 4
including. DD/D1 includes a schema data holding section 11 and a dictionary data holding section 12.

FIG. 2 shows schema data and dictionary data of DD/D1 whose entity type is "table". Here, each of the "table name", "item", "definer", and "definition date" is an attribute of the entity type "table". Information indicating what kind of dictionary data the DD/D1 has is called schema data. This schema data is held in the schema data holding unit 11 shown in FIG.

[0011] "Personnel table A", "employee number", "name", "height", "weight", "gender", "X" shown in FIG.
, and data actually stored such as "90/01/01" is dictionary data. This dictionary data is held in the dictionary data holding unit 12 shown in FIG.

FIG. 3 shows an example of the structure of the dictionary data "Personnel A" in FIG. 2. Referring again to FIG. 1, the intermediate file 2 includes a schema intermediate data holding section 21 and a dictionary intermediate data holding section 22.

The schema intermediate data holding unit 21 temporarily stores schema data during transfer, and the dictionary intermediate data holding unit 22 temporarily stores dictionary data during transfer. The transfer DD/D3 includes a schema data holding section 31 and a dictionary data holding section 32.

FIG. 4 shows schema data and dictionary data of which the entity type of the transfer DD/D3 is "table". Here, "table name", "item", "
"Definer" and "Update date" are attributes of the entity type "Table". Information indicating whether the transfer DD/D3 has dictionary data such as and is called schema data.

The schema data section 11 shown in FIG. 1 stores these schema data. “
"Personnel table A", "Employee number", "Name", "Height", "Weight", "Gender", "X", "90/10/01" etc. are called dictionary data actually stored. The data is stored in the dictionary data holding unit 12 shown in FIG.
is held in These dictionary data differ in schema data from the DD/D1 that stores them, and have no "definition date" but an "update date."

Referring again to FIG. 1, the transfer processing unit 4
It includes schema data output means 41, dictionary data output means 42, dictionary data input means 43, and schema data check means 44.

The schema data output means 41 outputs schema data from the DD/D 1 to the schema intermediate data holding section 21 of the intermediate file 2 . The dictionary data output means 42 outputs the dictionary data from the DD/D1 to the dictionary intermediate data holding section 22 of the intermediate file 2. The dictionary data input means 43 outputs the dictionary data from the DD/D 1 to the dictionary data holding section 22 of the intermediate file 2 . The schema data checking means 44 DD/D the dictionary data.
1 Intermediate file 2 dictionary intermediate data holding unit 2
2, the schema data from the schema intermediate data holding portion 21 and the schema data from the schema data holding unit 31 are checked, and the schema data from the schema data holding unit 3 is output to the schema data holding unit 3.
The dictionary data is held in the dictionary data holding unit 31 according to the schema data from 1.

Next, the operation of one embodiment of the present invention will be explained in detail. An example of transferring dictionary data from the DD/D1 to the transfer DD/D3 will be explained.

First, schema data is output. The detailed data is as follows. The schema data output means 41 outputs "table name" and "item" which are schema data of DD/D1 given from the schema data holding unit 11.
, "definer" and "definition date" are transferred to and held in the schema intermediate data holding portion 21 of the intermediate file 2.

Next, the output of dictionary data will be explained in detail. Dictionary data output means 42
is the dictionary data “Personnel table A”, “Employee number”, “Name”, “
Weight”, “Gender”, “X” and “90/01/01”
Dictionary intermediate data holding unit 2 of intermediate file 2
Transfer to 2 and hold.

Furthermore, checking of schema data and inputting dictionary data will be explained in detail. The schema checking means 44 compares and checks the schema data of the DD/D1 from the schema intermediate data holding unit 21 of the intermediate file 2 and the schema data from the schema data holding unit 31 of the transferred DD/D3.

[0022] The schema data of DD/D1 is "table name",
"Item", "Definer", and "Definition date", and the schema data of transfer DD/D3 is "Table name", "Item", "Definition date".
"Definer" and "Updated date." Transfer DD/D3 does not have a "definition date" but has an "update date".

Therefore, the dictionary data input means 4
3 is dictionary data “Personnel table A”, “Employee number”
, "Name", "Weight", "Gender", and "X" are transferred to the dictionary data holding unit 32 of the transfer DD/D3 and held therein. The dictionary data corresponding to the schema data "update date" is given a NULL value.

[0024]

[Effect of the invention] The present invention provides a dynamically customizable DD.
/D, by enabling the transfer of dictionary data between DDs and Ds, the first step is to physically save dictionary data in case of a failure, the second is to migrate from the test system to the production system, and the third is to save the schema. When transferring dictionary data to another system with different data, there is an effect that dictionary data can be freely transferred between DD/Ds customized for each user.

[Brief explanation of the drawing]

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

FIG. 2 is a diagram showing dictionary data, which is schema data, in which the entity type of DD/D1 in FIG. 1 is "table."

FIG. 3 is a diagram showing a configuration example of the dictionary data “personnel table A” in FIG. 2;

[Figure 4] Entity type of transfer DD/D3 is “table”
FIG. 2 is a diagram showing schema data and dictionary data.

[Explanation of symbols]

1 DD/D 2 Intermediate file 3 Transfer DD/D 4 Transfer processing section 11 Schema data holding section 12 Dictionary data holding section 21 Schema intermediate data holding section 22 Dictionary intermediate data holding section 31 Schema data holding section 32 Dictionary data holding section 41 Schema Data output means 42 Dictionary data output means 43 Dictionary data input means 44 Schema data check means

Claims (2)

[Claims] 1. A data dictionary/dictionary means having a dictionary data holding section that holds information resource data, and a schema data holding section that holds schema data that is definition information of the data dictionary/dictionary; At the time of transfer, an intermediate file means having a schema intermediate data holding section for temporarily storing schema data and a dictionary intermediate data holding section for temporarily storing dictionary data; and schema data is transferred from the data dictionary/dictionary means to the intermediate file means. 1. A dynamically customizable data dictionary/dictionary system transfer system, comprising: schema data output means for outputting; and dictionary data output means for outputting dictionary data from the data dictionary/dictionary means to intermediate file means. [Claim 2] A dictionary data holding unit that holds information resource data to be transferred, and a data dictionary/
a data dictionary/dictionary means having a schema data holding unit that holds schema data that is dictionary definition information; a data dictionary/dictionary means that transfers dictionary data from an intermediate file to the data dictionary/dictionary; A dynamically customizable data dictionary/transfer dictionary system comprising: a schema data check means for checking schema data when inputting dictionary data with a dictionary data input means and checking whether the dictionary data can be transferred; system.