Microsoft Word - 01-sifis_ed.doc ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 105 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina A. Tanovic Department for IT Development of Multimedia Services BH Telecom d.d. Sarajevo Bosnia and Herzegovina anel.tanovic@bhtelecom.ba I. Androulidakis Jožef Stefan International Postgraduate School Jamova 39, Ljubljana SI-1000, Slovenia sandro@noc.uoi.gr F. Orucevic Department of Computer Science and Informatics University of Sarajevo Bosnia and Herzegovina forucevic@etf.unsa.ba Abstract – IPTV service is a new service which is today offered from almost every Telecom operator. One of the advantages of IPTV service stemming from its architecture is certainly the fact that it is very easy to measure what TV channels are the ones mostly watched. This papers desribes this measurement and analysis results in one Telecom operator in Bosnia and Herzegovina. They describe what TV channels are mostly watched in different time periods. We developed a simple weighting algorithm to order the channels by watching rate. Based on it we are providing extensive tables. This paper forms an industrial contribution with results important for marketing but also is scientific contribution because it introduces one new method of scoring TV channels based on previous measurements in their audience. We also developed IPTV Statistics model and described results from this research for a new statistics model. This paper is the continuous of previously published contributions from this area. Keywords – IPTV; TV channel; telecom operator; channel rating; statistics model. I. INTRODUCTION IPTV service is a new IP service which is introduced in almost every Telecom operator [2-4]. IPTV system has several subsystems like: Middleware system, Video on Demand system, Encryption system, Database system, Monitoring system, Statistics system and Headend system [3-4]. Middleware system and the Statistics system are the important elements for the process of measurement of watched TV channels. The relationship between these 2 systems is shown in Figure 1. Figure 1. describes an IPTV system in one Telecom operator in Bosnia and Herzegovina where all measurements have been done. Middleware system is responsible for the normal working of all IPTV applications, Video on Demand system is responsible for all actions with Video on Demand contents, Encyption system is responsible for the encoding and decoding of live TV channels and VoD contents, Database system is responsible for the storing of all data, Monitoring system is responsible for the process of monitoring Set Top Boxes in each geographical area in Bosnia and Herzegovina and Headend system is responsible for the working of all satellite antennas, receivers and encoders [1, 3, 4]. Statistics system is responsible for communication with every Set Top Box and it has a MySQL database where millions of records are placed about the watched TV channels. With red colour in Figure 1 we are marking the Statistics system and with blue colour the Middleware system. Figure 1. describes the position of Statistics subsystem in the IPTV system and its connections to other IPTV subsystems, primarly to Middleware subsystem which is responsible for communication with STB’s on which users are watching TV channels. Fig. 1. The relationship between 2 IPTV subsystems Previous research of authors from this field is based on description of changing Middleware system based on ITIL V3 recommendations [3] and the analysis of implementation of Information Security Management in IPTV system of Telecom operator [4]. This research continues with researches in this Telecom operator and the aim of all investigations is to improve business processes which are connected to IPTV. This contribution builts upon [10] to further explore rating of IPTV channels user’s preference [11]. Section II describes the methodology of the measurement which is done in Telecom operator in Bosnia and Herzegovina and section III has a detailed description of the results in graphs. Section IV presents the conclusion of work in which is introduced one new method of scoring TV channels based on ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 106 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina previous done measurements and new developed IPTV Statistics model. II. METHODOLOGY OF THE RESEARCH Statistics system is responsible for communication with every Set Top Box [6, 7]. This system has internal scripts and a MySQL database which is responsible for storing all data [5]. Internal scripts communicate with every Set Top Box and if user watches one TV channel more than 60 seconds, these scripts write the relevant new record in the MySQL database. The value of 60 seconds is an approximate value stemming from previous research in the area, trying to answer the question of how many continuous seconds must elapse before we can say that the user is actually watching the given TV channel [8, 9]. The main table in this database is table STAT which contains fields that are described in Table I. TABLE I. TABLE STAT IN STATISTICS DATABASE The name of field The meaning of field Type of the variable EVENT_ID This field signs what type of IPTV content is used for statistics – 1 is for TV, 2 is for VoD, 3 is for Radio INTEGER CHANNEL_TAG The name of TV channel VARCHAR2 SUBSCRIBER_ID Unique number for each subscriber INTEGER DEVICE_ID Unique number for each Set Top Box INTEGER CONTENT_ID Unique number for each TV content INTEGER TIMESTAMP The time when TV content starts DATETIME DURATION The duration of TV content INTEGER RATING The rating of TV content INTEGER INSERT_DATE Date and time when the record is inserted into MySQL database DATETIME All measurements are done with a few SQL queries which link all these fields: “select channel_tag, sum(duration)/3600 from stat s where s.event_id='1' and s.timestamp between '2011-05-01 00:00:00' and '2011-06-01 00:00:00' group by s.content_id” The measurements have been done on 30,000 of users and they included 16840649 records during May 2011. This month has been taken into account because the number of IPTV users in Telecom operator [4] was the biggest in this month. The number of TV channels is 75. The research has been done in 11 categories (each category corresponding to different time periods) and for each category we included the first 20 TV channels. For the rating algorithm, 20 points are given for the 1 st channel in order in each test category, 19 points are given for the 2 nd channel in order, 18 points are given for the 3 rd channel in order, 17 points are given for the 4 th channel in order etc. and for the last 20 th channel just 1 point. The summary results are given in table II. TABLE II. THE NUMBER OF POINTS FOR EACH TV CHANNEL The name of TV channel The number of points for each TV channel FTV 219 NTV HAYAT 200 OBN 197 BHT 189 NOVA TV 178 PINK BIH 171 MINIMAX 141 OTV VALENTINO 139 HRT 1 123 FOX LIFE 122 TV 1 111 TVSA 97 FOX CRIME 73 RTV SLON 69 NTV JASMIN 65 DISNEY XD 58 ARENA SPORT 3 46 HRT 2 37 DISC. TRAVEL & LIVING 26 RTV TK 13 DISCOVERY 11 RTL + 6 ARENA SPORT 2 5 TV 1000 4 HISTORY CHANNEL 4 NATIONAL GEOGRAPHY 2 EUROSPORT 2 ARENA SPORT 4 1 III. RESULTS Figure 2 presents the most watched TV channels during May 2011. Figure 3 shows the most watched TV channels in the 1 st week of May 2011 from 1 st May to 8 th May. Figure 4 presents the most watched TV channels in the 2 nd week of May 2011 from 8 th May to 15 th May. Figure 5 shows the most watched TV channels in the 3 rd week of May 2011 from 15 th May to 22 th May. Figure 6 shows the most watched TV channels in 4 th week of May 2011 from 22 nd May to 31 st May. Figure 7 presents the most watched TV channels for working days through May 2011. As such, it includes every day except weekend days with total number of 24 days. Figure 8 shows the most watched TV channels for weekend days through May 2011 with the total number of 7 days. Figure 9 describes the most watched TV channels for morning hours which includes hours from 6 a.m. to 12 a.m. Figure 10 presents the most watched TV channels for afternoon hours which includes hours from 12 a.m. to 8 p.m. Figure 11 describes the most watched TV channels for evening hours which includes hours from 8 p.m. to 11 p.m. Figure 12 presents the most watched TV channels for night hours which includes hours from 12 p.m. to 6 a.m. ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 107 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina The column ‘the number of points for each TV channel’ in table II is the summary of points for each TV channel in all measurements. In all measurements, we gave 20 points for the 1st TV channel, 19 points for the 2nd TV channel, 18 points for the 3rd TV channel and etc., and finally 2 points for the 19th TV channel and 1 point for the 20th TV channel. The total number of TV channels that have at least 1 point is 28. So even 47 TV channels, of the total number of TV channels which are 75, are not presented in this table. Table II shows that first 5 TV channels are local channels, and in first 10 channels is just 1 foreign TV channel. Month report 0 200000 400000 600000 800000 1000000 1200000 1400000 1600000 FT V H a ya t T V O B N B H T 1 N o va T V P in k B H M in im ax O T V V al en tin o F O X L ife H R T 1 T V 1 T V S A F O X C rim e R T V S lo n N T V J as m in D is ne y X D A re n a S po rt 3 H R T 2 D is c. T ra ve l & L iv in g R T V T K TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 2. The most watched TV channels in month (May 2011.) Week 1 Report 0 50000 100000 150000 200000 250000 300000 350000 400000 F T V O B N H a ya t T V B H T 1 N o va T V P in k B H M in im ax O T V V al en tin o F O X L ife H R T 1 T V 1 T V S A N T V J as m in R T V S lo n A re n a S po rt 3 F O X C rim e D is ne y X D D is c. T ra ve l & L iv in g D is co ve ry R T V T K TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 3. The most watched TV channels in the 1 st week of month (May 2011.) ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 108 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Week 2 Report 0 50000 100000 150000 200000 250000 300000 FT V B H T 1 O B N H ay at T V N o va T V P in k B H M in im ax H R T 1 O T V V al en tin o F O X L ife T V S A T V 1 R TV S lo n N T V J as m in F O X C rim e D is ne y X D A re n a S po rt 3 H R T 2 D is c. T ra ve l & L iv in g D is co ve ry TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 4. The most watched TV channels in the 2 nd week of month (May 2011.) Week 3 Report 0 50000 100000 150000 200000 250000 300000 350000 400000 FT V O B N H ay at T V P in k B H N o va T V B H T 1 M in im ax O T V V al en tin o F O X L ife T V 1 H R T 1 R TV S lo n T V S A F O X C rim e D is ne y X D N T V J as m in H R T 2 A re n a S po rt 3 D is c. T ra ve l & L iv in g D is co ve ry TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 5. The most watched TV channels in the 3 rd week of month (May 2011.) ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 109 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Week 4 Report 0 50000 100000 150000 200000 250000 300000 350000 400000 450000 FT V H ay at T V O B N B H T 1 N o va T V P in k B H M in im ax O T V V al en tin o T V 1 F O X L ife H R T 1 T V S A F O X C rim e D is ne y X D N T V J as m in R TV S lo n H R T 2 R T V T K D is c. T ra ve l & L iv in g A re n a S po rt 3 TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 6. The most watched TV channels in the 4 th week of month (May 2011.) Working days Report 0 200000 400000 600000 800000 1000000 1200000 FT V O B N H ay at T V B H T 1 N o va T V P in k B H M in im ax O T V V al en tin o F O X L ife H R T 1 T V S A T V 1 R TV S lo n F O X C rim e N T V J as m in D is ne y X D H R T 2 A re n a S po rt 3 D is c. T ra ve l & L iv in g D is co ve ry TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 7. The most watched TV channels in working days of month (May 2011.) ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 110 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Weekend days Report 0 50000 100000 150000 200000 250000 300000 350000 FT V B H T 1 H ay at T V P in k B H N o va T V O B N M in im ax O T V V al en tin o T V 1 H R T 1 F O X L ife R TV S lo n N T V J as m in T V S A F O X C rim e A re n a S po rt 3 D is ne y X D R T V T K D is c. T ra ve l & L iv in g H R T 2 TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 8. The most watched TV channels in weekend days of month (May 2011.) Morning hours Report 0 50000 100000 150000 200000 250000 300000 350000 H ay at T V FT V O B N P in k B H B H T 1 N o va T V M in im ax R TV S lo n H R T 1 T V S A N T V J as m in F O X L ife O T V V al en tin o D is ne y X D T V 1 F O X C rim e R T V T K H R T 2 D is c. T ra ve l & L iv in g D is co ve ry TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 9. The most watched TV channels in morning hours of month (May 2011.) ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 111 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Afternoon hours Report 0 100000 200000 300000 400000 500000 600000 700000 FT V O B N H ay at T V B H T 1 N o va T V M in im ax P in k B H O T V V al en tin o F O X L ife D is ne y X D H R T 1 N T V J as m in T V 1 T V S A R TV S lo n F O X C rim e D is c. T ra ve l & L iv in g A re n a S po rt 3 D is co ve ry R T V T K TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 10. The most watched TV channels in afternoon hours of month (May 2011.) Evening hours Report 0 50000 100000 150000 200000 250000 300000 350000 400000 F T V O B N H a ya t T V B H T 1 N o va T V P in k B H H R T 1 O T V V al en tin o T V 1 A re n a S po rt 3 F O X L ife T V S A H R T 2 F O X C rim e R T L + A re n a S po rt 2 T V 10 00 D is ne y X D E ur o sp o rt A re n a S po rt 4 TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 11. The most watched TV channels in evening hours of month (May 2011.) ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 112 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina Night hours Report 0 50000 100000 150000 200000 250000 300000 FT V N o va T V B H T 1 H ay at T V P in k B H O B N O T V V al en tin o T V 1 F O X L ife H R T 1 F O X C rim e T V S A H R T 2 A re n a S po rt 3 A re n a S po rt 2 D is c. T ra ve l & L iv in g H is to ry C h an ne l D is co ve ry N at G e o N T V J as m in TV Channel N u m b e r o f w a tc h in g h o u rs Fig. 12. The most watched TV channels in night hours of month (May 2011.) Final results 219 200 197 189 178 171 141 139 123 122 111 97 73 69 65 58 46 37 26 13 11 6 5 4 4 2 2 1 0 50 100 150 200 250 F T V O B N N O V A T V M IN IM A X H R T 1 T V 1 F O X C R IM E N T V J A S M IN A R E N A S P O R T 3 D IS C . T R A V E L & L IV IN G D IS C O V E R Y A R E N A S P O R T 2 H IS T O R Y C H A N N E L E U R O S P O R T TV channel N u m b e r o f p o in ts Fig. 13. Final results after all 11 tests TABLE III. RESULTS FOR IPTV STATISTICS MODEL FOR THIS RESEARCH The name of category Results for each category 1 st 42.5% 2 nd 30.1% 3 rd 25.7% 4 th 1.5% 5 th 0% ETASR - Engineering, Technology & Applied Science Research Vol. 1, �o. 5, 2011, 105-113 113 www.etasr.com Tanovic et al: Analysis of IPTV Channels Watching Preferences in Bosnia and Herzegovina IV. CONCLUSION AND FUTURE WORK Comparison of results from Figure 13 and other figures is giving these concluding remarks for Telecom operator from Bosnia and Herzegovina: 1. Final results are totally the same as the results from Figure 2 which considers the most watched TV channels in a month for the first 20 channels except that in the final result TV channel HRT 1 is not on 10 th place but on 9 th place. 2. Last seven TV channels on final Figure 13 are obtained from Figure 11 which represents the most watched TV channels in the evening hours. It means that for each analysis of the most watched TV channels, evening hours (from 8 p.m. to 11 p.m.) should be placed in the special category. 3. The analysis has shown that 28 TV channels are presented in the final table. The total number of TV channels are 75, so 47 TV channels are almost not watched. 4. 8 of 10 first TV channels are local TV channels and only Minimax, which is on the 7 th place, and Fox Life, which is on the 10 th place, are foreign TV channels. Simply conclusion is that local TV channels are more watched than foreign TV channels. 5. There are major differences in ratings between the first 6 TV channels and only minor differences in ratings between channels under the 6 th place. 6. First 12 TV channels are only important for the most users (the number of points is 100 and more). This is specific result for this Telecom operator. This analysis can be used to predict user prefences about watching TV channels in Bosnia and Herzegovina. From previous research we can conclude what TV channels are most watched in: morning hours, afternoon hours, evening hours, night hours or during working days or weekends. In this way this investigation can be one important step for future sociology investigations about users’ preferences and wishes during different hours or different days. This research is important step for future not only technical studies but also sociological studies. Because of future researches in this area and based on results that are produced in this investigation, we proposed a little IPTV statistics model in which all TV channels are divided in 5 categories. In the first category are TV channels with a very high level of watching, in the second category are TV channels with a high level of watching, in the third category are TV channels with a medium level of watching, in the fourth category are TV channels with a low level of watching and in the fifth category are TV channels with a very low level of watching. For Telecom operator with 100 TV channels in the 1 st category are first the most watched TV channels, in the 2 nd category are TV channels from 6 th to 10 th place, in the 3 rd category are TV channels from 11 th to 20 th place, in the 4 th category are TV channels from 21 st place to 50 th place and in the 5 th category are TV channels from 51 st place to 100 th place. The aim is to compare results from the same Telecom operator in different months or from different Telecom operators in the same month. Future research in this area is based on these comparisons. Table III shows results for IPTV statistics model which are produced in this research. This result shows that all 3 channel categories in this research are almost equally watched. REFERENCES [1] A. Tanovic, I. Androulidakis, “Improving the eTOM standard for Telecom operators”, XXIII International Symposium on Information, Communication and Automation Technologies, ICAT 2011, Sarajevo, Bosnia and Herzegovina, 2011. [2] A. Tanovic, F. Orucevic, “Implementation of the Information System of the Telecom Operator Using the ITIL V3 Methodology for the Service Design Phase”, 2 nd International Conferences on Advanced Service Computing, SERVICE COMPUTATION 2010, pp. 82 - 91, Lisbon, Portugal, 2010. [3] A. Tanovic, F. Orucevic, “Changing the Middleware System for IPTV Services Telecom Operators Based on the Methodology of the Change Management Process”, 3 rd International Conferences on Advances in Multimedia, MMEDIA 2011, pp. 104 - 110, Budapest, Hungary, 2011. [4] A. Tanovic, F. Orucevic, “Analysis of the implementation of the Information Security Management in the IPTVVoIP system of the Telecom Operator”, 18 th International Conference on Systems, Signals and Image Processing, IWSSIP 2011, pp. 1-5, Sarajevo, Bosnia and Herzegovina, 2011, [5] J. Huang, A.B. Lee, D. Mumford, “Statistics of range images”, IEEE Conference on Computer Vision and Pattern Recognition, Vol. 1, pp. 324-331, 2000. [6] P. Gacs, J. T. Tromp, P. M. B. Vitanyi, “Algorithmic statistics”, IEEE Transactions on Information Theory, Vol. 47, No. 6, pp. 2443-2463, 2001. [7] Y. J. Won, Mi-Jung Choi, Byung-Chul Park, J. W. Hong, Hee-Won Lee, Chan-Kyu Hwang, Jae-Hyoung Yoo, “End-User IPTV Traffic Measurement of Residential Broadband Access Networks”, IEEE Network Operations and Management Symposium Workshops, NOMS 2008, pp. 95-100, 2008. [8] T. Zijian, R. C. Cannizzaro, G. Leus, P. Banelli, “Pilot-Assisted Time-Varying Channel Estimation for OFDM Systems”, IEEE Transactions on Signal Processing, Vol. 55, No. 5, pp. 2226-2238, 2007. [9] M. K. Tsatsanis, G.B. Giannakis, “Blind identification of time- varying channels using second-order statistics”, 29 th Asilomar Conference on Signals, Systems and Computers, pp. 162-166, 1995. [10] M. -J. Montpetit, H. Calhoun, H. Holtzman, D. Grossman, “Adding the Community to Channel Surfing: A New Approach to IPTV Channel Change.” 6th IEEE Consumer Communications and Networking Conference, CCNC 2009, pp. 1 – 5, Las Vegas, Nevada, USA, 2009 [11] H. Lin Wang, J. Gang Wang, W. Yun Yau, “Automated age regression for personalized IPTV services”, IEEE International Conference on Multimedia and Expo (ICME 2010), pp. 1333-1336, Singapore, 2010.