本文選題：數(shù)據(jù)共享 + 校園一卡通系統(tǒng)�。� 參考：《西北農(nóng)林科技大學(xué)》2017年碩士論文

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

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 李佳軍;;高校數(shù)字化信息資源多維度聚合搜索服務(wù)與應(yīng)用研究[J];情報(bào)科學(xué);2017年04期

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

3 朱力緯;劉麗勤;王健;;高�；诖髷�(shù)據(jù)時(shí)代的數(shù)字化校園建設(shè)探討[J];華東師范大學(xué)學(xué)報(bào)(自然科學(xué)版);2015年S1期

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

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

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

7 趙健;王曉峰;;基于ETL技術(shù)的數(shù)字化校園共享數(shù)據(jù)中心設(shè)計(jì)[J];軟件導(dǎo)刊;2015年01期

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

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

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

相關(guān)碩士學(xué)位論文 前2條

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

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

，

本文編號(hào)：2011095