JP2001034513A - Method and device for data conversion, and storage medium storing data conversion program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make executable the data conversion processing regardless of the data item name or the element name of a data form of the converting destination by inputting the text data including the tag information and the data defined by the tag information and outputting the text data after converting them according to a data rule while referring to a data conversion rule that is previously made to correspond to the tag information according to the tag information. SOLUTION: A data conversion program 120 reads a tag name out of an extracted data transfer area 160, retrieves a table name made to correspond to the tag name in a mapping definition information area 170 and writes the table name into a table insertion data area 182. Then the program 120 produces the data which are stored in a table column to a pair of an attribute name and attribute value stored in the area 160. furthermore, the program 120 produces the data which are stored in a column to correspond to the text data existing between the opening and closing tags. In this example, 'PRODNAME' corresponds to the text data, is paired with 'refrigerator' and then is written.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a data conversion method and device for converting text data described in a tagged language such as XML into a data format of a database, and a storage medium storing a data conversion program.

[0002]

2. Description of the Related Art At present, the Internet has become widespread worldwide, and has begun to be used not only as a means for sending and receiving e-mails and for browsing home pages, but also as a means for e-commerce between companies. Since companies around the world are connected to the Internet, it is thought that if e-commerce can be realized on the Internet, opportunities for acquiring new customers and increasing orders will dramatically increase.

In order to realize electronic commerce on the Internet, it is necessary for each company to be able to exchange slip data for electronic commerce between information systems constructed for performing ordering and other tasks. However, each information system is composed of computer systems provided by different manufacturers, and interfaces for inputting and outputting slip data are not unified. Therefore, slip data must be exchanged between computer systems of different manufacturers.

In order to realize the exchange of data between computer systems of different manufacturers, it is convenient to use text data as an intermediate format. This is because text data can be created and its contents can be confirmed by a general text editor program, so that a program for sending and receiving text data can be easily created and tested, and the development cost can be kept low.

Conventionally, CSV (Comma Separated Value) has been used as a text file format for exchanging data between computer systems of different manufacturers.
e) format has been used. In particular, CSV format files are widely used for exchanging data between databases of different manufacturers. Read the file in CSV format,
As a method of storing in a database, for example,
There is a method disclosed in U.S. Pat.
When the data of the database table is represented using the CSV format, one file corresponds to one table, one line of the file corresponds to one record of data, and a character string separated by a comma is a column. Corresponding to C
In the SV format file, data of a plurality of records belonging to a single table is stored in one file. Therefore, data of all records stored in one table of a database is transferred to a table of another database. It is convenient for cases. However, in order to send and receive data that collectively stores data to be stored in a plurality of tables, such as slip data for one order, C
SV format is not suitable. In order to represent the slip data for one order to be stored in a plurality of tables in CSV format, it is necessary to store the data in a plurality of CSV format files corresponding to each table, which is inconvenient. It is.

An XML (extensible Markup) is used as a format suitable for expressing a set of data to be stored in a plurality of tables in text.
Attention is being paid to markup languages such as Language. XML is SGML (Standard Ge).
neutralized Markup Language)
And HTML (Hyper Text Markup La)
As in the case of the nuggage), the data structure is expressed by using tags enclosed by '<' and '>'. In XML, a tag set which is a list of tag names and attribute names to be used is determined according to the type of data to be described. Each item of data to be exchanged is described as text between tags or attribute values.

In order to store data in an XML document in a database, an XML document storage program for extracting data items from the structure of the XML document and storing the data items in a predetermined table of the database is required. Such an X
As a method of creating an ML document storage program, Nikkei B
P. Nikkei Byte, January 1999, p. There are methods listed at 130. In this method, X is set according to the XML tag set to be handled and the storage destination table.
Create an ML document storage program individually. The created XML document storage program is a program dedicated to a specific tag set and a storage destination table structure.

[0008]

However, the above prior art has the following problems. That is, in the above-described conventional technology, it is necessary to implement a dedicated XML document storage program for each tag set and each storage destination table, which causes a problem that the development cost increases.

The present invention has been devised in view of the above-described problems, and solves the above-mentioned problems, and enables conversion processing regardless of the data item name or the element name of the data format of the conversion destination.
It is an object to provide a general-purpose data conversion method and apparatus.

[0010]

In order to solve the above-mentioned problems, a data conversion method provided by the present invention is a data conversion method for extracting and outputting data from text data. A tag that is a character string having an arbitrary number of attribute name and attribute value pairs, and tagged text data that is text data having plain text data that is non-tag text data as a first input, Mapping definition information, which is definition information that specifies a conversion rule between the tagged text data and the output data, is used as a second input, and the conversion target is converted from the tagged text data according to the specification of the mapping definition information. Processing target data acquisition processing, which is processing for retrieving processing target data that is the data to be processed, and converting the processing target data into the mapping definition information A process target data output process, which is a process of outputting according to the specification, is executed. In the process target data output process, process target data identification information that is information for identifying the process target data and the process target data itself are output. Like that.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS First Embodiment An embodiment of the present invention will be described below in detail with reference to the drawings.

