| Now is the era of rapid development of information technology,and radio technology is also advancing by leaps and bounds.Today,radio communication has covered all aspects of our social life,which greatly facilitates people's lives.This also puts pressure on radio management,monitors illegal signals,ensures normal radio communication,and monitors various channels to prevent the channel from being illegally occupied.At the same time,with the construction of China's radio monitoring system,radio monitoring facilities in various regions have gradually become networked,and higher requirements have been put forward for radio monitoring systems.The ever-increasing number of users of radio communication has led to a very large amount of data processing for radio monitoring systems.In this context,the performance requirements of the radio monitoring and monitoring system are becoming more and more demanding,and the performance of the database system largely affects the performance of the entire monitoring system.With the continuous development and growth of the monitoring service,the radio monitoring The database system has encountered performance bottlenecks,and the increase in hardware investment alone has been unable to meet the growth of monitoring data,such as adding large servers to the monitored network,or adding more memory and disk arrays to the server,but such costs will Very high,can not solve the performance bottleneck problem.In China,the optimization of radio monitoring system is mainly conducted in the aspect of hardware,and rarely involves the optimization of database.Firstly,the most important technologies in the development of radio monitoring system,including Oracledatabase technology,PowerdDesigerdatabasedesign technology and other technical principles involved in radio monitoring are applied in the research.Secondly,the requirement analysis and overall design of the radio monitoring system are carried out.Thesystemwilltakefeasibilityanalysis and Oracle database design,including database E-R design,database table design,and database physical structure design.Afterwards,the database optimization of the Oracle database of the radio monitoring system is designed in detail,including database system parameterconfiguration,instance optimization and Oracle SQL statement tuning.According to the optimization process of the database system of the radio monitoring system,combined with the service experience of Oracle database,the performance optimization research is done in the aspects of data storage mode,SQL statement tuning,index optimization in the storage process and table partition.For example,index improves the execution efficiency of the system by 40%in the aspect of stored procedure optimization.Finally,a radio monitoring system is designed.The main function modules include system management function,real-time monitoring function,business monitoring function,monitoring tools,etc. |
