An XUpdate2SQL Update Scheme Based On Relational Database

XML is a text and document markup language, and has a good scalability. At present, more and more applications use the XML standard to store information. These XML documents need a stable and efficient storage and management tool, especially a update management tool. Relational database with its mature, stable, efficient and many other advantages is used to store and manage XML data. There are two problems using relational database to manage XML data: how to store XML data from XML model into a relational mode; how to translate XML language into SQL language. This thesis will study the second issue.This thesis analyzes many research results about the XML language to the SQL language translation and finds there are two questions:(1) In the current XML languages, researchs about XUpdate (update language) to SQL language are not yet ripe.(2)In these researchs, the translation from XUpdate (updated language) to SQL language is for a particular storage mode, which means storage mode of production is fixed. If the storage mode needs to change, the cost will be relatively large. This limitation makes the research unflexible.As a result, this thesis will study the translation from XUpdate to SQL.This thesis will propose and realize a XUpdate2SQL update scheme based on relational database. The proposed scheme is a much convenient scheme,it mainly resolves two issues:(1) The realization of the translation from XUpdate to SQL language. The scheme provides a complete XUpdate to SQL translation algorithm, and the SQL language fits the SQL-92 standard, with good versatility.(2) Provied a method to resovle the fixed storage mode. The scheme designs a series of interface to the storage module, the language translation algorithm can only obtain the storage information by the interface, this seperates the storage module and translation module. When the storage module needs to change, there is no need to change the translation algorithm and so that the scheme will have a much smaller price adjustment.In addition, the author realizs the scheme to a real update system. According to the update scheme, the author modifys a query system that has been achieved by our laboratory and realizes a real update system that fits the scheme design in this thesis. The update system is in accordance with the design requirements and supports the translation from XUpdate to SQL, and enables users with a smaller price to adjust the storage mode.Finally, this thesis has a comprehensive assessment of the scheme and system and proposes the next step needs to carry out deep research.