The present invention provides a plurality of data conversion methods having different functions as data conversion methods for solving the above-mentioned problems. In the first embodiment, a first data conversion method will be described.

An object of the first data conversion method is to provide a data conversion method capable of performing a conversion process only by defining the correspondence between the structure of an XML document as a conversion source and a table of a database as a conversion destination. That is.

The data conversion method provided by the present invention is realized as an XML document storage program which is a program on a general-purpose computer. According to the present invention, the user has X
If only the mapping definition information, which is the definition information referred to by the ML document storage program, is prepared, the data in the XML document can be converted into a record in the database table without creating a dedicated XML document storage program.

First, a system configuration of a computer 10 on which an XML document storage program 100, which is a program implementing a data conversion method provided by the present invention, operates will be described with reference to FIG.

In FIG. 1, the computer 10 is connected to a network 17 and a disk device 16. Calculator 1
0 is a main storage device for storing programs and data areas, and a CPU 12 for performing arithmetic processing.
, A communication interface 13 for performing communication processing with the network 17, a disk interface 14 for controlling the disk device 16, and a bus 15 for connecting the above elements.

An XML document 200, which is an input of the XML document storage program 100 in the main storage device 11, is read via the network 17 (60) or from the disk device 16 (62). Further, the XML document storage program 100 outputs the table 4 on the disk device 16 as an output.
A record is inserted into 10 (64).

The main storage device 11 has the following components:
A business process is executed by taking the order document process as an example, and a business program 140 that uses the XML document storage program 100 as a part of the process, and an XML document 200 that is started by the business program 140 and receives a table 410
Document storage program 100 for controlling the entire process of inserting a record into XML document, and XML document storage program 10
It has a data extraction program 110 which is a subroutine called from 0, a data conversion program 120 and a data output program 130. Further, it has a parameter transfer area 150 which is a work data area, an extracted data transfer area 160, an output data transfer area 180, and a mapping definition information area 170 which is a data area for definition information.

Next, each subroutine on the main storage device 11 will be described. Data extraction program 11
Reference numeral 0 denotes a subroutine for parsing an input XML document. The data extraction program 110 performs syntax analysis using the XML document 200 as an input, detects syntax elements such as tags and attributes, and detects and detects each syntax element.
Syntax data, which is character string data such as the tag name, attribute name, attribute value, and text other than the tag, is extracted. The extracted syntax data is stored in the extracted data transfer area 160. The data extraction program 110 inputs the XML document 200 via the communication interface 13 (61) or the disk interface 14 (63).

The data conversion program 120 is a subroutine for creating data to be inserted into a table based on data in an XML document. Data conversion program 120
Creates the table insertion data, which is the data to be stored in a table or the like, according to the mapping definition information stored in the mapping definition information area 170, using the syntax data stored in the extracted data transfer area 160 as an input. Output data transfer area 1 for inserting data
Output to 80.

The data output program 130 is a subroutine for outputting converted data. In the present embodiment, a database table is taken as an example of an output destination of converted data. The data output program 130 is a subroutine that stores the table insertion data created by the data conversion program 120 in a data structure such as a database table. In this embodiment, the data output program 130 inserts a record into a table such as the table 410 according to the table insertion data stored in the output data transfer area 180. The data output program 130 may be replaced with a program that outputs converted data to another data structure or program.

Next, each data area on the main storage device 11 will be described.

The parameter transfer area 150 is a work area for storing parameters transferred between the business program 140 and the XML document storage program 100.

The extracted data transfer area 160 is an XML
A work area for storing syntax data extracted from a document, which is written by the data extraction program 110 and referenced by the data conversion program 120.

The mapping definition information area 170 contains XML
A data area that stores mapping definition information that is definition information of the correspondence between the syntax elements of the document and the components of the table. The data area is set in advance prior to the start of the XML document storage program 100.
0 refers.

The output data transfer area 180 is a work data area for storing table insertion data, written by the data conversion program 120 and referenced by the data output program 130.

The computer 10 is configured as described above.

The disk device 16 has a table storage area 4 for storing a series of tables including a table 410.
00. Further, the disk device 16 may store the XML document 200.

Next, the operation flow of a series of programs will be described. When the business program 140 started in advance stores the location of the input XML document 200 in the parameter transfer area 150 and starts the XML document storage program 100, the XML document storage program 100 is composed of three subroutines. The data extraction program 110, the data conversion program 120, and the data output program 130 are sequentially activated. The data extraction program 110 reads the XML document 200 whose location is specified as an input, performs syntax analysis, and stores the syntax data as a result in the extracted data transfer area 160. Next, the data conversion program 120 receives the syntax data as an input, and
The table insertion data is created in accordance with the mapping definition information stored in the output data transfer area 180. Finally, the data output program 130 receives the table insertion data as input, and
0, a record is inserted into the table 410.

