JP5564226B2 - Data conversion system and data conversion method - Google Patents

Description

  The present invention relates to a data conversion system and a data conversion method capable of converting data of different data formats into a mutual format, and in particular, a data conversion system and a data conversion method capable of checking inconsistencies in a data format before conversion. About.

  In recent years, an EDI (Electronic Data Interchange) system has been established that unifies information related to commerce into a standard format and is exchanged electronically between companies. Electronic data related to the arrival of goods is digitized according to a predetermined format and transmitted / received through a network such as a dedicated line or VAN.

In this EDI system, data exchange procedures (communication protocols) and business messages to be used (ordering, payment, etc.) are often different for each company, and the format of the message is often different for each retail company. In many cases, the communication is not via a direct communication method but via a relay center called an EDI center. Data formats in this EDI system are roughly classified into a fixed length format and a distribution business message standard format (distribution BMS format), and the reference format of the distribution BMS format is an XML format. Note that XML (extensible Markup Language) format data is data described in a markup language for describing the meaning and structure of documents and data, and fixed-length format data is a data type (attribute) to be stored. And data in which the data size ( number of digits ) is described in a predetermined format.

  As described above, since the EDI system has a data conversion function for converting data in different formats, it is indispensable to make an agreement on both the data format and data structure in advance, and whether the data conforms to the agreement. In order to check whether or not, it was necessary to develop a dedicated data check system.

  In addition, there is a schema that expresses the definition of an XML tree structure called XML Schema as a standard for checking the content consistency of XML data, and the consistency check of XML data can be performed using this schema. .

  The following Patent Document 1 is cited as a document describing a technique for checking the consistency of the data format. According to Patent Document 1, check conditions can be easily changed by storing check conditions in a database and creating a check condition logical expression by combining an operator and a function with a data name. The technology to do is described.

JP 2004-213488 A

  In the data format consistency check method in the EDI system according to the prior art, even if inconsistency is found as a result of checking the consistency of the data after conversion, it is difficult to specify the inconsistent portion in the data before conversion. There was a problem. In addition, when trying to check the XML schema check items of the converted XML data in the pre-conversion data, it is necessary to develop a data check system having only the number of XML schemas × the number of data formats, which increases work load and cost. There was also. In addition, it is conceivable to extract a check definition into parameters and develop a common check system. However, there is a problem that the work for performing the check definition occurs only for the number of schemas × the number of data formats.

  An object of the present invention is to provide a data conversion system and a data conversion method that can easily check data format inconsistency of a conversion source.

In order to achieve the above object, the present invention performs a mutual conversion between markup language format data described in a markup language and fixed-length format data described with a data type and data digits fixed in advance by a computer. A data conversion system,
Fixed-length data including a hierarchy name constituting the fixed-length format data, a data start position corresponding to the hierarchy name, the number of data digits , a data attribute, an appearance order of the hierarchy name, and a mandatory flag indicating whether it is an essential item A fixed length definition information table part storing structure information;
Markup language data structure information including a hierarchy name constituting the markup language format data, a tag name corresponding to the hierarchy name, the number of data digits , the appearance order of the hierarchy name, and a mandatory flag indicating whether or not it is a mandatory item Markup language definition information table section storing
A conversion definition information table part storing layer name correspondence information between the layer name of the markup language format data and the layer name of fixed-length format data;
Read fixed length data structure information stored in the fixed length definition information table section, markup language data structure information stored in the markup language definition information table section, and hierarchy name correspondence information stored in the conversion definition information table section Based on the read fixed-length data structure information, markup language data structure information, and hierarchy name correspondence information, the fixed-length format data is converted into markup language format data or the markup language format data is converted into fixed-length format data. Generating conversion parameter information for conversion, and determining whether the fixed-length format data and the markup language format data are consistent with the fixed-length data structure information and the markup language data structure information ; Data attributes and data of the fixed-length data structure information and markup language data structure information A parameter generating engine which generates a data check parameter information including the mandatory flag indicating whether the arranging order and required items for the number of hierarchical names,
A data check engine unit for verifying the consistency of the markup language format data to be converted and the fixed-length format data based on the data check parameter information,
The data check engine unit
A first step of reading fixed-length format data as check target data for each layer, and referring to the fixed length definition information table unit to determine whether the read check target data is the first layer;
When it is determined in the first step that the check target data is not the first hierarchy, a second determination is made as to whether the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data Process,
When it is determined in the second step that the hierarchy appearance order of the previous check target data is not equal to or less than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information A third step of determining whether or not a required hierarchy exists in the lower layer with reference to
When it is determined in the second step that the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information are A fourth step of referring to determine whether or not there is a required hierarchy between the hierarchy of the previous check target data and the current check target data hierarchy;
When it is determined in the first step that the check target data is the first layer, or when it is determined in the third step that an essential layer exists in the lower layer, or in the fourth step, the layer of the previous check target data When it is determined that the required hierarchy does not exist between the current check target data hierarchy, the data structure of the input data is determined to be consistent ,
When it is determined that mandatory hierarchy exists in the third step and the fourth step, and executes a data structure check process to determine that there is no consistent data contents of the input data,
Read markup language format data as check target data for each hierarchy, refer to the markup language definition information table section, and whether the check target data item satisfies the condition of the data attribute included in the data check parameter information A fifth step of determining
A sixth step of determining whether an item of data to be checked satisfies a condition for the number of data digits included in the data check parameter information ;
A seventh step of determining whether an item of data to be checked satisfies a condition of an essential flag included in the data check parameter information ;
When it is determined that the condition is not satisfied in any of the seventh step from said fifth step, to perform the data contents check processing to determine that there is no consistent data contents of the input data and the first feature.

