Research On SQL-To-XQuery Conversion System Based On Web Service

The data is stored in RDB traditionally, along with XML becoming the standard of theexchange of information and the sharing of data in the network, many merchants promote theproducts which support XML, because the current information system exists in theorganization such as ERP system mostly established on relational database managementsystem which has high stability and high maturity, the sharing of the two kind of data becomesan important topic. On the research of SQL and XQuery based on domestic and foreignpresent situations, a Sql-To-XQuery system model based on web service is presented, whichcan exchange the data between the information system based on relational database and theXML data.Firstly, the architecture of web service is presented, and two kind of query languagesSQL and the XQuery are analyzed, the analysis is carried on from six aspects such as thecomplete restraint, the mapping dictionary which needed by the conversion system model isbased on these differences mainly.Secondly, format and the establishment process of the mapping dictionary are presented.Thirdly, the algorithm and the algorithmic analysis of the conversion model are presented.For the assistance of conversion process, several sets are designed, then a series of conversionprinciples are carried on to these sets, thus the goal of converting query sentence isachieved.When the SQL query sentence request is sent from the system based on the relationaldatabase information system to the conversion model, the conversion model will be able tocarries out the conversion mechanism stored in the mapping dictionary beforehand, andconvert the SQL sentence to the XQuery sentence in the same meaning.Finally, the conversion model is presented. This conversion system is applied to Germanreal estate analysis system and supply chain based on RosettaNet, and the efficiency of theconversion system is analyzed.