With the above series of operations, the XML document 200
Is stored as a record in the table 410.

Next, the processing content of the XML document storage program 100 will be described with reference to FIG. FIG. 2 is a PAD showing a processing procedure of the XML document storage program 100.

First, the XML document storage program 100 activates the data extraction program 110 to detect a syntax element of the XML document 200, and stores the syntax data of the detected syntax element in the extracted data transfer area 160 (101). . Next, the data conversion program 120 is started, syntax data is read from the extracted data transfer area 160, table insertion data is created based on the mapping definition information stored in the mapping definition information area 170, and the output data transfer area 140 is created. (102). Finally, the data output program 130 is started, the table insertion data is read from the output data transfer area 180, and a record is inserted into the table 410 (103).

According to the above procedure, a series of processes from reading an XML document to inserting records in a table are executed.

Next, the processing procedure of the data conversion program 120 will be described with reference to FIG. In this embodiment, the data conversion program 120 implements a first data conversion method among a plurality of data conversion methods provided by the present invention.

FIG. 3 shows the principle of the first data conversion method.

The first data conversion method is characterized in that a table name is determined based on a tag name and a column name is determined based on an attribute name.

The data conversion program 120 stores the table insertion data in the table insertion data area 182 on the output data transfer area 180 from the syntax data stored in the extracted data transfer area 160 according to the following procedure.

First, the data conversion program 120 reads a tag name from the extracted data transfer area 160, searches the mapping definition information area 170 for a table name corresponding to the tag name, and searches for the table name. Write to the table insertion data area 182. In FIG. 3, “ORDER” is added to the tag name “order details”.
The table name “ITEM” is associated (1
000), “ORDERITEM” is written in the table name area 402 on the table insertion data area 182 (1004).

Next, data to be stored in the columns of the table is created for the set of the attribute name and the attribute value stored in the extracted data transfer area 160. In FIG.
"ORDERID" for attribute name "order number"
(1001) and the attribute value is “O501001”, the column name area 4
03 and the column name “ORDERID” in the column value area 4
04 and the attribute value “O501001” is written as a set (1005). Similarly, the column name “AMOUNT” is associated with the attribute name “NUMBER” (1002), and the attribute value is “10”. The attribute value "10" is written as a group in the value area 404 (1006).

Next, data to be stored in the column is created corresponding to the text data between the opening tag and the closing tag. In FIG. 3, the text data between the opening and closing tags of the tag “Order Details” is “PRO
The column name “DNAME” is associated with (1
003), "Electric refrigerator" as the syntax data of the corresponding location
Is stored in the column name area 40
3 is assigned the column name “PRODNAME” and the column value area 4
04 is written as a set of syntax data “electric refrigerator” (1007). The above data stored in the table insertion data area 182 is
0 is inserted into the table 410 by the data output program 130 started after 0. In the case of the data example of FIG. 3, "ORDERI" is stored in the ORDERITEM table.
A record in which the values of the columns “D”, “AMOUNT”, and “PRODNAME” are “O501001”, “10”, and “electric refrigerator” is inserted.

The above is the processing procedure of the first data conversion method. According to the above procedure, depending on the contents of the definition stored in the mapping definition information area 170, data in an XML document having an arbitrary tag name or attribute name can be replaced with an arbitrary table name or column name. It can be stored in a table. That is, according to the above procedure, if the user prepares only the mapping definition information to be referred to by the XML document storage program, the data in the XML document can be stored in the record of the database table without creating a dedicated XML document storage program. Can be converted to
The purpose of the first data conversion method is achieved.

<< Second Embodiment >> Next, a second embodiment will be described.

In the second embodiment, of the plurality of data conversion methods provided by the present invention, the second data conversion method will be described.

The purpose of the second data conversion method is to be able to specify the type of data format conversion processing for syntax data in an XML document. If this can be realized, for example, when expressing the amount of money in the slip data as an XML document, the data is described in a format such as an integer with a comma, and the data is stored in the integer type column of the table. It is possible to specify such a data format conversion process.

In the present embodiment, the second data conversion method is implemented as a program that operates on a computer system having the same configuration as that of the first embodiment. The only difference between the first embodiment and the present embodiment lies in the way in which the mapping definition information is provided to the data conversion program and the processing procedure of the data conversion program. Hereinafter, these differences will be described.

In the second data conversion method, the specification of the type of data format conversion processing to be applied to the syntax data is stored in advance in the mapping definition information area 170 in association with the syntax element in the XML document. It is characterized in that the format is converted from the syntax data format to the data format to be stored in the table by the data format conversion processing of the following types.

The processing procedure of the second data conversion method will be described below with reference to FIG.

FIG. 4 is an operation principle diagram of the second data conversion method.

In the present embodiment, the second data conversion method implemented by the data conversion program 120 specifies a data format conversion process corresponding to a syntax element in addition to the processing contents of the first data conversion method. The feature is that it can be done.

