【摘要】：中國的證券市場經(jīng)過十多年的發(fā)展積累了大量的歷史數(shù)據(jù),這些數(shù)據(jù)中蘊(yùn)含著大量的有用信息。應(yīng)用數(shù)據(jù)倉庫技術(shù)來挖掘有價(jià)值的客戶、拓展新客戶,從而實(shí)現(xiàn)有限資源的合理配置和利潤最大化,在激烈的競爭中保持優(yōu)勢成為越來越多券商的共識。 本文在研究數(shù)據(jù)倉庫技術(shù)和ETL工具Kettle的基礎(chǔ)上,以東莞證券公司的數(shù)據(jù)中心項(xiàng)目為背景,對該公司數(shù)據(jù)中心的相關(guān)業(yè)務(wù)進(jìn)行了分析；從而提出了構(gòu)成數(shù)據(jù)中心的“五大平臺”,即數(shù)據(jù)交換平臺、數(shù)據(jù)服務(wù)平臺、智能分析平臺、業(yè)務(wù)展現(xiàn)平臺、統(tǒng)一管理平臺,并且闡述了基于該架構(gòu)的數(shù)據(jù)中心系統(tǒng)的設(shè)計(jì)和實(shí)現(xiàn)。 本文重點(diǎn)介紹了證券公司數(shù)據(jù)中心系統(tǒng)的三層數(shù)據(jù)組織結(jié)構(gòu)和數(shù)據(jù)模型設(shè)計(jì)。該數(shù)據(jù)模型參照FS-LDM模型(Financial Services LogicalData Model)的同時(shí),結(jié)合證券行業(yè)的業(yè)務(wù)特點(diǎn)進(jìn)行了適當(dāng)?shù)臄U(kuò)展,建立了包括當(dāng)事人、內(nèi)部機(jī)構(gòu)、產(chǎn)品、協(xié)議、事件等五個(gè)主題。 本文還詳細(xì)介紹了統(tǒng)一管理平臺以及兩個(gè)基于數(shù)據(jù)中心的應(yīng)用實(shí)例(監(jiān)管報(bào)表、領(lǐng)導(dǎo)視圖)的設(shè)計(jì)與實(shí)現(xiàn)。對于統(tǒng)一管理平臺,重點(diǎn)闡述了的運(yùn)維監(jiān)控、ETL調(diào)度管理等功能模塊的設(shè)計(jì)與實(shí)現(xiàn)。對于監(jiān)管報(bào)表,重點(diǎn)闡述了報(bào)表的報(bào)送流程的設(shè)計(jì)以及基于數(shù)據(jù)中心相關(guān)數(shù)據(jù)模型的報(bào)表數(shù)據(jù)匯總實(shí)現(xiàn)。對于領(lǐng)導(dǎo)視圖,重點(diǎn)闡述其基于數(shù)據(jù)中心相關(guān)數(shù)據(jù)模型的數(shù)據(jù)匯總實(shí)現(xiàn)。 本文研發(fā)的證券公司數(shù)據(jù)中心系統(tǒng)已在東莞證券公司實(shí)際部署,并且穩(wěn)定運(yùn)行了一年多。實(shí)際運(yù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.
【學(xué)位授予單位】：云南大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2013
【分類號】：TP311.13;TP308

【參考文獻(xiàn)】

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

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

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

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

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

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

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

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

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

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

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

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

，

本文編號：2141555