期刊文献+

XML文档到关系型数据库的模型映射方法 被引量:4

Research of Model Mapping Method from XML Document to Relational Database
下载PDF
导出
摘要 基于XML的数据集成系统设计中XML文档的存储问题,提出一种由XML文档到关系型数据库的模型映射方法;所提出的连续标记方法,遍历XML文档树对所有节点进行标记编码,通过映射算法将节点数据映射到关系型数据库中。文中给出XML文档的数据模型、映射算法的设计和实验评估。实验结果表明,相比较现有的几种映射方法,该方法能有效地支持XML数据在关系型数据库中的存储和查询,实现高效的结构化查询,同时适用于任何模式的XML文档。 To solve the storage problem of XML documents in the design of a data integration system based on XML,this paper proposes a method of model-mapping from XML documents to relational database. By proposing a persistent labeling method,the paper makes coding for all the nodes by traversing XML documents tree,then nodes data would be mapped into relational database through mapping algorithm. Four aspects of data model of XML documents,design of the mapping algorithm and experimental evaluation results are discussed. The results of experiments show the effectiveness of this proposed method. Compared with the exiting methods,the new method can support storing and query XML data in relational database,and can realize efficient structured query and be a general solution for any schema of XML documents.
作者 史涛 沈艳霞
出处 《江南大学学报(自然科学版)》 CAS 2015年第5期590-595,共6页 Joural of Jiangnan University (Natural Science Edition) 
关键词 模型映射 XML文档 关系型数据库 算法 model-mapping XML document relational database algorithm
  • 相关文献

参考文献14

  • 1Femau H.Learning XML grammars[C]//7th International Conference,MLDM 2011.New York:[s.n.],2001,1:73-87.
  • 2袁景凌,徐丽丽,苗连超.基于XML的虚拟法异构数据集成方法研究[J].计算机应用研究,2009,26(1):172-174. 被引量:25
  • 3Haw S C,Lee C S,Node labeling schemes in XML query optimization:a survey and trends[J].IETE Technical Review,2009,26(2):88-99.
  • 4曹兰英,严义,邬惠峰.基于模式匹配的XML自动转换技术[J].计算机工程与应用,2012,48(25):72-76. 被引量:6
  • 5Florescu D,Kossmann D.Storing and querying XML data using an RDBMS[J].IEEE Data Engineering Bulletin,1999,22(3):27-34.
  • 6Shanmugasundaram J,Shekita E,Kieman J,et al.A general technique for querying XML documents using a relational database systems[EB/OL].http://citeseerx.ist.psu.edu/viewdoc/summary? doi =10.1.1.118.6801.
  • 7耿飙,宋余庆,梁成全,陈健美.XML文档到关系数据库映射方法的研究[J].计算机应用研究,2010,27(3):951-954. 被引量:21
  • 8LI Xuhui,ZHU Shanfeng,LIU Mengchi,et al.Presenting XML schema mapping with conjunctive-disjunctive views[J].Web-Age Information Management Lecture Notes in Computer Science,2013,7923:105-110.
  • 9Eun-Young Kim,Se-Hak Chun.New database mapping schema for XML document in electronic commerce[J].Multimedia and Ubiquitous Engineering,2013,240:353-358.
  • 10Clark J,Derose S.XML path language (Xpath) version 1.0[EB/OL].W3C Recommendation,http://www.w3.org/TR/ xpath,1999.

二级参考文献26

  • 1景娅萍.基于Web异构数据源的整合与集成[J].贵州教育学院学报,2004,20(4):72-73. 被引量:3
  • 2吴爱华,刘小玲,王洪,吴清茂.基于混合映射的XML数据的关系存储和查询[J].郑州大学学报(理学版),2007,39(2):157-160. 被引量:6
  • 3顾天竺,沈洁,陈晓红,李慧,张舒,吴颜.基于XML的异构数据集成模式的研究[J].计算机应用研究,2007,24(4):94-96. 被引量:40
  • 4ALBERT J. Data integration in the RODIN multidatabase system [ C]//Proc of the 1 st International Conference on Cooperative Information Systems. 1996:48-57.
  • 5DEUTSCH A, FERNANDEZ M, SUCIU D. Storing semistructured data with STORED[ C]// Proc of ACM SIGMOD Conference. 1999: 431 - 442.
  • 6BOHANNON P, FREIRE J, ROY P, et al. From XML schema to relations: a cost-based approach to XML storage[ C]//Proc of the 18th International Conference on Data Engineering. 2002: 64-75.
  • 7TATARINOV I, VIGLAS S, BEYER K, et al. Storing and querying ordered XML using a relational database system [ C ]//Proc of SIGMOD. 2002: 204-215.
  • 8SOLTAN S, RAHGOZAR M. A clustering-based scheme for labeling XML trees [ J]. International Journal of Computer Science and Network Security,2006,6(9A) : 84-89.
  • 9SHANMUGASUNDARAM J, TUFTE K, ZHANG Chun, et al. Relational database for querying XML documents : limitations and opportunities [C]//Proc of the 25th International Conference on Very Large Data Bases. 1999:302-314.
  • 10LEE D, CHU W W. CPI : constraint-preserving inlining algorithm for mapping XML to relational schema[J]. Data and Knowledge Engineering, 2001, 39( 1 ):3-25.

共引文献49

同被引文献32

  • 1任文明,舒振杰.飞机/悬挂物电气接口标准研究[J].航空标准化与质量,2013(2):18-21. 被引量:6
  • 2文龙.XML与非结构化数据管理[J].电脑知识与技术(过刊),2009,0(6):1306-1308. 被引量:13
  • 3於志勇,杨志义,於志文,李长德.XML数据存储方式的性能评价研究[J].计算机工程与应用,2006,42(17):171-173. 被引量:7
  • 4孙伟,刘大昕.一种XML代数及其查询优化方法[J].哈尔滨工程大学学报,2007,28(8):899-904. 被引量:4
  • 5Whittaker G. Improving performance of schemaless docu-ment storage in PostgreSQL using BSON [ J]. 2013.
  • 6Nolan D,Lang Duncan Temple. JavaScript,Object Notation[M] ‘ New York:Springer,2014:227-253.
  • 7Simon M, Christian R, Peter M, et al. XML and JSON[M], Hoboken:John Wiley & Sons,Ltd,2014:41-78.
  • 8Bharthan A,Bharathan D. Relational JSON,an enrichedmethod to store and query JSON records [ J] . InternationalJournal of Computer Applications,2014,98(7 ) :3-6.
  • 9罗正伟.一种XML与关系数据库的安全转换方法[P].CN103778147A,2014.
  • 10Chodorow K. Mongo DB:The definitive guide [ M]. 0Reil-ly Media, Inc ,2013.

引证文献4

二级引证文献3

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部