基于主数据管理的数据中心系统设计与实现
发布时间：2019-03-16 10:10
【摘要】：随着国内证券信息化的深入发展,各应用信息系统储存了大量的历史数据,但是数据存储分散,格式不一致,数据共享和管理变得越来越困难。同时,业务的发展对数据质量的要求也越来越高,质量低下的数据将增加企业的运营成本和决策风险。如何有效利用数据,提高客户服务质量,为公司决策提供依据,成为证券公司面临的问题。针对以上问题,本文在研究主数据管理和数据仓库技术的基础上,结合证券公司数据中心系统项目,对证券公司数据中心进行业务分析。针对证券业务流程进行梳理分析,利用ETL技术、主数据管理技术,并进行数据模型设计。建立主数据管理的数据中心平台,统一并合理规划数据交换方式和交换标准,对证券公司内部与外部之间的证券信息数据共享方式进行规范。实现系统平台客户之间、公司内部及外部之间、行业之间有关信息的数据集成,建立客户、企业内部等数据。构建主数据管理平台,对证券公司的数据定义和关联关系进行规范化,在此创建公司信息标准化管理体系,使得证券公司数据中心系统在将来具有较好的可扩展性和可维护性。通过系统的设计与实现,并通过日志记录分析、权限管理控制等方式来保障了数据库的安全;系统对界面进行统一化设计,其操作简便易用。该系统已在实际项目中正式运行,实际的运行效果高效稳定。
[Abstract]:With the in-depth development of domestic securities informatization, various application information systems have stored a large number of historical data, but the data storage is scattered, the format is inconsistent, and data sharing and management become more and more difficult. At the same time, the development of business requires higher and higher data quality. Low-quality data will increase the operation cost and decision-making risk of enterprises. How to use the data effectively, improve the quality of customer service, and provide the basis for the company's decision-making, has become a problem faced by securities companies. In view of the above problems, based on the research of master data management and data warehouse technology, this paper analyzes the business of securities company data center combined with the data center system project of securities company. This paper analyzes the security business process, uses ETL technology, master data management technology, and carries on the data model design. The data center platform of the main data management is set up, and the data exchange mode and standard are unified and reasonably planned, and the securities information data sharing mode between the internal and external securities companies is regulated. System platform between customers, internal and external, industry-related information data integration, establish customers, enterprise internal data. The main data management platform is constructed to standardize the data definition and association relationship of the securities company, and the company information standardization management system is established in this paper, which makes the data center system of the securities company have better expansibility and maintainability in the future. Through the design and implementation of the system, and through the log analysis, authority management control and other ways to ensure the security of the database, the system for unified design of the interface, its operation is simple and easy to use. The system has been officially run in the actual project, and the actual operation effect is efficient and stable.
【学位授予单位】：天津大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52
[Abstract]:With the in-depth development of domestic securities informatization, various application information systems have stored a large number of historical data, but the data storage is scattered, the format is inconsistent, and data sharing and management become more and more difficult. At the same time, the development of business requires higher and higher data quality. Low-quality data will increase the operation cost and decision-making risk of enterprises. How to use the data effectively, improve the quality of customer service, and provide the basis for the company's decision-making, has become a problem faced by securities companies. In view of the above problems, based on the research of master data management and data warehouse technology, this paper analyzes the business of securities company data center combined with the data center system project of securities company. This paper analyzes the security business process, uses ETL technology, master data management technology, and carries on the data model design. The data center platform of the main data management is set up, and the data exchange mode and standard are unified and reasonably planned, and the securities information data sharing mode between the internal and external securities companies is regulated. System platform between customers, internal and external, industry-related information data integration, establish customers, enterprise internal data. The main data management platform is constructed to standardize the data definition and association relationship of the securities company, and the company information standardization management system is established in this paper, which makes the data center system of the securities company have better expansibility and maintainability in the future. Through the design and implementation of the system, and through the log analysis, authority management control and other ways to ensure the security of the database, the system for unified design of the interface, its operation is simple and easy to use. The system has been officially run in the actual project, and the actual operation effect is efficient and stable.
【学位授予单位】：天津大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52
【相似文献】
相关期刊论文 前10条
1 杨书静;河北中行实现全省一个数据中心[J];中国金融电脑;2001年06期
2 江南;数据中心如何应付管理挑战[J];互联网周刊;2001年40期
3 ;简化管理挑战——惠普推实用数据中心解决方案[J];每周电脑报;2001年67期
4 李庆莉;去数据中心看一看——中国银行华北信息中心计划处处长云恩善谈数据中心运行、管理[J];中国金融电脑;2002年12期
5 马天蔚;;数据中心按需造[J];每周电脑报;2002年25期
6 戚丽,蒋东兴,武海平,冯珂;校园数据中心建设与管理方法的探索[J];教育信息化;2002年S1期
7 何俊山;您企业的数据中心2003了吗?[J];微电脑世界;2003年17期
8 ;挖潜数据中心[J];金融电子化;2004年07期
9 王琨月;;数据中心业务就绪[J];每周电脑报;2004年21期
10 包东智;新热点:创建下一代数据中心[J];上海信息化;2005年10期
相关会议论文 前10条
1 姚，
本文编号：2441161
本文链接：https://www.wllwen.com/kejilunwen/ruanjiangongchenglunwen/2441161.html
