基于混合数据库的长江流域数据要素流通平台构建  

Construction of data circulation platform for Changjiang River Basin based on hybrid database technology

作　　者：金和平 杨磊 涂晶 罗惠恒 李林泽 安日辉 JIN Heping;YANG Lei;TU Jing;LUO Huiheng;LI Linze;AN Rihui(China Three Gorges Corporation,Wuhan 430071,China;Wuhan Science and Technology Innovation Park,China Three Gorges Corporation,Wuhan 430071,China)

机构地区：[1]中国长江三峡集团有限公司,湖北武汉430071 [2]中国长江三峡集团有限公司武汉科创园,湖北武汉430071

出　　处：《人民长江》2025年第3期222-229,共8页Yangtze River

基　　金：湖北省自然科学基金项目(2023AFD188)。

摘　　要：随着数字化技术的不断发展,数据要素对经济社会发展的推动作用日益显著,数据要素的流通有利于进一步释放数据的潜在价值。目前,长江流域数据要素已经具备了流通体系构建的基础,但其存储管理及共享缺乏标准化体系,存在多源异构数据资源管理效率低、安全共享支持能力较弱的问题。针对以上问题,利用耦合ClickHouse、PostgreSQL和MongoDB的混合数据库技术构建长江流域数据要素流通平台,实现业务管理、基础地理、时序数据、遥感影像4类主体要素的存储与共享,从数据结构和数据索引的角度设计了数据要素存储方案,从数据要素查询、服务和权限管理的角度设计了数据要素共享方案。该方法为数据要素流通平台提供大容量存储能力、高效写入写出能力以及并发共享能力,并通过区块链技术确保了数据要素流通全流程的安全性,形成了一套标准化的数据要素流通技术。实践应用表明,所提出的数据要素流通技术符合长江流域数据要素流通平台的应用需求。With continuous advancement of digital technologies,data elements have demonstrated significant driving effects on socio-economic development,as their circulation facilitates the further unleashing of latent data value.Currently,the Changjiang River Basin has established the basic infrastructure for data element circulation systems.However,there is still a lack of standardized frameworks for data storage management and sharing mechanisms.Therefore,this study proposes a hybrid database technology integrating ClickHouse,PostgreSQL,and MongoDB to construct a data element circulation platform for the Changjiang River Basin.This platform enables the storage and sharing of four main data elements,including business management data,basic geographic data,time series data,and remote sensing image data.The hybrid database technology designs the data element storage method based on data structure and data indexing,and designes the data element sharing method based on data query,service,and authority management.It provides the data element circulation platform with high-capacity storage,efficient data writing,and concurrent sharing capabilities,while ensuring the security of the entire data element circulation process through blockchain technology,forming a standardized set of data element circulation technologies.The practical application of the Changjiang River Basin data element circulation platform show that the proposed data element circulation technology meets the platform′s application requirements.

关 键 词：数据要素流通 数据存储 数据共享 列式数据库 关系型数据库 空间数据库 分布式文件数据库 长江流域 

分 类 号：F49[经济管理—产业经济] TP311.13[自动化与计算机技术—计算机软件与理论]