JP2000105765A - Data converting device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data converting device capable of efficiently performing a data converting work. SOLUTION: This data converting device is provided with a data conversion information parameter storing part 3 for storing data conversion information parameters including the code system, full size/half size, data storage position, and file edition information of the data of an input file 1 and the data of an output file 7, and a data converting part 5 for converting the data of the input file 1 into data to be stored in the output file 7 based on the data conversion parameters. The data conversion information is turned into parameters independently of an application so that it is not necessary to operate any work for correcting a source program or operating compile again according to the content of the change of a data conversion and code conversion system or the like. Thus, it is possible to generalize an application program for data conversion.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to, for example, FAX-O
The present invention relates to a data conversion device used for a CR system or the like.

[0002]

2. Description of the Related Art Conventionally, for example, in a financial business such as a bank or a large-scale retail store, a plurality of branches are scattered in various places, and a FAX-OCR system for processing a slip generated in these branches by a management center is known. It's being used.

In the case of a conventional FAX-OCR system, a voucher is transmitted from each branch to the management center by facsimile, the voucher received by facsimile is read by the OCR, and the contents are converted into a predetermined processing format. Processing.

[0004] In the management center, the data read by the OCR is stored in an IS environment under an OS environment such as UNIX (trade name).
Create a data file such as an AM file and save it to W
Oracle (trade name) in the Windows (trade name) environment
And migrate data to other databases.

In this type of system, data conversion can be performed under the same OS environment, that is, between files of the same organization, but data conversion under an environment of a different OS is impossible. Therefore, in the case of a conventional system, when performing data structure conversion, code conversion, and conversion using a combination of the two, a dedicated application program individually created in accordance with the conversion content operates in any OS environment. I was using it.

Since this application program is a dedicated one, every time a change in data to be converted, such as a data structure or a code conversion method, occurs, it is necessary to correct the source program in accordance with the change, and compile again. is there.

At this time, it is necessary to analyze the logic of the source program in order to confirm the contents of the data conversion pattern.

[0008]

However, if the programs are analyzed and corrected one by one in order to conform to the data structure and the code conversion method, efficient work is difficult, and the work efficiency is reduced. There was a problem.

The present invention has been made to solve such a problem, and an object of the present invention is to provide a data conversion device capable of performing data conversion work efficiently.

[0010]

According to a first aspect of the present invention, there is provided a data conversion apparatus, comprising: a code system for input data and output data; full-width / half-width; data storage position; Conversion information storage means for storing data conversion information parameters including the data conversion information parameters, and data conversion means for converting input data into output data based on the data conversion information parameters stored in the conversion information storage means. .

In the case of the first aspect of the present invention, the conversion information storage means storing the data conversion information parameter and the data conversion means for performing data conversion based on the data conversion information parameter of the conversion information storage means are separate means. When the data structure and the code conversion method of the data to be converted are changed by the separation, the data conversion information parameters of the conversion information storage means, for example, code system conversion,
By dynamically changing full-width / half-width conversion, data storage position, file organization information, and the like, data conversion can be performed without changing data conversion means. That is, the data conversion means can be used, for example, as a general-purpose application, and the analysis of the source program is not required.

As a result, data conversion under a different OS environment becomes possible, which cannot be performed by the conventional data conversion method. For example, from the ISAM file
Data can be easily migrated to a database such as a rack.

According to a second aspect of the present invention, there is provided a data conversion apparatus comprising:
Code system of input data and output data, full-width / half-width,
A data storage position, conversion information storage means for storing data conversion information parameters including at least file organization information, and means for confirming the presence or absence of fixed information among the data conversion information parameters stored in the conversion information storage means; When the fixed information is confirmed, data conversion means for performing data conversion based on a data conversion information parameter while giving priority to the fixed information is provided.

According to the second aspect of the present invention, when performing data conversion, the presence or absence of fixed information in the data conversion information parameter is confirmed. If the fixed information is confirmed, the data conversion is performed while giving priority to the fixed information. Since data conversion is performed based on the information parameter, information other than input data can be converted as output data, for example, by describing a character string used instead of input data as fixed information.

According to a third aspect of the present invention, there is provided a data conversion apparatus comprising:
The fixed information is at least one of a date, a time, version information, counter information, and an encryption key.

In the case of the third aspect of the present invention, a time stamp is applied to each application in order to manage converted records. However, date, date, and time are fixed information to be confirmed at the time of data migration. By adding the time, the version information, the counter information, the encryption key, and the like, for example, the date, the time, and the like can be set to the values at the time of conversion, so that the history of data conversion can be managed. The provision of the counter information makes it possible to clearly manage the processing order of records. Further, the converted program can be specified based on the version information. In addition, by encrypting only a specific item on a record using an encryption key, it is possible to selectively apply security.

That is, the data conversion pattern can be dynamically changed only by changing the data conversion information parameter, and the data conversion can be performed without changing the application or recompiling the data. It can be carried out.

[0018]

Embodiments of the present invention will be described below in detail with reference to the drawings.

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

As shown in FIG. 1, the data conversion apparatus comprises an input file 1, an input buffer 2, a data conversion information parameter storage 3, a memory 4, a data converter 5, an output buffer 6, an output file 7, and the like. Have been.

The input file 1 is a file for storing pre-conversion information. The input buffer 2 is a storage unit for temporarily storing data read from the input file 1. The output buffer 6 is a storage unit for temporarily storing data to be output to the output file 7. The output file 7 is a file for storing the converted data. The memory 4 is a work area for performing data conversion. The data converter 5 is a general-purpose application program for data conversion for controlling the input file 1, the output file 7, the data conversion information parameter storage 3, and the like.