In addition, the present invention provides a hierarchy name that constitutes fixed-length format data, a data start position corresponding to the hierarchy name, the number of data digits , a data attribute, an appearance order of the hierarchy name, and an essential flag indicating whether it is an essential item, A fixed-length definition information table part storing fixed-length data structure information including
Markup language data structure information including a hierarchy name constituting markup language format data, a tag name corresponding to the hierarchy name, the number of data digits, the order of appearance of the hierarchy name, and a mandatory flag indicating whether it is a mandatory item Stored markup language definition information table part,
A conversion definition information table part storing layer name correspondence information between the layer name of the markup language format data and the layer name of fixed-length format data;
Read fixed length data structure information stored in the fixed length definition information table section, markup language data structure information stored in the markup language definition information table section, and hierarchy name correspondence information stored in the conversion definition information table section Based on the read fixed-length data structure information, markup language data structure information, and hierarchy name correspondence information, the fixed-length format data is converted into markup language format data or the markup language format data is converted into fixed-length format data. Generating conversion parameter information for conversion, and determining whether the fixed-length format data and the markup language format data are consistent with the fixed-length data structure information and the markup language data structure information ; Data attributes and data of the fixed-length data structure information and markup language data structure information A parameter generating engine which generates a data check parameter information including the mandatory flag indicating whether the arranging order and required items for the number of hierarchical names,
A data check engine unit for verifying the consistency of the markup language format data to be converted and the fixed-length format data based on the data check parameter information,
A data conversion method in which a computer performs mutual conversion between markup language format data described in a markup language and fixed-length format data described with a data type and data digits fixed in advance,
In the data check engine section,
A first step of reading fixed-length format data as check target data for each layer, and referring to the fixed length definition information table unit to determine whether the read check target data is the first layer;
When it is determined in the first step that the check target data is not the first hierarchy, a second determination is made as to whether the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data Process,
When it is determined in the second step that the hierarchy appearance order of the previous check target data is not equal to or less than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information A third step of determining whether or not a required hierarchy exists in the lower layer with reference to
When it is determined in the second step that the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information are A fourth step of referring to determine whether or not there is a required hierarchy between the hierarchy of the previous check target data and the current check target data hierarchy;
When it is determined in the first step that the check target data is the first layer, or when it is determined in the third step that an essential layer exists in the lower layer, or in the fourth step, the layer of the previous check target data When it is determined that the required hierarchy does not exist between the current check target data hierarchy, the data structure of the input data is determined to be consistent ,
When it is determined that mandatory hierarchy exists in the third step and fourth step, the executing data structure check process to determine that there is no consistent data contents of the input data,
Read markup language format data as check target data for each hierarchy, refer to the markup language definition information table section, and whether the check target data item satisfies the condition of the data attribute included in the data check parameter information A fifth step of determining
A sixth step of determining whether an item of data to be checked satisfies a condition for the number of data digits included in the data check parameter information ;
A seventh step of determining whether an item of data to be checked satisfies a condition of an essential flag included in the data check parameter information ;
When it is determined that from the fifth step does not satisfy the condition in any of the seventh step, the second, characterized in that to execute the data contents check processing to determine that there is no consistent data contents of the input data.

  In the data conversion system and method according to the present invention, the data check engine compares whether the check target data is in the first layer and compares the hierarchy appearance order of the previous check target data with the hierarchy appearance order of the current check target data. Data structure check processing and check by determining whether there is no required hierarchy in the lower and lower layers, and whether the required hierarchy exists between the previous check target data hierarchy and the current check target data hierarchy. By executing the data content check process depending on whether the target data item satisfies the attribute condition, the digit number condition, or the item mandatory condition, it is possible to easily check the data format inconsistency before conversion.

