Design And Implementation Of Business Data Statistics And Analysis Platform Of Sichuan Cable TV Network Based On OLAP Technology

Data is the lifeblood of the enterprise network operators, business data analysis is an important tool to promote sustainable development of enterprise network operators, and therefore, statistical analysis platform technology is to achieve efficient and effective means to secure data processing. Currently, most radio and television operators to deal with the use of traditional transaction processing environments and data increasingly large data processing requirements of the increasingly high demand for management decision support, the lack of comprehensive data processing services, features timeliness and diversity. This phenomenon leads to radio and television operators the ability to weak corporate data applications, a lot of valuable information to be submerged. As demand management and business operators to use more and more data to urgent, use business intelligence technology to fully tap the potential of the data value and great significance. In this context, this paper combined with the actual situation SICHUAN CABLE TV NETWORK data processing operations, proposed the construction of a data analysis program platform.In this article, the first building on the background data analysis platform is analyzed, current development and design platforms need to use the technology are summarized, analyzed the necessity of using technology to build OLAP(On-Line Analytical Processing) data analysis platform. Status and OLAP systems require the construction of a paper based on SICHUAN CABLE TV NETWORK data processing operations, from feasibility analysis, data source analysis, functional analysis platform, platform interface analysis and data safety analysis of statistical data analysis platform for a detailed needs analysis. On the basis of the needs analysis, the paper designs the technology framework and architecture of the platform, the platform of functional modules and interfaces need to implement the specification design, and security platform were two levels of design, to ensure the smooth platform operational use. Demand and on the basis of the detailed design, the design of the platform software and hardware solutions, and developed a test program to test the platform, the platform through functional testing, performance testing platform and platform defect management indicated that the design and functionality of the platform to achieve perfect, good performance, and basically complete the system design goals.In the broadcasting industry, data processing lack of planning, lack of integration of the background papers combined SICHUAN CABLE TV NETWORK status quo of business data processing, statistical analysis, OLAP technology platform is based on the construction of the data used is suitable for SICHUAN CABLE TV NETWORK. Through the platform, implementation and testing, in general terms, the platform to build a data base platform that can integrate data sources, as far as possible to eliminate information silos, establish standard data model and implement a one-stop service data information, the data analysis and processing phase separation and data transaction processing, data processing to reduce the pressure of the production system, and be able to quickly respond to the evolving needs of the data, so that the business sector quick access to data, the need for timely response to decision support plays an important role.