The data conversion program 120 stores data in the table insertion data area 182 on the output data transfer area 180 from the syntax data stored in the extracted data transfer area 160 according to the following procedure.

First, the data conversion program 120 reads a tag name from the extracted data transfer area 160, searches the mapping definition information for a table name corresponding to the tag name, and inserts the searched table name into the table. Write to the table name area 402 on the data area 182. In FIG. 4, since the table name “ORDERITEM” is associated with the tag name “order details” (2000), “ORDERITE” is added to the table name area 402 on the table insertion data area 182.
M "is written (2005).

Next, data to be stored in the columns of the table is created for the set of the attribute name and the attribute value stored in the extracted data transfer area 160 and the text data between the open tag and the close tag. At this time, if the data format conversion process is specified, the specified data format conversion process is executed. In FIG. 4, data format conversion processing is not specified for the two attribute names “order number” and “part number”, and the attribute names and the attribute values are similar to those in the first embodiment. The corresponding data is stored in the column name area 403 and the column value area 404 (2001, 2002, 2006, 2007). However, for the attribute name “money”, “PRICE” is associated as a column name, and (2)
003), “integer with comma” is specified as the type of data format conversion processing (2004). Therefore, according to the specification, the attribute value “1,000” is regarded as an integer with a comma, and is converted into an integer. The column name “PRICE” is stored in the column name area 403, and the converted value “ 1000 "as a set (20
08).

The above is the processing procedure of the second data conversion method. According to the above procedure, if the type of the data format conversion process is stored in the mapping definition information area 170 in association with the syntax element, the XM having an arbitrary input format is stored.
The data in the L document can be appropriately converted in format based on the data format conversion process, and the converted result can be stored in a table having an arbitrary table name or column name. That is, according to the above procedure, the purpose of the second data conversion method is achieved.

Third Embodiment Next, a third embodiment will be described.

In the third embodiment, a third data conversion method among a plurality of data conversion methods provided by the present invention will be described.

The purpose of the third data conversion method is the following two points.

A first object is to allow, as data to be stored in a table, data passed from a business program as an input parameter in addition to syntax data in an XML document. If this can be realized, XML
Although it is not described in the XML document itself, such as the time at which the document was registered, it is possible to store data that should be stored in the business design in the table.

A second object is to enable, in addition to a table, an output parameter to be returned to a business program to be specified as a storage destination of data described in an XML document. If this can be realized, of the data described in the XML document, the data such as the creator of the document that is desired to be used not only for storing in the table but also for displaying the screen in the business program should be passed to the business program. Becomes possible.

In the present embodiment, the third data conversion method is realized as a program that operates on a computer system having the same configuration as that of the first embodiment. The difference between the first embodiment and the present embodiment is that the mapping definition information is given to the data conversion program 120, the processing procedure of the data conversion program 120, and the data stored in the parameter transfer area 150. is there.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

Hereinafter, the processing procedure of the third data conversion method will be described with reference to FIG.

FIG. 5 is an operation principle diagram of the third data conversion method.

In FIG. 5, the parameter transfer area 15
0, an input parameter area 152 that stores input parameters passed from the business program 140 to the XML document storage program, and a parameter output area 151 that stores output parameters passed from the XML document storage program to the business program 140. It is provided.

The third data conversion method has two features.

A first feature is that data stored in the parameter input area 152 can be stored in a table in addition to syntax data which is data described in an XML document. The data in the parameter input area 152 is set to a value before the business program 140 activates the XML document storage program. This achieves the first purpose of the third data conversion method.

The second feature is that the extracted data transfer area 1
The point is that the syntax data extracted from 60 can be output to the parameter output area 151 in addition to the table insertion data area 182. Thereby, the second object of the third data conversion method is achieved.

In the present embodiment, an example of implementation in which the above two features are realized at the same time is shown. However, both can be realized independently, and only one of them can be realized.

In the present embodiment, the data conversion program 120 implements the third data conversion method having the above-described features. According to the following procedure, the syntax data stored in the extracted data transfer area 160 With the parameters stored in the parameter input area 152 as input, data is output to the table insertion data area 182 and the parameter output area 151.

First, in the same manner as in the first data conversion method, the data conversion program 120 converts the data corresponding to the tag name, the attribute name, and the attribute value into the table insertion data 182 according to the specification stored in the mapping definition information area 170. (3001, 3002).

Next, the specified element of the column value area 404 is written to the parameter output area 151 in accordance with the specification of the mapping definition information area 170. In FIG.
The column value for the “ORDERID” column is written in the parameter output area 151 (3003).

Next, in accordance with the specification in the mapping definition information area 170, the contents of the parameter input area 152 are written in the column name area 403 and the column value area 404 in association with the specified column name. In FIG. 5, the designated column name is “DATE” and the parameter input area 15
2 is “1999-07-19”, the column name “DATE” is stored in the column name area 403 and the column value area 4
04, the contents of the parameter input area 152 "1999-07
-19 "is written as a set (3004).

