JP2007164700A - Data conversion design unit, data conversion system, method therefor, and program therefor - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data conversion design unit or a data converter for verifying a data conversion result before executing a data conversion program, and a system, method and program therefor. <P>SOLUTION: This data conversion design unit or data converter has a conversion source file definition information acquiring part 31 and a converted file definition information acquiring part 32 for acquiring items of a conversion source data 51 and items thereof after conversion, a conversion source/destination item correspondence defining part 13 for displaying correspondence between the items of the conversion source data 51 before and after conversion, and the item of the converted data of existing data conversion definition information, when requiring the assignment of executed conversion processing, a conversion source/destination item conversion defining part 14 for displaying a conversion condition of the existing data conversion definition information, when requiring the assignment of the conversion condition in the conversion processing, and a data conversion definition generating part 15 for generating information correspondence of the items before and after the data conversion of the conversion source data 51, the conversion processing and the conversion condition, as data conversion definition information, to be stored in a storage means. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a data conversion design apparatus, a data conversion system, and a method and program thereof, and in particular, a data conversion design apparatus that enables verification of conversion results of actual data by sampling when designing a data conversion program with a special transfer method, The present invention relates to a data conversion system, a method thereof, and a program.

Conventional data exchange systems
1. Definition of data conversion rules Create a data conversion program. Data conversion is performed with the conversion source data as the processing target.

  That is, first, a data conversion rule is defined, then a data conversion program is created, and the converted data cannot be obtained unless this data conversion program is executed. That is, the conversion result cannot be verified before the data conversion program is executed.

Conventional techniques relating to verification of data conversion results include a “data file conversion system” disclosed in Patent Document 1 and a “data conversion apparatus” disclosed in Patent Document 2.
Japanese Patent Laid-Open No. 2004-21698 JP-A-4-350740

In the invention disclosed in Patent Document 1, the conversion source / destination format information setting area is fixed information defined in advance, and data conversion is performed efficiently for undefined data or a data conversion program is executed. You can't convert data without doing it.
The invention disclosed in Patent Document 2 is also the same, and the conversion table must be defined in advance.

  As described above, the conventional data conversion system has a problem that even if the data has been converted once, the conversion result cannot be verified with the actual data when the data conversion is designed for the undefined data. .

  The present invention has been made in view of such problems, and an object thereof is to provide a data conversion design device, a data conversion system, a method thereof, and a program.

  In order to achieve the above object, according to a first aspect of the present invention, there is provided a data conversion design device that defines, as data conversion definition information, the contents of data conversion processing for converting conversion source data into conversion destination data. The method of acquiring the conversion source data item of the conversion target data that is the target of conversion processing and the item of the conversion destination data when the data is converted, and the items of the conversion source data and the conversion destination data of the conversion target data When requesting the user to specify the conversion processing to be performed and the conversion source data item, the data conversion definition information stored in the data conversion definition information storage means displays the data conversion destination data item Data conversion definition when requesting the user to specify the conversion condition in the conversion process for the conversion processing for the existing data conversion definition information conversion destination item display means and conversion source data items The existing data conversion definition information conversion condition display means for displaying the conversion conditions of the existing data conversion definition information stored in the information storage means, and the conversion source data and the conversion destination data of the conversion target data specified by the user Data conversion definition generating means for generating, as data conversion definition information, information indicating the correspondence between items, conversion processing performed on the items of the conversion source data, and conversion conditions in the conversion processing, and the generated data conversion definition information, The present invention provides a data conversion design apparatus characterized by comprising means for storing data conversion definition information storage means.

  In the first aspect of the present invention, the existing data conversion definition information conversion destination item display means includes the items of the conversion source data and the conversion destination data in the data conversion definition information stored in the data conversion definition information storage means. It is preferable to display the item of the conversion destination data although the correspondence with the item matches the conversion target data.

  In any of the above configurations according to the first aspect of the present invention, the existing data conversion definition information conversion condition display means is an item of conversion source data among the data conversion definition information stored in the data conversion definition information storage means. It is preferable to display the conversion condition for the case where the correspondence between the data and the item of the conversion destination data matches the correspondence specified by the user.

  In order to achieve the above object, the present invention provides, as a second aspect, data conversion design apparatus according to any one of the first aspect of the present invention and conversion source data as data according to the data conversion definition information. A data conversion system including a data conversion verification device that converts and outputs conversion destination data is provided.

