东莞证券数据中心的分析与设计
发布时间：2018-07-24 13:39
【摘要】：中国的证券市场经过十多年的发展积累了大量的历史数据,这些数据中蕴含着大量的有用信息。应用数据仓库技术来挖掘有价值的客户、拓展新客户,从而实现有限资源的合理配置和利润最大化,在激烈的竞争中保持优势成为越来越多券商的共识。 本文在研究数据仓库技术和ETL工具Kettle的基础上,以东莞证券公司的数据中心项目为背景,对该公司数据中心的相关业务进行了分析；从而提出了构成数据中心的“五大平台”,即数据交换平台、数据服务平台、智能分析平台、业务展现平台、统一管理平台,并且阐述了基于该架构的数据中心系统的设计和实现。 本文重点介绍了证券公司数据中心系统的三层数据组织结构和数据模型设计。该数据模型参照FS-LDM模型(Financial Services LogicalData Model)的同时,结合证券行业的业务特点进行了适当的扩展,建立了包括当事人、内部机构、产品、协议、事件等五个主题。 本文还详细介绍了统一管理平台以及两个基于数据中心的应用实例(监管报表、领导视图)的设计与实现。对于统一管理平台,重点阐述了的运维监控、ETL调度管理等功能模块的设计与实现。对于监管报表,重点阐述了报表的报送流程的设计以及基于数据中心相关数据模型的报表数据汇总实现。对于领导视图,重点阐述其基于数据中心相关数据模型的数据汇总实现。 本文研发的证券公司数据中心系统已在东莞证券公司实际部署,并且稳定运行了一年多。实际运行的情况表明,该系统是高效可用的。
[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
本文编号：2141555
[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 管丽娟;;数据ETL研究与展望[J];电脑知识与技术(学术交流);2007年06期
2 李颖,陈跃新;运用UML语言设计分布式应用系统的一般过程和方法[J];计算机应用研究;2001年08期
3 范晔;黄征;顾锡康;;数据仓库技术及其在证券管理中的应用[J];科技经济市场;2007年05期
4 张锐;姜晓峰;;数据仓库建设中ETL的架构设计和实现[J];苏州科技学院学报(工程技术版);2007年01期
5 刘静岩,王守茂,杨连贺;数据仓库技术概述[J];天津纺织工学院学报;2000年04期
相关硕士学位论文 前5条
1 李仕龙;基于面向对象技术的OA系统的开发[D];吉林大学;2004年
2 任立平;卷烟销售数据仓库应用技术及实现研究[D];重庆大学;2004年
3 李亚巍;数据仓库与数据挖掘在机组运行数据分析中的应用[D];华北电力大学（北京）;2006年
4 马洪印;基于面向对象技术的作战系统界面设计与实现[D];吉林大学;2006年
5 梁明;面向对象技术在物流信息系统中的应用[D];同济大学;2007年
，本文编号：2141555
本文链接：https://www.wllwen.com/kejilunwen/jisuanjikexuelunwen/2141555.html
