为实现XML数据到关系数据库的映射,提出一种基于模型的映射方案,可以将任何一个格式良好的XML文档存储到结构固定的关系模式中,实现结构互异的XML文档的固定关系模式存储,不受DTD变化的约束,同时在存储的过程中自动插入节点的Dewey编码及深度。利用JDOM提取XML文档信息数据,给出了附加Dewey编码的映射算法实现,实验结果表明该方案设计合理、有效。
In order to realize the mapping from XML data to relational database, a mapping scheme is proposed,in which any well-formed XML documents can be stored in a relationship mode of the fixed structure tc realize the mode storage of the fixed relationship for XML documents with different structures, which is not affected by the constraints of DTD changes. Meanwhile, the Dewey coding and depth of the node are automatically inserted in the storage process. The XML document information can be extracted by using JDOM, the additional Dewey coding mapping algorithm is given, and the results indicate that the design is reasonable and effective.