Font Size: a A A

A Storing And Querying Approach For XML Document Based On RDBMS

Posted on:2007-11-28Degree:MasterType:Thesis
Country:ChinaCandidate:H X DuanFull Text:PDF
GTID:2178360185451011Subject:Computer software and theory
Abstract/Summary:PDF Full Text Request
XML has already become the standards of the express, integration and exchange of the data on web. It has simple form and strong self-describing ability. Besides, it realizes the separation of the content, structure and exhibition, so it is more adapt to data express and exchange. During recent years, XML is widely used in various fields, and its data have abundantly appeared on web. In order to effectively analyze and process these XML data, researchers have proposed various query languages and storage managing techniques of XML. At present, because relational database is the most mature data-managing technique, XML data-processing which is based on relation, is obviously a feasible and prospective way among all ways of storing and managing XML data. And it attracts extensive attention in the academia. However, as the data models are different, using the relational database to access and query XML data challenges traditional database technique.This paper does a thorough research and discussion on the relational storage of XML data and the querying process of the path expression, and proposes a new approach to storage and query XML document using relational database, which can store the information of nodes with text-value in XML document tree and those without text-value in two different relational tables respectively. Neither does this approach interest in the DTD model, nor does it need to design any index structures.The main contributions of this paper are summarized as follows:(1)A new kind of path-based relational storage approach for XML document is put forward. It can completely record the information of each node, side, and value of a XML document. In other words, the information about name, id, parented, and level of each element, and the path information of all the attributes and elements that have text values are stored in relation tables, which accelerate the query and process.(2)A new query transformational algorithm based on table join is...
Keywords/Search Tags:XML, relational database, path expression, SQL, table join
PDF Full Text Request
Related items