JP3339408B2 - Data conversion device and data conversion method of data conversion device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data conversion device and a data conversion method for the data conversion device, and more particularly to a data conversion device for converting an arbitrary database structure into a structure of a programming language, and a data conversion method for the data conversion device. About.

[0002]

2. Description of the Related Art Conventionally, as this kind of data conversion device,
One disclosed in Japanese Patent Application Laid-Open No. 5-274112 is known. The invention disclosed in the gazette, between systems of different architectures, using a predetermined conversion parameter a record consisting of a plurality of data fields configured according to a predetermined rule described based on a predetermined architecture, The record is converted into a record including a plurality of data fields based on a desired architecture different from the above-described architecture.

[0003]

In the conventional data converter described above, conversion between different architectures is performed by:
To convert the data type described by a given architecture according to a given conversion rule that converts it to a data type compatible with one different architecture, treat it as the number of digits or integer required for the data type, or treat it as a decimal There was a problem that no consideration was given to the situation.
Also, since only the conversion of the database structure between different architectures is considered, there is no mention of converting the database structure determined in the upstream design into a data structure of a specific language.

The present invention has been made in view of the above problems, and is a data conversion apparatus capable of converting an abstractly described database structure into a structure of a specific language having an appropriate data type. And a data conversion method for a data conversion device.

[0005]

In order to achieve the above object, the invention according to claim 1 reads the upstream design information having database information whose data type is undetermined, and reads the upstream design information. Upstream design information input means for holding as internal information, conversion rule information including a rule for converting the held upstream design information into a specific language, and predetermined fields and data read out from the conversion rule information A data conversion control unit that creates a data type conversion rule table and converts the upstream design information into a specific language according to the contents of the table, and a downstream design in which the upstream design information is converted by the data conversion control unit. And a downstream design information output means for outputting information.

In the invention according to claim 1 configured as described above, the upstream design information reads the upstream design information including abstract database information and holds it as internal information. The data conversion control means reads the conversion rule information including rules for converting the held upstream design information into a specific language and creates a data type conversion rule table including predetermined fields and data. The upstream design information is converted into a specific language according to the contents of the table. The downstream design information output means outputs downstream design information obtained by converting the upstream design information by the data conversion control means.

That is, the upstream design information described by a predetermined database structure is converted into a specific language structure according to a data type conversion rule table developed from the conversion rule information. In the data type conversion rule table, the data type of the structure of the specific language is defined in one-to-one correspondence for each digit of the data type of the database structure described in the upstream design information.

[0008] Although the conversion rule information stores predetermined conversion rules, not all rules cover the conversion rules. Therefore, when the data conversion control means performs the conversion, the conversion rule does not exist in the conversion rule information. If the pattern corresponding to the data type conversion rule table does not exist, the conversion process may be performed by error processing or the like. It may be interrupted or the part may be left unconverted.

Therefore, as an example of the configuration of the data conversion control means, the invention according to claim 2 is the data conversion apparatus according to claim 1, wherein the data conversion control means corresponds to the data type conversion rule table in the data type conversion rule table. When there is no digit number to be converted, the nearest digit number is searched for in the same conversion source data type, and the data type is converted to a conversion destination data type corresponding to the same digit number.

[0010] In the invention according to claim 2 configured as described above, if conversion source data that does not exist in the conversion rule information is described in the upstream design information, the data conversion control means executes the data type conversion. Since the corresponding digit number does not exist in the conversion rule table, the nearest digit number is searched for in the same conversion source data type and converted to the conversion destination data type corresponding to the same digit number.

For example, in the data type of the upstream design information, a rule is defined that 4 digits of “NUMBER” are converted to “short” and 9 digits of “NUMBER” are converted to “long”. In such a case, since the number of digits is not defined, conversion is performed according to the conversion rule of the nearest number of digits.

Further, as an example of the configuration of the upstream design information input means, the invention according to claim 3 is a data conversion device according to any one of claims 1 and 2, wherein the upstream design information input means is And a data type conversion definition information storage means for reading and storing the data type conversion definition information stored in the information design information.

[0013] In the invention according to claim 3 configured as described above, the upstream design information includes data type conversion definition information corresponding to a type of a database structure, and the data conversion control means includes the upstream design information. When the information is read, the data type conversion definition information is obtained and stored in the data type conversion definition information storage means.

Further, as an example of the configuration of the conversion rule information, the invention according to claim 4 is the data conversion device according to any one of claims 1 to 3, wherein each of the conversion rule information is individually And a plurality of pieces of conversion rule information having conversion rules.

[0015] In the invention according to claim 4 configured as described above, the conversion rule information includes a plurality of conversion rules each having a different conversion rule, in order to cope with a case where the plurality of upstream design information items have different database structures. Has the conversion rule information.

Further, as an example of the configuration of the data conversion control means, the invention according to claim 5 is the data conversion apparatus according to any one of claims 1 to 4, wherein the data conversion control means The data type conversion definition information stored in the data type conversion definition information storage means is obtained, the contents of the definition are determined, and appropriate conversion rule information is read from the plurality of conversion rule information.

