国家水资源监控能力建设项目数据库设计

Database Design of National Water Resources Monitoring Capacity Construction Project

该数据库设计是在多方努力、历经多年建设实践中取得,是国家水资源监控能力建设项目形成的一系列标准规范的重要组成内容;各相关标准规范已在各级水资源管理部门得到应用,为水资源信息交换共享提供了关键性技术支撑。本文力求简练,从数据划分、数据库模型、关系表设计等方面介绍该数据库整体设计方案及主要技术特点;并根据当前对精准管理及数据安全需求,给出了一种有效的数据归档存储方案。

Database design technology is obtained through many efforts and many years of construction practice. It is an important part of a series of standards formed by the national water resources monitoring capacity construction project. All relevant standards have been applied in water resources management departments at all levels, providing a key technical support for water resources information exchange and sharing. This paper tries to concisely introduce the overall design scheme and main technical features of the database from the aspects of data division, database model, relational table design, etc., and give an effective data archiving and storage scheme according to the current demand for accurate management and data security.