The above is the processing procedure of the third data conversion method. According to the above procedure, as data to be stored in the table, in addition to the data described in the XML document,
It is possible to specify data passed from a business program as an input parameter. Also, XML
As a destination for storing the data described in the document, it is possible to specify an output parameter to be returned to the business program in addition to the table. That is, according to the above procedure, the two objects of the third data conversion method are achieved.

Fourth Embodiment Next, a fourth embodiment will be described.

In the fourth embodiment, a fourth data conversion method among a plurality of data conversion methods provided by the present invention will be described.

The purpose of the fourth data conversion method is not to use syntax data in an XML document as it is as data to be stored in a table, but to pass the syntax data to a program prepared by a user once, To perform an arbitrary conversion process and store the resulting value in a table. If this can be realized, special data format conversion specific to business programs,
It is possible to use a user program that executes automatic numbering processing for key columns of records stored in the database.

In the present embodiment, the fourth data conversion method is implemented as a program that operates on a computer system having the same configuration as that of the first embodiment. The first embodiment differs from the present embodiment in three points, namely, how to provide mapping definition information for a data conversion program, the processing procedure of the data conversion program, and data stored in a parameter transfer area.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

Hereinafter, the processing procedure of the fourth data conversion method will be described with reference to FIG.

FIG. 6 is an operation principle diagram of the fourth data conversion method.

In FIG. 6, a user callback program 500 is provided as one of the components constituting the business program 140. The user callback program 500 is a subroutine called by the data conversion program 120, and is prepared by the user as a part of the business program 140. The counter 501 is an example of a variable used by the user callback program 500.

In this embodiment, the parameter transfer area 15
0 is a callback input parameter area 153 for storing input parameters for calling the user callback program 500;
And a callback output parameter area 154 for storing the output parameters returned from.

In the fourth data conversion method, a user callback program 500 which is a subroutine prepared by the user can be called from the data conversion program 120 in order to achieve the above object.
Further, as the components of the mapping definition information, the specification of the callback input parameter, which is the input parameter to be passed to the user callback program 500, and the storage destination of the callback output parameter, which is the output parameter returned from the user callback program 500, The feature is that the designation is added.

The syntax data to be passed to the callback input parameter can be specified in any format as long as the corresponding element can be specified from among the plurality of syntax data stored in the extracted data transfer area 160. For example, it is possible to have a user specify an attribute name and pass an attribute value corresponding to the attribute name as an input parameter.

As the designation of the storage destination of the callback output parameter, a column name to be passed to the column name area 403 on the table insertion data area 182 can be used.

Any number of callback input parameters and callback output parameters may be used.

FIG. 6 shows an example of an automatic numbering process as an example of a process executed by the user callback program 500. That is, the user callback program 500 manages the counter 501 for numbering, increases the value of the counter each time it is called, and outputs a character string in which the value of the counter is connected to the data passed as the callback input parameter. are doing.

In the present embodiment, the data conversion program 120 implements the fourth data conversion method having the above-described features, and performs the following procedure based on the syntax data stored in the extracted data transfer area 160. , And outputs data to the table insertion data area 182.

First, similarly to the first data conversion method, the data conversion program 120 converts syntax data corresponding to tag names, attribute names, and attribute values into the table insertion data according to the specification stored in the mapping definition information area 170. Area 1
82 (4001, 4002, 4003).

Next, the syntax data to be passed as the callback input parameter is stored in the extraction data transfer area 160 according to the specification stored in the mapping definition information area 170.
And stored in the callback input parameter area 153 (4004). In FIG. 6, a character string “O501” is stored as an example of the syntax data.

Next, the user callback program 50
0 and activates the process prepared by the user with the data of the callback input parameter area 153 as input (4).
005), and stores the processing result in the callback output parameter area 154 (4006). In FIG.
As an example of processing executed by the user callback program 500, a character string "O501-131" in which a hyphen and a serial number "131" held by the counter 501 are output after the input character string "O501" is output. I have.

Next, the callback output parameter area 15
4 in the table insertion data area 18 according to the specification stored in the mapping definition information area 170.
2 is stored. In FIG. 6, the value of the callback output parameter area 154 is “O501-131”, and the column name specified on the mapping definition information area 170 is “SEQ”.
“EQ” is written in the column value area 404 as a set of the value “O501-131” of the callback output parameter area 154 (4007).

The above is the processing procedure of the fourth data conversion method. According to the above procedure, data described in an XML document is not directly stored as data to be stored in a table, but is passed once to a program prepared by a user, and arbitrary conversion processing is performed in the program. It is possible to store the value after application. That is, according to the above procedure, the object of the fourth data conversion method is achieved.

<< Fifth Embodiment >> Next, a fifth embodiment will be described.

In the fifth embodiment, of the plurality of data conversion methods provided by the present invention, the fifth data conversion method will be described.

The purpose of the fifth data conversion method is to be able to determine a table name of a database to be stored in a set of a tag name, an attribute name, and an attribute value. If this can be realized, it is possible to add the type of the table of the storage destination by the difference of the attribute value of the tag, without increasing the type of tag used in the XML document, using the already defined tag name as it is Becomes

