Research on Storage and Query of XML in Rational Database
|School||Harbin Engineering University|
|Course||Applied Computer Technology|
|Keywords||XML DTD XML Query Relational Model|
With the vigorous development of internet, the traditional data-exchanging manner of HTML can not meet the need of increasing data. Because of the character of XML, which includes platform independence, easy for expansion, better interaction, abundance semantic, well formatted, XML has already become an emerging standard for information exchange on the WWW, The number of documents published in form of XML has been rapidly growing . It is becoming of great importance on how to store and query XML documents.The thesis analyze three approaches for storing and querying XML data, and compare the difference between traditional relational-database and XML. Because of the merits of relational-database, which includes mature technique , abroad application, easy for expansion, better interaction, abundance semantic, well formatted,well ability for control data, security, so we decide to choose the method that store XML document to relational DB.This is also one hotspot on research XML.The major challenges of this approach include: one aspect, XML data model needs to be mapped into the target model namely the relational model. The thesis research several method and developed an efficient method which takes an XML DTD as input and produces a relational schema as output for storing and querying XML documents conforming to the input DTD. The method features several significant improvements over the presence method including completeness, eliminating redundancies enhancing efficiency and so on. The other aspect, queries posed in XML query languages need to be translated into ones in the relational query languages as SQL, the query results from the target database engines need to be published back to XML format.