【摘要】：中國的證券市場經(jīng)過十多年的發(fā)展積累了大量的歷史數(shù)據(jù),這些數(shù)據(jù)中蘊含著大量的有用信息。應用數(shù)據(jù)倉庫技術來挖掘有價值的客戶、拓展新客戶,從而實現(xiàn)有限資源的合理配置和利潤最大化,在激烈的競爭中保持優(yōu)勢成為越來越多券商的共識。 本文在研究數(shù)據(jù)倉庫技術和ETL工具Kettle的基礎上,以東莞證券公司的數(shù)據(jù)中心項目為背景,對該公司數(shù)據(jù)中心的相關業(yè)務進行了分析；從而提出了構成數(shù)據(jù)中心的“五大平臺”,即數(shù)據(jù)交換平臺、數(shù)據(jù)服務平臺、智能分析平臺、業(yè)務展現(xiàn)平臺、統(tǒng)一管理平臺,并且闡述了基于該架構的數(shù)據(jù)中心系統(tǒng)的設計和實現(xiàn)。 本文重點介紹了證券公司數(shù)據(jù)中心系統(tǒng)的三層數(shù)據(jù)組織結構和數(shù)據(jù)模型設計。該數(shù)據(jù)模型參照FS-LDM模型(Financial Services LogicalData Model)的同時,結合證券行業(yè)的業(yè)務特點進行了適當?shù)臄U展,建立了包括當事人、內(nèi)部機構、產(chǎn)品、協(xié)議、事件等五個主題。 本文還詳細介紹了統(tǒng)一管理平臺以及兩個基于數(shù)據(jù)中心的應用實例(監(jiān)管報表、領導視圖)的設計與實現(xiàn)。對于統(tǒng)一管理平臺,重點闡述了的運維監(jiān)控、ETL調(diào)度管理等功能模塊的設計與實現(xiàn)。對于監(jiān)管報表,重點闡述了報表的報送流程的設計以及基于數(shù)據(jù)中心相關數(shù)據(jù)模型的報表數(shù)據(jù)匯總實現(xiàn)。對于領導視圖,重點闡述其基于數(shù)據(jù)中心相關數(shù)據(jù)模型的數(shù)據(jù)匯總實現(xiàn)。 本文研發(fā)的證券公司數(shù)據(jù)中心系統(tǒng)已在東莞證券公司實際部署,并且穩(wěn)定運行了一年多。實際運行的情況表明,該系統(tǒng)是高效可用的。
[Abstract]:After more than a decade of development, China's stock market has accumulated a lot of historical data, which contains a lot of useful information. Using data warehouse technology to mine valuable customers, expand new customers, realize the reasonable allocation of limited resources and maximize profits, and maintain advantage in the fierce competition has become the consensus of more and more securities companies. Based on the research of data warehouse technology and ETL tool Kettle, this paper analyzes the related business of data center of Dongguan Securities Company on the background of the data center project of Dongguan Securities Company, and puts forward the "five platforms" which constitute the data center. Data exchange platform, data service platform, intelligent analysis platform, business presentation platform, unified management platform, and the design and implementation of the data center system based on this architecture are described. This paper mainly introduces the three-tier data organization structure and data model design of securities company data center system. With reference to FS-LDM model (Financial Services LogicalData Model), the data model is extended according to the business characteristics of the securities industry and five topics including parties, internal institutions, products, protocols and events are established. This paper also introduces the design and implementation of unified management platform and two application examples based on data center (supervision report, leader view). For the unified management platform, the design and implementation of ETL scheduling and management module for operation and maintenance monitoring are described. For the supervision report, the design of the report process and the realization of the report data summary based on the data center data model are described in detail. For the leadership view, it focuses on the implementation of data aggregation based on the data center related data model. The securities company data center system developed in this paper has been deployed in Dongguan Securities Company and has been running steadily for more than a year. The actual operation shows that the system is efficient and available.
【學位授予單位】：云南大學
【學位級別】：碩士
【學位授予年份】：2013
【分類號】：TP311.13;TP308

【參考文獻】

相關期刊論文 前5條

1 管麗娟;;數(shù)據(jù)ETL研究與展望[J];電腦知識與技術(學術交流);2007年06期

2 李穎,陳躍新;運用UML語言設計分布式應用系統(tǒng)的一般過程和方法[J];計算機應用研究;2001年08期

3 范曄;黃征;顧錫康;;數(shù)據(jù)倉庫技術及其在證券管理中的應用[J];科技經(jīng)濟市場;2007年05期

4 張銳;姜曉峰;;數(shù)據(jù)倉庫建設中ETL的架構設計和實現(xiàn)[J];蘇州科技學院學報(工程技術版);2007年01期

5 劉靜巖,王守茂,楊連賀;數(shù)據(jù)倉庫技術概述[J];天津紡織工學院學報;2000年04期

相關碩士學位論文 前5條

1 李仕龍;基于面向?qū)ο蠹夹g的OA系統(tǒng)的開發(fā)[D];吉林大學;2004年

2 任立平;卷煙銷售數(shù)據(jù)倉庫應用技術及實現(xiàn)研究[D];重慶大學;2004年

3 李亞巍;數(shù)據(jù)倉庫與數(shù)據(jù)挖掘在機組運行數(shù)據(jù)分析中的應用[D];華北電力大學（北京）;2006年

4 馬洪印;基于面向?qū)ο蠹夹g的作戰(zhàn)系統(tǒng)界面設計與實現(xiàn)[D];吉林大學;2006年

5 梁明;面向?qū)ο蠹夹g在物流信息系統(tǒng)中的應用[D];同濟大學;2007年

，

本文編號：2141555