The Design And Implementation Of Date Warehouse System In Commercial Banks

With the development of science and technology in recent years, Chinese science and technology rapid development, China has entered the information age. The old IT construction has been unable to meet the requestion of the financial industry now, IT needs to build the financial industry innovation and development. The international financial industry has long led the nation, the widespread use of data mining technology to build commercial banking data warehouse system, innovative financial services and products. With China’s accession to the WTO has been more than a decade, outside the financial sector more open to foreign financial firms growing threat to the country, the competition heats up, the commercial bank data warehouse construction is imminent.The main bottleneck in the development of this paper from commercial banks to undertake an analysis to find the cause, according to the bank’s future development trends, customer needs and delve into scientific analysis to determine the customer, the bank organization, account transaction records based on conditions existing domestic banking sector( event), the product, the six channels subject and determine the corresponding one of the six dimensions for subject according to the six dimensions of the design theme and its corresponding service layer data model and the analysis of the data model layer washed source data, transformation, loading and data extraction, final design rights management data warehouse system, can be of different dimensions with different themes according to data queries demonstrate the appropriate permissions.This paper using a variety of data warehouse technology, combined. NET framework technology to existing financial data in enterprise information systems for the collection and analysis of the law and contact them to find the data source independently run at different systems of Unified integration, enterprise-class data warehouse. Provide efficient, stable data analysis tool for commercial banks to decision-makers. Innovative financial products in order to occupy a dominant position in the peer.