The Design Of Basic Data Platform For Bank

The current financial securities industry business-critical systems include the core trading systems, trading systems, settlement systems, business systems delivery, membership services, systems, Internet systems, a dozen business systems. The data associated with this resource, including the production database, the database market, membership service system database, the database query system, monitoring system database, the depth of market database and historical database, and various other internal and external data resources. Of which:Production database: the database is the core of the daily transactions of the transaction data, business data and customer information data, financial data stored in the production database.History database: the data stored in transaction history database, commission, open and closed profit and loss and other details of historical data, historical database has no direct business applications, only for temporary data storage and data query purposes, save for a few years history database Or even longer historical transaction data, the data volume is very high.According to statistics, the current major financial institutions and the amount of data close to 10T, of which nearly 40% of the data stored in the database, located in the production database, historical database, the new query system applications, nearly 40% of the data to Guangpan , form a storage tape, as well as nearly 20% of the data in paper form of archiving, data used from the point of view, CD-ROM and tape form and paper form data is clearly not easy to use, it adversely to the information analysis factors.The new data query system is a technology-based business intelligence solutions, from application point of view of the business sector to meet the basic data query and analysis needs. However, with the range of financial services, business volume continues to expand, the emerging market risk, business sector analysis will subsequently become increasingly complex and in-depth, relying on the new query system, the existing storage and processing capacity will be insufficient to support the long-period and complex data query, statistical and analytical needs. Query the database is currently stored in the main business of trading system to produce data, but data from multiple systems do not integrate, in addition, a lot of external data used by business analysts to get their own channels, respectively, and these data were analyzed. These data are not currently a unified planning and integration, on the one hand, lack of uniform data format standard, the same data multiple storage, the lack of a unified tool for business analysts, computational tools, their analysis also can not share, resulting in waste of resources ; the other hand, isolated, not integrated data and I can not form an effective relationship existing data, there is one-sided and incomplete data, thus weakening the analysis results.In this paper, basic data platform architecture, implementation mechanism, implementation of the program were detailed, the construction of the basic data platform goal is to build XX banks operating data storage systems to meet the banking complex, heterogeneous, logical relationship between a business Source system data integration needs, and combined with previous experience in business analysis applications, the application of forward-looking consider the future needs to ensure that data integration can be based on the support of the maximum after the application of business analysis and decision support, while building a complete operating mechanism of the ODS , Including: ODS model building, XX banking application needs analysis, to provide data related systems outside support.