Computer Science ›› 2017, Vol. 44 ›› Issue (Z6): 510-514.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!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!