1 is an overall configuration diagram of a data conversion system according to an embodiment of the present invention. The whole operation | movement flowchart of the data conversion system by this embodiment. The check processing operation | movement flowchart of the data conversion system by this embodiment. The figure for demonstrating inconsistency of the data format by this embodiment. The figure for demonstrating the data structure of the definition information by this embodiment. The figure which shows the specific example of the data structure of the definition information by this embodiment. The figure which shows the example of the code conversion table in the conversion definition information by this embodiment. The output flow figure of the check parameter by this embodiment. The conversion parameter output flow figure by this embodiment. The figure which shows the input data format work table by this embodiment. The figure which shows the conversion definition work table by this embodiment. FIG. 6 is a processing flow diagram of a structure check according to this embodiment. The processing flow figure of the item check by this embodiment. FIG. 5 is a process flow diagram of code list check according to the present embodiment.

  Hereinafter, a data conversion system for realizing a data conversion method according to the present invention will be described with reference to the drawings. First, data inconsistency which is a premise of the present invention will be described. For example, as shown in FIG. 4A, for example, a fixed-length data format in electronic commerce has a transfer header S first, and file headers A and B at one level below the transfer header S. These file headers A and B Is defined so that a slip header B is located in a lower layer of the slip header B, and a slip detail D is located in a lower layer of the slip header B. The inconsistency of data described in the present embodiment means that, for example, as shown in FIG. 4B, there is no slip header B (3) that should be present one step below the second row file header A (2), and slip This is a data format that does not match the definition shown in FIG.

[overall structure]
The data conversion system according to the present embodiment is included in, for example, an EDI system in electronic commerce. As shown in FIG. 1, the conversion parameter 201 and the data check parameter 302 are based on the definition information of the data format before and after the conversion. Data conversion definition setting system 100 that generates data, and data that converts input data (for example, fixed-length format data) 202 into output data (XML format data) 204 using the conversion parameter 201 generated by the data conversion definition setting system 100 The system includes a conversion system 200 and a data check system 300 that inputs the data check parameter 302 and the input data 202 and checks the consistency of the input data 202. In the present specification, hardware-like illustrations and explanations are given, but each of the above-described systems is constituted by data and programs stored in the memory of a computer.

[Data conversion definition setting system 100]
The data conversion definition setting system 100 includes a fixed-length definition information table unit 101 that stores fixed-length definition information in which electronic commerce data is defined in advance as a fixed-length data format, and electronic commerce data in advance as an XML data format. The XML definition information table unit 103 that stores the defined XML definition information, the conversion definition information table unit 102 that stores the conversion information between the fixed length definition information and the XML definition information, and the fixed length definition information table unit 101 Based on the stored fixed length definition information, the XML definition information stored in the XML definition information table unit 103, and the conversion information stored in the conversion definition information table unit 102, a conversion parameter 201 and a data check parameter 302 described later are generated. The parameter generation engine unit 104 is configured.

[Fixed length definition information table section 101]
The structure of the fixed length definition information stored in the fixed length definition information table section 101 is, for example, as shown in FIG. 5A, as a hierarchical name, “transfer header”, “file header”, “slip header”, “slip description”. It is defined as a data structure that it is a four-layer name, that each identification character is defined as “S”, “A”, “B”, and “D”, and that each record length is 256 bits. In the fixed length definition information table section 101, fixed length data item information of fixed length data corresponding to the item name is defined, for example, as shown in FIG. As shown, the start position of the item name “record classification” is defined as “1”, the length (number of digits) is “1”, and the attribute is “X”, and item information for other item names is also shown in the figure. It is.

