摘要
我省畜产品溯源系统存在着数据分散、异构、多规范等问题,影响了全面、高效、便捷的畜产品质量安全追溯平台的建立。本文针对这一问题,通过对XML与关系数据库间映射技术的分析,用有向图的方式来构建关系数据库的通用关系模式,并将其转换为XML SCHEMA,以其作为XML与关系数据库的映射模型和数据转换条件控制,能够较好地解决畜产品溯源系统中遇到的异构数据交换问题,使得分布在各地的不同子系统的数据与中心数据库之间的异构数据交换成为可能。
Livestock traceability system of province exists data dispersed, heterogeneous, multi-specifications and that impact to establish a comprehensive, efficient and convenient retroactive platform of the quality and safety of animal products. In this paper, to solve this problem, through analysis mapping between XML and relational database technology, the way of a directed graph to build a generic relationship of the relational database model and convert it to XML SCHEMA. As the mapping relational database model of XML and data conversion conditions control, it can solve the problem of heterogeneous data exchange in livestock traceability system and it makes the data between around the different subsystems of data and central database exchange heterogeneous data possibly.
出处
《自动化技术与应用》
2014年第1期32-35,39,共5页
Techniques of Automation and Applications
基金
国家支撑计划项目(2012BAK17B04)
黑龙江省科技攻关计划项目(GC12B305)
黑龙江省畜牧兽医行业公共基础数据平台关键技术研究与建立(GC10B501)
关键词
异构数据库
XML映射
关系数据库
模板驱动
模型驱动
heterogeneous databases
XML mapping
relational database
template driven
model driven
