Research XML Data Management Based On Relational Database

XML has been the standard for information publication and exchange on the Web, substituting for HTML. Comparing to HTML, XML is simple, self-description, and the content, structure and representation of XML documents are independent, which makes XML more suitable for data representation and exchange on the Internet. Recently, XML has been widely used in various applications, and very large volumes of XML data have been appeared in the Web. To organize and manage XML data efficiently, several XML data management approaches have been proposed. Relational Database technology has been almost perfect and dominant in business data management area. How to use RDBMS to manage XML data is extensively studied in recent years. However, due to the differences between data models, RDBMS-based XML data management brings up numerous challenges for traditional database techniques.This paper has studied on storage and query technologies of XML data management based on RDBMS, especially focused on semantic preserving XML storage in relations and XML query based on XML view. The primary tasks of the paper are as follows:1) We summarize and classfiy XML storage approaches. There are three alternative schemas for storing XML data nowadays: file system, semi-structured data warehouse and data management system. We introduce them in details and then compare the advantages and disadvantages of them.2) We study on XML storage technologies based on RDBMS. Firstly, we analyze and compare the current and mainstream approaches for storing XML in RDBMS. Secondly, we introduce three transformation algorithms from DTD schema to relational schema. At last, we analyze DTD semantic constrains and present an algorithm which can capture and map these semantic constrains into relational schema.3) We study on XML query technologies based on RDBMS. At first, we discuss the current approaches for querying XML document which is stored in RDBMS. And then, based on XML view, we design an XQuery processing solution which gets good adaptability and extensibility, and provides convenience to users'query on XML document that is stored in RDBMS using XQuery.