Research Of On-Line Transaction Processing Model For Radio And TV Business

Radio and TV provide more and more services to users along with technology's development. Especially as the bidirectional transformation technology of CATV's HFC network becomes constantly mature, interactive services in radio and TV business, such as Video On Demand are emerging gradually. The increasement of business types and volume raises new demands to the database servers used in Business Operation Support System. This paper researches the radio and television business model, and specific and feasible method is put forward in the paper to estimate hardware configuration and server performance.Give a comprehensive introduction to various radio and television business, analyze the development situation, focused on the interactive business development status and trends such as interactive video-on-demand.Introduce On-line Transaction Processing related concepts, expound the the core content and evaluation indicators of TPC-C benchmark model. Discuss entities'model of radio and TV business, analyze the structure of each entity and related tables. Based on this sum up the major business transactions, analyze the transactions'complexity, take the example of billing transaction we calculate the complexity's value in detail. Calculate of the radio business transactions'volume in Wuhan, estimates the database server's performance indicators——tpmC. Finally,estimates the database server's hardware configuration.A great deal of practical research is done and the radio and TV business model established in this paper is representative. We choose IBM company's empirical formula for server's performance indicators calculating, and the result is reasonable.As radio and TV business is complex,some processes in transaction flow are omitted, a few of the parameters's choice is subjective, pending further study and improvement.