作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2010, Vol. 36 ›› Issue (5): 40-42,4. doi: 10.3969/j.issn.1000-3428.2010.05.015

• 软件技术与数据库 • 上一篇    下一篇

XML文档到关系数据库的映射策略

李思莉1,李 娟2   

  1. (1. 成都理工大学工程技术学院计算机科学系,乐山 614007;2. 遵义医学院医学工程系,遵义 563000)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2010-03-05 发布日期:2010-03-05

Strategy of Mapping XML Document to Relational Database

LI Si-li1, LI Juan2

  

  1. (1. Department of Computer Science, Engineering & Technical College Chengdu University of Technology, Leshan 614007;
    2. Department of Medical Engineering, Zunyi Medical College, Zunyi 563000)
  • Received:1900-01-01 Revised:1900-01-01 Online:2010-03-05 Published:2010-03-05

摘要: 在分析已有数据映射策略的基础上,提出新的XML 文档到关系数据库存储的映射策略和算法,以避免在数据转换过程中丢失信息,解决在查询和重构时因转换结果中关系过多或过少带来的问题。结合实例给出转换后的关系表,从而证明该映射策略能有效处理元素的循环引用,并保留元素之间的结构关系。

关键词: XML文档, 映射, 关系数据库

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

中图分类号: