Design And Implementation Of Statistic Information System In Commercial Bank

As rapid development of science technology, especially computers and network technology, information management platform gradually apply in commercial banks, which changes the organization forms and improves management efficiency greatly. Statistical information system is a fundamental solution for improving the laggard statistics collection methods and processing means, can provide the timely, accurate, scientific and complete statistic analysis data, and also provide a strong guarantee for commercial banks to carry out scientific and rational decision-making.It's the critical development period of domestic banking industry, as the economic system reform in China continually deepen, particularly banking industry's open transition period ended, the domestic banking industry is facing so many opportunities and challenges. Therefore, China Construction Bank expects to improve the internal decision-making ability and enhance the correct judging ability through building the statistical information system which is bases on data warehouse technology. The statistical information system includes 6 subsystems: index platform, general ledger, PBC data-delivery, general statistics, industry statistics and banking card statistics. This paper is based on building a GL subsystem of the statistical information system, and the research is focus on data modeling, ETL (Extract Transform Load) process and data engine:1. The index base is divided into fundamental index base and derivational index base by data modeling which is based on multi-dimensional model strategy and hierarchical design patterns. The fundamental index base and derivational index base constitute a logical unified data model.2. The ETL process is based on ETL universal model, and could realize extraction, transformation and loading index data from source system with professional tools.3. Index engine could generate derivational index data by customize rules and index algorithms, thus enhance operation efficiency and system expansibility.This paper is used software engineering idea as the main line, and describes the implementation of general ledger subsystem in detail from the following aspects : demand analysis, architecture design, data modeling, detailed design, performance testing and systems integration.