基于SOA的数字校园异构数据库集成的关键技术研究
|
摘要
随着高校信息化的蓬勃发展,许多高校已经建立了相当多数量的应用系统,然而由于开发平台、工具的异构性和紧耦合性导致了应用系统之间不能互通互联、资源共享与软件复用,从而形成了“信息孤岛”[1]。如何将这些具有不同数据源结构、异构操作平台接口的数据,通过耦合的方式,以一种统一、透明的数据模式描述出来,使系统资源通过Web服务进行互联、集成和协同,是目前校园信息集成平台亟待解决的问题。SOA架构(Service-Oriented Architecture)提供粗粒度、松散耦合、可组合结构,特别是基于Web Service的实现方式,为应用和数据集成提供了新的解决方案。本文主要研究内容如下:
1、针对现有的校园信息集成所面临的困难,研究一种基于SOA的数字校园信息集成方案,采用面向服务的SOA架构,深度整合现有校园的各种信息系统,使用业界成熟的Web Service技术,通过Web服务使各系统资源进行互联、集成和协同。
2、研究一种新的基于公共数据中心的SOA集成架构,并详细阐述了该架构中各组件的功能,构建了一个用于和底层数据库进行数据同步的中心数据平台,通过公共数据交换,实现所有应用系统在共享公共数据基础上的整合与集成。制定了一套更具体的《高校数字校园通用信息标准》,利用XML技术实现中心数据库和异构数据库间的数据交换。
With the rapid development of information technology in universities, many universities have established a considerable number of applications. However, tools and development platforms that have heterogeneity and tight coupling lead to information resource between applications cannot be shared, interconnected and reused, thus forming“information islands one by one”. Data with different data sources and heterogeneous platform interfaces can be described in a unified and transparent data mode through the coupling way. System resources can be connected, integrated and collaborated though Web service in the process of data integration, as is a serious problem to be solved in the research of campus information integration platform. SOA (Service-Oriented Architecture) that has coarse-grained, loosely coupled, composite structure based on Web Services in particular provides a new solution for applications and data integration. The main work of this paper is shown as follows:
1、Through the analysis of existing campus information integration that faced difficulties, the paper proposed SOA-based campus information integration project, based on which all kinds of the existing campus information systems can be integrated deeply. In order to enable all system resources can be connected, integrated and collaborated through Web, the paper uses the industry’s sophisticated Web Service technology.
2、The paper proposed a new SOA integration architecture based on a public data central and the function of each component was described in detail. The central data platform was constructed to realize data synchronization between central database and heterogeneous databases. Through public data exchanging, all applications on the basis of sharing public data can realize information integration. The paper established a series of specific“Campus Digital Common Information Standards”, based on which data exchanging can be completed among campus heterogeneous databases through XML technology.
1、针对现有的校园信息集成所面临的困难,研究一种基于SOA的数字校园信息集成方案,采用面向服务的SOA架构,深度整合现有校园的各种信息系统,使用业界成熟的Web Service技术,通过Web服务使各系统资源进行互联、集成和协同。
2、研究一种新的基于公共数据中心的SOA集成架构,并详细阐述了该架构中各组件的功能,构建了一个用于和底层数据库进行数据同步的中心数据平台,通过公共数据交换,实现所有应用系统在共享公共数据基础上的整合与集成。制定了一套更具体的《高校数字校园通用信息标准》,利用XML技术实现中心数据库和异构数据库间的数据交换。
With the rapid development of information technology in universities, many universities have established a considerable number of applications. However, tools and development platforms that have heterogeneity and tight coupling lead to information resource between applications cannot be shared, interconnected and reused, thus forming“information islands one by one”. Data with different data sources and heterogeneous platform interfaces can be described in a unified and transparent data mode through the coupling way. System resources can be connected, integrated and collaborated though Web service in the process of data integration, as is a serious problem to be solved in the research of campus information integration platform. SOA (Service-Oriented Architecture) that has coarse-grained, loosely coupled, composite structure based on Web Services in particular provides a new solution for applications and data integration. The main work of this paper is shown as follows:
1、Through the analysis of existing campus information integration that faced difficulties, the paper proposed SOA-based campus information integration project, based on which all kinds of the existing campus information systems can be integrated deeply. In order to enable all system resources can be connected, integrated and collaborated through Web, the paper uses the industry’s sophisticated Web Service technology.
2、The paper proposed a new SOA integration architecture based on a public data central and the function of each component was described in detail. The central data platform was constructed to realize data synchronization between central database and heterogeneous databases. Through public data exchanging, all applications on the basis of sharing public data can realize information integration. The paper established a series of specific“Campus Digital Common Information Standards”, based on which data exchanging can be completed among campus heterogeneous databases through XML technology.
引文
[1] Newcomer E, Lomow G.Understanding SOA with Web Services[M].徐涵,译,北京:电子工业出版社,2006.
[2] Feimin Li, Kebin Huang, Bin Yang, etc. Research on SOA-Based Education Resource Service System[C]. Second International Conference on Genetic and Evolutionary Computing, Sept, 2008, p. 427-430.
[3] IBM. SOA and Web services专区. 2004. http://www-900.ibm.tom/developer works/cn/ websevices/newto/web2svc.shtml.
[4]刘琰.基于重构技术的教务管理信息系统[D].长沙:中南大学,2006.
[5]庞妙珍.校级管理系统的设计与实现[D].广州:华南理工大学,2007.
[6]于瀛军.数字化高职学院教务管理系统的设计与实现[D] .大连:大连理工大学,2007.
[7] 2007年中中国教育信息化创新与发展论坛.教育信息化发展现状与展望[EB/OL]. 2007. http://www.e-chi2naedu.cn/zhuanti/index.html.
[8] 2008年中国教育信息化创新与发展论坛.上海交通大学信息资源综合服务平台的建设与应用[EB/OL]. 2008. http://www.e-chinaedu.cn/zhuanti/2008/luntan/ gao2dengluntan.asp.
[9]陈建华,马玉芳.浅谈如何构建高校数字化校园信息综合管理平台[J].全国商情:经济理论研究. 2009,(10):114-115.
[10]王世辉.浅析数字化校园建设[J].青岛远洋船员学院学报,2008,29(4):78-81.
[11]覃正,原欣伟,卢致杰等.面向服务的广义企业信急系统架构研究[J].计算机应用, 2004(6):62-70.
[12]杨立,左春,王裕国.面向服务的知识发现体系结构研究与实现[J].计算机学报,2005,28(4):445-457.
[13] Mamdouh lbrahim, Kerrye Holley. The Future of SOA: What worked, what didn’t, and where is it going from here?, 2007.
[14]李福盛.基于企业服务总线的SOA框架研究与应用[D].山东:曲阜师范大学,2009.
[15] PMike P Papazoglou, Willem-Jan Heuvel. Service oriented architectures: approaches, technologies and research issues[J]. The Intemational Journal on Very Large Data Bases, 2007, 16(3): p. 86—89.
[16] N.Bieberstein, S.Bose, L.Walker, A.Lynch.Impact of service—oriented architecture on enterprise systems[J]. IBM Systems Journal, 2007, 44(4) : p. 52-56.
[17] PI.Wong-Bushby, PR.Egan, C.Isaacson. A Case Study in SOA and Re—architecture at Company ABC. Proceedings of the 39th Annual Hawaii International Conference on System Sciences, 2006.
[18] Takayuki Yamaizumi, Takashi Sakairi, Masaki Wakao, PHideaki Shinomi, Samuel Adams. Easy SOA: Rapid Prototyping environment with Web Services for End Users. Proceedings of the IEEE International Conference on Web Services, 2006.
[19]中华人民共和国教育部.教育管理管理信息化标准部分:学校管理信息标准.北京:人民邮电出版社,2002.
[20]裘惠奇,陈世平.数字校园共享数据平台模型探讨[J].科技信息,2008,(11):89-91.
[21]采用GB/T 4658-2006学历代码[S].
[22] GB/T 2261.3-2003健康状况代码[S].
[23]龙宇翔.数字化校园中信息采集标准的建立与规划.中国校外教育,2009.
[24] hanyou. SOA十大设计原则. http://dev.yesky.com/115/7703115.shtml, 2007.
[25] PMike P.Papazoglou, Willem-Jan Heuvel. Service oriented architectures: approaches, technologies and research issues[J]. The Intemational Journal on Very Large Data Bases, 2007, 16(3): p. 86—89.
[26] Jeff Sutherland, Willem-Jan Van den Heuvel. Enterprise Application Integration Encounters Complex Adaptive Systems. IEEE International Conference on System Science, 2002.
[27]于彩荣.基于XML的消息队列中间件的设计与实现[D].西安:西北工业大学,2004.
[28] EUGSTER P T, PASCAL A FELBER, RACHID GUERRAOUI, ET AL. The Many Faces of Publish/Subscribe[J]. ACM Computing Surveys, 2003, 35(2): 114-131.
[29] W3C. Extcnsible Markup Language(XML). 1998. http://www.w3.org/XML.
[30] Tim Bray, Jean Paoli, Eve Maler. Extensible Markup Language(XML)1.0(Fourth Edition). W3C Recommendation[EB/OL]. 2006. http://wwww.w3.org/TR/REC-xml.
[31] eXtensible Stylesheet Language(XSL)[EB/OL]. 2005. http://wvw.w3c.org/tr/xsl.
[32] Feng Tian, David DeWitt, Jianjun Chen. The Design and Performance Evaluation of Alternative XML Storage Strategies[J]. ACM STGMOD Recd. 2002, 31(1): 5-10.
[33]徐舒亮.基于消息的企业应用与电子商务集成研究[D].福建:福州大学,2004.
[34] J. Fong, H. K. Wong, Z. Cheng. Converting relational database into XML documents with DOM[J]. Information and Software Technology, 2003, (45):p. 335-355.
[35]周蕊.校园一卡通系统信息安全技术方案[D].山东:山东大学,2007.
[36]朱涌.基于WEB的安全传输通道的研究[D].四川:成都理工大学,2004.
[37] William Stallings. Cryptography and Network Security Principles and Practice[D]. Publishing House of Electronics.
[38]陈晓红.校园一卡通系统安全方案设计[J].武汉职业技术学院学报.2008,7(1):79-82.
[39]赵福祥.唐钢一卡通系统的设计与实现[D].天津:天津大学,2009.
[40]李军刚.服务器集群负载均衡技术的研究[D].河北:河北工业大学,2008.
[41]徐海臣.学生选课及学分成绩管理系统的设计与实现[D].山东:山东大学,2010.
[2] Feimin Li, Kebin Huang, Bin Yang, etc. Research on SOA-Based Education Resource Service System[C]. Second International Conference on Genetic and Evolutionary Computing, Sept, 2008, p. 427-430.
[3] IBM. SOA and Web services专区. 2004. http://www-900.ibm.tom/developer works/cn/ websevices/newto/web2svc.shtml.
[4]刘琰.基于重构技术的教务管理信息系统[D].长沙:中南大学,2006.
[5]庞妙珍.校级管理系统的设计与实现[D].广州:华南理工大学,2007.
[6]于瀛军.数字化高职学院教务管理系统的设计与实现[D] .大连:大连理工大学,2007.
[7] 2007年中中国教育信息化创新与发展论坛.教育信息化发展现状与展望[EB/OL]. 2007. http://www.e-chi2naedu.cn/zhuanti/index.html.
[8] 2008年中国教育信息化创新与发展论坛.上海交通大学信息资源综合服务平台的建设与应用[EB/OL]. 2008. http://www.e-chinaedu.cn/zhuanti/2008/luntan/ gao2dengluntan.asp.
[9]陈建华,马玉芳.浅谈如何构建高校数字化校园信息综合管理平台[J].全国商情:经济理论研究. 2009,(10):114-115.
[10]王世辉.浅析数字化校园建设[J].青岛远洋船员学院学报,2008,29(4):78-81.
[11]覃正,原欣伟,卢致杰等.面向服务的广义企业信急系统架构研究[J].计算机应用, 2004(6):62-70.
[12]杨立,左春,王裕国.面向服务的知识发现体系结构研究与实现[J].计算机学报,2005,28(4):445-457.
[13] Mamdouh lbrahim, Kerrye Holley. The Future of SOA: What worked, what didn’t, and where is it going from here?, 2007.
[14]李福盛.基于企业服务总线的SOA框架研究与应用[D].山东:曲阜师范大学,2009.
[15] PMike P Papazoglou, Willem-Jan Heuvel. Service oriented architectures: approaches, technologies and research issues[J]. The Intemational Journal on Very Large Data Bases, 2007, 16(3): p. 86—89.
[16] N.Bieberstein, S.Bose, L.Walker, A.Lynch.Impact of service—oriented architecture on enterprise systems[J]. IBM Systems Journal, 2007, 44(4) : p. 52-56.
[17] PI.Wong-Bushby, PR.Egan, C.Isaacson. A Case Study in SOA and Re—architecture at Company ABC. Proceedings of the 39th Annual Hawaii International Conference on System Sciences, 2006.
[18] Takayuki Yamaizumi, Takashi Sakairi, Masaki Wakao, PHideaki Shinomi, Samuel Adams. Easy SOA: Rapid Prototyping environment with Web Services for End Users. Proceedings of the IEEE International Conference on Web Services, 2006.
[19]中华人民共和国教育部.教育管理管理信息化标准部分:学校管理信息标准.北京:人民邮电出版社,2002.
[20]裘惠奇,陈世平.数字校园共享数据平台模型探讨[J].科技信息,2008,(11):89-91.
[21]采用GB/T 4658-2006学历代码[S].
[22] GB/T 2261.3-2003健康状况代码[S].
[23]龙宇翔.数字化校园中信息采集标准的建立与规划.中国校外教育,2009.
[24] hanyou. SOA十大设计原则. http://dev.yesky.com/115/7703115.shtml, 2007.
[25] PMike P.Papazoglou, Willem-Jan Heuvel. Service oriented architectures: approaches, technologies and research issues[J]. The Intemational Journal on Very Large Data Bases, 2007, 16(3): p. 86—89.
[26] Jeff Sutherland, Willem-Jan Van den Heuvel. Enterprise Application Integration Encounters Complex Adaptive Systems. IEEE International Conference on System Science, 2002.
[27]于彩荣.基于XML的消息队列中间件的设计与实现[D].西安:西北工业大学,2004.
[28] EUGSTER P T, PASCAL A FELBER, RACHID GUERRAOUI, ET AL. The Many Faces of Publish/Subscribe[J]. ACM Computing Surveys, 2003, 35(2): 114-131.
[29] W3C. Extcnsible Markup Language(XML). 1998. http://www.w3.org/XML.
[30] Tim Bray, Jean Paoli, Eve Maler. Extensible Markup Language(XML)1.0(Fourth Edition). W3C Recommendation[EB/OL]. 2006. http://wwww.w3.org/TR/REC-xml.
[31] eXtensible Stylesheet Language(XSL)[EB/OL]. 2005. http://wvw.w3c.org/tr/xsl.
[32] Feng Tian, David DeWitt, Jianjun Chen. The Design and Performance Evaluation of Alternative XML Storage Strategies[J]. ACM STGMOD Recd. 2002, 31(1): 5-10.
[33]徐舒亮.基于消息的企业应用与电子商务集成研究[D].福建:福州大学,2004.
[34] J. Fong, H. K. Wong, Z. Cheng. Converting relational database into XML documents with DOM[J]. Information and Software Technology, 2003, (45):p. 335-355.
[35]周蕊.校园一卡通系统信息安全技术方案[D].山东:山东大学,2007.
[36]朱涌.基于WEB的安全传输通道的研究[D].四川:成都理工大学,2004.
[37] William Stallings. Cryptography and Network Security Principles and Practice[D]. Publishing House of Electronics.
[38]陈晓红.校园一卡通系统安全方案设计[J].武汉职业技术学院学报.2008,7(1):79-82.
[39]赵福祥.唐钢一卡通系统的设计与实现[D].天津:天津大学,2009.
[40]李军刚.服务器集群负载均衡技术的研究[D].河北:河北工业大学,2008.
[41]徐海臣.学生选课及学分成绩管理系统的设计与实现[D].山东:山东大学,2010.