Design And Implementation Of Small Statistical Data Analysis System For Commercial Bank

The bank is the information industry, play a dominant role. Almost all banks inChina has accumulated a large amount of business data in order to complete theintegration of large amounts of data. But at different times, in isolation, the data set,resulting in many islands of information. These data can not be shared and maintainduplication of data to a common industrial practice. Data does not effectively uselessand limited mining large amounts of data, but the storage space. Integration of all thedata of the application, is the most effective way to address the problem of informationsilos dissolved and the creation of high-quality data-mining platform. The purpose ofthe theme of the article is such a project.OLAP, enterprise information construction of the new invention, a technique ofmulti-dimensional information exchange, support efficient analysis. Enterprise metadataallows users to the various dimensions of the data through the operation, as observedslicing, cutting, drilling and multi-dimensional data on the pivot point. Through the useof OLAP statistical system, it will bring not only to reduce maintenance costs, but alsoto make an accurate and timely decision-making, enterprise technical support.First Bank are discussed (BC) status and problems, and then suggest the need forbuilding OLAP-based statistical system. And then illustrate the statistical system offersBC a core process of discussion and analysis, such as data acquisition, data processingand reporting revelation. Third, the structure of the system analysis, then how dataacquisition subsystem, transaction processing and report manager brocade sofa springdiscussed achieve architecture. Next, change the user how to calculate one businessmetrics, at different times, and last year, the relative change in conjunction with OLAPtools on how to calculate. ABC statistics system performance has been analyzed.