In order to achieve the above object, according to a third aspect of the present invention, there is provided a data conversion design method for defining, as data conversion definition information, contents of data conversion processing for converting conversion source data into conversion destination data. ,
The step of obtaining the conversion source data item of the conversion target data that is the target of the data conversion process and the conversion destination data item when the data is converted, and the items of the conversion source data and the conversion destination data of the conversion target data And the conversion destination data item of the existing data conversion definition information stored in the data conversion definition information storage means when requesting the user to specify the conversion process to be performed on the conversion source data item. The existing data conversion stored in the data conversion definition information storage means when requesting the user to specify the conversion conditions in the conversion process for the conversion process for the items of the existing data conversion definition information to be displayed and the conversion source data Existing data conversion definition information conversion condition display step that displays the conversion conditions of definition information, and conversion of conversion target data specified by the user A data conversion definition generation step for generating, as data conversion definition information, correspondence between items of data and conversion destination data, conversion processing performed on the items of the conversion source data, and information indicating conversion conditions in the conversion processing, and generation And a step of storing the data conversion definition information in a data conversion definition information storage means.

  In the third aspect of the present invention, in the existing data conversion definition information conversion destination item display step, among the data conversion definition information stored in the data conversion definition information storage means, items of conversion source data and conversion destination data It is more preferable to display the item of the conversion destination data even though the correspondence relationship with the item matches the conversion target data.

  In any of the above-described configurations of the third aspect of the present invention, the existing data conversion definition information conversion condition display means is an item of conversion source data among the data conversion definition information stored in the data conversion definition information storage means. It is preferable to display the conversion condition for the case where the correspondence between the data and the item of the conversion destination data matches the correspondence specified by the user.

  In order to achieve the above object, the present invention provides, as a fourth aspect, conversion source data according to the data conversion definition information in a subsequent stage of the data conversion design method according to any one of the configurations of the third aspect of the present invention. The data conversion method for performing the data conversion verification process for converting the data and outputting the conversion destination data is provided.

  In order to achieve the above object, according to a fifth aspect of the present invention, there is provided a data which causes a computer to execute the data conversion design method according to any one of the third aspect of the present invention. A conversion design program is provided.

  In order to achieve the above object, the present invention provides, as a sixth aspect, a data conversion program that causes a computer to execute the data conversion method according to the fourth aspect of the present invention. It is.

  According to the present invention, it is possible to provide a data conversion design device, a data conversion system, and a method and program thereof that can verify a data conversion result before executing the data conversion program.

[First Embodiment]
A preferred embodiment of the present invention will be described. FIG. 1 shows a configuration of a data conversion system according to the present embodiment.
The data conversion system includes a data conversion design device 1, a data conversion verification device 2, storage devices 3 to 5, an input device 6, an output device 7, an input device 8, and an output device 9. The data conversion design device 1 and the data conversion verification device 2 may be configured by dedicated hardware, or may be configured by software processing by a general computer including an input device and a storage device.
Note that the data conversion design device 1 and the data conversion verification device 2 may have an integrated configuration (in the case of software processing by a computer, a configuration in which two functional units are formed on the same computer).

