国家水资源监控能力建设项目数据库设计
Database Design of National Water Resources Monitoring Capacity Construction Project
DOI: 10.12677/JWRR.2020.94040, PDF,    国家科技经费支持
作者: 雷四华, 吴永祥, 王高旭：南京水利科学研究院，水利部水文水资源工程技术研究中心，江苏 南京
关键词: 国家水资源监控能力建设项目；数据库设计；对象关系表；数据归档管理；National Water Resources Monitoring Capacity Construction Project； Database Design； Object Relation Table； Data Archiving Management
摘要: 该数据库设计是在多方努力、历经多年建设实践中取得，是国家水资源监控能力建设项目形成的一系列标准规范的重要组成内容；各相关标准规范已在各级水资源管理部门得到应用，为水资源信息交换共享提供了关键性技术支撑。本文力求简练，从数据划分、数据库模型、关系表设计等方面介绍该数据库整体设计方案及主要技术特点；并根据当前对精准管理及数据安全需求，给出了一种有效的数据归档存储方案。
Abstract: 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.
文章引用：雷四华, 吴永祥, 王高旭. 国家水资源监控能力建设项目数据库设计[J]. 水资源研究, 2020, 9(4): 386-393. https://doi.org/10.12677/JWRR.2020.94040

参考文献

[1] 国家水资源监控能力建设项目办公室. 国家水资源监控能力建设项目标准制修订情况[EB/OL]. http://szyjk.mwr.gov.cn/szhjnl/, 2019-4-29. National Water Resources Monitoring Capacity Building Project Office. National water resources monitoring capacity building project standard preparation and revision. http://szyjk.mwr.gov.cn/szhjnl/, 2019-4-29. (in Chinese)
[2] 中国标准研究中心. 分类与编码通用术语: GB/T 10113-2003 [S]. 北京: 中国标准研究中心, 2003: 1-2. China Standards Research Center. General terms of classification and coding: GB/T 10113-2003. Beijing: China Standards Re-search Center, 2003: 1-2. (in Chinese)
[3] 王高旭, 吴永祥, 雷四华, 等. 国家水资源监控能力建设项目对象编码研究[J]. 水利信息化, 2018(6): 35-38. WANG Gaoxu, WU Yongxiang, LEI Sihua, et al. Study on object coding of national water resources monitoring capacity con-struction project. Water Conservancy Informatization, 2018(6): 35-38. (in Chinese)
[4] 雷四华, 韩晴. 国家水资源监控能力建设项目数据库数据完整性约束设计分析[J]. 水利信息化, 2018(3): 28-31. LEI Sihua, HAN Qing. Data integrity constraint design analysis of national water resources monitoring capacity construction pro-ject. Water Conservancy Informatization, 2018(3): 28-31. (in Chinese)
[5] 金喜来, 徐瑶. 国家水资源监控能力建设项目数据库标准规范应用实践[J]. 中国水利, 2015(19): 59-61. JIN Xilai, XU Yao. Application practice of national water resources monitoring capacity construction project database standard. China Water Resources, 2015(19): 59-61. (in Chinese)
[6] 张丽丽, 李臣民, 刘圆圆. 国家水资源监控能力建设项目标准应用情况分析[J]. 水利信息化, 2016(5): 39-44. ZHANG Lili, LI Chenmin, LIU Yuanyuan. Analysis on application of national water resources monitoring capacity construction project standard. Water Conservancy Informatization, 2016(5): 39-44. (in Chinese)