一种改进的基于表的模型驱动映射策略研究
A Research on Improved Table-Based Model-Driven Mapping Strategies
DOI: 10.12677/SEA.2016.52017, PDF, HTML, XML, 下载: 1,740  浏览: 4,721  科研立项经费支持
作者: 韩 昱:山西省高速公路收费管理结算中心,山西 太原;吕进来:太原理工大学计算机科学与技术学院,山西 太原
关键词: XML Schema模型驱动数据交换基于表的映射XML Schema Model-Driven Data Exchange Table-Based Mapping
摘要: 为解决数据交换过程中,数据从数据库到XML的映射问题,对目前广泛使用的模型驱动映射方法进行了分析研究。对基于表的模型驱动映射方法进行改进,提出结合XML Schema的基于表的模型驱动映射方法,并制定了映射规则。这种改进的映射方法很好地保留了关系数据库表的结构特性和约束条件。还对映射过程中因参照关系而需有序插入数据的现象,提出了表插入优先计算方法。
Abstract: To solve the problem of mapping database to XML during data exchange process, the currently widely used model-driven mapping method has been analyzed and studied. The table-based model-driven mapping method has been improved, and a combination of this method with XML Schema is proposed. And mapping rules have been developed. This improved mapping method can preserve the structural characteristics of relational database tables and constraints better than others. On the other hand, to solve the data inserting sequence problem caused by reference between data in different tables during mapping process, a table data inserting priority calculating algorithm has been proposed.
文章引用:韩昱, 吕进来. 一种改进的基于表的模型驱动映射策略研究[J]. 软件工程与应用, 2016, 5(2): 154-163. http://dx.doi.org/10.12677/SEA.2016.52017

参考文献

[1] 陈爱华. 基于XML和WebService的异构数据库数据交换研究[J]. 软件工程师, 2011(5): 56-58.
[2] 周长宝. 基于XML的制造业应用软件异构异构数据库集成技术研究[D]: [硕士学位论文]. 哈尔滨: 哈尔滨理工大学, 2012.
[3] Xing, G.M., Xia, Z.H. and Ernest, A. (2007) Building Automatic Mapping between XML Documents Using Approximate Tree Matching. Proceedings of the ACM Symposium on Applied Computing, 525-526.
[4] Della Penna, G., Di Marco, A., Intrigila, B., Melatti, I. and Pierantonio, A. (2014) Interoperability Mapping from XML Schemas to ER Diagrams. Data and Knowledge Engineering, 59, 166-188.
http://dx.doi.org/10.1016/j.datak.2005.08.002
[5] 曹虎. 基于XML的异构数据库集成中间件技术研究[D] : [硕士学位论文]. 哈尔滨: 哈尔滨工程大学, 2009.
[6] 綦娜娜. 基于XML的数据库转换技术研究[D] : [硕士学位论文]. 济南: 山东大学, 2011.
[7] 吕晓妮. 基于XML的异构数据集成技术研究与中间件开发[D]: [硕士学位论文]. 青岛: 山东科技大学, 2011.
[8] 崔静, 翟玉梅. 基于XML技术的异构数据集成研究[J]. 商丘职业技术学院学报, 2011, 10(2): 32-34.
[9] 张亚军, 华一新, 赵军喜. 基于模型驱动的态势显示研究[J]. 测绘科学技术学报, 2010, 27(4): 289-293.
[10] 姚全珠, 白敏, 黄蔚. 基于模型映射方法实现与关系数据的相互转换[J]. 软件工程师, 2014(6): 289-293.
[11] 孙更新, 等. XML编程与应用教程[M]. 第2版. 北京: 清华大学出版社, 2014.
[12] 王珊, 萨师煊. 数据库系统概论[M]. 第5版. 北京: 高等教育出版, 2014.
[13] 侯莹. 基于XML异构数据交换的研究与应用[D]: [硕士学位论文]. 大连: 大连理工大学, 2009.
[14] Si, G.N., Zhou, Z.J., Li, N., Xu, J. and Yang, J.F. (2011) A Scheme for Evaluating XML Engine on RDBMS. International Journal of Modern Education and Computer Science (IJMECS), 3, 51-60.
http://dx.doi.org/10.5815/ijmecs.2011.02.08
[15] Dietrich, S.W. and Chaudhari, M. (2013) The LINQ between XML and Databases: A Gentle Introduction. Journal of Computing Sciences in Colleges, 158-164.
[16] Haw, S.-C., Lee, C.-S. and Mustapha, N. (2010) Bridging XML and Relational Databases: Mapping Choices and Performance Evaluation. IETE Technical Review, 27, 308-317.
http://dx.doi.org/10.4103/0256-4602.62593
[17] Wang, F.S., Zaniolo, C. and Zhou, X. (2014) ArchIS: An XML-Based Approach to Transaction-Time Temporal Database Systems. The VLDB Journal—The International Journal on Very Large Data Bases, 17, 1445-1463.
[18] Wu, Q.L., Sun, Y.X., Yang, X.X., Liang, Y. and Geng, X. (2011) Study on XML-Based Heterogeneous Agriculture Database Sharing Platform. IFIP Advances in Information and Communication Technology, 346, 1-7.
http://dx.doi.org/10.1007/978-3-642-18354-6_1