The data conversion design device 1 includes a conversion source file definition information acquisition unit 11, a conversion destination file definition information acquisition unit 12, a conversion source destination item correspondence definition unit 13, a conversion destination item conversion definition unit 14, and a data conversion definition generation unit 15. .
The conversion source file definition information acquisition unit 11 acquires the conversion source file definition information 31 stored in the storage device 3. The conversion destination file definition information acquisition unit 12 acquires conversion destination file definition information 32 stored in the storage device 3. The conversion source / destination item correspondence definition unit 13 causes the output device 7 to display the acquired conversion source file definition information 31 and the conversion destination file definition information 32. At this time, if the data conversion definition information 41 is stored in the storage device 4 and a conversion destination item name 415 equal to the item name 322 of the acquired conversion destination definition information 32 exists, the acquired data conversion definition information Forty-one conversion destination items 415 are displayed on the output device 415. The conversion source / destination item conversion definition unit 14 causes the output device 7 to display the item correspondence information defined by the conversion source / destination item correspondence definition unit 13. At this time, the data conversion definition information 41 is stored in the storage device 4 and the conversion item 412 and the conversion destination item 415 of the data conversion definition information 41 equal to the item correspondence information defined by the conversion source destination item correspondence definition unit 13 are used. If there is, the condition 413 and the action 414 of the data conversion definition information 41 are displayed on the output device 7. The data conversion definition information generation unit 15 outputs the data conversion definition information 41 created by the conversion source destination item correspondence definition unit 13 and the conversion source destination item conversion definition unit 14 to the storage device 4 for storage.

The data conversion verification device 2 includes a data conversion definition information acquisition unit 21, a conversion source data acquisition unit 22, and a data conversion unit 23.
The data conversion definition information acquisition unit 21 acquires data conversion definition information 41 stored in the storage device 4. The conversion source data acquisition unit 22 acquires the conversion source data 5 stored in the storage device 5. The data conversion unit 23 converts the conversion source data 51 according to the data conversion definition information 41 and causes the output device 9 to display it.

  The storage device 3 stores conversion source file definition information 31 and conversion destination file definition information 32.

  FIG. 2 shows an example of the data structure of the conversion source file definition information 31 and the conversion destination file definition information 32. The conversion source file definition information 31 includes a file name 311, an item name 312, a column name 313, an attribute 314, and the number of digits 315 as file definition information. The conversion destination file definition information 32 includes a file name 321, an item name 322, a column name 323, and attributes 324 and 325 as file definition information.

  The storage device 4 stores data conversion definition information 41.

  FIG. 3 shows an example of the data structure of the data conversion definition information 41. The data conversion definition information 41 includes a conversion source file 411, a conversion source item 412, a condition 413, an action 414, and a conversion destination item 415.

  The conversion source item 412 and the conversion destination item 415 are associated with each other by the conversion source destination item correspondence definition unit 13. The definition of the condition 413 and the action 414 is made by the conversion source / destination item conversion definition unit 14.

  The storage device 5 stores the conversion source data 51.

  The input device 6 is a user interface for a user to input information (definition input) to the data conversion design device 1.

  The output device 7 is a device for presenting information processed by the data conversion design device 1 to the user.

  The input device 8 is a user interface for the user to input information (data input) to the data conversion verification device 2.

  The output device 9 is a device for presenting information processed by the data conversion verification device 2 to the user.

Next, the operation of the data conversion system according to the present embodiment will be described.
4 and 5 show the operation flow of the data conversion system according to the present embodiment.
First, the operation at the time of data conversion design will be described.
When conversion source and conversion destination file definition information is specified by a user input operation via the input device 6 (step S101), the conversion source file definition information acquisition unit 11 stores the specified conversion source file definition information 31. Obtained from the storage device 3 (step S102). Also, the conversion destination file definition information acquisition unit 12 acquires the specified conversion destination file definition information 32 from the storage device 3 (step S103). The conversion source destination item correspondence definition unit 13 displays the conversion source file definition information 31 and the conversion destination file definition information 32 acquired from the storage device 3 on the output device 7 (step S104). If the existing data conversion definition information 41 exists (step S105 / Yes), a conversion destination item 415 equivalent to the item name 312 of the conversion source file definition information 31 is displayed on the output device 7 (step S106).

