摘要
数据库优化问题是船舶数据管理系统中的一个关键模块,数据库优化结果直接影响数据查询效率和查询准性,针对当前船舶数据库优化方法存在的错误差、优化时间长等难题,以改善船舶数据库优化效果为目标,设计了一种基于聚类分析的船舶数据库优化方法。首先对船舶数据库优化原理进行分析,提出当前船舶数据库优化方法各自存在的不足,然后引入聚类分析算法对船舶数据库优化问题进行挖掘,发现船舶数据库变化特点,找到最优的船舶数据库优化策略,最后进行了船舶数据库优化仿真对比测试。相对于其他船舶数据库优化方法,聚类分析方法的船舶数据库查询效率高,改善了船舶数据库优化实时性,提高了船舶数据库查准率,船舶数据库优化结果显著优于对比船舶数据库优化方法,在船舶数据库管理中具有更高的应用价值。
Database optimization is a key module in ship data management system. The results of database optimization directly affect the efficiency and accuracy of data query. Aiming at the problems of poor error and long optimization time in current ship database optimization methods, a ship database optimization method based on clustering analysis is designed to improve the effect of ship database optimization.. Firstly, the principle of ship database optimization is analyzed,and the shortcomings of current ship database optimization methods are pointed out. Then the clustering analysis algorithm is introduced to mine the ship database optimization problem, find the changing characteristics of ship database, find the optimal strategy of ship database optimization, and finally, the ship database optimization simulation and comparative test are carried out. Compared with other ship database optimization methods, the clustering analysis method has high query efficiency,improves the real-time performance of ship database optimization, and improves the accuracy of ship database. The result of ship database optimization is significantly better than that of ship database optimization methods. It has higher application value in ship database management.
引文
[1]王青松,李爽,马瑞萍,等.基于模糊聚类分析的数据库模糊查询的研究[J].小型微型计算机系统,2015,36(6):1199–1202.
[2]刘文远,杨丹丹,王宝文. IRP中基于聚类分析的主题数据库划分研究[J].情报杂志,2009,28(1):17–18+16.
[3]陈怀,楼永坚.基于聚类分析的数据库入侵检测框架及其应用[J].杭州电子科技大学学报,2008,28(6):83–86.
[4]李侃,高春晓,刘玉树.基于SVM的空间数据库的层次聚类分析[J].北京理工大学学报,2002(4):485–488.
[5]梁双,周丽华,杨培忠.基于聚类分析分库策略的社交网络数据库查询性能与数据迁移[J].计算机应用,2017,37(3):673–679.