Implementation Of Storing And Querying On Xml Documents In Relational Database

In recent years, the emergence of a Web of XML data for oneself, XML format describes ability, simple structure, content, and the performance of separation, in every field is widely used. XML has become the data on the Web, integration and exchange of standard. Based on the relational database query technique is stored and storage and query XML ways in the most mature a data management technology. Many scholars have proposed a variety of XML query and storage management methods to XML data processing, analysis and effective treatment.Because the XML document storage in the relational database with inquires from all aspects of the existed problems, this article launched thorough research and discussion. Puts forward a solution. This method is not establish any index structure, also need not consider the XML document information. The pattern DTD But will the XML document tree all nodes of information stored in a relationship.Specifically, this paper made the following main job:1. Puts forward a kind of relationship with different storage method, this method is based on the path of the XML document data storage method, it is a complete record the data in an XML document that all information, a storage structure model of relationship between the XML document, the specific storage in an XML document, edge, and each node in the value of information, namely the relation table in various elements and attributes of id, name, xlevel, attribute, parentid, xvalue cdata, and all of the element or attribute information, reduced the path connecting, enhance the inquiry list of efficiency.2. Puts forward a kind of query processing mechanism, this method based on the table above applies to connect and storage method is given, and the corresponding algorithm of conversion. This algorithm can be converted to the corresponding path expression to the SQL statement. 3. Puts forward a method of storing and query mechanism of optimization strategy. If the XML document, you will have more levels of the same path of storage redundant phenomenon, when the store when the relation table into a path path, can avoid the situation, If the XML data query expressions for linear structure of the path, in order to reduce the number of connection form, can use string matching method, also can reduce the number of input and output.4. Through constructing and storage system verify this thesis storage conversion and query processing algorithm, using online collection of different size XML document instance document storage time tested and response time, and finally the data with data demonstrate that the method is feasible and efficient.