Method and system for transferring data between MIME attachments and relational databases
A method and a system for the transfer of data contained in an electronic message, in particular a MIME attachment, to a relational database comprising the steps of providing an XML sequence, which determines, how the data is to be processed, executing a sequencer, which takes the message and the XML sequence as input, wherein the executing of the sequence comprises the execution of at least one SQL statement for accessing the relational database.
1. A computer-implemented method for the transfer of data contained in an electronic message, in particular a MIME attachment, to a relational database comprising:
utilizing a computer to perform:
a. providing a plurality of predefined SQL templates, wherein each predefined SQL template comprises a SQL statement and at least one parameter;
b. providing an XML sequence, which determines how the data is to be processed, wherein the XML sequence is an XML file comprising at least one XML statement corresponding to at least one of the plurality of predefined SQL templates;
c. executing a sequencer, which is a computer program comprising executable code, wherein said executing the sequencer comprises the steps of loading the message, loading the XML sequence, and executing the XML sequence, wherein said executing the XML sequence by the sequencer comprises:
loading the at least one predefined SQL template;
using the data derived from the message as parameter values of the SQL template to provide at least one executable SQL statement; and
executing the at least one SQL statement for accessing the relational database.
2. The method of claim 1 , wherein the execution of the at least one SQL statement provides output data, and wherein the output data are stored as data in an output message.
3. The method of claim 1 , wherein the output data comprise a first and a second parameter, wherein the value of the first and the second parameter are stored in the message body and the attachment of the output message, respectively.
4. A non-transitory computer accessible memory medium storing program instructions for transferring data from a message, in particular a MIME attachment, to a relational database, wherein the program instructions are executable to implement:
a. a plurality of predefined SQL templates, wherein each predefined SQL template comprises a SQL statement and at least one parameter;
b. an XML sequence, which determines how the data is to be processed, wherein the XML sequence is an XML file comprising at least one XML statement corresponding to at least one of the plurality of predefined SQL templates;
c. a sequencer, which is a computer program comprising executable code adapted to load the message, to load the XML sequence, and to execute the XML sequence, wherein, when executing the XML sequence, the sequencer is further adapted to;
load the at least one predefined SQL template;
use the data derived from the message as parameter values of the SQL template to provide at least one executable SQL statement; and
execute the at least one SQL statement for accessing the database.
5. The non-transitory computer accessible memory medium of claim 4 , wherein the sequencer is further adapted to store data provided by the execution of the at least one SQL statement as output data in an output message.
6. The non-transitory computer accessible memory medium of claim 5 , wherein the output data comprise a first and a second parameter, and wherein the sequencer is further adapted to store the value of the first and second parameter in the message body and the attachment of the output message, respectively.