Xpostgresql For Xml Support Strategy

With more and more XML application coming forth, the support for XML is becoming a very important part of the DBMS function. This paper brings forward XPostgreSQL, the new version PostgreSQL completely supporting XML, and introduces the strategies on the support for XML of the XPostgreSQL from three aspects, XML documents storage and query in RDB, the transformation from the XML documents to relational data and the transformation vice versa.And, in the process of discussing the collection storage of the XML documents in RDBMS, a novel model-mapping approach named XAS is proposed, which describes the general mapping relationship between relational schema and XML schema. In XAS, data type SliderorderPath is used to store the hierarchy and sequential information of XML documents; and with the help of a group of functions defined on the type SlideorderPath, XAS can easily manipulate SlideorderPath., So many demerits of Model Mapping methods existed are avoided. Finally, this paper also presents the arithmetic that translates the XPath queries to SQL queries in XAS.