Computer Science ›› 2017, Vol. 44 ›› Issue (Z6): 510-514, 542.doi: 10.11896/j.issn.1002-137X.2017.6A.113

Previous Articles     Next Articles

Research on Construction and Application of Radio Monitoring Data Warehouse

TIAN Bin, ZHU Ya-lei, ZHANG Yun-chun, HU Jian-tao and ZHANG Chen-bin   

  • Online:2017-12-01 Published:2018-12-01

Abstract: When faced with massive data on radio signal detection and surveillance,the simple storage and queries fail to meet the application requirements.In order to satisfy the requirements of higher level decision making in radio monitoring system and intelligent monitoring services,a radio monitoring data warehouse was designed based on the preprocessing of the data collected from existing radio monitoring system.First,ETL (Extract/Transform/Load) rules were defined to collect data from application systems and information platforms.Second,an unknown signal data cube was built after the design of dimensions,measures,and levels.Finally,the implementation of analysis,prediction and decision-making functions based on multidimensional data models was done.It helps to enhance the business functions relatedwith unknown signals.

Key words: Data warehouse,Unknown signals,Radio monitoring,Data cube

[1] INMON WH.数据仓库[M].王志海,译.北京:机械工业出版社,2006.
[2] 周渝霞,刘道践,郝玉清.基于Oracle的OLTP与OLAP数据库设计及实现[J].电脑编程技巧与维护,2012(10):29-31.
[3] 左翔,姜文彪.分布式数据库系统的设计与优化[J].赤峰学院学报,2012,8(10):20-21.
[4] 顾玮.分布式数据库技术在教务管理系统中的应用[J].办公自动化,2009(24):50-52.
[5] 陈世敏.大数据分析与高速数据更新[J].计算机研究与发展,2015,2(2):333-342.
[6] 王有为,王伟平,孟丹.基于统计方法的Hive数据仓库查询优化实现[J].计算机研究与发展,2015,2(6):1452-1462.
[7] 武彤,谭光炜.基于索引视图实现动态数据仓库的实时数据加载[J].计算机科学,2016,49(6A):493-496.
[8] 苗晟,董亮,何丽波,等.基于小型监测站的无线电监测系统构建[J].电子测量技术,2014,7(5):132-135.
[9] 杜远宗,张金刚,夏堃,等.ETL工具在建设数据仓库中的应用[J].中国科技信息,2005(8):6.
[10] 崔忙良,张文彬.浅析不明信号的有效标注与排查[J].中国无线电,2005(1):46-47.

No related articles found!
Full text



[1] LEI Li-hui and WANG Jing. Parallelization of LTL Model Checking Based on Possibility Measure[J]. Computer Science, 2018, 45(4): 71 -75, 88 .
[2] XIA Qing-xun and ZHUANG Yi. Remote Attestation Mechanism Based on Locality Principle[J]. Computer Science, 2018, 45(4): 148 -151, 162 .
[3] LI Bai-shen, LI Ling-zhi, SUN Yong and ZHU Yan-qin. Intranet Defense Algorithm Based on Pseudo Boosting Decision Tree[J]. Computer Science, 2018, 45(4): 157 -162 .
[4] WANG Huan, ZHANG Yun-feng and ZHANG Yan. Rapid Decision Method for Repairing Sequence Based on CFDs[J]. Computer Science, 2018, 45(3): 311 -316 .
[5] SUN Qi, JIN Yan, HE Kun and XU Ling-xuan. Hybrid Evolutionary Algorithm for Solving Mixed Capacitated General Routing Problem[J]. Computer Science, 2018, 45(4): 76 -82 .
[6] ZHANG Jia-nan and XIAO Ming-yu. Approximation Algorithm for Weighted Mixed Domination Problem[J]. Computer Science, 2018, 45(4): 83 -88 .
[7] WU Jian-hui, HUANG Zhong-xiang, LI Wu, WU Jian-hui, PENG Xin and ZHANG Sheng. Robustness Optimization of Sequence Decision in Urban Road Construction[J]. Computer Science, 2018, 45(4): 89 -93 .
[8] LIU Qin. Study on Data Quality Based on Constraint in Computer Forensics[J]. Computer Science, 2018, 45(4): 169 -172 .
[9] ZHONG Fei and YANG Bin. License Plate Detection Based on Principal Component Analysis Network[J]. Computer Science, 2018, 45(3): 268 -273 .
[10] SHI Wen-jun, WU Ji-gang and LUO Yu-chun. Fast and Efficient Scheduling Algorithms for Mobile Cloud Offloading[J]. Computer Science, 2018, 45(4): 94 -99, 116 .