| Through 95598 marketing system and other software,Sichuan Power Company has basically realized the informatization and automation of electric power marketing business management.However,with the continuous expansion of the power marketing business,the amount of data in the marketing business also increases rapidly.In order to be able to effectively integrate the power marketing data,according to the company’s marketing index rules,and to achieve data aggregation and secondary application,a set of marketing index management and control system is designed and implemented.In the research,the business background of the system was briefly described first.Based on the problems existing in the business,the development goals of the system is analyzed.The functional objectives of the system are divided into two aspects: index data interaction and index data management.At the same time,in accordance with the research and development goals of the system,the technical selection of the system was analyzed,and an overall technical framework based on Java Web technology and data interaction technology was established.Subsequently,the overall plan of the system is designed and analyzed,including functional model,network structure and module structure.The key technology of the system is sorted out,the key functions of the system are divided into three aspects: Web service function,data interaction function and data visualization function,and detailed analysis and design are carried out.The data logic structure of the system is analyzed,the E-R diagram is used as a tool to establish the data logic structure of the system,and the data table structure is defined and designed through the Oracle database.According to the functional characteristics of the system,the system’s function realization process is studied,and on this basis,the system’s internal function module realization process and method are studied,focusing on the realization principle and thinking of each function module,and the system function interface.Finally,the system was tested,and the function and performance of the system were investigated through actual application environment deployment.According to the system’s function and performance requirements,the system has been verified.This system uses database sharing and NAS network incremental technology to realize data cross-platform interaction with 95598 marketing system and other software.In accordance with the rules of marketing indicators,the interactive data is summarized,counted,and calculated to obtain more valuable information for decision-making assistance.Therefore,the system can replace the original application process of electric power marketing data through manual aggregation and analysis,and reduce the workload of marketing managers,which has high practical significance. |