Research Of XML Data Storage Technique In Relational Database

As powerful extensibility and self-description ability of XML, more and moredevelopers have employed it as the main mechanism for transforming data onnetworks. As a matter of fact, XML file is inherently a structure for storinginformation, and it incapable of processing all the date it holds. By transforming theXML data to relational data, and using the powerful data manipulation ability ofrelational database, we can get a considerable processing result.As an important target, many researchers have laid their attention on reducing theresponse time of data processing. Base on edge-mapping, this paper proposes an XMLdata storage mechanism. The mechanism can effectively transform the XML data tomore power relational data, specifically:(1) Different from the mechanism of separate-value-table, this paperspecifies and clarifies the document tree according to the node type ofthe XML document. By doing this, we can improve the reliability ofXML document reconstruction.(2) By employing the strategy of combining the order number and the pathof each node, we can specify the path information of each node. Thisfurther improves the performance for querying XML document.(3) At last, based on this storage mechanism we construct and implement adatabase prototype.This mechanism can effective reduce the size of underlying data storage;meanwhile reduce the response time of data processing. This mechanism can alsoimprove the accuracy when we come to reconstruct the XML document. Theexperimental results have show that our data storage mechanism and the constructeddatabase can effectively reduce the response time of data processing as well as reducethe size of data storage.