Research And Application Of TV Ratings Statistic And Analysis System Based On Data Warehouse

At present, with fast development of the broadcasting and television industries, Analog TV will be replaced by Digital TV (DTV) in our country. One merit of the DTV is that it can provide interactive service based on Hybrid Fiber Coax (HFC) network. The TV ratings have shown the quality of the TV programs and they also have reflected the requirement of the TV viewers. They are considered to be a fixed index of TV evaluation system.Based on return path for two-way HFC, this dissertation provides a method that the ratings data gathered through the Set Top Box (STB) and returned through the return path. The Data Warehouse (DW) is also built to pick up the useful information from this tremendous" data. The information will support the decision for Broadcasting and Television Company. At the same time, there are some other services in the back-end DTV systems. Most services are On-Line Transaction Processing (OLTP). They lack handling the business of depth analysis, can't get a necessary information to decision. This dissertation has accomplished the DW which centered the data. The data in the DW have been integrated. These integrating data have improved capabilities of user service information analysis and decision making in enterprise management level.Firstly, this dissertation has overall introduced the concept of DW, then explained the architecture of the DW, described the characteristics of the DW for multi-dimensional. Secondly, this dissertation has taken a preliminary introduction to the traditional methods of TV ratings investigation, pointed out the insufficiencies of these methods, then provided a method of ratings data gathering based on DTV. This method has made full use of the STB and the two-way path, sent the raw data to the back-end system. Thirdly, this dissertation has pointed out the absence of the OLTP service systems for decision support in broadcasting and television company, then provided the TV ratings statistic and analysis system based on data warehouse and the requirement analysis. Fourthly, this dissertation has designed the TV ratings statistic and analysis system. It has applied Microsoft SQL server 2000 and Analysis Services to set up the data warehouse and implement OLAP.