Research And Optimization Of Data Warehouse Model In Bank Based On Teradata

In recent years, a substantial increasing in the business-critical data and customer data of enterprises, data warehouse is the best solution means for those who wish to make use of these data with advantages. Many enterprises had put lot of resources in the data warehouse building, but they didn't receive the expected return. The key point is that the data warehouse model construction and related fields couldn't be very good combine, which is the one of the hotspots for all the data warehouse vendors. And researching on the reconstruction of targeted model Based on Specific products has become an important issue.In the banking field, the customer-modeling has been an important research direction in data warehouse, which includes the logic model that decides the overall structure and the physical model that based on specific data warehouse platform, and both are need to closely integrate the fields of bank business, so it's a good guide for all. Researching on the model's optimization Based on the characteristics of bank's business is also a focus of study.For the above-mentioned problems, this paper is focused on researching and optimization of Data Warehouse Model in Bank Based on Teradata. The traditional research are based on the Microsoft SQL Server or Oracle or other products, most of the model only applicable to a business on the one hand, is not universal. In this paper, the commercial bank adopted the industry-leading Teradata data warehouse, and it used a mature financial model, organized the diverse sources of business data effectively, and used unified logic language for description of banking business to meet the different departments. So it satisfies the different Business needs and data access. Besides, in accordance with the characteristics of the banking business, we propose the design features of the logic customer-modeling to the physical customer-modeling, and to establish its own bank data warehouse model. Subsequently, because of the requirements of storage space and efficiency, we explore optimized design based on assurance for consistency and specific operating environment, and have achieved initial results.