Research On Storing XML Document Using Relational Databases

With the rapid development of internet and information technology,XML has become the important standard for information exchange anddenotation on the internet, thus that how to manage the XML document inan efficient, systematic and scientific way has become a great challenge inthe field of database study. By storing the XMLdocuments in the relationaldatabase, we can make full use of the mature data management skills ofrelationdatabase so as to integrate thelargeamount ofcommercial data thatis stored in the relational database. However, as the structure of tables inrelational database is greatly different from the hierarchy structure of XMLdocuments,itisdifficultfortherelational databasetostoreXMLdocumentseffectively while keeping its structure and document information. The coreissue of relation storage of XML documents based on schema is themappingbetweenXMLschemaandrelationalschema.This subject based on XML Schema intends to actualize relationstorage of XML documents by a close study on the mapping techniquebetween XML schema and relational schema. This paper mainly containsthe following aspects. First, it will analyze the storage theories andtechniques concerning XML documents both at home and abroad. Then, itwill focus on the relation storage of XMLdocuments. Moreover, this paper put forward a mapping method to convert the XML Schema into therelational schema. Given the characteristics of all kinds of XML modules,this method manages to keep the completeness and semantic restriction ofits schema information, thus it achieves the transformation between modelssuccessfully. In addition, this method also succeeds in storing XMLdocuments effectively by taking the features of these documents such ashierarchy, gradation, and restriction into consideration. As to the efficiencyof relational storage, this paper studies the matching and updatingtechniques of XML Schema and finally comes up with a feasible way tosolve the problem. Finally, this paper will set up a prototypic system, whichwill not rely on the specific operational system and relational databaseplatform, based on the mapping theory that we have mentioned above.Thissystem testifies the structural mapping arithmetic based on XML Schema,thusitwouldbeveryhelpfultorelationalstorageofXMLdocuments.