基于数据共享平台的校园一卡通数据共享设计与实现

发布时间：2018-06-12 21:08

本文选题：数据共享 + 校园一卡通系统　；参考：《西北农林科技大学》2017年硕士论文

【摘要】：本文通过分析研究高校数据共享集成的相关技术,结合西北农林科技大学数字化校园一卡通建设项目,主要针对高校部门级的业务系统因建设缺乏顶层系统设计和信息标准不统一而引起的高校内信息资源流通不畅、数据共享困难等问题。通过对校园一卡通系统与数据共享平台的数据共享进行研究,目的在于解决不同架构、不同系统下信息资源的互通共享,实现高校内部各部门之间的业务协同,进而缓解高校在深化信息化发展过程中亟需解决的数据壁垒矛盾,最终打破信息孤岛的局面。通过校园数据共享平台实现高校各业务系统的数据共享,从而为学校实现全方位的信息查询、更深层次的数据挖掘、智能决策等研究提供全面、准确的数据基础,为进一步实现智慧校园奠定基础。本文的主要内容和结论如下:(1)研究了基于ETL的数据集成技术和Oracle数据集成工具ODI,并讨论了数据提取的不同方式,重点对触发器、时间戳、Oracle CDC等增量抽取方式进行了对比,为实现校园一卡通系统数据共享提供可靠的技术支持。(2)实现了基于ODI的校园卡系统数据增量抽取方案设计,在数据源端创建单独的时间戳表,用来保存数据同步的时间节点信息,下次数据提取时,只需提取时间点后记录,即可完成增量提取,这种设计有利于提高数据抽取效率,避免对源数据库数据表的重复操作。(3)结合校园一卡通系统基础数据,确定了需要从数据共享平台获取的数据字段类型及结构,并完成了对接数据库的设计。(4)研究了中间件模式下,通过校园数据共享平台实现校园一卡通系统与第三方业务系统的数据共享,实现了校园一卡通系统数据库的学生信息、教工基础信息及扩展信息的互通共享,减少了人员基础信息的重复采集,提高了工作效率。实现了校园卡与助学金、资产管理与财务报销等数据的共享,方便了师生,为科研辅助工作提供了方便。
[Abstract]:Through analyzing and studying the related technology of data sharing and integration in colleges and universities, combining with the construction project of digital campus of Northwestern University of Agriculture and Forestry Science and Technology, This paper mainly aims at the problems caused by the lack of top-level system design and information standard, such as the poor circulation of information resources and the difficulty of data sharing in colleges and universities. Through the research on the data sharing between the campus card system and the data sharing platform, the purpose of this paper is to solve the problem of sharing information resources under different structures and systems, and to realize the business cooperation among different departments in colleges and universities. Then it can alleviate the contradiction of data barrier that should be solved in the process of deepening information development, and finally break the situation of isolated island of information. Through the campus data sharing platform to realize the data sharing of various business systems in colleges and universities, so as to provide a comprehensive and accurate data base for the school to realize the omni-directional information query, the deeper data mining, the intelligent decision-making and so on. For the further realization of the wisdom of campus laid the foundation. The main contents and conclusions of this paper are as follows: (1) the data integration technology based on ETL and the Oracle data integration tool ODI are studied, and the different methods of data extraction are discussed, especially the incremental extraction methods such as trigger, timestamp and Oracle CDC. This paper provides reliable technical support for data sharing of campus card system. It implements the design of data increment extraction scheme of campus card system based on ODI, and creates a separate timestamp table at the end of data source. The time node information used to save the data synchronization, the next data extraction, only need to extract the time point after the record, you can complete incremental extraction, this design is conducive to improve the efficiency of data extraction, Avoiding the duplicate operation of the data table of the source database. 3) combining with the basic data of the campus card system, the data field type and structure that need to be obtained from the data sharing platform are determined. And completed the design of docking database. 4) studied the data sharing between the campus card system and the third party business system through the campus data sharing platform under the middleware mode, and realized the student information of the campus card system database. The interworking and sharing of basic information and extended information of teaching staff can reduce the repeated collection of basic information of personnel and improve the working efficiency. The data sharing of campus card and grant, asset management and financial reimbursement is realized, which is convenient for teachers and students, and provides convenience for scientific research auxiliary work.
【学位授予单位】：西北农林科技大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP399-C1

【参考文献】