Abstract:
This paper presents an algorithm and a strategy for mapping XML document to relational database based on analysis of some data mapping strategies. It avoids information loss in the process of data transfer and the problems in query and reconstruction caused by too many or too few relations in the transfer results. Example relation tables after transferring are given, which prove that the mapping strategy can solve the problems of element recursion efficiently and maintain the structure relationship between elements.
Key words:
XML document,
mapping,
relational database
摘要: 在分析已有数据映射策略的基础上,提出新的XML 文档到关系数据库存储的映射策略和算法,以避免在数据转换过程中丢失信息,解决在查询和重构时因转换结果中关系过多或过少带来的问题。结合实例给出转换后的关系表,从而证明该映射策略能有效处理元素的循环引用,并保留元素之间的结构关系。
关键词:
XML文档,
映射,
关系数据库
CLC Number:
LI Si-li; LI Juan. Strategy of Mapping XML Document to Relational Database[J]. Computer Engineering, 2010, 36(5): 40-42,4.
李思莉;李 娟. XML文档到关系数据库的映射策略[J]. 计算机工程, 2010, 36(5): 40-42,4.