Based On Data Mining Technology The Application In The Supermarket Management System

Due to computer data acquisition tools and relational database technology applications, all sectors currently stored amounts of data. The traditional data analysis means to cope with the large volume of data, thus more and more enterprises realized in the competition to win, gain greater gains, must use data warehouse, network and so on computer technology, deep analysis, mining current and historical data, and related environmental data, automatic quickly get a useful decision information, provides fast and accurate decision support, thus resulting from a large database mining compelling the message of the huge demand.Data mining technology and OLAP technology are two kinds of methods of DSS implementing. In order to improve system working efficiency, the article merges the two technologies in the DSS of RenRenLe supermarket and has established the high-efficient which is suitable for retail business.This paper firstly introduces the background and papers in data mining development status of clustering analysis. And then, starting from the system demand analysis completed all of the data warehouse music supermarket in design and system construction of sales management OLAP cube data warehouse technology, using the star model for multi-dimension data modeling, build a sales information related forms:sales fact sheets, the time dimension table, manufacturers dimension table, commodity dimension table, departments dimension table, according to the different dimension table built to build inquires the conditions, the fact that fact sheets search query result.Finally through from a user and function of system of two Angle supermarket management system requirements are analyzed in detail, and meanwhile will system is divided into system Settings information management and merchandise sales information management in two parts. System Settings information management includes commodity classification management, factory management, commodities management, management of department, administrator management. Merchandise sales information management includes commodity sale management, sales management, historical facts today sales facts management, commodity sales date summary. In the history of facts but according to sales of time or period, sales manufacturers, commodities to inquires the classification of goods sold all previous.Use SQL Server 2005 database backend database design and implementation, using. ASP.net development tools for system operation interface design and implementation.