In the present embodiment, the fifth data conversion method is realized as a program that operates on a computer system having the same configuration as in the first embodiment. The fifth embodiment is different from the fifth embodiment only in the way of providing mapping definition information to the data conversion program and in the processing procedure of the data conversion program.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

In the following, the processing procedure of the fifth data conversion method will be described with reference to FIG.

FIG. 7 is an operation principle diagram of the fifth data conversion method.

In the present embodiment, the data conversion program 120 implements the fourth data conversion method, and, based on the syntax data stored in the extracted data transfer area 160, according to the following procedure, 18
2 to output the data.

The data conversion program 120 first reads a set of a tag name, an attribute name, and an attribute value from the extracted data transfer area 160, and sets a table corresponding to the tag name, the attribute name, and the attribute value in the mapping definition information. A name is searched, and the searched table name is written in the table insertion data area 182. In FIG. 7, “CO_ORDE” is assigned to a set of a tag name “order slip”, an attribute name “customer type”, and an attribute value “corporation”.
R "is associated with the table name (500
0), “CO_ORDER” is written in the table name area 402 on the table insertion data area 182 (5003).

Next, data to be stored in the columns of the table is created for the pair of the attribute name and the attribute value stored in the extracted data transfer area 160. In FIG.
“CUSTCOD” for the attribute name “Company code”
E ”is associated with the column name (500
1) Since the attribute value is “1234”, “CUSTCODE” is set in the column name area 403 and the column value area 404
Is written with the attribute value "1234" as a set (5
004). Similarly, the column name “CUSTNAME” is associated with the attribute name “Company name” (5002), and the attribute value is “Company A”, so the column name “CUSTNAME” is added to the column name area 403. The attribute value “company A” is written in the column value area 404 as a set (5005).

The above is the processing procedure of the fifth data conversion method. According to the above procedure, if table names are stored in the mapping definition information area 170 in association with sets of tag names, attribute names, and attribute values, the types of tags used in the XML document can be increased. Instead, it is possible to use the already defined tag name as it is and add the type of the storage destination table depending on the attribute value of the tag. That is, according to the above procedure, the object of the fifth data conversion method is achieved.

<< Sixth Embodiment >> Next, a sixth embodiment will be described.

In the sixth embodiment, of the plurality of data conversion methods provided by the present invention, the sixth data conversion method will be described.

The purpose of the sixth data conversion method is to obtain a value to be stored in one record of a table from only a single tag in an XML document and to specify a value from a single tag as a reference. That is, it can be obtained from another tag having a relative positional relationship. If this can be realized, it becomes possible to store, in a predetermined column of a predetermined table, an attribute value of a tag that can be specified by specifying a relative position such as “tag one step outside” when viewed from a reference tag.

In the present embodiment, the sixth data conversion method is realized as a program that operates on a computer system having the same configuration as in the first embodiment. The only difference between the first embodiment and the present embodiment lies in the way in which the mapping definition information is provided to the data conversion program and the processing procedure of the data conversion program.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

Hereinafter, the processing procedure of the sixth data conversion method will be described with reference to FIG.

FIG. 8 is an operation principle diagram of the sixth data conversion method.

In the sixth data conversion method, in specifying the association between the syntax element stored in the mapping definition information area 170 and the column, another tag located at the specified relative position with the tag to be stored in the record as the starting point The feature is that the above syntax element can be specified.

In the present embodiment, the data conversion program 120 implements the sixth data conversion method having the above-described characteristics, and outputs the data from the syntax data stored in the extracted data transfer area 160 according to the following procedure. Data is stored in the table insertion data area 182 on the data transfer area 180.

The data conversion program 120 firstly, according to the specification stored in the mapping definition information area 170, converts the syntax data corresponding to the tag name, attribute name, and attribute value into the table insertion data, as in the first data conversion method. Area 1
82 (6000, 6001, 6002, 60
04, 6005, 6006).

Next, as syntax data to be stored in a column, acquisition of syntax data on another tag at a specified relative position from a reference tag is specified in the mapping definition information area 170. In this case, the specified syntax data is obtained based on the specified data, and the data corresponding to the table insertion data area 182 is stored. FIG.
In, as part of the process of inserting the record corresponding to the “order detail” tag into the “ORDERITEM” table, the syntax data to be stored in the “CUSTNAME” column is viewed from the reference order “order detail”. The "order slip" tag (600
8), it is specified to be acquired from the “company name” attribute (6003). Therefore, the syntax data “Company A”, which is the value of the “Company Name” attribute, is added to “CUSTNAM”.
The column name area 403 is associated with the column name “E”.
And added to the column value area 404 (600
7).

The above is the processing procedure of the sixth data conversion method. According to the above procedure, if the column name is stored in the mapping definition information area 170 in association with the combination of the tag name and the relative position specification and the attribute name, the attribute value of the tag searched by the relative position specification Can be stored in a table having an arbitrary table name or column name. That is, according to the above procedure, the purpose of the sixth data conversion method is achieved.