[Conversion definition information table section 102]
As shown in FIG. 5B, the conversion information stored in the conversion definition information table unit 102 has a correspondence between the conversion source (fixed length format) and the definition name after conversion (XML format). "Name" is converted "Hierarchy name", Conversion source "Transfer header" is converted "SBDH", Conversion source "File header" is "Header", Conversion source "Slip header" is converted "Transaction", Conversion source " “Details of slip” are defined as corresponding to “details” after conversion. In the conversion definition information table unit 102, the item name and conversion information in the XML format after conversion corresponding to the item name in the fixed-length format of the conversion source are registered, which is shown in FIG. 6B, for example. As shown, the item name after conversion corresponding to the conversion source item name “slip number” is “detail number”, and the conversion information is “padded with zeros before (inserts zeros in empty digits higher than the number of digits. ) "Format, and information for other item names is also shown in the figure.

[XML definition information table section 103]
In the structure of the XML definition information stored in the XML definition information table section 103, as shown in FIG. 5 (b), each item of “tag name”, “appearance order”, “required or optional” for the hierarchy name is defined. For example, the tag name of the hierarchical name “SBDH” (Standard Business Document Header) is stored as “shStandardBusinessDocumentHeader”, the appearance order is “1”, and “essential flag”.
In this XML definition information table section 103, XML item information of classification information of tag name (XPath) / attribute / number of digits / required / arbitrary for item name is defined, for example, as shown in FIG. As shown, the tag name (XPath) of the item name “detail number” is defined as “data / list / item / lineNumber”, the attribute is “alphanumeric”, the number of digits is “maximum 4”, and the classification information is “required”. Item information for other item names is also shown in the figure. The XML definition information table unit 103 defines XML item information of tag information (XPath) / attribute / number of digits / required / arbitrary division information for an item name. For example, FIG. As shown in the table, the tag name (XPath) of the item name “detail number” is “data / list / item / lineNumber”, the attribute is “alphanumeric”, the number of digits is “maximum 4”, and the classification information is “essential”. Item information for other item names is also shown in the figure. Although omitted in FIG. 6C, the appearance order of the hierarchy names may be stored as numerical values in the same manner as in FIG.

  The “slipless category” in FIG. 6B indicates a category code that does not require a slip. For example, as shown in FIG. 7B, the code “01” is “slipless” (no paper slip exists). , Code “02” means “slip is present” (paper slip is present), and the conversion table before and after conversion is defined as the relationship between input and output as shown in FIG. 7A, for example. It is attached.

[Operation]
Next, an operation in which the data conversion system (EDI system) according to the present embodiment configured as described above converts fixed-length format data into XML format data will be described with reference to an operation flowchart.
[Consistency check of input data]
First, the consistency check operation of input data by the data conversion system according to the present embodiment will be described. In this consistency check operation, as shown in FIG. 2, the data check engine unit 301 of the data check system 300 reads the data check parameter from the data check parameter 302, and reads the one-layer data of the input data to be checked. In step S502, the structure of the read one-layer data is checked, and when it is determined that the data is inconsistent (NG), the process proceeds to step S508 to output an error log. In step S503, the structure check result is consistent. A step S504 for reading the one-layer data when it is determined to be present (OK), and an item check for the read one-layer data is performed, and a step S508 is performed when it is determined that there is a mismatch (NG). And the step When it is determined that there is consistency (OK) in 505, the code list is checked. When it is determined that there is inconsistency (NG), the process proceeds to step S508, and the data to be checked is at the end (lowermost layer). ), The process returns to step S502 when it is determined that it is not the end, and step S507 is executed to end the process when it is determined that it is the end.

  The data check system 300 according to the present embodiment reads the input data having a multilayer structure for each layer by executing the above-described steps, and executes each check of the structure, items, and code list of each layer, Inconsistency of input data can be determined.

[Data check parameter and conversion parameter generation]
Next, in the data conversion system according to the present embodiment, the data check system 300 performs data conversion (for example, conversion of fixed-length format data to XML format data) with reference to the conversion parameter by the conversion engine unit 203 described above. This conversion operation will be described with reference to FIG.
As shown in FIG. 3, in this conversion operation process, the parameter generation engine 103 of the data conversion definition setting system 100 reads fixed length definition information from the fixed length definition information table unit 101 and also reads XML definition information from the XML definition information table unit 103. , Step S102 for outputting the data check parameter 302 based on the read definition information, and the data check engine unit 301 input based on the fixed-length input data 202 and the data check parameter 302 described above. Step S103 for performing data check of data, Step S105 for determining whether or not the check result in Step S103 is normal (input data having no inconsistency), and checking when there is an abnormality in Step S105 Result , The process returns to step S102 after correcting the abnormal (inconsistent) portion of the input data, and when it is determined in step S105 that there is no abnormality (inconsistent), the conversion parameter 201 is converted into the conversion engine 201. The input data matching is performed by executing step S106 to be output to the unit 203 and step S107 in which the conversion engine unit 203 converts the input data 202 using the input conversion parameter 201 and outputs it as the output data 204. It can operate to perform data conversion after checking the sex.

