Research On Application Of Data Mining In Market Decision Surport System

A MDSS is put forward based on MS SQL Server Analysis Service and OWC(Office Web Component) after the general data mining and data warehouse principle studying. This system supports synthetical analysis and query, and also it can find the relation degree between goods. MDSS can predict the purchasing power and consumption mode of member customers. Market manager can be supported from MDSS.MDSS is result in application of data warehouse,online-analysis-process and data mining in marketing system after full study on characteristic of the market. This system is represented to the user by way of Web. Its server side uses ASP (Active Server Page) and VBScript to program, and its client side uses such technologies as JavaScript, CSS and DOM to control interface. The thin client architecture can bring users much convenience.General method and step of data warehouse based data mining is discussed through design and application of this system, and also web based system design skills is summarized at the end of this article. In addition the program of OWC is deeply probed into in this paper. Large amount of VBA programming skill is consulted in course of this system. And the merit of combining Office' s programming in the practical application is shown.