<< Seventh Embodiment >> Next, a seventh embodiment will be described.

In the seventh embodiment, of the plurality of data conversion methods provided by the present invention, the seventh data conversion method will be described.

The purpose of the seventh data conversion method is to allow the serial number of such a tag to be stored in a designated column when the same tag appears successively. If this can be realized, even if the serial number of the tag is not described in the XML document, the serial number of the automatically assigned tag is used for storage in a predetermined column of a predetermined table or delivery to a user program, and the like. It is possible to do.

In the present embodiment, the seventh data conversion method is realized as a program that operates on a computer system having the same configuration as that of the first embodiment. The only difference between the first embodiment and the present embodiment lies in the way in which the mapping definition information is provided to the data conversion program and the processing procedure of the data conversion program.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

FIG. 9 is an operation principle diagram of the seventh data conversion method.

In FIG. 9, the data conversion program 12
0 automatically assigns the tag serial number when extracting the tag name from the extracted data transfer area 160 (60
0). In this embodiment, the data conversion program 120
Implements the seventh data conversion method having the above characteristics, and extracts the extracted data transfer area 1 according to the following procedure.
The data is output to the table insertion data area 182 based on the syntax data stored in 60.

The data conversion program 120 firstly, in accordance with the specification stored in the mapping definition information area 170, converts the syntax data corresponding to the tag name, attribute name, and attribute value into the table insertion data, as in the first data conversion method. Area 1
82 (7000, 7001, 7002, 70
04, 7005, 7006).

Next, the serial number of the tag automatically numbered by the data conversion program 120 is stored in the table insertion data area 1
Write to 82. In FIG. 9, a column name “SEQ” is associated with a serial number corresponding to a tag “order details” (7003), and the serial number value is “2”. “SE
“Q” is written in the column value area 404 as a set of serial number values “2” (7007).

The above is the processing procedure of the seventh data conversion method. According to the above procedure, if the column name is stored in the mapping definition information area 170 in association with the serial number of the tag, even if the serial number of the tag is not described in the XML document, it is automatically taken. The serial number of the numbered tag can be used for storage in a predetermined column of a predetermined table, delivery to a user program, and the like. That is, according to the above procedure, the purpose of the seventh data conversion method is achieved.

<< Eighth Embodiment >> Next, an eighth embodiment will be described.

In the eighth embodiment, an eighth data conversion method among a plurality of data conversion methods provided by the present invention will be described.

The purpose of the eighth data conversion method is to treat a plurality of consecutive tags as a group and to insert syntax data on the plurality of tags into a table as one record. If this can be achieved,
It is possible to represent a repeating element by a set of tags that appear in a predetermined order, and store the attribute value of each tag as a single record in a predetermined table.

In this embodiment, the eighth data conversion method is realized as a program that operates on a computer system having the same configuration as that of the first embodiment. The only difference between the first embodiment and the present embodiment lies in the way in which the mapping definition information is provided to the data conversion program and the processing procedure of the data conversion program.

In the following, these differences will be described, and description of the same points as in the first embodiment will be omitted.

The processing procedure of the eighth data conversion method will be described below with reference to FIG.

FIG. 10 is an operation principle diagram of the eighth data conversion method.

In the present embodiment, the data conversion program 120 implements an eighth data conversion method. The data conversion program 120 executes the following procedure, based on the syntax data stored in the extracted data transfer area 160, in the table insertion data area. 18
2 to output the data.

The data conversion program 120 first reads a set of tag names from the extracted data transfer area 160, searches the mapping definition information 170 for a table name corresponding to the set of tag names, and searches the table. The table name is written into the table insertion data area 182. In FIG. 10, a table name “ORDERITEM” is associated with a set of tag names “product number” and “quantity” (8000), so that the table name area 402 on the table insertion data area 182 “ORD
ERITE ”is written (8003).

Next, in the same manner as in the first data conversion method, according to the specification stored in the mapping definition information area 170, tag names, attribute names, attribute values, and text data between an open tag and a close tag are handled. The syntax data is stored in the table insertion data area 182 (8001, 8002, 8
004, 8005).

The processing procedure of the eighth data conversion method has been described above. According to the above procedure, if a table name is stored in the mapping definition information area 170 in association with a set of tag names, a group of syntax data expressed by a plurality of tags can be stored in one record. Can be inserted into any table. That is, according to the above procedure, the purpose of the eighth data conversion method is achieved.

According to these embodiments, the user does not need to implement a dedicated XML document storage program for each of the tag set and the storage destination table, and the development cost can be reduced.

[0138]

According to the present invention, it is possible to perform a conversion process in which the data item name and the element name in the data format of the conversion destination are less dependent.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a computer system to which the present invention is applied.

FIG. 2 is a PAD diagram of an XML document storage program 100;

