Research And Realization Of Data-Driven Securities Company Data Center System

In recent years, Securities companies in China are generally completed in order to concentrate trading system as the core task of the second phase of information technology. With the rapid development of China's capital market, competition among securities companies increased homogenization, the war of price is widespread, in the securities company, many business applications supported by the completion of their business needs, while also making for the company departments and government regulators to provide a large number of reports, reducing the efficiency of the system, but also reduces system development needs to respond to business change capability. To provide differentiated, refined products and services, reduce the homogeneity of the product in order to achieve customer-centric business philosophy changes, the data center has become a fierce competition in the securities companies leading the important means. How to build a flexible, efficient, strong, safe, low-cost, easy to maintain data center becomes into an important issue of the securities industry information technology.To address the above issues, this paper studies the data warehouse technology and ETL tool Datastage, based on a large securities company's actual project, analysis of the company's data center-related business; proposes a data-driven architecture for securities company data center system including data base platform, data services platform, intelligent analysis platform, business presentation platform, unified management platform; describes the research and realization of securities company data center system based on the architecture; focuses on the designing of three-layer data structure and data models of securities company data center, the data models including party model, internal organization model, location model, product model, agreement model, event model; details of the research and realization of the unified management platform.The securities company data center system has been a practical application of a large securities company, the system is feasible and effective based on the practical application. With traditional data warehouse systems, the securities company data center system described in this paper has the following characteristics:l The paper designs data models of securities company data center including party model, internal organization model, location model, product model, agreement model, event,based data-driven data warehouse architecture model, expanding in accordance with Financial Services Logical Data Model (FS-LDM) .l The paper proposes an architecture of securities company data center including data base platform, data services platform, intelligent analysis platform, business presentation platform, unified management platform.l The system has been applied in a large securities company, it eliminates unnecessary redundant data,achieve resource sharing by the collecting, cleaning, integrating of data from applications including centralized trading system,margin System,self-system,asset management system,unified account system,financial system,legal settlement system, provides active and passive data services for these applications. The system also achieved a web-based, with good extension, and single-sign-on integrating with internal existing portals of data presentation platform; an intelligent analysis platform which can provide business reports,company competitive analysis,network management analysis, customer analysis report; an unified management platform which can complete metadata management, operation and maintenance monitoring, quality management, system management.