您現在的位置:網站首頁答辯論文語言論文英語論文

基于Web服務的異構數據集成設計

  • 簡介:摘 要:企業對信息技術的應用經歷了不同的階段。各階段的應用,無論是開發語言、部署平臺、通信協議還是數據格式及架構都存在較大的差異,如何將企業內部的“信息孤島”聯系起來,實現信息的交互和共享,已成為實現
    類型:word    頁數:33    字數:9115    價格:230   
    資料包括:論文 任務書 開題報告   
  • 論文簡介
  • 相關論文
  • 論文下載
摘 要:企業對信息技術的應用經歷了不同的階段。各階段的應用,無論是開發語言、部署平臺、通信協議還是數據格式及架構都存在較大的差異,如何將企業內部的“信息孤島”聯系起來,實現信息的交互和共享,已成為實現企業戰略目標的必需手段和捷徑。
數據集成是企業應用集成的根基,決定著企業集成的成敗。基于Web服務的異構數據集成設計的數據集成是將一個異構的,存在沖突的,分散的源數據抽取出來,進行相應的結構和數據轉換后加載到目標系統中的過程。數據集成分為三個步驟:集成分析,數據分析,數據遷移。
本設計的內容是以湖南大學學生管理系統和公寓管理系統為例,分析系統數據來源及相互關系,總結公共信息模型,從而設計并實現整合后的數據倉庫。本設計利用數據庫和.NET Framework相關知識實現為源系統定制的ETL工具,將數據從源系統中提取出來,經過相應轉換和清洗,最終加載到數據倉庫;該工具擁有記錄和顯示數據加載的狀態,導入導出狀態文件,根據狀態文件繼續尚未完成的導庫工作等功能。集成流程必須最優利用源系統,并對未來需求可擴展,因此本設計利用NHibernate實體映射解決數據倉庫中數據字段和頁面邏輯層數據綁定字段的沖突,以Web服務提供數據倉庫中數據的管理,此為數據消費的過程,目的在于達成源系統數據實時更新和一致的目標。

關鍵字:數據集成;ETL;數據倉庫;NHibernate實體映射 

The Design of Heteromerous Data Integration Based on Web Service

Abstract:Nowadays application of information technologies in enterprises has gone through several phases. No matter from languages to deployment platforms or from communication protocol to data format and schema, systems developed in different phases are diverse from each other. So connecting those isolated data islands, realizing information sharing and communication are the required and express way to achieve strategic goal in enterprise.
The foundation of application integration is data integration, which decides whether the integration will be successful. Data integration extracts data from isomerous, conflicted and isolated sources, transforms data and then loads it into the destination. It has three steps: Integration Analysis, Data Analysis, and Data Transference.
The design uses Hunan University Student MIS and Dormitory MIS as samples, analyzes data resources and their connection, produces the common data model and designs data warehouse. The Extract-Transform-Load (ETL) process is applied into data integration and an ETL tool is customized; it has following features: record and display the importing status, import and export status file, read status files and continue what have not been finished during last importing. The whole integration process must make full use of source applications and be extensible to potential requirements in future, so here DW uses NHibernate OR-Mapping to get rid of the confliction of data fields between DW and UI layer and provides data management to resource applications by web services, finally this data consumption process reaches the goal to update data in real time and achieve data consistence in all sources.

Key Words: Data Integration; ETL; Data Warehouse; NHibernate OR-Mapping


The Table of contents
1. Introduction 1
1.1 Thesis background 1
1.2 The research actualities between the domestic and abroad 2
1.3 The course points 3
1.4 The dissertation structure and research contents 3
2. Integration analysis and data analysis 5
2.1 Integration analysis 5
2.1.1 Overview 5
2.1.2 Integration requirement analysis 5
2.1.3 Integration design 7
2.2 Data analysis 8
2.2.1 Overview 8
2.2.2 Database design of source applications 9
2.2.3 Design of data warehouse 11
3. ETL 13
3.1 Overview 13
3.1.1 Concepts of ETL 13
3.1.2 Challenges facing to ETL 14
3.1.3 Related technologies about ETL 16
3.2 Data integration tool 16
3.2.1 Features of data integration tool 16
3.2.2 Design of data integration tool 17
3.2.3 Implementation 17
4. Implementation of data consumption 21
4.1 Requirements of data consumption 21
4.2 Architecture of integrated application 21
4.3 NHibernate OR mapping 22
4.3.1 Introduction to NHibernate 22
4.3.2 Application of NHibernate 23
4.4 Works presentation 25
4.5 Conclusion and prospect 26
Acknowledgments 28
References 29


1. Introduction
1.1 Thesis background
Student MIS and Dormitory MIS are both developed by 3C Studio in Software School of Hunan University; they are developed at the different time, with Dormitory MIS designed at first. Due to the reason, there is a module to manage students’ information in Dormitory MIS, for the fact that there are no data sources to get students’ information at that time. But later Student MIS is developed, it also has the module mentioned above, and then conflicts come out. The two systems have connections on students’ information, but the students’ information should only be input by users of Student MIS, so employees make out a rule according to the situation, what is the functions in Dormitory MIS, like input students’ information, update, delete should be abandoned; its information in database should be extracted from Dormitory MIS by database manager. It is the current situation, and that’s why the course is raised out.
The defects of current situation include that:
1. Data in Dormitory MIS is not in real time; they are inconsistent with the fact. As the data is only imported at a newly start semester, it will not be updated during the coming days until the next semester.
查看評論 已有0位網友發表了看法
  • 驗證碼:
四川三人麻将 浙江体彩20选5开奖 河南快三今天专家预测 加拿大快乐8号是不是合法的 黑龙江11选5前三走势图 股票配资平台深圳 江西十一选五遗漏表 十一选五浙江开奖结果 安徽快3是合法的吗 河南泳坛夺金20分钟 长江证券股票