[Data check parameter 302 output processing]
As shown in FIG. 8, the parameter generation engine unit 104 reads the fixed length definition information from the fixed length definition information table unit 101 and outputs the XML definition from the XML definition information table unit 103 as shown in FIG. Step S201 for reading information, and the read fixed length definition information and XML definition information in the input data check work table (temporary storage area on the memory not shown), and the information shown in FIG. Step S202 for storing and reflecting as hierarchical information, etc., and step for storing and reflecting the item definition information shown in FIG. 6 in item information such as attribute / number of digits / required or optional in the input data check work table S203 and each data stored in the input data check work table By executing the step S204 of outputting the content as a data check parameter 302 can be output as a data check parameter 302.

The information stored in the input data check work table in the step S201 is identification character / record length / appearance order / essential or arbitrary division information corresponding to the hierarchy name. For example, as shown in FIG. The identification name is “S”, the record length is “##”, the appearance order is “1”, and the classification is “required” for the hierarchy name “transfer header”, and the input data check work table is stored in step S202. Is stored in the element information corresponding to the item name. For example, as shown in FIG. 10A, the start position of the item name “product code group edition” is “6”, The length (number of digits) is stored as “12”, the input attribute is “9”, the output attribute is “alphanumeric”, the number of digits is “maximum 10”, and the required category is “arbitrary”. Element information is also shown .

[Conversion parameter 201 generation processing]
In the generation (output) process of the conversion parameter 201 in step S102, the parameter generation engine unit 104 reads the fixed length definition information from the fixed length definition information table unit 101 and also from the XML definition information table unit 103 as shown in FIG. Step S301 for reading the XML definition information, and storing and reflecting the read fixed length definition information and XML definition information in the conversion definition work table (temporary storage area on a memory not shown) as hierarchical information linked as described later. Step S302, step S303 for adding element information associated with each definition information to the conversion definition work table, and step S304 for outputting various information stored in the conversion definition work table as the data check parameter 302 are executed. To do.

  The hierarchy information stored in the conversion definition work table in the step S302 is each hierarchy information consisting of identification characters / record length / tag name (XPath) corresponding to the hierarchy name. As shown in FIG. , The identification character of the hierarchy name “transfer header” is stored as “S”, the record length is “##” (arbitrary value), the tag name (XPath) is stored as “shStandardBusinessDocumentHeader”, and the hierarchy information for other item names As shown.

The element information stored in the conversion definition work table in step S303 is element information consisting of start position / length (number of digits) / tag name (XPath) / conversion information corresponding to the item name, as shown in FIG. ), For example, the start position of the hierarchical name “slip line number” is “4”, the length (number of digits) is “3”, the tag name (XPath) is “data / list / item / lineNumber”, conversion Information is stored as “front zero”, and element information for other item names is also shown in the figure.

[Structure check processing in step S105]
Details of the structure check processing procedure of the input data 202 executed by the data check engine unit 301 in step S105 in the conversion process shown in FIG. 3 will be described with reference to FIG.
In this check processing procedure, when the data check engine unit 301 determines that the acquired one-layer information is not the first check in step S401 and the first check in step S401, as shown in FIG. Step S402 is executed to compare the hierarchy appearance order (number) of the previous check target hierarchy information with the hierarchy appearance order (number) of the current check target. The hierarchy appearance order is a predetermined appearance order (order) of each hierarchy of the data shown in FIG. 4. In the above-described step S402, the current hierarchy appearance order (for example, the second hierarchy) is set. Then, by determining whether or not (≧) is equal to or smaller than the previous hierarchy appearance rank (for example, the first hierarchy), it is determined whether the current hierarchy appearance rank is equal to or lower than the previous hierarchy appearance rank.

  Next, in this processing procedure, when it is determined in step S402 that the current hierarchy appearance rank (for example, the second hierarchy) is equal to or smaller (≧) than the previous hierarchy appearance rank (for example, the first hierarchy), that is, When the hierarchy rank is determined to be lower than the previous hierarchy rank, it is determined whether there is no required hierarchy between the previous hierarchy of the previous check target hierarchy data and the current check hierarchy, and it is determined that the required hierarchy does not exist In step S403, the process proceeds to step S406 where it is determined that the input data is inconsistent (NG). In step S402, the current hierarchy appearance rank (eg, the second hierarchy) is the previous hierarchy appearance order (eg, one hierarchy). Necessary hierarchy in the lower layer when it is determined that it is not equal to or smaller than the first), that is, when the current hierarchy rank is determined to be equal to or higher than the previous hierarchy rank (excluding the same rank) When it is determined that the data is present, the process proceeds to step S405 where it is determined that the data is consistent (OK). When it is determined that the data is not present, the input data is determined to be inconsistent (NG). Step S404 which moves to step S406 is executed.

