Application of Data Warehouse technology in data service platform

Introduction

With the rapid development of China's financial industry, it is an urgent problem for the bank to support the decision analysis by classifying and storing the customer data, analyzing the automatic discriminant of the various factors, and digging out the information needed by the bank managers and the business analyst in the presence of a large amount of data. Data inconsistency, external data, and unstructured data problems are difficult to resolve because the real situation of the data in most enterprises is decentralized rather than integrated.

Data Warehouse is a new technology and concept which is proposed to solve the use of data with the rapid development of relational database, parallel processing and distributed technology, and it is the most widely used solution currently known. It is not an alternative to traditional databases, but rather a new organization of data on the basis of traditional databases. Using Data Warehouse to complete and all the scattered raw business data within the financial enterprise, and through convenient and effective data access means, can support different departments within the enterprise, different needs, different levels of users at any time to obtain their own required information, and can integrate the distribution of business data in the network together, Provide various types of data analysis for decision makers.

1 definition and characteristics of data Warehouse

The concept of Data Warehouse is for the enterprise to effectively manage and utilize the various historical data and statistic information accumulated over the years, and serve the background of decision support. W.h.inmon, the father of the Data Warehouse, puts it in the book "Building Data Warehouses": Data warehousing is a theme-oriented, integrated, non-renewable (Stable), data collection that changes over time (at different times) to support the decision making process in management [1]. This definition describes a design approach, which focuses on the characteristics of the data itself and the description of the characteristics of the data model, mainly to solve the problem of "easy access" data.

The Data Warehouse transforms the data integration of different media and different organizations into a consistent analytical data environment, which provides a consistent data view for different sources of data [2]. Its biggest advantage is that it can bring together data from different information islands in the corporate network, stored in a single integrated database, and provides a variety of means of data statistics, analysis, and allows the various departments of the enterprise to share data, for enterprises faster and better decision-making to provide more accurate and complete information.

Subject-oriented is the basic principle of data organization in Data Warehouse, all data in Data Warehouse is organized and unfolded around a topic. The data stored in the Data warehouse is extracted from the original distributed subsystems, but it is not a simple copy of the original data, but it is unified and integrated. The Data warehouse is stable at a certain time interval, where the data is periodically updated over time.