[1]王晓虹 刘莹 张艳凤[].高校数据集成系统的ETL设计与实现[J].计算机技术与发展,2011,(07):186-189.
　WANG Xiao-hong,LIU Ying,ZHANG Yan-feng.Design and Implementation of ETL Based on University Data Integration System[J].,2011,(07):186-189.
点击复制

高校数据集成系统的ETL设计与实现()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
期数:
2011年07期
页码:
186-189
栏目:
应用开发研究
出版日期:
1900-01-01

文章信息/Info

Title:
Design and Implementation of ETL Based on University Data Integration System
文章编号:
1673-629X（2011）07-0186-04
作者:
王晓虹1 刘莹2 张艳凤[3]
[1]辽宁石油化工大学计算机与通信工程学院[2]东北大学信息科学与工程学院[3]沈阳农业大学
Author(s):
WANG Xiao-hong; LIU Ying; ZHANG Yan-feng
[1]School of Information Engineering,Liaoning University of Petroleum ＆ Chemical Technology[2]College of Information Science and Engineering,Northeastern University[3]Shenyang Agricultural University
关键词:
ETL; 数据集成; 实时抽取
Keywords:
ETL;  data integration;  real-time extraction
分类号:
TP393
文献标志码:
A
摘要:
高校数字化校园建设是高校教育信息化发展的一项重要任务。由于高校普遍采用不同的数据库系统来管理学校的一切事务,致使信息存在大量的冗余、不一致,乃至＂信息孤岛＂的现象,从而严重制约了高校的信息化的建设。基于ETL的数据集成技术能够很好地解决这个难题。以高校集成数字校园平台建设为背景,提出了高校数据集成系统中基于ETL平台的建设方案。系统将ETL技术与传统的数据集成技术相结合,采用适配器技术和中间件技术,处理大批量的历史数据、实时处理小批量的变化的数据,全方位地满足用户对所有数据处理的需求,解决了异构数据集成和共享问题
Abstract:
Digital campus construction is an important task for the higher education information development.Due to the different database commonly used by universities to manage all matters of the school system,there are a lot of redundant and inconsistent information or even the information island.These have seriously hampered the university information construction.The data integration technology based on ETL can solve this problem.Taking the university integrated digital campus platform as the background,the construction program of the university data integration system based on ETL is proposed.The system integrates the ETL technology with traditional technology,and use adapter technology and middleware technology to handle large quantities of historical data and to deal with small quantities of data in real-time,which can meet customer demand of all the data processing,and solve the problem of heterogeneous data integration and sharing

相似文献/References:

[1]梁美红 张男楠 李建 伍东 胡永泉 杨静.一种钻井数据仓库ETL系统的设计[J].计算机技术与发展,2010,(03):250.
　LIANG Mei-hong,ZHANG Nan-nan,LI Jian,et al.Design of ETL System for Drilling Data Warehouse[J].,2010,(07):250.
[2]范金花 梁正和.报表系统中ETL通用框架的设计与研究[J].计算机技术与发展,2009,(06):202.
　FAN Jin-hua,LIANG Zheng-he.Design and Research of Universal ETL Framework in Report System[J].,2009,(07):202.
[3]郑垒 曹宝香.基于SDO的异构数据集成研究与应用[J].计算机技术与发展,2009,(11):163.
　ZHENG Lei,CAO Bao-xiang.Research and Application of Heterogeneous Data Integration Based on SDO[J].,2009,(07):163.
[4]周运 牟占生 徐久成.基于XML虚拟数据库的异构数据源集成模型研究[J].计算机技术与发展,2008,(04):84.
　ZHOU Yun,MU Zhan-sheng,XU Jiu-cheng.Research on Data-Source Heterogeneity Model Based on XML Virtual Database[J].,2008,(07):84.
[5]黄怀毅 杨路明.一种轻量级架构的ETL系统设计与实现[J].计算机技术与发展,2008,(06):202.
　HUANG Huai-yi,YANG Lu-ming.Design and Implementation of Lightweight Architecture of ETL System[J].,2008,(07):202.
[6]毛赟 徐宏炳.基于共享库的数据集成方案改进[J].计算机技术与发展,2008,(07):170.
　MAO Yun,XU Hong-bing.Improving Solution of Data Integration Based on Shared Database[J].,2008,(07):170.
[7]王亮 葛玮.ETL过程的思考[J].计算机技术与发展,2008,(10):130.
　WANG Liang,GE Wei.Thinking in ETL Process[J].,2008,(07):130.
[8]戴文娟 王晓峰.基于XML和BizTalk数据集成平台的设计与构建[J].计算机技术与发展,2008,(10):162.
　DAI Wen-juan,WANG Xiao-feng.Design and Construction of Data Integration Platform Based on XML and BizTalk Technology[J].,2008,(07):162.
[9]温志萍 刘爱华 程初.基于SDO的虚拟视图多源数据集成研究[J].计算机技术与发展,2010,(07):89.
　WEN Zhi-ping,LIU Ai-hua,CHENG Chu.Multi-Source Data Integration Research of Virtual View Based on SDO[J].,2010,(07):89.
[10]韩松 曹宝香.基于本体的数据集成系统的设计与实现[J].计算机技术与发展,2010,(08):104.
　HAN Song,CAO Bao-xiang.Design and Implementation of Database Integration System Based on Ontology[J].,2010,(07):104.

备注/Memo

备注/Memo:
国家自然科学基金（青年基金）（61003003）王晓虹（1970-），女，副教授，研究方向为数据库和数据仓库、网络安全、嵌入式
更新日期/Last Update: 1900-01-01