Design and realizing of the lightweight cable digital television data analysis system

Author

Qiaogong Dong ; Yujun Wen ; Pengzhou Zhang ; Jiuqiang Jiang

Author_Institution

Sch. of Comput. Sci., Commun. Univ. of China, Beijing, China

Volume

2

fYear

2011

fDate

12-14 Aug. 2011

Firstpage

813

Lastpage

815

Abstract

In order to get useful information from mass data of cable digital television to support TV station´s decision analysis, we present a lightweight cable digital television data analysis system. The system is based on the partition technology of SQL Server 2005 Database, and the data is collected by the set-top boxes of the digital TV. This paper elaborately discusses the architecture and the functional modules of the data analysis system, and emphasizes the storage management of the mass data and the optimization of the stored procedure. Through test, the system is proved to have a good performance on data processing and analysis, and it meets the need of the TV station.

Keywords

SQL; cable television; data analysis; digital television; storage management; SQL Server 2005 Database; Structured Query Language; TV station´s decision analysis; data processing; lightweight cable digital television data analysis system; mass data storage management; partition technology; set-top boxes; Data analysis; Digital TV; Indexes; Servers; Switches; digital TV data analysis; mass data processing; partitioned table;

fLanguage

English

Publisher

ieee

Conference_Titel

Electronic and Mechanical Engineering and Information Technology (EMEIT), 2011 International Conference on

Conference_Location

Harbin, Heilongjiang, China

Print_ISBN

978-1-61284-087-1

Type

conf

DOI

10.1109/EMEIT.2011.6023218

Filename

6023218