The data converter 5 may be constituted by hardware.

The data conversion information parameter storage unit 3 stores
Each data structure of input file 1 / output file 7 (file name, file organization, number of bytes, data start position),
A code system, full-width / half-width information, fixed character strings as fixed information, and the like are set in the form of a table. Hereinafter, the operation of the data converter will be described with reference to FIG. In this data conversion device, the data conversion unit 5 which is a general-purpose application, based on the data conversion information parameters in the data conversion information parameter storage unit 3, inputs file name, output file name, number of input bytes, number of output bytes, data conversion The information is acquired and stored in the memory 4.

The data conversion information referred to here is the input data start position / the number of bytes from the start position of the input data / the code system of the input data / the start position of the output data / the number of bytes from the start position of the output data / the output data Code system / full-width / half-width information / fixed character string / file organization.

First, the data converter 5, which is a general-purpose application, opens the input file 1 and the output file 7, respectively.

Access to the input file 1 / output file 7 adopts a method in accordance with the file organization specified by the data conversion information parameter of the data conversion information parameter storage unit 3.

For example, an input file 1 has an ISAM file created under an OS environment such as UNIX, and the input file 1 has a bank name (8 bytes, full width) and a branch name (8 bytes) as shown in FIG. Byte, full-width), address (48 bytes, full-width), amount of money (12 bytes, full-width), and the like. This is a data structure of a database such as Oracle in the Windows environment, such as an address (24 bytes, half-width), In the case where the output is rearranged in the order of the amount (4 bytes, one-byte), the bank name (8 bytes, two-byte), the branch name (8 bytes, two-byte), and the like, the data conversion unit 5 inputs the same number of input bytes from the input file 1 After reading the data into the buffer 2, the data conversion information (input data start position,
Input data based on information defined as the number of input data bytes, full-width / half-width classification, input code system (EUC / SJIS), output data start position, output data byte count, output code system, fixed character string, etc.) The data is converted into an output form, stored in the output buffer 6 by the number of output bytes, and output to the output file 7. This work is called EOF (En
d of File).

The conversion based on the information defined in the data conversion information means that the data read into the input buffer 2 is output from the input data start position to the output buffer 6 by the number of bytes from the input data start position. This refers to a process of outputting data from the data start position for the number of bytes from the output data start position. At this time, if conversion between the input data coding system and the output data coding system and full-width / half-width conversion are specified, the output buffer 6
Output to

When there is a fixed character string in a certain table in the data conversion information parameter stored in the data conversion information parameter storage unit 3, the data conversion unit 5 executes the fixed character string before executing the conversion processing. The column is checked.

Then, the fixed character string is given priority and the data conversion process is executed.

For example, when a predetermined character string such as TEST is described as a fixed character string, data is not read from the input file 1 and the fixed character string “TES” is read.
T "is output from the start position of the output data by the number of bytes from the start position of the output data based on the information in the table.

By using date, time, version information, counter information, an encryption key, and the like as fixed information to be checked, the conversion time can be set by, for example, date, time, etc. Can be managed. Also, the processing order of records can be clearly managed by the counter information. Further, the converted program can be specified based on the version information. In addition, by encrypting only a specific item on a record with an encryption key, it is possible to selectively apply security.

As described above, according to the data converter of this embodiment, the data structure, code conversion information, and file organization information of the input file 1 and the data structure, code conversion information, and file organization information of the output file 7 are used as parameters. By managing the data in the form of a table in the data conversion information parameter storage unit 3, it is not necessary to create an application depending on the conversion pattern, and the data conversion unit 5 can be realized as an independent general-purpose application.

In this case, the data conversion pattern can be dynamically changed only by changing the data conversion information parameter of the data conversion information parameter storage unit 3 without changing / recompiling the application.

As a result, the data conversion operation can be performed efficiently.

[0036]

As described above, according to the present invention, the data conversion information is parameterized independently of the application, so that each time a change in the data conversion or code conversion method occurs, the source is adjusted according to the change. It is not necessary to modify the program and compile it again, so that the application program for data conversion can be generalized.

Therefore, by changing the data conversion information parameter, data conversion can be performed with various data conversion patterns. The contents of the data conversion information parameters are tabulated, and the data conversion pattern can be easily known by checking this table.

That is, the data conversion pattern can be changed only by changing the data conversion information parameter, and the data conversion can be performed without changing the application or recompiling the data.

As a result, the data conversion operation can be performed efficiently.

[Brief description of the drawings]

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

FIG. 2 is a diagram showing an example of a conversion source file and a conversion destination file in the data conversion apparatus.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... input file, 2 ... input buffer, 3 ... data conversion information parameter storage part, 4 ... memory, 5 ... data conversion part, 6 ... output buffer, 7 ... output file.

Claims (3)

[Claims] 1. A conversion information storage means for storing a data conversion information parameter including a code system of input data and output data, full-width / half-width, data storage position, file organization information, and the conversion information storage means. A data conversion unit for converting input data to output data based on the data conversion information parameter. 2. Conversion information storage means for storing a data conversion information parameter including at least a code system of input data and output data, full-width / half-width, data storage position, and file organization information, and stored in the conversion information storage means. Means for confirming the presence or absence of fixed information in the data conversion information parameters obtained, and data conversion means for performing data conversion based on the data conversion information parameter while giving priority to the fixed information when the fixed information is confirmed. A data conversion device characterized in that: 3. The data conversion device according to claim 2, wherein the fixed information is at least one of a date, a time, version information, counter information, and an encryption key.