Next, when the user associates conversion source destination items using the input device 6 (step S107), the conversion source destination item conversion definition unit 14 outputs the conversion source item / conversion destination item / conversion definition name to the output device. 7 is displayed (step S108). If the existing data conversion definition information 41 exists (step S109 / Yes), the conversion source destination item conversion definition unit 14 refers to this, and the correspondence between the conversion source item 412 and the conversion destination item 415 indicates that the user If it is equal to the conversion source and destination item conversion definition defined by, the condition 413 and the action 414 are displayed on the output device 7 (step S110). That is, the data conversion definition information 41 in which the combination of the conversion source item 412 and the conversion destination item 415 matches the combination of the conversion source item and the conversion destination item specified by the user is searched in the storage device 4, and if it exists, The condition 413 and action 414 of the data conversion definition information 41 are displayed on the output device 7.
Specifically, when the user designates “account item” as the conversion source item and “account item” as the conversion destination item using the input device 6, the conversion source item conversion definition unit 14 stores the data in the storage device 4. To obtain the record shown at the top in FIG. Then, “−” and “A + *” which are the condition 413 and the action 414 of the record are displayed on the display device 7.

  Next, when the user performs conversion source / destination conversion definition using the input device 6 (step S111), the conversion source / destination item conversion definition unit 14 causes the output device 7 to display the conversion source / destination item conversion definition information. The data conversion definition generation unit 15 generates data conversion definition information 41 and stores it in the storage device 4.

Next, the operation at the time of data conversion will be described.
When data conversion is actually performed by the user using the input device 8 to specify conversion definition information 41 (step S201), the data conversion definition information acquisition unit 21 stores the specified data conversion definition information 41 in the storage device 4. (Step S202). Subsequently, when the user specifies the conversion source data 51 using the input device 8 (step S203), the conversion source data acquisition unit 22 acquires the specified conversion source data 51 from the storage device 5 (step S204). The data conversion unit 23 converts the acquired conversion source data 51 in accordance with the data conversion definition information 41, and displays information as shown in FIG. 6 on the output device 9 (step S205).
The user can verify the data with reference to the information displayed on the output device 9 (step S206).

  As described above, the data conversion system according to the present embodiment stores the data conversion definition information 41 in the storage device 4 when the data conversion design is newly performed. Therefore, the data conversion similar to the already converted data is performed. When performing the above, data conversion design can be performed using information stored in the storage device 4. For this reason, it becomes possible to verify the conversion result at the time of data conversion design (before executing the data conversion program).

In addition, the said embodiment is an example of suitable implementation of this invention, and this invention is not limited to this.
For example, in the above embodiment, the configuration including the storage device 3, the storage device 4, and the storage device 5 is taken as an example, but these are integrated configurations (a configuration in which one storage device is divided into a plurality of storage areas). ).
The input device 6 and the input device 8 may be realized by the same user interface. Similarly, the output device 7 and the output device 9 may be realized by the same user interface.
Thus, the present invention can be variously modified.

It is a figure which shows the structure of the data conversion system concerning suitable embodiment of this invention. It is a figure which shows the example of a data structure of the conversion source file definition information and the conversion destination file definition information. It is a figure which shows the example of a data structure of data conversion definition information. It is a figure which shows the flow of the conversion definition operation | movement of a data conversion system. It is a figure which shows the flow of the data conversion operation | movement of a data conversion system. It is a figure which shows an example of the data displayed on an output device for verification of conversion data.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Data conversion design apparatus 2 Data conversion verification apparatus 3, 4, 5 Storage device 6, 8 Input apparatus 7, 9 Output apparatus 11 Conversion source file definition information acquisition part 12 Conversion destination file definition information acquisition part 13 Conversion source destination item correspondence definition Unit 14 Conversion source destination item conversion definition unit 15 Data conversion definition generation unit 21 Data conversion definition information acquisition unit 22 Conversion source data acquisition unit 23 Data conversion unit 31 Conversion source file definition information 32 Conversion destination file definition information 41 Data conversion definition information 51 Conversion source data