FIG. 3 is an operation principle diagram of a first data conversion method.

FIG. 4 is an operation principle diagram of a second data conversion method;

FIG. 5 is an operation principle diagram of a third data conversion method.

FIG. 6 is an operation principle diagram of a fourth data conversion method;

FIG. 7 is an operation principle diagram of a fifth data conversion method;

FIG. 8 is an operation principle diagram of a sixth data conversion method.

FIG. 9 is an operation principle diagram of a seventh data conversion method.

FIG. 10 is an operation principle diagram of an eighth data conversion method.

[Explanation of symbols]

10 Computer, 11 Main Storage Device, 12 Central Processing Unit, 13 Communication Interface, 14 Disk Interface, 15 Bus, 16 Disk Device, 17
Network, 100 ... XML document storage program, 1
10: Data extraction program, 120: Data conversion program, 130: Data output program, 140: Business program, 150: Parameter transfer area, 151 ...
Output parameter area, 152 ... input parameter area, 153
... Callback input parameter area, 154 ... Callback output parameter area, 160 ... Extraction data transfer area, 170 ... Mapping definition information area, 180 ... Output data transfer area, 182 ... Table insertion data area
200 XML document, 400 Table storage area, 40
2 ... Table name area, 403 ... Column name area, 404 ...
Column value area, 410: table, 500: user callback program, 501: counter, 600: tag serial number

Continuing from the front page (72) Keiichi Katsukura, Inventor 5030 Totsuka-cho, Totsuka-ku, Yokohama-shi, Kanagawa Prefecture F-term in the Software Division, Hitachi, Ltd. 5B075 ND03 ND35 NK02 NK13 NK43 NK49 NK54 UU05 5B082 GA02

Claims (16)

[Claims] 1. Text data including tag information and data defined by the tag information is input, and a data conversion rule previously associated with the tag information is referenced based on the tag information. A data conversion method for converting and outputting the data based on the data. 2. The data conversion method according to claim 1, wherein
A data conversion method, wherein the processing target data identification information is represented by a combination of hierarchical identification information. 3. The data conversion method according to claim 2, wherein
A data conversion method, wherein a combination of the hierarchical identification information includes a table name and a column name. 4. The data conversion method according to claim 2, wherein identification information specified in the mapping definition information in association with the tag name is included in the processing target data identification information. Data conversion method. 5. The data conversion method according to claim 2, wherein the identification information specified in the mapping definition information in association with the combination of the tag name and the attribute name is replaced with the data to be processed. A data conversion method characterized by being included in information. 6. The data conversion method according to claim 2, wherein in the processing target data output processing, the processing target data is output in the mapping definition information instead of outputting the output target data itself. A data conversion method characterized by outputting format-converted data to be processed, which is data resulting from applying a specified format conversion process. 7. The data conversion method according to claim 2, wherein the data to be processed includes, in addition to the tagged text data, a parameter passed from a user in an input. Conversion method. 8. The data conversion method according to claim 2, wherein in the processing target data output processing, the processing target data is output to a data area prepared by a user. . 9. The data conversion method according to claim 2, wherein, in the processing target data output processing, the processing target data is specified in the mapping definition information instead of outputting the output target data itself. A data conversion method, wherein the data is passed to a user program, and data processed by the user program, which is output data of the user program, is output. 10. The data conversion method according to claim 2, wherein the identification information associated with the combination of the tag name, the attribute name, and the attribute value in the mapping definition information is processed by the processing. A data conversion method characterized by being included in target data identification information. 11. The data conversion method according to claim 2 or 3, wherein a tag as a base point and a tag at a relative position specified in the mapping definition information from the tag as the base point are determined by the tag. A data conversion method characterized by acquiring conversion target data. 12. The data conversion method according to claim 2, wherein, in the processing data acquisition processing, a serial number of a tag to which the processing data to be acquired belongs is output. 13. The data conversion method according to claim 2, wherein a plurality of continuous tags specified in the mapping definition information are treated as a unit. 14. The data conversion method according to claim 1, wherein the tag name, a tag which is a character string having an arbitrary number of pairs of attribute names and attribute values, and a plain text which is text data other than the tags. The first input is tagged text data that is text data having data, and the second input is mapping definition information that is definition information that specifies a conversion rule between the tagged text data and output data. In accordance with the specification of the mapping definition information, a processing target data acquisition process for extracting processing target data that is data to be converted from the tagged text data is executed. A process target data output process, which is a process of outputting according to the designation, is executed. In the process target data output process, the process target data output process is performed. A data conversion method characterized by outputting processing target data identification information as information for identifying data and the processing target data itself. 15. A means for inputting text data including tag information and data defined by the tag information, and referring to a data conversion rule previously associated with the tag information based on the tag information, Means for converting and outputting the data based on a rule. 16. Text data including tag information and data defined by the tag information is input, and a data conversion rule previously associated with the tag information is referred to based on the tag information. A computer-readable storage medium storing a data conversion program for converting and outputting the data based on the data.