A Commercial Bank System Model Design And Implementation Of Data Warehouse

With economic globalization and financial integration, especially the gradual formation of the knowledge economy, China’s banking industry is undergoing a profound revolution in the bank’s focus to the application of information technology e-business processes, centralized data management, management decision-making information such as direction. In order to optimize and improve the analysis of commercial banks in various management systems, improve data accuracy, cross-system analysis applications mature, a number of domestic commercial banks to start planning and building an enterprise data warehouse to improve the level of analysis of banking data and decision-making capacity, and create competitive advantage, improve the scientific management for commercial banks to the future management and business development has laid a good foundation of data.Size and operation of commercial banks continued to expand, prompting a large number of business systems, produce large amounts of business data every day, because the system is relatively independent, and platform differences, the inevitable formation of multiple information silos, leading decision-makers is difficult to the perspective of the whole line profitability analysis and forecasting risks. How to use advanced technology, from the existing data in the decision-making analysis to obtain the required information is an urgent need to address the problem. This article looks at the data warehouse data model, combined with the actual use of project design and implementation process for future commercial banks in enterprise data warehousing systems, the technical and business lay a good foundation.This thesis describes the history of banking information to start comparing the development status of domestic and international data warehouse, data warehouse bank that the construction of domestic problems. Second, introduce the basic concepts of data warehousing, database and compared the data warehouse, data warehouse modeling introduced the basic concepts, through modeling and multidimensional modeling paradigm comparison of two methods to find a suitable platform with different data modeling approach, combined with the actual project using the platform product instructions. Again, the thesis is introducing the actual situation and project-related infrastructure, and focus on the parties to the agreement, three core themes of the event design and implementation of the results of a detailed introduction and description. Based on the logical data model establishment, the thesis mainly discusses the physical model of the design, entity selection, technical specifications, and naming and other aspects of the main points, and data applications of the model. Finally, the thesis summary and outlook for the experience and the data warehouse system trends and prospects.