Data Mining And Decision Analysis Based On Customer Card

Currently, parts of petroleum companies have already adopted the petroleum customer's card to carry on the sale of oil. The use of IC card reduces the economy loss which brings to business enterprise because the oil price undulates, makes the oil article allocate reasonable, science, lower a conveyance cost, accelerates financial, commercial and carrying information to circulation, raises a work efficiency, eradicates completely loophole, promote the whole diathesis of the employee, encourages to bring for the customer also biggest convenient, have thus function of raising the business enterprise performance. The movement of customer card system, produced a huge economic performance for the petroleum company. However, system circulate, output great capacity for data, is not made use of well, from these data, people are difficult to discover the deep manages rules and knowledge of marketing, as a result it is difficult to help people carry on customer to working analysis and make decision-making further.The petroleum customer's card collects a great deal of information, mainly including a customer's basic information, customer's trade details etc. contents, aiming at petroleum profession to carry on an analytical urgent demand to this kind of data, this topic puts forward and carried out a analyze system based on data mining and decision of customer's card. The system adopts Oracle9i database petroleum business database as a data source, using the BlueQuery3000 which is the product of Guangzhou ShangNan company as development and design platform, using tomcat 4.0 server releases design results, finally carried out look over customer's data analysis results by B/S structure. In this process, the main technique for involving includes the design that data warehouse and data markets, the design and usage of the topics of On-Line Analytical Processing and the design to identify customer's behavior pattern by using k_means arithmetic, we use BlueQuery3000 software to carry out the building of data warehouse and data market, the web page which uses IE which combines the VB plug-in of bluequery3000 software to realize On-Line Analytical Processing, using the Java Bean which includes k_means arithmetic to carry on the cluster of customers in the JSP, and display to the cluster result in the IE. In the circulate of system, we point specialized personnel who take charge to analyze the data coming form customer's card, this man will use BlueQuery3000 tools to design the topic of On-Line Analytical Processing and release them to a appointed position, by this release we can immediately carry out the topic renewal in the Web. In the meantime, we use a way that establishes a mission plan to renewal the data in the data cube and change demonstration result on the stage. The whole system operates in brief, circulate stability, the function be strong, satisfying the request of a businessenterprise to analyze the customer's data.The realization of this system discusses the general step and method which mine the data of business enterprise management and introduces the way that uses B/S structure to look over the business enterprise daily business data, convenience each section look into customer's data and analysis, Finally this system attains the target including science decision and raise of the business enterprise economic performance and management level.