In the invention according to claim 5 configured as described above, the data conversion control means acquires the data type conversion definition information stored in the data type conversion definition information storage means, and acquires the data type conversion definition information. Determine the content,
Appropriate conversion rule information is read from the plurality of conversion rule information.

As described above, the method of converting an abstractly represented database type table into a data type of a specific language according to a predetermined rule need not be limited to an actual device. It is easy to understand that also works.

Therefore, the invention according to claim 6 is a data
In a data conversion method of a data conversion device for converting a database type table whose data type is undetermined into a data type of a specific language according to a predetermined rule, an upstream design information including database information whose data type is undetermined Reading the data as internal information, and reading conversion rule information including rules for converting the stored upstream design information into a specific language, and creating a data type conversion rule table including predetermined fields and data. And converting the upstream design information into a specific language in accordance with the contents of the table, and outputting the downstream design information obtained by converting the upstream design information.

[0020]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a data conversion device according to an embodiment of the present invention. In the figure, the data conversion apparatus includes an upstream design information reading unit 100, a downstream design information writing unit 110, an upstream design information 120, a downstream design information 130, a data type conversion rule information 140, a data type conversion And a data type conversion rule table 160.

As shown in FIG. 3, the data type conversion unit 150 includes a conversion rule information reading unit 150a, a data type determination unit 150b, and a data digit number determination unit 150c. Further, the same data type conversion rule table 160
2, a conversion source data type 160a indicating a data type described in the upstream design information, and conversion source data indicating the number of digits of data defined in the data type of the conversion source data type 160a. The destination data type 160 defined in a one-to-one relationship with the number of digits 160b of the type and the number of digits 160b of the source data type 160a and the source data type 160b
c.

Here, the upstream design information reading section 100
Is the upstream design information 1 created by the upstream design function.
20, for example, database design information and the like are read and held as internal information. The downstream design information writing unit 110
The data type conversion unit 150 converts the data type described in the upstream design information 120 into an appropriate data type and holds the downstream design information 1 stored as internal information.
30 is output.

The conversion rule reading section 150a reads the data type conversion rule information 140 and stores the conversion source data type 16 in the data type conversion rule table 160.
0a, the conversion source data digit number 160b, and the conversion destination data type 160c. The data type determination unit 150b
The data type of the data to be converted is searched by referring to the conversion source data type 160a of the data type conversion rule table 160 created by the conversion rule reading unit 150a. Is extracted and output to the data digit number determination unit 150c.

The data digit number determining section 150c compares the converted data type digit number 160b of the record of the data type conversion rule table 160 extracted by the data type determining section 150b with the data digit number to be converted. Thus, it is determined whether the number of data digits of the data type to be converted is included in the extracted number of digits of the conversion source data type. If it is included, it is converted by the conversion destination data type 160c of the extracted record, and if it is not included, the data type determination unit 150b is operated again. As a result, the conversion source data type 160a described in the upstream design information 120 is changed to an appropriate conversion destination data type 1
60c.

Therefore, by acquiring the read upstream design information, identifying the data type included in the upstream design information, and converting the data type into an appropriate data type according to the read data type conversion rule, the upstream design information is obtained. Since the information is converted into downstream design information, the data conversion unit 15 is used.
0 constitutes data type conversion means.

In the present embodiment, the data type conversion section 150 expands only the information stored in the data conversion rule information 140 into a data type conversion rule table 160 and uses the data in the table 160 as a reference. The upstream design information 120 is converted to the downstream design information 130.
, But, of course, is not limited to this configuration. For example, when there are a plurality of the upstream design information 120, each having a different data type,
A configuration in which a plurality of the conversion rule information 140 are set as shown in FIG. 4 in order to appropriately convert each data type may be used.

At this time, the upstream design information reading unit 100a
Data type information representing the type of the database in which the upstream design information is described is acquired from the plurality of upstream design information 120 and stored in the data type information storage unit 100a1, and the stored data type information is converted into conversion information. Decision unit 1
Output to 50d. Then, the conversion information determining unit 150d
Is the conversion rule reading unit 1 based on the data type information.
By controlling the 50a, the appropriate data type conversion rule information 140 is selected and read from the plurality of data type conversion rule information 140, and the upstream design information 120 is selected by the selected data type conversion rule 140.
Is converted into the downstream design information 130. Therefore, the data type information constitutes the data type conversion definition information by representing the type of the database described in the upstream design information 120, and the data type information is acquired and stored by acquiring the same data type information. The storage unit 100a1 forms a data type conversion definition information storage unit.

FIG. 5 is a flowchart showing the contents of the data type conversion processing executed by the data type conversion section 150. First, the data type conversion rule table 16
0 is set as the comparison target record that refers to the first record (step S200). The change source record 160a of the setting record and the upstream design information 12
0 (step S205) to determine whether they are the same (step S2).
10).