As described above, in the check processing procedure according to the present embodiment, the data check engine unit 301 compares the current hierarchy appearance rank with the previous hierarchy appearance rank, and determines whether the current hierarchy appearance rank is lower than the previous hierarchy appearance rank. The first step to determine (step S402) and the second step to determine whether or not there is an indispensable hierarchy below the current check hierarchy when it is determined as higher by the determination in the first process (N in step S402) (Step S404) and when it is determined in the first step that the current hierarchy appearance rank is not lower than the previous hierarchy appearance rank, it is indispensable between the previous hierarchy and the current hierarchy. Performing a third step (step S403) for determining whether or not a hierarchy exists,
When it is determined in the second step that an essential layer does not exist in the structure definition information below the current check layer (N in step S404), or an essential layer exists between the previous layer and the current layer in the third step. When it is determined that the structure definition information exists (Y in step S403), it is checked that the input data is consistent, and in the second step, it is determined that an essential hierarchy exists in the structure definition information below the current check hierarchy. (Yes in step S404), or when it is determined in the third step that there is no required hierarchy in the structure definition information between the previous hierarchy and the current hierarchy (N in step S403), the input data is inconsistent You can check that there is.

[Item Check Processing in Step S105]
Details of the check process procedure of the input data 202 executed by the data check engine unit 301 in step S105 in the above-described check process of FIG. 3 will be described with reference to FIG.

  In this item check processing procedure, as shown in FIG. 13, the data check engine unit 301 determines whether or not the item of the input data satisfies the attribute information, and whether or not the item satisfies the digit number condition. Step S502 for determining and step S503 for determining whether or not the item of the input data satisfies the indispensable condition are executed, and when it is determined that any of the conditions in step S501 is not satisfied, the input data is inconsistent. When it is checked and it is determined that all the conditions of steps S501 to S503 are satisfied, it can be checked that the input data is consistent.

