内部质量保证体系中校本数据中心建设探讨--以异构数据迁移方法为例  

Discussion on the Construction of School-based Data Center in Internal Quality Assurance System--Taking Heterogeneous Data Migration Method as an Example

作　　者：许琦[1] XU Qi(Institute of Education Quality Assessment,Taizhou Vocational and Technical College,Taizhou 318000,China)

机构地区：[1]台州职业技术学院教育质量评估院,浙江台州318000

出　　处：《职业技术》2020年第5期1-6,共6页Vocational Technology

基　　金：浙江省高等教育“十三五”第一批教学改革研究项目“以教学诊改为依托构建内部质量保证体系:台职院的实践与探索”(jg20180741);中国高等职业技术教育研究会“十二五”规划课题“高职院校产学研结合与区域发展联动模式探索—以台州职业技术学院为例”(GZYLX2015075);台州市2019年度教育科学规划研究课题“高职院校内部质量保证体系建设:以台职院为例”(gg19021)。

摘　　要：校本数据中心建设是内部质量保证体系建设的"瓶颈"。文章从数据仓库视角,研究基于XML的异构数据迁移方法。在分析内部质量保证体系数据迁移框架和校本数据中心架构的基础上,以XML文件为载体,定义了"一对一""多对一"和"一对多"等三种数据映射模型。以kettle为辅助工具,将不同业务系统的后台数据迁移到校本数据中心,进行统一存放,并提供下游应用访问。经实践检验,该方法可实现数据编码格式统一转换,同时,在数据迁移和检索效率方面基本符合校本数据中心的建设要求,实现了原业务系统和校本数据中心的无缝数据衔接。The construction of a school-based data center is the bottleneck of an internal quality assurance system.This article studies a heterogeneous data migration method based on XML from the perspective of data warehouse.On the basis of the analysis of an internal quality assurance system data migration framework and a school-based data center architecture,three data mapping models,such as one-to-one,many-to-one and one-to-many,are defined with XML files as carriers.Taking kettle as an auxiliary tool,the background data of different business systems are migrated to the school-based data center for unified storage,which provides access to downstream applications.The practice shows that the method proposed in this article can realize uniform conversion of data coding format,and basically meet the requirements of the school-based data center construction in terms of data migration and retrieval efficiency,and realize seamless data connection between the original business systems and the school-based data center.

关 键 词：校本数据中心 内部质量保证体系 数据迁移 KETTLE 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]