Claims (10)

A data conversion design device that defines, as data conversion definition information, the contents of data conversion processing for setting conversion source data as conversion destination data,
Means for acquiring the item of the conversion source data of the conversion target data that is the target of the data conversion process and the item of the conversion destination data when the data is converted;
Stored in the data conversion definition information storage means when requesting the user to specify the correspondence between items in the conversion source data and the conversion destination data of the conversion target data and the conversion processing to be performed on the items of the conversion source data Existing data conversion definition information conversion destination item display means for displaying the conversion destination data item of the existing data conversion definition information,
An existing data conversion definition that displays the conversion conditions of the existing data conversion definition information stored in the data conversion definition information storage means when requesting the user to specify the conversion conditions in the conversion process for the item of the conversion source data Information conversion condition display means;
Information indicating the correspondence between the items of the conversion source data and the conversion destination data of the conversion target data designated by the user, the conversion process performed on the items of the conversion source data, and the conversion conditions in the conversion process Data conversion definition generating means for generating as definition information;
A data conversion design apparatus comprising: means for storing the generated data conversion definition information in the data conversion definition information storage means.   The existing data conversion definition information conversion destination item display means has a correspondence relationship between the conversion source data item and the conversion destination data item in the data conversion definition information stored in the data conversion definition information storage means. The data conversion design apparatus according to claim 1, wherein an item of conversion destination data that matches the conversion target data is displayed.   The existing data conversion definition information conversion condition display means has a correspondence relationship between the items of the conversion source data and the items of the conversion destination data in the data conversion definition information stored in the data conversion definition information storage means. The data conversion design apparatus according to claim 1 or 2, wherein a conversion condition that matches the correspondence specified by the user is displayed.   A data conversion device comprising: the data conversion design device according to any one of claims 1 to 3; and a data conversion verification device that converts the conversion source data according to the data conversion definition information and outputs the conversion destination data. system. A data conversion design method for defining the contents of data conversion processing for setting conversion source data as conversion destination data as data conversion definition information,
Obtaining a conversion source data item of the conversion target data that is the target of the data conversion process and a conversion destination data item when the data is converted;
Stored in the data conversion definition information storage means when requesting the user to specify the correspondence between items in the conversion source data and the conversion destination data of the conversion target data and the conversion processing to be performed on the items of the conversion source data An existing data conversion definition information conversion destination item display step for displaying the conversion destination data item of the existing data conversion definition information,
An existing data conversion definition that displays the conversion conditions of the existing data conversion definition information stored in the data conversion definition information storage means when requesting the user to specify the conversion conditions in the conversion process for the item of the conversion source data An information conversion condition display step;
Information indicating the correspondence between the items of the conversion source data and the conversion destination data of the conversion target data designated by the user, the conversion process performed on the items of the conversion source data, and the conversion conditions in the conversion process A data conversion definition generation step to generate as definition information;
And storing the generated data conversion definition information in the data conversion definition information storage means.   In the existing data conversion definition information conversion destination item display step, in the data conversion definition information stored in the data conversion definition information storage means, the correspondence relationship between the item of the conversion source data and the item of the conversion destination data 6. The data conversion design method according to claim 5, wherein an item of data to be converted is displayed that matches the data to be converted.   The existing data conversion definition information conversion condition display means has a correspondence relationship between the items of the conversion source data and the items of the conversion destination data in the data conversion definition information stored in the data conversion definition information storage means. The data conversion design method according to claim 5 or 6, wherein a conversion condition of the one corresponding to the correspondence specified by the user is displayed.   The data conversion which performs the data conversion verification process which performs the data conversion of the said conversion source data according to the said data conversion definition information, and outputs the said conversion destination data in the back | latter stage of the data conversion design method of any one of Claim 5 to 7 Method.   A data conversion design program for causing a computer to execute the data conversion design method according to any one of claims 5 to 7.   A data conversion program for causing a computer to execute the data conversion method according to claim 8.

Images