| Nowadays,the television media retail business in the field of electricity providers has begun to show some obvious features,of which the more prominent ones are: large sales space,heavy workload and complicated work data.According to the operation and maintenance features of TV media,how to efficiently integrate TV media information,complete all aspects of data mining services and bring highly efficient data to the retail solutions of TV media is of great importance to the operation and maintenance of TV media in the field of e-commerce influences.The combination of technologies such as data warehousing and data mining and the retail media management approach in the e-commerce space can greatly improve the accuracy and punctuality of TV retail programs.Therefore,the development of such a system is urgent.After conducting research on the demand for retail decision support for the TV media,a clear system role requirement,function requirement and performance requirement are formed.Based on this,the system is designed in detail.Through the functional requirements of a clear system architecture framework and the corresponding level of functional responsibilities;The main functions of the system include data processing management,data query management,data analysis and forecast management decision-making four major functions,including the main basis for the division module is the system functional requirements.According to the requirements of system design in software engineering,the design of flow process and database required by the output system development is designed to meet the requirements of pre-design from the overall function and performance design to support the subsequent implementation and testing.In the process of project design and system development,we mainly follow the tenet of "overall design,distributed implementation,resource sharing and reasonable allocation",combined with the more advanced program development technologies and database technologies to fully realize the maximization of existing resource utilization rate,Achieve the goal of optimizing the efficiency of data mining,speeding up decision-making and management level.System selection Visual Studio 2008 as a system development platform,SQL Server 2015 Enterprise Edition as a database to carry out development,while using data mining and data warehouse technology,making the systemdevelopment efficiency,operational efficiency and maturity are reliably guaranteed.Once the television media retail decision support system is developed and passed the test,it can be put into the market for use.Related companies through the system trial,OLAP can combine the superior performance of data audit and data mining in intelligent search features,the three aspects of efficient integration,thereby greatly improving the efficiency of decision making,thereby enhancing the television The overall effectiveness of media retailers. |