Research On XML-Based Data To Relational Database Storage

Since the mark language XML technology has been possible to expand to appear, having widespread support in many domains and having the broad application prospect. The XML key role manifests in the data exchange and sharing. Realizes the data transformation and the demonstration using the XML style language, may satisfy the user many kinds of demands. Although XML has many superiority, but has not displayed in the memory, How to save and manages the XML data has being become a research hot spot effectively.This article showed that XML and database union is ultimately, proposed a transformation frame from XML data to relational database. This transformation frame's main design concept divides into two parts, one is from Schema to the database mapping technology.it can store the XML data to the relational database.Another is the XML data's inquiry. This article launches the research in view of the three steps of this frame's work flow.First researching is the method in DTD to the Schema transformation. The first step is the DTD to Schema's transformation through translation table in DTD to Schema. The second is translation of primitive Schema to D_Schema through the element extraction algorithm, which can produces the new type through extracting elect the element, the complex element, the multiple-valued element and the group element. Through these work,we can build the Schema tree.Then we make a research on the XML documents to the relational scheme mapping algorithm. In this article, we study predecessor's theory achievement at first. Finding one kind of mapping algorithm product many data sheets and occupy so big data storage space, we propose this kind of improvement mapping algorithm. Use the Schema tree to transform the complex element into the data sheet, establish the main foreign key between each table through the father and son node's relation and retain the Schema various elements relations; In this way the Schema mapping becomes the relational table. And the data sheet's storage space is reduced.This article also proposes another one algorithm and establishes the Schema tree. Simultaneously each node of the tree was entrusted five attributes, then through this tree to carry on the search. This way took various elements and elements' relations of Schema to store the database directly , then stores the data of XML documents to the database through the depth-first search, this process only need produce two tables, compared with the data sheet produced by the first algorithm the storage space was smaller. Finally through JAVA language tool we realized the XML documents'analysis and the data to database.In example confirmation stage, uses XML water quality information of XML Schema's description for data source and selects SQL Server2000 relational database to realize the memory. The experiment indicated that we can store the relational scheme water quality information memory effectively by the use of the relational database's superiority.Finally, we propose the further work based on some existence questions of XML data storage.