If they are the same, the data type digit number 160b corresponding to the change source data type 160a of the setting record is compared with the data digit number to be changed (step S21).
5) It is determined whether they are the same (step S220).
If they are the same, the conversion destination data type 16
0c is extracted as the data type to be converted, and is used as the downstream design information 130 (step S225). Also,
If it is determined in steps S210 and S220 that they are not the same, the data type conversion rule table 1
The record next to 60 is set as a setting record (step S
230), and the above steps S205 to S225 are repeated.

In this embodiment, step S2
In 10 and S220, the processing configuration is such that the data type and the number of digits of the data type are determined only by the same.
If the same data type or the same data type digit number does not exist, conversion may not be possible with such a processing configuration. Therefore, the processing configuration shown by the broken line in FIG. 5 may be used. In this case, if the search is completed for all the records of the data type conversion rule table 160 without finding the same data type and the same data type digit number (step S235), the same data type exists and the same data If a type digits are not present, the data type number of digits is converted in the same data type based on data digits than
Extract and convert the nearest data type above . If neither the same data type nor the same data type digit exists , the nearest data type whose data type digit number is equal to or greater than the conversion source data digit is extracted and converted (step S240).

Next, the operation of this embodiment configured as described above will be described. In software development, design a database etc. at the stage of upstream design where the programming language to be used is undecided, and input the designed database information to this data conversion device when moving to downstream design using a programming language At the same time, the data conversion process of the data conversion unit 150 is started. Then, the designed database information is sequentially converted into the programming language and stored. This allows
The downstream designer does not need to rewrite or modify the database information created by the upstream designer.

As described above, when the upstream design information 120, which is a data type such as database information, is converted into the downstream design information 130, which is a data type of a specific language, the conversion source data type and the conversion source data type are converted from predetermined conversion rule information. Expand the data type change rule table into the data type change rule table corresponding to the number of digits of the source data type, and search this table to take into account not only the data type but also the number of digits of the data type. Can be performed, and more detailed data type conversion can be realized.

[0033]

As described above, the present invention provides a data conversion device capable of converting an abstractly described database structure into a structure of a specific language having an appropriate data type. Can be. Further, according to the second aspect of the present invention, it is possible to convert the data type of the conversion source having the number of digits that does not exist in the conversion rule into an appropriate data type. Furthermore, according to the invention of claim 3, it is possible to recognize what database structure describes the upstream design information.

Further, according to the invention of claim 4,
Since there are a plurality of pieces of conversion rule information, an appropriate conversion rule can be applied. Furthermore, according to the invention of claim 5, it is possible to deal with a plurality of pieces of upstream design information.
Further, according to the invention of claim 6, there is provided a data conversion method of a data conversion device capable of converting an abstractly described database structure into a structure of a specific language having an appropriate data type. can do.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a data conversion device according to an embodiment of the present invention.

FIG. 2 is a data configuration diagram showing a configuration of a data conversion rule table of the data conversion device.

FIG. 3 is a block diagram illustrating a detailed configuration of a data conversion unit.

FIG. 4 is a block diagram showing another configuration of the data conversion unit.

FIG. 5 is a flowchart showing processing contents of a data conversion process executed by the data conversion unit.

[Explanation of symbols]

 100 upstream design information reading diagram 110 downstream design information writing diagram 120 upstream design information 130 downstream design information 140 data type conversion rule information 150 data type conversion section 160 data type conversion rule table

Claims (6)

(57) [Claims] 1. An upstream design information comprising database information whose data type is undecided, an upstream design information input means for reading the upstream design information and holding it as internal information, and converting the held upstream design information into a specific language. Conversion rule information having a rule to be converted, and reading the conversion rule information to create a data type conversion rule table having predetermined fields and data, and converting the upstream design information into a specific language according to the contents of the table. A data conversion device comprising: a data conversion control unit for converting the upstream design information into downstream design information by the data conversion control unit; 2. The data conversion device according to claim 1, wherein the data conversion control means is configured to determine, when the corresponding number of digits does not exist in the data type conversion rule table, the nearest digit in the conversion source data type. A data conversion device for retrieving a number and converting it to a conversion destination data type corresponding to the same number of digits. 3. The data converter according to claim 1, wherein said upstream design information input means reads and stores data type conversion definition information stored in said upstream design information. A data conversion device comprising conversion definition information storage means. 4. The data conversion device according to claim 1, wherein the conversion rule information includes a plurality of conversion rule information each including a conversion rule individually. Data converter. 5. The data conversion device according to claim 1, wherein the data conversion control unit stores the data type conversion definition information stored in the data type conversion definition information storage unit. A data conversion device that acquires, defines the same definition, and reads out appropriate conversion rule information from the plurality of conversion rule information. 6. A data conversion method for a data conversion apparatus for converting a database type table whose data type is undetermined into a data type of a specific language according to a predetermined rule, wherein upstream design information including database information whose data type is undetermined. Reading the stored upstream design information as internal information, and reading conversion rule information including rules for converting the stored upstream design information into a specific language, and creating a data type conversion rule table including predetermined fields and data. Data converting the upstream design information into a specific language in accordance with the contents of the table, and outputting the downstream design information obtained by converting the upstream design information. The data conversion method of the conversion device.