[Field list check]
The processing operation in step S506 for performing the code list check in FIG. 2 will be described with reference to FIG. In this code list check process, as shown in FIG. 14, first, whether one item information acquired in step S504 matches any of the corresponding item input values in the code conversion table (conversion definition information in FIG. 7A). The process proceeds to step S702 with consistency when it matches any of the corresponding item input values, and shifts to step S703 when it does not match any of the corresponding item input values. The code list check can be performed by executing step S701.

  Thus, the data conversion system and method according to the present invention includes:
  Fixed-length data structure including a hierarchy name constituting fixed-length format data, a data start position corresponding to the hierarchy name, the number of data digits, a data attribute, an appearance order of the hierarchy name, and a mandatory flag indicating whether it is a mandatory item Fixed-length definition information table section 101 storing information;
  Markup language data structure information including a hierarchy name constituting the markup language format data, a tag name corresponding to the hierarchy name, the number of data digits, the appearance order of the hierarchy name, and a mandatory flag indicating whether or not it is a mandatory item XML (markup language) definition information table section 103 storing
  A conversion definition information table unit 102 that stores layer name correspondence information between the layer name of the markup language format data and the layer name of fixed-length format data;
  Fixed length data structure information stored in the fixed length definition information table section 101, markup language data structure information stored in the XML (markup language) definition information table section 103, and hierarchy stored in the conversion definition information table section 102 Name correspondence information is read, and fixed length format data is converted into markup language format data or markup language format data based on the read fixed length data structure information, markup language data structure information, and hierarchy name correspondence information Conversion parameter information for converting data into fixed-length format data, and whether the fixed-length format data and markup language format data are consistent with the fixed-length data structure information and markup language data structure information Fixed-length data structure information and markup language data for determining A parameter generating engine 104 for generating a data check parameter information including the mandatory flag indicating whether the arranging order and required item of data attributes and data digits and hierarchical name concrete information,
  A data check engine unit 301 for verifying the consistency of the original markup language format data and the fixed-length format data based on the data check parameter information;
  The data check engine unit 301
  Step S401 for reading fixed-length format data as check target data for each layer and determining whether the read check target data is the first layer with reference to the fixed-length definition information table section;
  When it is determined in step S401 that the check target data is not the first hierarchy, it is determined whether the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data; ,
  When it is determined in step S402 that the hierarchy appearance order of the previous check target data is not equal to or less than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information are set. Step S404 for determining whether or not a required hierarchy exists in the lower layer with reference to,
  When it is determined in step S402 that the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data, refer to the hierarchy order and the mandatory flag included in the data check parameter information Step S403 for determining whether or not there is a required hierarchy between the previous check target data hierarchy and the current check target data hierarchy;
  When it is determined in step S401 that the check target data is the first layer, or when it is determined in step S403 that an indispensable layer exists, or in step S403, the previous check target data layer and the current layer When it is determined that the required hierarchy does not exist between the check target data hierarchy, it is determined that the data structure of the input data is consistent,
  When it is determined in step S404 and step S403 that an essential hierarchy exists, a data structure check process for determining that the data content of the input data is inconsistent is executed,
  Markup language format data is read for each layer as check target data, and the XML (markup language) definition information table section 103 is referred to. Step S501 for determining whether or not to satisfy,
  Step S502 for determining whether or not the item of data to be checked satisfies the condition for the number of data digits included in the data check parameter information;
  Step S503 for determining whether or not the item of data to be checked satisfies the condition of the mandatory flag included in the data check parameter information;
  When it is determined that the condition is not satisfied in any of Steps S501 to S503, a data content check process before the conversion is performed by executing a data content check process that determines that the data content of the input data is not consistent. It can be easily checked.

  100: Data conversion definition setting system, 101: Fixed length definition information table section, 102: Conversion definition information table section, 103: XML definition information table section, 104: Parameter generation engine section, 200: Data conversion system, 201: Conversion parameter 202: input data, 203: conversion engine unit, 300: data check system, 301: data check engine unit, 302: data check parameter table unit, 303: check result data.

Claims (2)

