Analysis And Design Of Credit Information System Based On Data Warehouse

In the actual application inside of the big and medium-sized business enterprise, The data of large database can't be fully used and analyzed by the traditional database management information system, and also short of correspond analytical tools. On the other hand, through the application of data warehouse can nicely resolve this problem. Data mining and data warehouse resolve such problem well. The technique of data warehouse really makes a relationship in those lonely data to form some valuable information which supply strong technical service for all kinds of application. Date warehouse technique has a rapid growth as Internet, and the application field of it is developed continuously.Modern market economy is the credit economy, credit is the basis of a modern market economy. General trustworthy behavior is a necessary precondition for Market transactions to ongoing and expanding and for economy and the steady development of continuous operation. But, under the planned economy to a market economy in the process of transition, occurred in some units and members of society tended to dilute the concept of credit, social credit default promises to increase dramatically, the market economic order of the phenomenon of disorder. Impact on the health of the economic and social development and opening to the outside world, damage to the reputation and image of the country. Now, Lack of Credit in behavior have been widespread concern, reconstruction of the whole society credit has become a common voice, Social Credit has become a modern market economy to improve by the need to address an important issue.This paper first introduces the development background of the credit information system, and gives a brief introduction in data warehouse technology applications in various fields, and then set out a number of major data warehouse technical knowledge: data extraction,data conversion,data loading,On-Line Analytical Processing,data mining models and the application of statistical techniques etc. And based on the latest features of credit information system, design of the credit information system module, of credit information system in detail. The development of this system embodies the enterprise's potential requirement for data warehouse; data warehouse is different from conventional database technology. This paper constructs subject-oriented logic model, and study and practice the design of data warehouse, data organization and storage, and ETL method and techniques.As a application, this paper analyzing the application require and condition background of this system, and this paper discusses mainly about building a tobacco production management data warehouse logical model with the method of star schema, and collecting data, extracting data, transforming data etc. The "valuable and clean" data is loaded into the data warehouse, and then the physical model of tobacco production management data warehouse is finished. And the same time, this paper establishes the enterprise data-related information in data warehouse, mining enterprise credit rating of the development trend of association rules, give support for user to determine enterprise credit.