| We can find what the society demand for the requirements of the times development and know the development direction of computer technology and application through the graduation project that based on the electronic commerce systems desingning and realization in the audiovisual publishing. OLAP(Online Analytical Processing)has got the extensive application in commercial field. Through analysising data in data warehouse with OLAP technology,it can help company manage the sale target, progress of the project ,even forecasting the development trendency in some special field,so it makes the manager or client obtain the useful data information more conveniently and quickly,and make the decisions.The audiovisual sale system that we designed is a sales analysis system based on the OLAP technology. The interface design include sales shops and sales analysis.The background data design include the design of the data warehouse and the design of database. The function of the audiovisual sale analysis system is analysing the customer's consumption and audiovisual sales. The administrator of the enterprise may know the the consumption trend through analysing the consumption.In order to improve the performance,the administrator may forecast the sales trend through analysing the result of audiovisual sale,and make the next sale decision.The system combines of online sale, back-office management and sales analysis, integrating sales and market consumption. Furthermore, it taks audio-visual e-business as mould, the system as frame, then expands to other fields to complete and realize the needs in different fields.The system was designed with c# as development language, SQL Server 2005 as database,and Visual Studio 2005 as development tool. |