Study On The Techniques Of Storing XML Data By Relational Schema

The technologies on WWW are the fastest developed technologies on Internet. There are plenty of data on Web now, most of them are of HTML format. And it is sure that there will be more and more data appearing on Web, but most of them will be of XML format. How to store and query XML data efficiently is becoming urgent. Because the database technologies are highly developed, it's natural to store XML data in databases. And the basic principle is to process the storage by mapping the XML data mode into the database data mode. But all of the methods differ in detail for the different databases in use. The relational database is the most mature and popular database technology nowadays. The relational database is chosen as the database environment for storing XML data, and the research focuses on the method for mapping the XML data mode to relational mode.There are some files which descript the mode or structure of XML data, such as DTD, XML Schema, XDR or SOX and so on. DTD and XML Schema are the most popular ones. Although DTD is the dominant XML data mode description file, it is certain that XML Schema will be the main XML mode file in the near future. The XML Schema file is selected as the XML mode/structure description file.Based on the analysising all the research of storing XML data in relational databases home and abroad, a model is proposed which is for storing XML data in relational databases by XML Schema, and the steps to make it is put forward whereafter. Then a algorithm on mode mapping is given. In the end, this model is implemented in a project name AMS which is developed in Microsoft .NET framework.