XML数据在关系数据库中存储和检索的研究和实现

Research and implementation of storing and retrieving the XML data in RDBMS

论述了关系型数据和XML数据之间的相互转换 ,给出了将XML数据存储在关系数据库和将存储在关系数据库的XML数据恢复为XML形式的算法 .由于实际数据类型的复杂性 ,使用Schema来定义XML文档类型 .试验结果表明算法具有较好的性能 .讨论了将XMLQL查询语句转换为SQL查询语句的设计 ,根据文中XML数据存储在关系型数据库中的算法 ,可以对XMLQL查询语句的语法、语义进行分析以转换为相应形式的SQL语句来在关系数据库中查询被存储的XML数据 。

The conversion of relational data into XML and vice versa is expounded and an algorithm of converting XML data to relational data and recovering the data back to XML format is presented. Because of the complexity of data type in use, Schema is adopted to define the XML document type. The experiment shows that the algorithms have good performance. The problem of converting XMLQL into SQL is also discussed. According to the XML data storing algorithms mentioned in this paper,it is enabled to analyze the syntax and semantics of the XMLQL query and convert it into SQL to query stored XML data in the RDBMS, which can return to the dataset accordingly.