本文選題：數據共享 + 校園一卡通系統(tǒng)　； 參考：《西北農林科技大學》2017年碩士論文

【摘要】：本文通過分析研究高校數據共享集成的相關技術,結合西北農林科技大學數字化校園一卡通建設項目,主要針對高校部門級的業(yè)務系統(tǒng)因建設缺乏頂層系統(tǒng)設計和信息標準不統(tǒng)一而引起的高校內信息資源流通不暢、數據共享困難等問題。通過對校園一卡通系統(tǒng)與數據共享平臺的數據共享進行研究,目的在于解決不同架構、不同系統(tǒng)下信息資源的互通共享,實現(xiàn)高校內部各部門之間的業(yè)務協(xié)同,進而緩解高校在深化信息化發(fā)展過程中亟需解決的數據壁壘矛盾,最終打破信息孤島的局面。通過校園數據共享平臺實現(xiàn)高校各業(yè)務系統(tǒng)的數據共享,從而為學校實現(xiàn)全方位的信息查詢、更深層次的數據挖掘、智能決策等研究提供全面、準確的數據基礎,為進一步實現(xiàn)智慧校園奠定基礎。本文的主要內容和結論如下:(1)研究了基于ETL的數據集成技術和Oracle數據集成工具ODI,并討論了數據提取的不同方式,重點對觸發(fā)器、時間戳、Oracle CDC等增量抽取方式進行了對比,為實現(xiàn)校園一卡通系統(tǒng)數據共享提供可靠的技術支持。(2)實現(xiàn)了基于ODI的校園卡系統(tǒng)數據增量抽取方案設計,在數據源端創(chuàng)建單獨的時間戳表,用來保存數據同步的時間節(jié)點信息,下次數據提取時,只需提取時間點后記錄,即可完成增量提取,這種設計有利于提高數據抽取效率,避免對源數據庫數據表的重復操作。(3)結合校園一卡通系統(tǒng)基礎數據,確定了需要從數據共享平臺獲取的數據字段類型及結構,并完成了對接數據庫的設計。(4)研究了中間件模式下,通過校園數據共享平臺實現(xiàn)校園一卡通系統(tǒng)與第三方業(yè)務系統(tǒng)的數據共享,實現(xiàn)了校園一卡通系統(tǒng)數據庫的學生信息、教工基礎信息及擴展信息的互通共享,減少了人員基礎信息的重復采集,提高了工作效率。實現(xiàn)了校園卡與助學金、資產管理與財務報銷等數據的共享,方便了師生,為科研輔助工作提供了方便。
[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

【參考文獻】

相關期刊論文 前10條

1 李佳軍;;高校數字化信息資源多維度聚合搜索服務與應用研究[J];情報科學;2017年04期

2 王春杰;朱保鋒;;校園信息化中數據共享問題的研究及解決方案[J];河南教育學院學報(自然科學版);2015年02期

3 朱力緯;劉麗勤;王健;;高�；诖髷祿䲡r代的數字化校園建設探討[J];華東師范大學學報(自然科學版);2015年S1期

4 金培莉;王曉震;;校園一卡通系統(tǒng)決策支持實例分析[J];華東師范大學學報(自然科學版);2015年S1期

5 趙巍;劉丹;王歡;;高等學校共享式數據中心設計與實現(xiàn)[J];長春理工大學學報(自然科學版);2015年01期

6 姜鴻斌;;智慧校園建設整體系統(tǒng)架構[J];無線互聯(lián)科技;2015年03期

7 趙健;王曉峰;;基于ETL技術的數字化校園共享數據中心設計[J];軟件導刊;2015年01期

8 孫瑋;;基于ODI技術搭建高校數字化校園公共數據平臺[J];軟件工程師;2014年07期

9 張鐵楠;劉鐵武;;數字化校園統(tǒng)一數據中心的研究與設計[J];湖南工程學院學報(自然科學版);2014年01期

10 葛蘇慧;梁宏濤;房正華;;高校共享數據中心虛擬化技術的架構[J];計算機技術與發(fā)展;2014年04期

相關碩士學位論文 前2條

1 伍劍宇;校園一卡通系統(tǒng)的設計與應用[D];吉林大學;2013年

2 葉汝軍;浙江商業(yè)職業(yè)技術學院數字化校園建設的研究與實施[D];復旦大學;2008年

，

本文編號：2011095