船舶运输决策系统是为航运企业和港口等提供决策支持的重要信息系统。该系统通常采用索引机制,提升数据库的数据读取速率,从而提高整个决策系统的决策效率。本文提出一种基于遗传算法的数据库属性访问概率决策支持系统,使用遗传算法完成有效的最优数据库索引创建。本文提出的系统将Microsoft SQL Server 2000作为后端数据库,并采用C#进行实现。实验结果表明,本方法具有显著的性能改进,能够基于用户的访问需求,生成的最佳数据库索引集。
Decision making system of ship transportation is an important information system to provide decision support for shipping enterprises and ports. This system usually adopts the index mechanism to improve the reading speed of the data in the database, so as to improve the decision-making efficiency of the whole system. In this paper, we propose a database attribute access decision support system based on genetic algorithm. This system will be Microsoft SQL Server 2000 as a back-end database, and using C to achieve. Experimental results show that the proposed method has significant performance improvement, which can minimize the overhead involved in the query process and generate the best database index set based on access requirements.
2017,39(1A): 138-140 收稿日期:2016-10-31
DOI:10.3404/j.issn.1672-7619.2017.1A.047
分类号:TP311
作者简介:郑红霞(1977-),女,本科,副教授,研究方向为计算机应用。
参考文献:
[1] GÜTING R H, SCHNEIDER M, et al. moving objects databases[M]. USA:CRC press, 2007:15-18.
[2] 陈启楠. 舰船稳性实时监测系统研究与设计[J]. 舰船科学技术, 2011, 33(S1):39-42.
[3] ZHOU Z H, LIU ZY. The design of satellite communication system for delivering ocean environment monitoring data[J]. Ocean Technology, 2003, 1(22):58-62.
[4] LI Y F, BAI Y P. Marine environment monitoring database of south china sea region and web application development[J]. China New Technologies and Products, 2010, 1(12):50-54.
[5] PATTER J R, LIM T W, CHITRE M. Acoustic imaging & theNatural soundscapein singapore water[J], DSO-NUS Joint R&D Seminor, 1997(12):167-173.