【正文】 摘要 I 摘要 在計(jì)算機(jī)信息技術(shù)快速發(fā)展的今天，社會(huì)進(jìn)入了一個(gè)信息化的時(shí)代。從某種程度上來說，金融行業(yè)特別是銀行業(yè)和信息技術(shù)已經(jīng)是不可分離的。信息技術(shù)成為了銀行業(yè)的基礎(chǔ)配置，并且在銀行業(yè)的競(jìng)爭(zhēng)中發(fā)揮著核心競(jìng)爭(zhēng)力。目前，銀行業(yè)存在著各個(gè)業(yè)務(wù)系統(tǒng)如客戶信息系統(tǒng)、集中處理平臺(tái)系統(tǒng)、存貸款系統(tǒng)、結(jié)算業(yè)務(wù)系統(tǒng)等，在各個(gè)系統(tǒng)中因?yàn)闆]有采用統(tǒng)一的技術(shù)標(biāo)準(zhǔn)和規(guī)范，并且數(shù)據(jù)在規(guī)模上的快速增長(zhǎng)和在精度上的細(xì)化為銀行的人力物力成本造成了很大的挑戰(zhàn)。從廣度上看，如今對(duì)數(shù)據(jù)的應(yīng)用和分析并不止局限于單個(gè)業(yè)務(wù)系統(tǒng)中，重視的是綜合的，跨業(yè)務(wù)平臺(tái)的數(shù)據(jù)。所 以如何優(yōu)化數(shù)據(jù)的存儲(chǔ)能力，提高數(shù)據(jù)的質(zhì)量，促成數(shù)據(jù)的跨業(yè)務(wù)平臺(tái)的綜合利用就成為了銀行業(yè)的重要課題。 本文的目的是建立高質(zhì)量的數(shù)據(jù)管理系統(tǒng)，在銀行實(shí)地調(diào)研的基礎(chǔ)上，明確了本系統(tǒng)的實(shí)際功能需求。在本文中對(duì)銀行數(shù)據(jù)管理系統(tǒng)的總體結(jié)構(gòu)以及各個(gè)功能模塊的實(shí)現(xiàn)進(jìn)行了詳細(xì)的描述。系統(tǒng)實(shí)現(xiàn)了以數(shù)據(jù)遷移的方式獲取銀行各業(yè)務(wù)子系統(tǒng)的待處理數(shù)據(jù)，將數(shù)據(jù)遷移過程分為三步，數(shù)據(jù)抽取、數(shù)據(jù)加載和數(shù)據(jù)整合。在遷移的過程中，針對(duì)未正確抽取和各業(yè)務(wù)子系統(tǒng)缺少的數(shù)據(jù)，采用手工補(bǔ)錄的方式進(jìn)行添加。在數(shù)據(jù)表中創(chuàng)建權(quán)限標(biāo)示符，明確用戶對(duì)該數(shù)據(jù)的權(quán)限 。接著對(duì)獲取的數(shù)據(jù)進(jìn)行質(zhì)量管理，即通過控制調(diào)用規(guī)則引擎對(duì)數(shù)據(jù)進(jìn)行完整性、正確性和有效性規(guī)則校驗(yàn)。實(shí)現(xiàn)數(shù)據(jù)查詢模塊，將獲得的數(shù)據(jù)提供給用戶，實(shí)現(xiàn)日志模塊，記錄用戶操作狀況和系統(tǒng)運(yùn)行狀況。 該系統(tǒng)采用了 B/S 架構(gòu)，基于 MVC 的設(shè)計(jì)模式，使用 Spring開發(fā)框架，采用 JAVA語言進(jìn)行開發(fā)，并且將 Oracle 作為系統(tǒng)的數(shù)據(jù)庫(kù)。進(jìn)行了功能測(cè)試和兼容性測(cè)試，通過測(cè)試結(jié)果可知，該銀行數(shù)據(jù)管理系統(tǒng)滿足了設(shè)計(jì)要求。在系統(tǒng)部署后，用戶反映系統(tǒng)整體運(yùn)行良好。上述結(jié)果說明系統(tǒng)達(dá)到了預(yù)期的目標(biāo)。 關(guān)鍵詞： 銀行數(shù)據(jù)管理系統(tǒng)，數(shù)據(jù)遷移 ，數(shù)據(jù)質(zhì)量管理，功能測(cè)試 西安電子科技大學(xué) 碩士學(xué)位 論文 II ABSTRACT III ABSTRACT Computer information technology develops rapidly today, the society has entered an era of information. To some extent， the financial industry especially the bank and information technology are inseparable. Information technology bees the foundation of the banking industry and plays a corepetitiveness in the petition of it. The banking industry has various systems at present, such as customer information system, central processing platform system, deposit system, etc. There is no uniform technical standards and the rapid growth of the data makes a lot of challenges for the cost of the bank. Looking from the breadth, the application and analysis of the data is not just confined to a single business system. Now the people pay attention to the data which is prehensive and across the business platform. So how to optimize the data storage capacity, improve the data39。s quality and implementation the data across business platform has bee an important subject in the banking industry. The purpose of this paper is to establish a high quality of data management system of bank. On the basis of survey of bank, defining the functional requirements of the system. The whole structure and function module of the system are described in detail. The system obtained the data of each business subsystem by the way of data migration. In this paper we divide data migration into three steps, data extraction, data loading and data integration. During the process of migration, we use the data’s makeup to add the missing data and abnormal data. Creating a authority identifier in the data table to ensure users operation rights of the data. Then using the rule engine to manage the data’s quality, includes the integrity, correctness and effectiveness. Through the log module, record the user39。s operating status and system operation status. The system adopts B/S architecture and based on the MVC architecture. We use JAVA language to develop the system and choose Oracle as the database system. After the pletion of the system, doing the functional test and patibility test. Through the test results, the bank’s data management system meets the design requirement. After the deployment of the system, users reflecting that the operation of the system is good. These results indicate that the system achieves the expected goal. 西安電子科技大學(xué) 碩士學(xué)位 論文 IV Keywords: bank’s data management system , data migration, data’s quality management,functional test 插圖索引 V 插圖索引 圖 MVC 模式的層次結(jié)構(gòu)圖 ............................................................................ 6 圖 用戶角色用例圖 ......................................................................................... 12 圖 數(shù)據(jù)遷移功能用例圖 ................................................................................. 14 圖 數(shù)據(jù)質(zhì)量管理用例圖 ................................................................................. 15 圖 數(shù)據(jù)查詢模塊用例圖 ................................................................................. 17 圖 日志模塊用例圖 ......................................................................................... 17 圖 系統(tǒng)邏輯結(jié)構(gòu)圖 ......................................................................................... 20 圖 系統(tǒng)部署圖 ................................................................................................. 21 圖 系統(tǒng)的功能模塊圖 ..................................................................................... 21 圖 銀行數(shù)據(jù) ER 圖 ........................................................................................ 23 圖 數(shù)據(jù)遷移模塊的邏輯結(jié)構(gòu)圖 ..................................................................... 28 圖 數(shù)據(jù)抽取子模塊的流程圖 ......................................................................... 29 圖 數(shù)據(jù)抽取子模塊的類圖 ............................................................................. 29 圖 機(jī)構(gòu)數(shù)據(jù)處理的流程圖 ............................................................................. 30 圖 機(jī)構(gòu)數(shù)據(jù)處理的類圖 ................................................................................. 31 圖 柜員數(shù)據(jù)處理的流 程圖 ............................................................................. 31 圖 柜員數(shù)據(jù)信息處理的類圖 ......................................................................... 32 圖 數(shù)據(jù)加載子模塊的流程圖 ......................................................................... 32 圖 數(shù)據(jù)加載子模塊的類圖 ............................................................................. 33 圖 數(shù)據(jù)整合子模塊的流程圖 ......................................................................... 34 圖 數(shù)據(jù)整合子模塊的類圖 ............................................................................. 34 圖 數(shù)據(jù)質(zhì)量管理 模塊的邏輯結(jié)構(gòu)圖 ............................................................. 35 圖 規(guī)則引擎管理器的類圖 ............................................................................. 36 圖 規(guī)則引擎監(jiān)控功能序列圖 ......................................................................... 37 圖 規(guī)則數(shù)據(jù)發(fā)布功能序列圖 ...................................