A data conversion system in which a computer performs mutual conversion between markup language format data described in a markup language and fixed-length format data described with a data type and data digit number fixed in advance,
Fixed-length data including a hierarchy name constituting the fixed-length format data, a data start position corresponding to the hierarchy name, the number of data digits , a data attribute, an appearance order of the hierarchy name, and a mandatory flag indicating whether it is an essential item A fixed length definition information table part storing structure information;
Markup language data structure information including a hierarchy name constituting the markup language format data, a tag name corresponding to the hierarchy name, the number of data digits , the appearance order of the hierarchy name, and a mandatory flag indicating whether or not it is a mandatory item Markup language definition information table section storing
A conversion definition information table part storing layer name correspondence information between the layer name of the markup language format data and the layer name of fixed-length format data;
Read fixed length data structure information stored in the fixed length definition information table section, markup language data structure information stored in the markup language definition information table section, and hierarchy name correspondence information stored in the conversion definition information table section Based on the read fixed-length data structure information, markup language data structure information, and hierarchy name correspondence information, the fixed-length format data is converted into markup language format data or the markup language format data is converted into fixed-length format data. Generating conversion parameter information for conversion, and determining whether the fixed-length format data and the markup language format data are consistent with the fixed-length data structure information and the markup language data structure information ; Data attributes and data of the fixed-length data structure information and markup language data structure information A parameter generating engine which generates a data check parameter information including the mandatory flag indicating whether the arranging order and required items for the number of hierarchical names,
A data check engine unit for verifying the consistency of the markup language format data to be converted and the fixed-length format data based on the data check parameter information,
The data check engine unit
A first step of reading fixed-length format data as check target data for each layer, and referring to the fixed length definition information table unit to determine whether the read check target data is the first layer;
When it is determined in the first step that the check target data is not the first hierarchy, a second determination is made as to whether the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data Process,
When it is determined in the second step that the hierarchy appearance order of the previous check target data is not equal to or less than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information A third step of determining whether or not a required hierarchy exists in the lower layer with reference to
When it is determined in the second step that the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information are A fourth step of referring to determine whether or not there is a required hierarchy between the hierarchy of the previous check target data and the current check target data hierarchy;
When it is determined in the first step that the check target data is the first layer, or when it is determined in the third step that an essential layer exists in the lower layer, or in the fourth step, the layer of the previous check target data When it is determined that the required hierarchy does not exist between the current check target data hierarchy, the data structure of the input data is determined to be consistent ,
When it is determined that the required hierarchy exists in the third step and the fourth step, a data structure check process for determining that the data content of the input data is inconsistent is performed,
Read markup language format data as check target data for each hierarchy, refer to the markup language definition information table section, and whether the check target data item satisfies the condition of the data attribute included in the data check parameter information A fifth step of determining
A sixth step of determining whether an item of data to be checked satisfies a condition for the number of data digits included in the data check parameter information ;
A seventh step of determining whether an item of data to be checked satisfies a condition of an essential flag included in the data check parameter information ;
The fifth step from the time it is determined that the condition is not satisfied in any of the seventh step, the data conversion system and executes the data contents check processing to determine that there is no consistent data contents of the input data. Fixed-length data structure including a hierarchy name constituting fixed-length format data, a data start position corresponding to the hierarchy name, the number of data digits , a data attribute, an appearance order of the hierarchy name, and a mandatory flag indicating whether it is a mandatory item Fixed-length definition information table section storing information;
Markup language data structure information including a hierarchy name constituting markup language format data, a tag name corresponding to the hierarchy name, the number of data digits, the order of appearance of the hierarchy name, and a mandatory flag indicating whether it is a mandatory item Stored markup language definition information table part,
A conversion definition information table part storing layer name correspondence information between the layer name of the markup language format data and the layer name of fixed-length format data;
Read fixed length data structure information stored in the fixed length definition information table section, markup language data structure information stored in the markup language definition information table section, and hierarchy name correspondence information stored in the conversion definition information table section Based on the read fixed-length data structure information, markup language data structure information, and hierarchy name correspondence information, the fixed-length format data is converted into markup language format data or the markup language format data is converted into fixed-length format data. Generating conversion parameter information for conversion, and determining whether the fixed-length format data and the markup language format data are consistent with the fixed-length data structure information and the markup language data structure information ; Data attributes and data of the fixed-length data structure information and markup language data structure information A parameter generating engine which generates a data check parameter information including the mandatory flag indicating whether the arranging order and required items for the number of hierarchical names,
A data check engine unit for verifying the consistency of the markup language format data to be converted and the fixed-length format data based on the data check parameter information,
A data conversion method in which a computer performs mutual conversion between markup language format data described in a markup language and fixed-length format data described with a data type and data digits fixed in advance,
In the data check engine section,
A first step of reading fixed-length format data as check target data for each layer, and referring to the fixed length definition information table unit to determine whether the read check target data is the first layer;
When it is determined in the first step that the check target data is not the first hierarchy, a second determination is made as to whether the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data Process,
When it is determined in the second step that the hierarchy appearance order of the previous check target data is not equal to or less than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information A third step of determining whether or not a required hierarchy exists in the lower layer with reference to
When it is determined in the second step that the hierarchy appearance order of the previous check target data is equal to or smaller than the hierarchy appearance order of the current check target data, the hierarchy order and the mandatory flag included in the data check parameter information are A fourth step of referring to determine whether or not there is a required hierarchy between the hierarchy of the previous check target data and the current check target data hierarchy;
When it is determined in the first step that the check target data is the first layer, or when it is determined in the third step that an essential layer exists in the lower layer, or in the fourth step, the layer of the previous check target data When it is determined that the required hierarchy does not exist between the current check target data hierarchy, the data structure of the input data is determined to be consistent ,
When it is determined that mandatory hierarchy exists in the third step and fourth step, the executing data structure check process to determine that there is no consistent data contents of the input data,
Read markup language format data as check target data for each hierarchy, refer to the markup language definition information table section, and whether the check target data item satisfies the condition of the data attribute included in the data check parameter information A fifth step of determining
A sixth step of determining whether an item of data to be checked satisfies a condition for the number of data digits included in the data check parameter information ;
A seventh step of determining whether an item of data to be checked satisfies a condition of an essential flag included in the data check parameter information ;
When it is determined that the condition is not satisfied in any of the fifth to seventh steps, it is determined that the data content of the input data is not consistent,
A data conversion method characterized by causing a data content check process to be executed.

Images