Study On Optical Communications, Volume. 48, Issue 5, 74(2022)

A Construction Method of Wireless AP Data Warehouse based on Anomaly Identification and Lossy Compression

Ming LI, Ming-chun LI*, and Shi-chao LIU
Author Affiliations
  • FiberHome Telecommunication Technologies Co., Ltd., Wuhan 430074, China
  • show less
    Figures & Tables(8)
    The overall architecture diagram of data acquisition and processing and data warehouse realization
    The scheme of signal strength RSSI data processing
    The value of K and the trend chart of E
    Comprehensive judgment logic based on clustering results and reference exception generator
    • Table 1. The data set uploaded by terminal

      View table
      View in Article

      Table 1. The data set uploaded by terminal

      数据集测试数据集1测试数据集2训练数据集
      正常样本3 5773 4943 471
      异常样本23106129
    • Table 2. Anomaly detection result

      View table
      View in Article

      Table 2. Anomaly detection result

      信号强度训练数据集
      ≤-100 dBm12
      -100 dBm < &&≤-90 dBm71
      -90 dBm <&&≤-80 dBm46
      >-80 dBm3 471
      识别为异常135
      实际异常129
    • Table 3. Anomaly detection result

      View table
      View in Article

      Table 3. Anomaly detection result

      信号强度测试数据集1测试数据集2
      ≤-100 dBm153
      -100 dBm <&&≤-90 dBm438
      -90 dBm <&&≤-80 dBm4812
      >-80 dBm3 4943 577
      识别为异常10727
      实际异常10623
    • Table 4. Data compression comparison

      View table
      View in Article

      Table 4. Data compression comparison

      对比项目测试数据集1测试数据集2
      原始数据条数/条3 6003 600
      原始数据大小/kbit240240
      有损压缩数据条数/条229149
      有损压缩数据大小/kbit1610
      数据压缩率(%)6.74.2
    Tools

    Get Citation

    Copy Citation Text

    Ming LI, Ming-chun LI, Shi-chao LIU. A Construction Method of Wireless AP Data Warehouse based on Anomaly Identification and Lossy Compression[J]. Study On Optical Communications, 2022, 48(5): 74

    Download Citation

    EndNote(RIS)BibTexPlain Text
    Save article for my favorites
    Paper Information

    Category: Research Articles

    Received: Mar. 23, 2022

    Accepted: --

    Published Online: Nov. 18, 2022

    The Author Email: Ming-chun LI (375952106@qq.com)

    DOI:10.13756/j.gtxyj.2022.05.013

    Topics