摘要
数据库是沿海围垦区水资源一体化管理决策支持系统的重要组成部分。基于系统数据处理量的庞大而选择性能优异、可伸缩性强的Oracle数据库,以Oracle作为核心数据库,根据国家水资源监控能力建设的设计规范,设计了系统数据库的结构和功能,探讨了系统开发中Oracle安全机制的建立和完善。其开发目的是为了实现基础数据的集成与计算结果的规范化存储,从而达到数据整合和共享的目的,使系统在信息支撑层的基础上得以安全高效地运行。经过试用表明,该数据库能够很好地满足用户实时数据访问与管理的需求,提高系统运行效率,为沿海围垦区水资源管理的数字化、现代化、科学化提供了有力的技术支撑。
The design and development of database is an important part coastal reclamation area. This study chose Oracle database with excellent of water integration resources management decision support system of performance and scalability because of the large system data and the complexity of processing. Taking Oracle 10G as the core database, it designed the structure and function of database system according to the design specification of national water resources monitoring ability, explored the establishment and improvement of Oracle security mechanism in the research of system development and introduced the key technology of the system database design. The purpose of its development was to realize the data integration and normalized storage of the results, so as to achieve the effect of data integration and sharing and made the system run efficiently on the basis of information support layer. The trial application shows that the needs of the database can meet user real -time data access and management to improve the efficiency of the system, and provide strong technical support for digital, modern, scientific management of water resources in coastal reclamation area.
出处
《人民黄河》
CAS
北大核心
2016年第4期50-53,共4页
Yellow River
基金
"十二五"国家科技支撑计划项目(2012BAB03B03)
江苏省2014年度普通高校研究生科研创新计划项目(KYZZ_0145)
关键词
决策支持系统
数据库
ORACLE
水资源管理
沿海围垦区
decision support system
database
Oracle
water resources management
coastal reclamation area
作者简介
张政尧（1992-）,男,江苏涟水人,硕士研究生,研究方向为水资源规划与管理.E-mail：hhzzy1992＠163.com
