大数据阶段项目之项目介绍 谁借莪1个温暖的怀抱¢ 2021-12-10 14:01 374阅读 0赞 # # **项目介绍** # 一、zebra概述 # ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70][] 1. 如图所示,电信运营商的用户通过连接到互联网中的各种网络设备访问一个网站时,其访问信息会通过基站在网络中传递,基站可以收集所有用户的访问日志数据 2. zebra是对电信运营商收集的用户上网数据进行分析的一个应用程序。通过分析得到的结果可以展现不同小区的上网详情 3. 注:zebra本意为斑马,命名类似hadoop的方式,并无特殊含义 # 二、整体分析 # 1. 该日志中的每一条数据都包含了77个字段,字段说明如下: <table style="margin-left:.3333in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段名</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">长度</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">说明</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">0</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">reporttime</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">string</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">14</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">从文件名截取获取,动态填上</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;"> Length</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">unsigned int</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">用于指示整个XDR所占用字节数</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">City</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">城市区号,如010代表北京</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">3</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Interface</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">unsigned int</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">接口类型,16进制编码</p> <p style="margin-left:0in;">1. Uu</p> <p style="margin-left:0in;">2. X2</p> <p style="margin-left:0in;">3. UE_MR</p> <p style="margin-left:0in;">4. Cell_MR</p> <p style="margin-left:0in;">5. S1-MME</p> <p style="margin-left:0in;">6. S6a</p> <p style="margin-left:0in;">7. S11</p> <p style="margin-left:0in;">8. S10</p> <p style="margin-left:0in;">9. SGs</p> <p style="margin-left:0in;">10. S5/S8</p> <p style="margin-left:0in;">11. S1-U</p> <p style="margin-left:0in;">12. Gn</p> <p style="margin-left:0in;">13~20 预留</p> <p style="margin-left:0in;">21. IDC出口</p> <p style="margin-left:0in;">22.省网出口</p> <p style="margin-left:0in;">23.省网网间出口</p> <p style="margin-left:0in;">24.骨干网网间出口</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">xDR ID</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">unsigned int</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">DPI设备内唯一的xDR编号,16进制编码。一个会话生成一个xDR ID。</p> <p style="margin-left:0in;">S1-U接口中,一个会话在同一个小区中的传输过程生成一个xDR ID,如该会话切换到新的小区,则生成新的XDR ID及会话记录。</p> <p style="margin-left:0in;">对于超长会话设立时间阈值,超过阈值则该条记录结束,重新生成另一条会话记录并生成新的XDR ID,阈值默认为5分钟。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">5</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">RAT</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">unsigned int</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">RAT类型,16进制编码</p> <p style="margin-left:0in;">1. UTRAN </p> <p style="margin-left:0in;">2. GERAN </p> <p style="margin-left:0in;">3. WLAN </p> <p style="margin-left:0in;">4. GAN </p> <p style="margin-left:0in;">5. HSPA Evolution</p> <p style="margin-left:0in;">6. EUTRAN</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">6</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">IMSI</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">用户IMSI(TBCD编码),通过Gn/S11接口信令获取</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">7</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">IMEI</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">终端IMEI(TBCD编码),通过Gn/S11接口信令获取</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">MSISDN</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">用户号码(TBCD编码),通过Gn/S11接口信令获取</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">9</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Machine IP Add type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">Unsigned int</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">设备IP地址类型,</p> <p style="margin-left:0in;">0x01:IPv4</p> <p style="margin-left:0in;">0x02:IPv6</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">10</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">SGW/GGSN IP Add</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4(16)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写GGSN的用户面IP地址;对于S1-U口,填写SGW的用户面IP地址</p> <p style="margin-left:0in;">Ipv4:4字节;</p> <p style="margin-left:0in;">Ipv6:16字节。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">11</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">eNB/SGSN IP Add</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4(16)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写SGSN的用户面IP地址;对于S1-U口,填写eNB用户面IP地址:</p> <p style="margin-left:0in;">Ipv4:4字节;</p> <p style="margin-left:0in;">Ipv6:16字节</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">12</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">SGW/GGSN Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写GGSN的端口;对于S1-U口,填写SGW端口</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">13</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">eNB/SGSN Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写SGSN的端口;对于S1-U口,填写eNB端口</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">14</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">eNB/SGSN GTP-TEID</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写该业务对应承载的SGSN侧GTP-TEID;对于S1-U口,填写该业务对应承载的eNB侧GTP-TEID</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">15</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">SGW/GGSN GTP-TEID</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">unsigned byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">对于Gn口,填写该业务对应承载的GGSN侧GTP-TEID;对于S1-U口,填写该业务对应承载的SGW侧GTP-TEID</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TAC</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TAC</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">17</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Cell ID</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">Byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">UE所在小区的ECI</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">18</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">APN</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">String</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">32</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">APN</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">19</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Type Code</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">业务类型编码,参见附录D XDR类型编码定义</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">20</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Procedure Start Time</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">dateTime</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP/UDP流开始时间,UTC时间),从1970/1/1 00:00:00开始到当前的毫秒数。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">21</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Procedure End Time</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">dateTime</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP/UDP流结束时间,UTC时间),从1970/1/1 00:00:00开始到当前的毫秒数。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">22</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Protocol Type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">协议类型</p> <p style="margin-left:0in;">集团规定的协议识别分类,参加《XXXX数据流量DPI识别能力规范》中的“DPI设备协议识别能力要求”</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">23</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">应用大类</p> <p style="margin-left:0in;">集团规定的18种应用大类,参见《XXXX数据流量DPI识别能力规范》</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">24</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Sub-type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">应用小类</p> <p style="margin-left:0in;">根据集团定义的识别规则识别出来的小类, 参见《XXXX数据流量DPI识别能力规范》。</p> <p style="margin-left:0in;">集团未定义的各厂家根据自己的DPI进行识别</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">25</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Content</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">应用小类的内容细分,如微信文本、微信语音等。</p> <p style="margin-left:0in;">0.心跳,1.文本,2.图片,3.音频,4.视频,5.其他文件</p> <p style="margin-left:0in;">如无则填全F。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">26</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Status</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">标识业务是否成功</p> <p style="margin-left:0in;">0:业务成功</p> <p style="margin-left:0in;">1:业务失败</p> <p style="margin-left:0in;">2:业务未识别</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">27</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">USER_IPv4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">终端用户的IPv4地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">28</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">USER_IPv6</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">终端用户的IPv6地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">29</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">User Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">用户的四层端口号</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">30</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">L4 protocal</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">L4协议类型:</p> <p style="margin-left:0in;">0:TCP</p> <p style="margin-left:0in;">1:UDP</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">31</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Server IP_IPv4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">访问服务器的IPv4地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">32</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Server IP_IPv6</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">访问服务器的IPv6地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">33</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">App Server Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">访问的服务器的端口</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">34</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">UL Data</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">上行流量</p> <p style="margin-left:0in;">单位:字节</p> <p style="margin-left:0in;">对于场景一,定义为从内层IP包头开始计算的数据包大小总和;</p> <p style="margin-left:0in;">对于其他场景,定义为从链路层封装开始计算的数据包大小总和。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">35</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">DL Data</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">下行流量</p> <p style="margin-left:0in;">单位:字节</p> <p style="margin-left:0in;"> </p> <p style="margin-left:0in;">对于场景一,定义为从内层IP包头开始计算的数据包大小总和;</p> <p style="margin-left:0in;">对于其他场景,定义为从链路层封装开始计算的数据包大小总和。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">36</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">UL IP Packet</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">上行IP包数</p> <p style="margin-left:0in;">内层IP包的个数</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">37</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">DL IP Packet</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">下行IP包数</p> <p style="margin-left:0in;">内层IP包的个数</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">38</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">上行TCP乱序报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">上行TCP乱序报文数</p> <p style="margin-left:0in;">L4协议非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">39</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">下行TCP乱序报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">下行TCP乱序报文数</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">40</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">上行TCP重传报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">上行TCP重传报文数</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">41</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">下行TCP重传报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">下行TCP重传报文数</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">42</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TCP建链响应时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP建链响应时延(ms)</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">43</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TCP建链确认时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP建链确认时延(ms)</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">44</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">UL_IP_FRAG_PACKETS</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">以内层IP包的分片为准</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">45</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">DL_IP_FRAG_PACKETS</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">以内层IP包的分片为准</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">46</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TCP建链成功到第一条事务请求的时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP建链成功到第一条事务请求的时延(ms)</p> <p style="margin-left:0in;">没有事务的时候可以不填写,此时填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">47</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">第一条事务请求到其第一个响应包时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">第一条事务请求到其第一个响应包时延(ms)</p> <p style="margin-left:0in;">没有事务的时候可以不填写,此时填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">48</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">窗口大小</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">窗口大小,TCP 建链协商后的窗口</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">49</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">MSS大小</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">MSS尺寸,TCP层的最大分段大小</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">50</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TCP建链尝试次数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP SYN的次数,一次TCP流多次SYN的数值</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">51</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">TCP连接状态指示</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">TCP连接状态指示</p> <p style="margin-left:0in;">0:成功;</p> <p style="margin-left:0in;">1:失败</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">52</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">会话是否结束标志</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">1:结束</p> <p style="margin-left:0in;">2:未结束</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">53</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">HTTP版本</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">0x01----HTTP0.9</p> <p style="margin-left:0in;">0x02----HTTP1.0</p> <p style="margin-left:0in;">0x03----HTTP1.1</p> <p style="margin-left:0in;">0x04----HTTP2.0</p> <p style="margin-left:0in;">0x05----WAP1.0</p> <p style="margin-left:0in;">0x06----WAP1.1</p> <p style="margin-left:0in;">0x07----WAP1.2</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">54</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">事务类型</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">HTTP/WAP2.0的事务类型,遵照HTTP/WAP1.x协议上的编码</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">55</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">HTTP/WAP事务状态</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">HTTP/WAP2.0层的响应码,参见附录A 状态编码</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">56</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">第一个HTTP响应包时延(MS)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">第一个HTTP响应包相对于第一个HTTP请求包(如get命令)的时延</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">57</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">最后一个HTTP内容包的时延(MS)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">最后一个HTTP内容包相对于第一个HTTP请求包(如get命令)的时延</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">58</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">最后一个ACK确认包的时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">最后一个HTTP包的ACK相对于第一个HTTP请求包(如get命令)的时延,如果无ACK,则按照最后一个数据包计算</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">59</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">HOST</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">64</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">访问域名</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">60</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">URI</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">512</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">访问的URI,对于超过512字节的URI进行截短</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">61</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">X-Online-Host</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">128</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">针对wap代理上网的私有头部字段,对于cmnet上网该字段与HOST字段相同</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">62</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">User-Agent</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">256</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">终端向访问网站提供的终端信息,包括IMEI、浏览器类型等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">63</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">HTTP_content_type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">128</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">HTTP的内容是文字还是图片、视频、应用等,具体编码参考附录A</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">64</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">refer_URI</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">128</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">参考URI</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">65</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Cookie</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">256</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">协议中Cookie字段</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">66</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Content-Length</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">协议中Content-Length字段</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">67</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">目标行为</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">目标行为,0:会话是用户主动点击的页面;1:站点目标而产生的页面。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">68</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">Wtp中断类型</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">WTP层的失败类型</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">69</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">wtp中断原因</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">WTP层失败原因</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">70</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">title</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">256</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">网站名称,在上网内容里解析</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">71</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">key word</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">256</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">网站关键字,在上网内容里解析</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">72</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">业务行为标识</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">0-业务登陆 1-页面访问</p> <p style="margin-left:0in;">2-刷新</p> <p style="margin-left:0in;">3-未识别;</p> <p style="margin-left:0in;">判断规则详见《业务KPI定义(20130821)》</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">73</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">业务完成标识</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">0-业务成功</p> <p style="margin-left:0in;">1-业务失败</p> <p style="margin-left:0in;">2-未识别</p> <p style="margin-left:0in;">成功的判断规则:状态码<400</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">74</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">业务时延(ms)</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">登陆、访问响应或者刷新时延,具体指标描述参见《业务KPI定义(20130821)》</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">75</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">浏览工具</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">详见附录F“浏览工具”,未识别的数据用0填充,该字段不能为空</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">76</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">门户应用集合</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">详见附录G“门户应用集合”,未识别的数据用0填充,该字段不能为空</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">77</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:2.0187in;"> <p style="margin-left:0in;">未知列</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0888in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.7534in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:6.6277in;"> <p style="margin-left:0in;">例:1:894/1102??这样字段</p> </td> </tr> </tbody> </table> **2.如图所示,运营商基站收集的用户上网日志中一行有很多字段,可能是用户某次短信发送,也可能是用户某次的通话,也可能是http访问或者app内通讯(比如:QQ好友之间聊天)等等。因为本次只针对所有的http访问进行分析,所以提取不同小区的上网详情所要处理的字段(清洗表):** <table style="margin-left:.3333in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段名</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">长度</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">说明</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">TAC</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">TAC</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">17</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">Cell ID</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">Byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">UE所在小区的ECI</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">19</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">App Type Code</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">业务类型编码,参见附录D XDR类型编码定义</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">20</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">Procedure Start Time</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">dateTime</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">TCP/UDP流开始时间,UTC时间),从1970/1/1 00:00:00开始到当前的毫秒数。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">21</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">Procedure End Time</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">dateTime</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">TCP/UDP流结束时间,UTC时间),从1970/1/1 00:00:00开始到当前的毫秒数。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">23</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">App Type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">应用大类</p> <p style="margin-left:0in;">集团规定的18种应用大类,参见《XXXX数据流量DPI识别能力规范》</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">24</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">App Sub-type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">应用小类</p> <p style="margin-left:0in;">根据集团定义的识别规则识别出来的小类, 参见《XXXX数据流量DPI识别能力规范》。</p> <p style="margin-left:0in;">集团未定义的各厂家根据自己的DPI进行识别</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">27</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">USER_IPv4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">终端用户的IPv4地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">29</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">User Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">用户的四层端口号</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">31</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">App Server IP_IPv4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">访问服务器的IPv4地址,如无则填全F</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">33</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">App Server Port</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">访问的服务器的端口</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">34</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">UL Data</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">上行流量</p> <p style="margin-left:0in;">单位:字节</p> <p style="margin-left:0in;">对于场景一,定义为从内层IP包头开始计算的数据包大小总和;</p> <p style="margin-left:0in;">对于其他场景,定义为从链路层封装开始计算的数据包大小总和。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">35</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">DL Data</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">下行流量</p> <p style="margin-left:0in;">单位:字节</p> <p style="margin-left:0in;"> </p> <p style="margin-left:0in;">对于场景一,定义为从内层IP包头开始计算的数据包大小总和;</p> <p style="margin-left:0in;">对于其他场景,定义为从链路层封装开始计算的数据包大小总和。</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">40</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">上行TCP重传报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">上行TCP重传报文数</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">41</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">下行TCP重传报文数</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">下行TCP重传报文数</p> <p style="margin-left:0in;">非TCP传输时,此字段填0</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">55</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">HTTP/WAP事务状态</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">HTTP/WAP2.0层的响应码,参见附录A 状态编码</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">59</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">HOST</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">64</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">访问域名</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">62</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">User-Agent</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">256</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">终端向访问网站提供的终端信息,包括IMEI、浏览器类型等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">63</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">HTTP_content_type</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">char</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">128</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">HTTP的内容是文字还是图片、视频、应用等,具体编码参考附录A</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">68</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">Wtp中断类型</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">WTP层的失败类型</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">72</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">业务行为标识</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">0-业务登陆 1-页面访问</p> <p style="margin-left:0in;">2-刷新</p> <p style="margin-left:0in;">3-未识别;</p> <p style="margin-left:0in;">判断规则详见《业务KPI定义(20130821)》</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">73</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.6381in;"> <p style="margin-left:0in;">业务完成标识</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.8493in;"> <p style="margin-left:0in;">byte</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">0-业务成功</p> <p style="margin-left:0in;">1-业务失败</p> <p style="margin-left:0in;">2-未识别</p> <p style="margin-left:0in;">成功的判断规则:状态码<400</p> </td> </tr> </tbody> </table> **其中,应用大类字段如下:** <table style="margin-left:.3333in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">业务类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">业务说明</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">即时通信</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">互联网消息即时收发业务,如:QQ、飞信等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">阅读</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">向用户提供在线或离线阅读服务的业务,如:移动手机阅读、熊猫阅读等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">3</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">微博</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">微博业务,如:移动微博、新浪微博等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">导航</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">提供浏览、查询、导航等功能的电子地图类业务,如:谷歌地图、高德导航等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">5</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">视频</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">向用户提供音视频内容的直播、分享和下载服务的网站和应用(不包括传统意义上基于P2P技术的视频业务),如:优酷、手机电视等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">6</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">音乐</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">提供音乐在线欣赏和下载服务的网站和应用,如:咪咕音乐、QQ音乐等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">7</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">应用商店</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">提供应用程序、音乐、图书等内容浏览、下载及购买服务的业务,如:Mobile Market、AppStore等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">游戏</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">基于客户端或者网页的游戏业务:QQ游戏、开心农场等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">9</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">支付</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">电子商务类业务,如:手机支付、支付宝、网银等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">10</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">动漫</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">提供动漫在线欣赏和下载服务的网站和应用,如:手机动漫、爱看动漫等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">11</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">邮箱</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">电子邮箱业务,如:139邮箱、QQ邮箱等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">12</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">P2P业务</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">基于P2P技术的资源共享业务,包括下载和视频两部分,前者如:迅雷、eMule等,后者如:迅雷看看、PPLive等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">13</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">VoIP业务</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">互联网语音通信业务,如:Skype、Uucall等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">14</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">彩信</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">彩信业务</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">15</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">浏览下载</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">基于HTTP、WAP、FTP等的普通浏览和下载业务</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">财经</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">金融资讯、股票证劵类业务,如:手机商界、大智慧等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">17</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">安全杀毒</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;">提供网络安全服务的应用,如:360安全卫士、麦咖啡等;以及网络恶意流量,如:病毒、攻击等</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">18</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.5208in;"> <p style="margin-left:0in;">其他业务</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;"> <p style="margin-left:0in;"> </p> </td> </tr> </tbody> </table> **DPI设备子业务识别能力要求(部分)** <table style="margin-left:.3333in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">业务类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">子业务</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;"> </span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;"> </span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;"> </span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;"> </span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">子业务名称</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">优先级</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">备注</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;">即时通信</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">1</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">飞聊</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;">自有业务</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">2</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">飞信</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">3</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Gtalk</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;">互联网业务</p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">4</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">MSN</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">5</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">QQ</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">6</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">TM</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">7</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">阿里旺旺</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">8</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">米聊</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">9</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">微信</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">10</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">人人桌面</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">必选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">11</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">AOL AIM</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">12</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Gadu_Gadu</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">13</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">go聊</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">14</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">ICQ</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">15</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">IMVU</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">16</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Lava-Lava</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">17</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">NetChat</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">18</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Paltalk</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">19</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">PowWow</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">20</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">TeamSpeak</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">21</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Trillian</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">22</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">VZOchat</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">23</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">Xfire</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">24</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">百度Hi</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">25</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">都秀</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">26</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">陌陌</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">27</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">天翼Live</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">28</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">翼聊</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">29</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">网易泡泡</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">30</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">新浪UC</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">31</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">新浪UT</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1951in;"> <p style="margin-left:0in;"> </p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.6868in;"> <p style="margin-left:0in;">32</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.4326in;"> <p style="margin-left:0in;">雅虎通</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.0423in;"> <p style="margin-left:0in;">可选</p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7527in;"> <p style="margin-left:0in;"> </p> </td> </tr> </tbody> </table> **3.对该字段进行整理,建立事实表F\_HTTP\_APP\_HOST:** <table style="margin-left:.3333in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><strong><span style="color:#FFFFFF;">序号</span></strong></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><strong><span style="color:#FFFFFF;">字段</span></strong></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><strong><span style="color:#FFFFFF;">字段类型</span></strong></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><strong><span style="color:#FFFFFF;">描述</span></strong></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">0</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">reportTime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">datetime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">小时 时间片 default 'YYYY-MM-DD HH24:MI:SS'</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">1</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">appType</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">应用大类</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">2</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">appSubtype</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">应用小类</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">3</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">userIP</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">用户IP</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">4</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">userPort</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">用户端口</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">5</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">appServerIP</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">服务器IP</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">6</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">appServerPort</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">服务器端口</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">7</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">host</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(50)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">域名</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">8</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">cellid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">小区ID</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">9</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">attempts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">10</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">accepts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">接受次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">11</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">上行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">12</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">下行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">13</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传上行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">14</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传下行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">15</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">failCount</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">延时失败次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:1.7347in;"> <p style="margin-left:0in;"><span style="color:#000000;">16</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.2527in;"> <p style="margin-left:0in;"><span style="color:#000000;">transDelay</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:3.6868in;"> <p style="margin-left:0in;"><span style="color:#000000;">传输时延*</span></p> </td> </tr> </tbody> </table> **4.可以利用该事实表来从不同维度进行分析:** 1. D\_H\_HTTP\_APPTYPE(应用欢迎度) <table style="margin-left:.7083in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">描述</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">0</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">hourid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">datetime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">小时时间片</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">1</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">appType</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">应用大类</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">2</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">appSubtype</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">应用小类</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">3</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">attempts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">4</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">accepts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">接受次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">5</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">succRatio</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试成功率</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">6</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">上行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">7</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">下行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">8</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">totalTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">总流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">9</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传上行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">10</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传下行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">11</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传报文数据</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">12</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">failCount</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">延时失败次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">13</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">transDelay</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">传输时延</span></p> </td> </tr> </tbody> </table> 1. D\_H\_HTTP\_HOST(各网站的表现) <table style="margin-left:.7083in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">描述</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">0</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">hourid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">datetime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">小时时间片</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">1</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">host</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(50)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">域名</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">2</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">appServerIP</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">服务器IP</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">3</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">attempts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">4</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">accepts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">接受次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">5</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">succRatio</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试成功率</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">6</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">上行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">7</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">下行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">8</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">totalTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">总流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">9</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传上行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">10</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传下行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">11</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传报文数据</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">12</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">failCount</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">延时失败次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">13</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">transDelay</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">传输时延</span></p> </td> </tr> </tbody> </table> 1. D\_H\_HTTP\_CELLID(小区HTTP上网能力) <table style="margin-left:.7083in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">描述</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">0</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">hourid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">datetime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">小时时间片</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">1</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">cellid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">小区ID</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">2</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">attempts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">3</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">accepts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">接受次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">4</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">succRatio</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试成功率</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">5</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">上行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">6</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">下行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">7</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">totalTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">总流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">8</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传上行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">9</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传下行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">10</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传报文数据</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">11</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">failCount</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">延时失败次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">12</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">transDelay</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:.85in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3083in;"> <p style="margin-left:0in;"><span style="color:#000000;">传输时延</span></p> </td> </tr> </tbody> </table> 1. D\_H\_HTTP\_CELLID\_HOST(小区上网喜好) <table style="margin-left:.7083in;"> <tbody> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">序号</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">字段类型</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#FFFFFF;">描述</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">0</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">hourid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">datetime</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">小时时间片</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">1</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">cellid</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">小区ID</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">2</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">host</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">varchar(50)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">域名</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">3</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">attempts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">4</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">accepts</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">接受次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">5</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">succRatio</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">尝试成功率</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">6</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">上行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">7</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">trafficDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">下行流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">8</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">totalTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">总流量</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">9</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranUL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传上行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">10</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranDL</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传下行报文数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">11</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">retranTraffic</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">重传报文数据</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">12</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">failCount</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">延时失败次数</span></p> </td> </tr> <tr> <td style="border-color:#a3a3a3;vertical-align:top;width:.6673in;"> <p style="margin-left:0in;"><span style="color:#000000;">13</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.1013in;"> <p style="margin-left:0in;"><span style="color:#000000;">transDelay</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.027in;"> <p style="margin-left:0in;"><span style="color:#000000;">int(20)</span></p> </td> <td style="border-color:#a3a3a3;vertical-align:top;width:1.3277in;"> <p style="margin-left:0in;"><span style="color:#000000;">传输时延</span></p> </td> </tr> </tbody> </table> [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70]: /images/20211210/ed1027f1994741ed8c85fb760722663c.png
还没有评论,来说两句吧...