黑龙江土种数据库构建——基于第二次土壤普查数据Construction of Heilongjiang soil species database-based on the second national soil survey
杜书立,赵军
摘要(Abstract):
本数据库是在全国第二次土壤普查黑龙江土种志,黑龙江土壤,中国土壤,中国土种志等数据和资料的基础上,根据E-R数据模型的理论构建的关系型数据库,实现了数据库存贮和查询等功能。数据库包含黑龙江省63个市县,17个土类,48个亚类,127个土属和254个土种的数据资源,描述了土种的分布、面积、属性及生产性能,以及每个土种的典型剖面。该数据库可为黑土区域土壤肥力评价、土壤质量评价以及土壤资源可持续利用提供数据支持。
关键词(KeyWords): 黑龙江土种;全国第二次土壤普查;土壤调查;土壤数据库
基金项目(Foundation): 中国科学院战略性先导科技专项(A类)(XDA23060504);中国科学院“十三五”信息化专项科学大数据工程项目(XXH13505-07)
作者(Author): 杜书立,赵军
参考文献(References):
- [1]龚子同,张甘霖,陈志诚,等.土壤发生与系统分类[M].北京:科学出版社,2007.GONG Z T,ZHANG G L,ZHANG Z C,et al.Exogenesis and soil taxonomy[M].Beijing:Science Press,2007.
- [2]黑龙江省土地管理局,黑龙江省土壤普查办公室.黑龙江土壤[M].北京:农业出版社,1992.Heilongjiang Land Administration Bureau,Heilongjiang Soil Survey Office.The soil of Heilongjiang Province[M].Beijing:China Agriculture Press,1992.
- [3]施建平,宋歌.中国土种数据库-基于第二次土壤普查的全国性土壤数据集[J].中国科学数据,2016,(2):1-12.SHI J P,SONG G.Soil type database of China:a nationwide soil dataset based on the second national soil survey[J].China Scientific Data,2016,(2):1-12.
- [4]黑龙江省土壤普查办公室.黑龙江省第二次土壤普查数据册[M].哈尔滨:黑龙江省土地勘测利用技术中心,1990.Heilongjiang Soil Survey Office.Data book of the second national soil survey in Heilongjiang Province[M].Harbin:Heilongjiang Land Survey and Utilization Technology Center,1990.
- [5]黑龙江省土壤普查办公室.黑龙江土种[M].哈尔滨:黑龙江省土地勘测利用技术中心,1990.Heilongjiang Soil Survey Office.Soil species of Heilongjiang Province[M].Harbin:Heilongjiang Land Survey and Utilization Technology Center,1990.
- [6]席承藩,章士炎.全国土壤普查科研项目成果简介[J].土壤学报,1994,31(3):330-335.XI C F,ZHANG S Y.Brief introduction on achievements in national soil survey project since 1979[J].Acta Pedologica Sinica,1994,31(3):330-335.
- [7]唐近春.全国第二次土壤普查与土壤肥料科学的发展[J].土壤学报,1989,26(3):234-240.TANG J C.The second nationwide general soil survey and the developments in soil and pertilizer sciences[J].Acta Pedologica Sinica,1989,26(3):234-240.
- [8]段兴武,赵振,刘刚.东北典型黑土区土壤理化性质的变化特征[J].土壤通报,2012,43(3):529-534.DUAN X W,ZHAO Z,LIU G.The variations of soil physico-chemical properties since the second national soil survey in the northeast typical black soil regions[J].Chinese Journal of Soil Science,2012,43(3):529-534.
- [9]奚小环,杨忠芳,崔玉军,等.东北平原土壤有机碳分布与变化趋势研究[J].地学前缘,2010,17(3):213-221.XI X H,YANG Z F,CUI Y J,et al.A study of soil carbon distribution and change in Northeast Plain[J].Earth Science Frontiers,2010,17(3):213-221.
- [10]中华人民共和国国家质量监督检验检疫总局,中国国家标准化管理委员会.土壤科学数据元数据:GB/T 32739-2016[S].北京:中国标准出版社,2016.General Administration of Quality Supervision,Inspection and Quarantine of the People's Republic of China.Standardization Administration of the People's Republic of China.Metadata for soil science data:GB/T 32739-2016[S].Beijing:Standards Press of China,2016.
- [11]中华人民共和国国家质量监督检验检疫总局,中国国家标准化管理委员.生态科学数据元数据:GB/T 20533-2006[S].北京:中国标准出版社,2016.General Administration of Quality Supervision,Inspection and Quarantine of the People's Republic of China.Standardization Administration of the People's Republic of China.Metadata for Ecological Data:GB/T 20533-2006[S].Beijing:Standards Press of China,2016.
- [12]中国科学院南京土壤研究所.中国土壤[M].北京:科学出版社,1980.Nanjing soil research institute of CAS.The soil of China[M].Beijing:Science Press,1980.
- [13]全国土壤普查办公室.中国土种志[M].北京:中国农业出版社,1995.National Soil Census Office.The soil species records of China[M].Beijing:China Agriculture Press,1995.
- [14]隋跃宇,赵军,冯学民.关于黑土白浆土沼泽土的论述-张之一文选[M].哈尔滨:哈尔滨地图出版社,2013:228.SUI Y Y,ZHAO J,FENG X M.Discussion on black soil,white slurry soil and swamp soil-selected works of Zhang Zhiyi[M].Harbin:Harbin Cartographic Publishing House,2013:228.
- [15]张之一.关于黑土分类和分布问题的探讨[J].黑龙江八一农垦大学学报,2005,17(1):5-8.ZHANG Z Y.Discuss on issue of black soils classification and it's distribution[J].Journal of Heilongjiang Bayi Agricultural University,2005,17(1):5-8.
- [16]鲁如坤.土壤农业化学分析方法[M].北京:中国农业科技出版社,1999.LU R K.Analysis method of soil and agrochemistry[M].Beijing:China Agriculture Press,1999.
- [17]王能斌.数据库系统教程[M].北京:电子工业出版社,2004.WANG N B.Database system tutorial[M].Beijing:Publishing House of Electronics Industry,2004.
- [18]杨中书,刘臣宇.基于E-R模型的关系数据库设计方法[J].价值工程,2014,33(30):242-243.YANG Z S,LIU C Y.Design method of relation database based on E-R model[J].Value Engineering,2014,33(30):242-243.
- [19]周海鸥,许洪波.浅谈在数据库设计中E-R模型与关系数据模型转换的规律[J].科技资讯,2011(15):51.ZHOU H O,XU H B.Research on the transformation rules between E-R model and relational data model in database design[J].Science and Technology Information,2011(15):51.
- [20]喻济兵.基于Access数据库信息管理系统的设计[J].船电技术,2011,31(4):57-59,63.YU J B.Design of the information management system based on access database[J].Marine Electric&Electronic Engineering,2011,31(4):57-59,63.
- [21]王大龙,秦琦.ACCESS数据库和SQL Server数据库的应用比较[J].科技资讯,2010(4):18.WANG D L,QIN Q.Application Comparison of Access Database and SQL Server Database[J].Science and Technology Information,2010(4):18.
- [22]杨睿娜.数据库设计过程中E-R图向关系模型的转换[J].硅谷,2009(11):28,44.YANG R N.Conversion of E-R graph to relational model in database design[J].Silicon Valley,2009(11):28,44.
- [23]庄琴生.以E-R模型为基础构造数据仓库的概念模型[J].计算机工程与应用,2004(10):195-197,200.ZHUANG Q S.Constructing conceptual model of data warehouse based on E-R schema[J].Computer Engineering and Applications,2004(10):195-197,200.