Design And Analyse The Payment Transaction Information Of The Data Warehouse

With the rapid development of the company,business products continue to emerge,trading trends are constantly changing,the transaction risk is also increasing.As a collection agency business,not only to consider the company's business development,but also need to assume to ensure that all the risks can be stopped in a timely manner.The company as a collection agency,every day a lot of transaction data,how to get from the data of the company's earnings summary of the transaction trend of the supporting data,transaction risk monitoring records.This paper mainly through the use of a wide range of data warehouses in the industry to analyze the data,data warehouses can provide data highly integrated,automated,intelligent information solutions to help enterprises in the data to obtain valuable information.The components of the data warehouse contain: databases,data marts,data extraction tools,metadata,data warehouse management,information publishing systems,access tools.All the components have been achieved in the system have a better implementation of the program,so this article only for analysis and implementation of data warehouse systems with other enterprises in different points to describe the description.First of all,the company's data to understand and analyze,we understand that the basic data contains business data,terminal data,transaction data,based on the basic data to find the subject information,business transaction theme,terminal transaction theme,the issuer's trading trend theme,Card trading trend theme,channel trading theme,risk trading monitoring theme.Secondly,how to design the data warehouse,and to analyze the basic data.The multidimensional model is used to analyze the subject data,and the fact table and the thematic theme are used to derive the dimension table,the month,the day,the different time dimension,and the different business dimension information according to the various topics.The description of the relationship between the subject table,the design of the theme data table,including the table primary key,table index,table partition,table elements and so on.Finally,through a case to explain the application of the system,including the description of the case,the case of the analysis,the final combination of the third chapter of the system design theme data generation design.