首页 期刊 论文 学科刊群 资讯 加盟 关于
EN
image
Article(id=1171165154826821759, tenantId=1146029695717560320, journalId=1146123346816638986, issueId=1171165154017321083, articleNumber=1000-8063(2025)03-0114-09, orderNo=null, doi=10.13426/j.cnki.yky.2025.01.03, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1736352000000, receivedDateStr=2025-01-09, revisedDate=null, revisedDateStr=null, acceptedDate=null, acceptedDateStr=null, onlineDate=1757157132106, onlineDateStr=2025-09-06, pubDate=1757433600000, pubDateStr=2025-09-10, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1757157132106, onlineIssueDateStr=2025-09-06, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1757157132106, creator=13701087609, updateTime=1757157132106, updator=13701087609, issue=Issue{id=1171165154017321083, tenantId=1146029695717560320, journalId=1146123346816638986, year='2025', volume='44', issue='3', pageStart='1', pageEnd='154', issueExtLink='null', onlineDate='null', pubDate='null', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=1, specialIssue=null, createTime=1757157131914, creator=13701087609, updateTime=1757582122913, updator=13701087609, preIssue=null, nextIssue=null, ext={EN=IssueExt(id=1172947695539994987, tenantId=1146029695717560320, journalId=1146123346816638986, issueId=1171165154017321083, language=EN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=), CN=IssueExt(id=1172947695539994988, tenantId=1146029695717560320, journalId=1146123346816638986, issueId=1171165154017321083, language=CN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=)}, issueFiles=null}, startPage=114, endPage=122, ext={EN=ArticleExt(id=1171165155032342660, articleId=1171165154826821759, tenantId=1146029695717560320, journalId=1146123346816638986, language=EN, title=Realization Method of Updating Resource Reserve Data Based on National Survey Database of Mineral Resources, columnId=null, journalTitle=Uranium Mining and Metallurgy, columnName=null, runingTitle=null, highlight=null, articleAbstract=

The data of mineral resources reserves is the focus of the management of mineral resources reserves, and the national survey of mineral resources is a national and basic survey of mineral resources. Based on the national survey database of mineral resources in Henan Province, it is necessary to study and put forward a method to quickly update the resource reserve data in the mineral resources reserve database to facilitate the efficient use of the mineral resources management department, which is necessary to solve many problems such as data missing, error, redundancy and low timeliness in the reserve database and to better manage the mineral resources. By designing a computer program algorithm, the resource reserve data records in the national survey database of mineral resources and the mineral resource reserve database were automatically compared according to the relevant fields, and the differences were found. According to the differences, different program codes were adopted to update the resource reserve data in the reserve database. Compared with the method of manually updating data in daily reserves management, this method can update the resources and reserves data in the mineral resources and reserves database more comprehensively, quickly, efficiently and accurately.

, correspAuthors=null, authorNote=null, correspAuthorsNote=null, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=null, magXml=null, pdfUrl=null, pdf=null, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=null, mapNumber=null, authorCompany=null, fund=null, authors=null, authorsList=Liqian DAI, Chaohui ZHU, Yuan MIN), CN=ArticleExt(id=1171165422113039195, articleId=1171165154826821759, tenantId=1146029695717560320, journalId=1146123346816638986, language=CN, title=基于国情调查更新矿产资源储量数据的实现方法, columnId=1171165154847793280, journalTitle=铀矿冶, columnName=开采·选治, runingTitle=null, highlight=null, articleAbstract=

矿产资源储量数据是矿产资源储量管理的重要抓手,矿产资源国情调查是一项全国性、基础性的矿产资源调查工作。基于目前河南省已全面完成的矿产资源国情调查数据库,提出快速更新矿产资源储量数据库中资源储量数据的方法,以方便矿产资源管理部门高效使用。本方法对于解决储量库中的数据缺失、错误、冗余、时效性低等诸多问题和更好地进行矿产资源管理十分必要。通过设计计算机程序算法,对矿产资源国情调查数据库和矿产资源储量数据库中的资源储量数据记录按照相关字段进行自动对比,查找差异,分情况采取不同的程序代码,对储量库中资源储量数据实施更新。和日常储量管理中常采用的人工更新数据方法相比,本方法能更全面、快速、高效、准确地实现矿产资源储量数据库中资源储量数据的更新。

, correspAuthors=null, authorNote=null, correspAuthorsNote=
祝朝辉(1978—),男,河南滑县人,博士,正高级工程师,主要从事矿产资源规划、开发利用与保护研究工作。
, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=fJMRchnIdwwmH4FS72GiCQ==, magXml=iYRZBfZ59Ukwf6NiGPjrSw==, pdfUrl=null, pdf=+ccRzrDG0xSAXmf589Fk0w==, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=qRa1y9XhrRy6vDyt69+9lw==, mapNumber=null, authorCompany=null, fund=null, authors=

戴立乾(1976—),男,河南驻马店人,工程硕士,高级工程师,主要从事矿产资源调查和研究、数据库工作。

, authorsList=戴立乾, 祝朝辉, 闵元)}, authors=[Author(id=1171206550321414159, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1171206550396911634, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550321414159, language=EN, stringName=Liqian DAI, firstName=Liqian, middleName=null, lastName=DAI, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=1, 2, address=1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China
2. Henan Key Laboratory of Land and Resources Remote Sensing Monitoring, Zhengzhou 450053, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1171206550447243283, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550321414159, language=CN, stringName=戴立乾, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=1, 2, address=1.河南省国土空间调查规划院,河南 郑州 450053
2.河南省国土资源遥感监测重点实验室,河南 郑州 450053, bio={"content":"

戴立乾(1976—),男,河南驻马店人,工程硕士,高级工程师,主要从事矿产资源调查和研究、数据库工作。

"}, bioImg=null, bioContent=

戴立乾(1976—),男,河南驻马店人,工程硕士,高级工程师,主要从事矿产资源调查和研究、数据库工作。

, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1171206550040395780, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550048784389, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China), AuthorCompanyExt(id=1171206550052978694, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1.河南省国土空间调查规划院,河南 郑州 450053)]), AuthorCompany(id=1171206550136864775, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550145253384, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550136864775, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=2. Henan Key Laboratory of Land and Resources Remote Sensing Monitoring, Zhengzhou 450053, China), AuthorCompanyExt(id=1171206550149447689, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550136864775, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=2.河南省国土资源遥感监测重点实验室,河南 郑州 450053)])]), Author(id=1171206550552100885, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1171206550644375575, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550552100885, language=EN, stringName=Chaohui ZHU, firstName=Chaohui, middleName=null, lastName=ZHU, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=1, address=1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1171206550707290136, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550552100885, language=CN, stringName=祝朝辉, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=1, address=1.河南省国土空间调查规划院,河南 郑州 450053, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1171206550040395780, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550048784389, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China), AuthorCompanyExt(id=1171206550052978694, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1.河南省国土空间调查规划院,河南 郑州 450053)])]), Author(id=1171206550778593306, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, orderNo=2, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1171206550879256604, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550778593306, language=EN, stringName=Yuan MIN, firstName=Yuan, middleName=null, lastName=MIN, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=3, address=3. Henan Institute of Geographic Information, Zhengzhou 450000, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1171206550954754077, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, authorId=1171206550778593306, language=CN, stringName=闵元, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=3, address=3.河南省地理信息院,河南 郑州 450000, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1171206550241722378, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550250110987, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550241722378, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=3. Henan Institute of Geographic Information, Zhengzhou 450000, China), AuthorCompanyExt(id=1171206550254305292, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550241722378, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=3.河南省地理信息院,河南 郑州 450000)])])], keywords=[Keyword(id=1171206551105749022, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=1, keyword=mineral resources), Keyword(id=1171206551214800927, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=2, keyword=national survey), Keyword(id=1171206551315464224, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=3, keyword=national survey database of mineral resources), Keyword(id=1171206551374184481, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=4, keyword=mineral reserves database), Keyword(id=1171206551432904738, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=5, keyword=reserve management), Keyword(id=1171206551495819299, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, orderNo=6, keyword=update), Keyword(id=1171206551546150948, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=1, keyword=矿产资源), Keyword(id=1171206551621648421, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=2, keyword=国情调查), Keyword(id=1171206551676174374, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=3, keyword=国情调查数据库), Keyword(id=1171206551726506023, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=4, keyword=储量数据库), Keyword(id=1171206551772643368, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=5, keyword=储量管理), Keyword(id=1171206551822975017, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, orderNo=6, keyword=更新)], refs=[Reference(id=1171206553873989699, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=33, issue=S2, pageStart=1, pageEnd=5, url=null, language=null, rfNumber=[1], rfOrder=0, authorNames=赵超, 许安民, 李鹏, journalName=中国矿业, refType=null, unstructuredReference=赵超, 许安民, 李鹏, 等. 关于我国战略性矿产供应安全的思考[J]. 中国矿业, 2024, 33(S2):1-5., articleTitle=关于我国战略性矿产供应安全的思考, refAbstract=null), Reference(id=1171206553924321348, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=33, issue=S2, pageStart=1, pageEnd=5, url=null, language=null, rfNumber=[1], rfOrder=1, authorNames=ZHAO Chao, XU Anmin, LI Peng, journalName=China Mining Magazine, refType=null, unstructuredReference=ZHAO Chao, XU Anmin, LI Peng, et al. Thoughts on supply security of strategic mineral resources in China[J]. China Mining Magazine, 2024, 33(S2):1-5 (in Chinese)., articleTitle=Thoughts on supply security of strategic mineral resources in China, refAbstract=null), Reference(id=1171206553974652997, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2014, volume=23, issue=2, pageStart=24, pageEnd=26, url=null, language=null, rfNumber=[2], rfOrder=2, authorNames=胡波, 龙士清, 周康辉, journalName=中国矿业, refType=null, unstructuredReference=胡波, 龙士清, 周康辉, 等. 矿产资源储量管理现状分析及对策建议[J]. 中国矿业, 2014, 23(2):24-26+39., articleTitle=矿产资源储量管理现状分析及对策建议, refAbstract=null), Reference(id=1171206554024984646, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2014, volume=23, issue=2, pageStart=24, pageEnd=26, url=null, language=null, rfNumber=[2], rfOrder=3, authorNames=HU Bo, LONG Shiqing, ZHOU Kanghui, journalName=China Mining Magazine, refType=null, unstructuredReference=HU Bo, LONG Shiqing, ZHOU Kanghui, et al. Status analysis and suggestions of mineral resources and reserves management[J]. China Mining Magazine, 2014, 23(2):24-26+39 (in Chinese)., articleTitle=Status analysis and suggestions of mineral resources and reserves management, refAbstract=null), Reference(id=1171206554079510599, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2013, volume=32, issue=33, pageStart=315, pageEnd=317, url=null, language=null, rfNumber=[3], rfOrder=4, authorNames=李晶晶, 杨武年, 鲁庆, journalName=价值工程, refType=null, unstructuredReference=李晶晶, 杨武年, 鲁庆. 矿产资源两库衔接中各数据库对应关系清理[J]. 价值工程, 2013, 32(33):315-317., articleTitle=矿产资源两库衔接中各数据库对应关系清理, refAbstract=null), Reference(id=1171206554150813768, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2013, volume=32, issue=33, pageStart=315, pageEnd=317, url=null, language=null, rfNumber=[3], rfOrder=5, authorNames=LI Jingjing, YANG Wunian, LU Qing, journalName=Value Engineering, refType=null, unstructuredReference=LI Jingjing, YANG Wunian, LU Qing, et al. Arrangement of corresponding relationships among databases in the join between two database of mineral resources[J]. Value Engineering, 2013, 32(33):315-317 (in Chinese)., articleTitle=Arrangement of corresponding relationships among databases in the join between two database of mineral resources, refAbstract=null), Reference(id=1171206554213728329, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2015, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[4], rfOrder=6, authorNames=吴晓萍, journalName=矿产资源利用现状调查成果与储量数据库衔接关键技术研究, refType=null, unstructuredReference=吴晓萍. 矿产资源利用现状调查成果与储量数据库衔接关键技术研究[D]. 成都: 成都理工大学, 2015., articleTitle=null, refAbstract=null), Reference(id=1171206554268254282, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2014, volume=null, issue=5, pageStart=42, pageEnd=44, url=null, language=null, rfNumber=[5], rfOrder=7, authorNames=黄礼霞, 耿艳辉, journalName=矿山测量, refType=null, unstructuredReference=黄礼霞, 耿艳辉. 关于矿产资源现状库与储量登记统计库衔接的几点思考[J]. 矿山测量, 2014(5):42-44+48., articleTitle=关于矿产资源现状库与储量登记统计库衔接的几点思考, refAbstract=null), Reference(id=1171206554373111883, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2014, volume=null, issue=5, pageStart=42, pageEnd=44, url=null, language=null, rfNumber=[5], rfOrder=8, authorNames=HUANG Lixia, GENG Yanhui, journalName=Mine Surveying, refType=null, unstructuredReference=HUANG Lixia, GENG Yanhui. Some thoughts on the connection between mineral resources database and reserve registration database[J]. Mine Surveying, 2014(5):42-44+48 (in Chinese)., articleTitle=Some thoughts on the connection between mineral resources database and reserve registration database, refAbstract=null), Reference(id=1171206554436026444, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2023, volume=39, issue=2, pageStart=62, pageEnd=68, url=null, language=null, rfNumber=[6], rfOrder=9, authorNames=陈敏, 孟刚, 苗琦, journalName=山东国土资源, refType=null, unstructuredReference=陈敏, 孟刚, 苗琦, 等. 矿产资源储量统计管理现状与建议[J]. 山东国土资源, 2023, 39(2):62-68., articleTitle=矿产资源储量统计管理现状与建议, refAbstract=null), Reference(id=1171206554490552397, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2023, volume=39, issue=2, pageStart=62, pageEnd=68, url=null, language=null, rfNumber=[6], rfOrder=10, authorNames=CHEN Min, MENG Gang, MIAO Qi, journalName=Shandong Land and Resources, refType=null, unstructuredReference=CHEN Min, MENG Gang, MIAO Qi, et al. Present situation and suggestions on statistical management of mineral resources reserves[J]. Shandong Land and Resources, 2023, 39(2):62-68 (in Chinese)., articleTitle=Present situation and suggestions on statistical management of mineral resources reserves, refAbstract=null), Reference(id=1171206554561855566, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2018, volume=null, issue=1, pageStart=48, pageEnd=52, url=null, language=null, rfNumber=[7], rfOrder=11, authorNames=邓颂平, 李治君, journalName=国土资源信息化, refType=null, unstructuredReference=邓颂平, 李治君. 探明储量的矿产资源统一确权登记技术实现方法探讨[J]. 国土资源信息化, 2018(1):48-52+9., articleTitle=探明储量的矿产资源统一确权登记技术实现方法探讨, refAbstract=null), Reference(id=1171206554624770127, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2018, volume=null, issue=1, pageStart=48, pageEnd=52, url=null, language=null, rfNumber=[7], rfOrder=12, authorNames=DENG Songping, LI Zhijun, journalName=Land and Resources Informatization, refType=null, unstructuredReference=DENG Songping, LI Zhijun. Discussions about the technical realization of the registrations for the unified confirmed authority of mineral resources with proved reserve[J]. Land and Resources Informatization, 2018(1):48-52+9 (in Chinese)., articleTitle=Discussions about the technical realization of the registrations for the unified confirmed authority of mineral resources with proved reserve, refAbstract=null), Reference(id=1171206554679296080, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=31, issue=2, pageStart=21, pageEnd=27, url=null, language=null, rfNumber=[8], rfOrder=13, authorNames=张照志, 李厚民, 潘昭帅, journalName=中国矿业, refType=null, unstructuredReference=张照志, 李厚民, 潘昭帅, 等. 新发展阶段中国矿产资源国情调查与评价现状及其技术体系[J]. 中国矿业, 2022, 31(2):21-27., articleTitle=新发展阶段中国矿产资源国情调查与评价现状及其技术体系, refAbstract=null), Reference(id=1171206554738016337, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=31, issue=2, pageStart=21, pageEnd=27, url=null, language=null, rfNumber=[8], rfOrder=14, authorNames=ZHANG Zhaozhi, LI Houmin, PAN Zhaoshuai, journalName=China Mining Magazine, refType=null, unstructuredReference=ZHANG Zhaozhi, LI Houmin, PAN Zhaoshuai, et al. The present situation of national mineral resources conditions investigation and appraisal (NMRCIA) and its supporting technological systems in the new development stage,China[J]. China Mining Magazine, 2022, 31(2):21-27 (in Chinese)., articleTitle=The present situation of national mineral resources conditions investigation and appraisal (NMRCIA) and its supporting technological systems in the new development stage,China, refAbstract=null), Reference(id=1171206554792542290, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=43, issue=11, pageStart=227, pageEnd=231, url=null, language=null, rfNumber=[9], rfOrder=15, authorNames=戴立乾, 祝朝辉, 赵鸿燕, journalName=煤炭技术, refType=null, unstructuredReference=戴立乾, 祝朝辉, 赵鸿燕, 等. 河南省矿产资源国情调查数据库与储量数据库衔接关键技术研究[J]. 煤炭技术, 2024, 43(11):227-231., articleTitle=河南省矿产资源国情调查数据库与储量数据库衔接关键技术研究, refAbstract=null), Reference(id=1171206554842873939, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=43, issue=11, pageStart=227, pageEnd=231, url=null, language=null, rfNumber=[9], rfOrder=16, authorNames=DAI Liqian, ZHU Chaohui, ZHAO Hongyan, journalName=Coal Technology, refType=null, unstructuredReference=DAI Liqian, ZHU Chaohui, ZHAO Hongyan, et al. Research on key technologies for connecting national mineral resources survey datebase and reserve datebase in Henan Province[J]. Coal Technology, 2024, 43(11):227-231 (in Chinese)., articleTitle=Research on key technologies for connecting national mineral resources survey datebase and reserve datebase in Henan Province, refAbstract=null), Reference(id=1171206554893205588, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2011, volume=null, issue=3, pageStart=35, pageEnd=37, url=null, language=null, rfNumber=[10], rfOrder=17, authorNames=李学刚, journalName=电脑编程技巧与维护, refType=null, unstructuredReference=李学刚. 加密数据库程序设计[J]. 电脑编程技巧与维护, 2011(3):35-37+42., articleTitle=加密数据库程序设计, refAbstract=null), Reference(id=1171206554947731541, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2011, volume=null, issue=3, pageStart=35, pageEnd=37, url=null, language=null, rfNumber=[10], rfOrder=18, authorNames=LI Xuegang, journalName=Computer Programming Skills & Maintenance, refType=null, unstructuredReference=LI Xuegang. Encrypted database programming[J]. Computer Programming Skills & Maintenance, 2011(3):35-37+42 (in Chinese)., articleTitle=Encrypted database programming, refAbstract=null), Reference(id=1171206554998063190, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=36, issue=3, pageStart=149, pageEnd=151, url=null, language=null, rfNumber=[11], rfOrder=19, authorNames=侯培杰, journalName=信息与电脑(理论版), refType=null, unstructuredReference=侯培杰. Access数据库技术及其应用研究[J]. 信息与电脑(理论版), 2024, 36(3):149-151., articleTitle=Access数据库技术及其应用研究, refAbstract=null), Reference(id=1171206555069366359, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=36, issue=3, pageStart=149, pageEnd=151, url=null, language=null, rfNumber=[11], rfOrder=20, authorNames=HOU Peijie, journalName=Information & Computer, refType=null, unstructuredReference=HOU Peijie. Research on access database technology and its application[J]. Information & Computer, 2024, 36(3):149-151 (in Chinese)., articleTitle=Research on access database technology and its application, refAbstract=null), Reference(id=1171206555123892312, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=19, issue=24, pageStart=121, pageEnd=124, url=null, language=null, rfNumber=[12], rfOrder=21, authorNames=吕兴琴, journalName=无线互联科技, refType=null, unstructuredReference=吕兴琴. 基于LabVIEW的Access数据库访问常用方法研究[J]. 无线互联科技, 2022, 19(24):121-124+137., articleTitle=基于LabVIEW的Access数据库访问常用方法研究, refAbstract=null), Reference(id=1171206555182612569, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=19, issue=24, pageStart=121, pageEnd=124, url=null, language=null, rfNumber=[12], rfOrder=22, authorNames=LYU Xingqin, journalName=Wireless Internet Technology, refType=null, unstructuredReference=LYU Xingqin. Research on common methods of access database access based on LabVIEW[J]. Wireless Internet Technology, 2022, 19(24):121-124+137 (in Chinese)., articleTitle=Research on common methods of access database access based on LabVIEW, refAbstract=null), Reference(id=1171206555245527130, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2023, volume=18, issue=1, pageStart=9, pageEnd=16, url=null, language=null, rfNumber=[13], rfOrder=23, authorNames=赵汀, 刘超, 李厚民, journalName=城市地质, refType=null, unstructuredReference=赵汀, 刘超, 李厚民, 等. 矿产资源国情调查数据库设计实现与大数据集成平台建设[J]. 城市地质, 2023, 18(1):9-16., articleTitle=矿产资源国情调查数据库设计实现与大数据集成平台建设, refAbstract=null), Reference(id=1171206555295858779, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2023, volume=18, issue=1, pageStart=9, pageEnd=16, url=null, language=null, rfNumber=[13], rfOrder=24, authorNames=ZHAO Ting, LIU Chao, LI Houmin, journalName=Urban Geology, refType=null, unstructuredReference=ZHAO Ting, LIU Chao, LI Houmin, et al. Big data integration and database on national mineral resources survey[J]. Urban Geology, 2023, 18(1):9-16 (in Chinese)., articleTitle=Big data integration and database on national mineral resources survey, refAbstract=null), Reference(id=1171206555350384732, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2019, volume=null, issue=5, pageStart=3, pageEnd=9, url=null, language=null, rfNumber=[14], rfOrder=25, authorNames=邓颂平, 武建飞, 李治君, journalName=国土资源信息化, refType=null, unstructuredReference=邓颂平, 武建飞, 李治君, 等. 非油气矿产资源国情调查成果数据库建设思路探讨[J]. 国土资源信息化, 2019(5):3-9., articleTitle=非油气矿产资源国情调查成果数据库建设思路探讨, refAbstract=null), Reference(id=1171206555409104989, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2019, volume=null, issue=5, pageStart=3, pageEnd=9, url=null, language=null, rfNumber=[14], rfOrder=26, authorNames=DENG Songping, WU Jianfei, LI Zhijun, journalName=Land and Resources Informatization, refType=null, unstructuredReference=DENG Songping, WU Jianfei, LI Zhijun, et al. Discussion about construction ideas on the national census of non-oil/gas mineral resources[J]. Land and Resources Informatization, 2019(5):3-9 (in Chinese)., articleTitle=Discussion about construction ideas on the national census of non-oil/gas mineral resources, refAbstract=null), Reference(id=1171206555472019550, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[15], rfOrder=27, authorNames=赵汀, 邓颂平, 刘超, journalName=矿产资源国情调查数据库建设技术要求与系统开发, refType=null, unstructuredReference=赵汀, 邓颂平, 刘超, 等. 矿产资源国情调查数据库建设技术要求与系统开发[M]. 北京: 地质出版社, 2022., articleTitle=null, refAbstract=null), Reference(id=1171206555539128415, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=null, issue=3, pageStart=1, pageEnd=9, url=null, language=null, rfNumber=[16], rfOrder=28, authorNames=邓颂平, 武建飞, 李治君, journalName=自然资源信息化, refType=null, unstructuredReference=邓颂平, 武建飞, 李治君, 等. 矿产资源储量数据库管理单元调整思路探讨[J]. 自然资源信息化, 2022(3):1-9., articleTitle=矿产资源储量数据库管理单元调整思路探讨, refAbstract=null), Reference(id=1171206555597848672, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2022, volume=null, issue=3, pageStart=1, pageEnd=9, url=null, language=null, rfNumber=[16], rfOrder=29, authorNames=DENG Songping, WU Jianfei, LI Zhijun, journalName=Natural Resources Informatization, refType=null, unstructuredReference=DENG Songping, WU Jianfei, LI Zhijun, et al. Discussion on adjustment thinking of mineral resources reserves database management unit[J]. Natural Resources Informatization, 2022(3):1-9 (in Chinese)., articleTitle=Discussion on adjustment thinking of mineral resources reserves database management unit, refAbstract=null), Reference(id=1171206555669151841, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2009, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[17], rfOrder=30, authorNames=王欣, journalName=SQL语法与范例详解词典, refType=null, unstructuredReference=王欣. SQL语法与范例详解词典[M]. 北京: 机械工业出版社, 2009., articleTitle=null, refAbstract=null), Reference(id=1171206555727872098, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2021, volume=44, issue=1, pageStart=24, pageEnd=26, url=null, language=null, rfNumber=[18], rfOrder=31, authorNames=姚堪, 刘琰洁, journalName=测绘, refType=null, unstructuredReference=姚堪, 刘琰洁. 基于Access的“两区”划定管护数据整合工具设计与实现[J]. 测绘, 2021, 44(1):24-26., articleTitle=基于Access的“两区”划定管护数据整合工具设计与实现, refAbstract=null), Reference(id=1171206555807563875, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2021, volume=44, issue=1, pageStart=24, pageEnd=26, url=null, language=null, rfNumber=[18], rfOrder=32, authorNames=YAO Kan, LIU Yanjie, journalName=Surveying and Mapping, refType=null, unstructuredReference=YAO Kan, LIU Yanjie. Design and implementation of data integration tool for the delineation of grain production functional areas and important agricultural product protection areas based on access[J]. Surveying and Mapping, 2021, 44(1):24-26 (in Chinese)., articleTitle=Design and implementation of data integration tool for the delineation of grain production functional areas and important agricultural product protection areas based on access, refAbstract=null), Reference(id=1171206555874672740, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=42, issue=5, pageStart=34, pageEnd=38, url=null, language=null, rfNumber=[19], rfOrder=33, authorNames=赵蓉城, journalName=佳木斯大学学报(自然科学版), refType=null, unstructuredReference=赵蓉城. 浅析数据库SQL应用性能优化处理[J]. 佳木斯大学学报(自然科学版), 2024, 42(5):34-38., articleTitle=浅析数据库SQL应用性能优化处理, refAbstract=null), Reference(id=1171206555929198693, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=42, issue=5, pageStart=34, pageEnd=38, url=null, language=null, rfNumber=[19], rfOrder=34, authorNames=ZHAO Rongcheng, journalName=Journal of Jiamusi University(Natural Science Edition), refType=null, unstructuredReference=ZHAO Rongcheng. Analysis of database sql application performance optimization processing[J]. Journal of Jiamusi University(Natural Science Edition), 2024, 42(5):34-38 (in Chinese)., articleTitle=Analysis of database sql application performance optimization processing, refAbstract=null), Reference(id=1171206555996307558, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=null, issue=7, pageStart=102, pageEnd=104, url=null, language=null, rfNumber=[20], rfOrder=35, authorNames=赵佳, journalName=中国高新科技, refType=null, unstructuredReference=赵佳. SQL_Server性能优化的技术分析[J]. 中国高新科技, 2024(7):102-104+107., articleTitle=SQL_Server性能优化的技术分析, refAbstract=null), Reference(id=1171206556042444903, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, doi=null, pmid=null, pmcid=null, year=2024, volume=null, issue=7, pageStart=102, pageEnd=104, url=null, language=null, rfNumber=[20], rfOrder=36, authorNames=ZHAO Jia, journalName=China High-tech, refType=null, unstructuredReference=ZHAO Jia. SQL_Server technical analysis of performance optimization[J]. China High-tech, 2024(7):102-104+107 (in Chinese)., articleTitle=SQL_Server technical analysis of performance optimization, refAbstract=null)], funds=[Fund(id=1171206553731383362, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, awardId=DD20190606, language=CN, fundingSource=全国矿产资源国情调查与综合评价(中国地质调查局地质调查项目)(DD20190606), fundOrder=null, country=null)], companyList=[AuthorCompany(id=1171206550040395780, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550048784389, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China), AuthorCompanyExt(id=1171206550052978694, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550040395780, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=1.河南省国土空间调查规划院,河南 郑州 450053)]), AuthorCompany(id=1171206550136864775, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550145253384, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550136864775, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=2. Henan Key Laboratory of Land and Resources Remote Sensing Monitoring, Zhengzhou 450053, China), AuthorCompanyExt(id=1171206550149447689, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550136864775, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=2.河南省国土资源遥感监测重点实验室,河南 郑州 450053)]), AuthorCompany(id=1171206550241722378, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, xref=null, ext=[AuthorCompanyExt(id=1171206550250110987, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550241722378, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=3. Henan Institute of Geographic Information, Zhengzhou 450000, China), AuthorCompanyExt(id=1171206550254305292, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, companyId=1171206550241722378, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=3.河南省地理信息院,河南 郑州 450000)])], figs=[ArticleFig(id=1171206552087216170, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 1, caption=Flow chart of updating of mineral reserves database, figureFileSmall=RQPss6xDE8BlmXGE8pVyPw==, figureFileBig=vvbMqoXI5k0em5xNK81T1g==, tableContent=null), ArticleFig(id=1171206552187879467, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图1, caption=储量数据库更新流程图, figureFileSmall=RQPss6xDE8BlmXGE8pVyPw==, figureFileBig=vvbMqoXI5k0em5xNK81T1g==, tableContent=null), ArticleFig(id=1171206552326291500, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 2, caption=Update the schematic diagram of resource reserves, figureFileSmall=aS+kluiBBQlbhuNYB1+fjw==, figureFileBig=Bn/WNLn9r5ZILT5MtPLwaA==, tableContent=null), ArticleFig(id=1171206552385011757, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图2, caption=更新资源储量示意图, figureFileSmall=aS+kluiBBQlbhuNYB1+fjw==, figureFileBig=Bn/WNLn9r5ZILT5MtPLwaA==, tableContent=null), ArticleFig(id=1171206552439537710, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 3, caption=Part code of module cl_update_1, figureFileSmall=hx8Tms4q5L4u2I7lRrahRg==, figureFileBig=scZO1gptpccfIP67ta1xVA==, tableContent=null), ArticleFig(id=1171206552485675055, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图3, caption=模块cl_update_1部分代码, figureFileSmall=hx8Tms4q5L4u2I7lRrahRg==, figureFileBig=scZO1gptpccfIP67ta1xVA==, tableContent=null), ArticleFig(id=1171206552544395312, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 4, caption=Part code of module cl_update_2, figureFileSmall=XT6R1EvY2dY8jM2GTSHUSw==, figureFileBig=Q0uMVk71WZCzfFnWN3DO8w==, tableContent=null), ArticleFig(id=1171206552607309873, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图4, caption=模块cl_update_2部分代码, figureFileSmall=XT6R1EvY2dY8jM2GTSHUSw==, figureFileBig=Q0uMVk71WZCzfFnWN3DO8w==, tableContent=null), ArticleFig(id=1171206552670224434, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 5, caption=Redundant information in the database, figureFileSmall=4ZfvlZNhulIZI5vvS7+JxQ==, figureFileBig=S8XiPwUXAj8bIueOS6aKRw==, tableContent=null), ArticleFig(id=1171206552720556083, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图5, caption=数据库中的冗余信息, figureFileSmall=4ZfvlZNhulIZI5vvS7+JxQ==, figureFileBig=S8XiPwUXAj8bIueOS6aKRw==, tableContent=null), ArticleFig(id=1171206552783470644, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 6, caption=Part code of module cl_update_5, figureFileSmall=9JQo07UwpICQwB+Tgj1b4A==, figureFileBig=lE0BZXLWMuK6d8yG0d1VYw==, tableContent=null), ArticleFig(id=1171206552842190901, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图6, caption=模块cl_update_5部分代码, figureFileSmall=9JQo07UwpICQwB+Tgj1b4A==, figureFileBig=lE0BZXLWMuK6d8yG0d1VYw==, tableContent=null), ArticleFig(id=1171206552900911158, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 7, caption=Part code for adjusting balance, figureFileSmall=rVM5GxIuxIOJCCkat2GPpA==, figureFileBig=y9IWEqMXQcE6MU4AUeKT6g==, tableContent=null), ArticleFig(id=1171206552959631415, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图7, caption=调整平衡部分代码, figureFileSmall=rVM5GxIuxIOJCCkat2GPpA==, figureFileBig=y9IWEqMXQcE6MU4AUeKT6g==, tableContent=null), ArticleFig(id=1171206553022545976, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 8, caption=Add comments, figureFileSmall=zb/i+XDosCNvqwI5eDNkyw==, figureFileBig=hIuQEE5qaE50bG7QQiZt0w==, tableContent=null), ArticleFig(id=1171206553081266233, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图8, caption=增加备注, figureFileSmall=zb/i+XDosCNvqwI5eDNkyw==, figureFileBig=hIuQEE5qaE50bG7QQiZt0w==, tableContent=null), ArticleFig(id=1171206553202901050, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 9, caption=Repeated problem, figureFileSmall=WAt4eGZX1Ui4x6tVIgx2Xw==, figureFileBig=m3XBkDAiPqSQWU5mHqSdOw==, tableContent=null), ArticleFig(id=1171206553265815611, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图9, caption=资源储量重复显示问题, figureFileSmall=WAt4eGZX1Ui4x6tVIgx2Xw==, figureFileBig=m3XBkDAiPqSQWU5mHqSdOw==, tableContent=null), ArticleFig(id=1171206553320341564, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Fig. 10, caption=Clear redundant code, figureFileSmall=pKC3tOYUqhNBN7mB984iNQ==, figureFileBig=gGVtxIgYSU50cXam2BctLw==, tableContent=null), ArticleFig(id=1171206553374867517, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=图10, caption=清除冗余部分代码, figureFileSmall=pKC3tOYUqhNBN7mB984iNQ==, figureFileBig=gGVtxIgYSU50cXam2BctLw==, tableContent=null), ArticleFig(id=1171206553429393470, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Table 1, caption=

Main fields of KCL_ZYCL table

, figureFileSmall=null, figureFileBig=null, tableContent=
字段名称 数据类型 字段别名
ND 整型 年度
KQBH 短文本(9) 矿区编号
DJFLBH 整型 登记分类编号
KSBH 短文本(23) 矿山编号
KCDM 长整型 矿产代码
TJDX 整型 统计对象
KSLX 长整型 矿石类型
KSPJ 整型 矿石品级
ZYCLLB 整型 资源储量类别
ZYCLLX 短文本(4) 资源储量类型
JSL 双精度 金属量
KSL 双精度 矿石量
KCZHM 整型 矿产组合码
KCZH 短文本(10) 矿产组合
YDJH 短文本(50) 原登记号
XSXH 整型 显示序号
…… …… ……
), ArticleFig(id=1171206553483919423, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=表1, caption=

KCL_ZYCL表主要字段

, figureFileSmall=null, figureFileBig=null, tableContent=
字段名称 数据类型 字段别名
ND 整型 年度
KQBH 短文本(9) 矿区编号
DJFLBH 整型 登记分类编号
KSBH 短文本(23) 矿山编号
KCDM 长整型 矿产代码
TJDX 整型 统计对象
KSLX 长整型 矿石类型
KSPJ 整型 矿石品级
ZYCLLB 整型 资源储量类别
ZYCLLX 短文本(4) 资源储量类型
JSL 双精度 金属量
KSL 双精度 矿石量
KCZHM 整型 矿产组合码
KCZH 短文本(10) 矿产组合
YDJH 短文本(50) 原登记号
XSXH 整型 显示序号
…… …… ……
), ArticleFig(id=1171206553546833984, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=EN, label=Table 2, caption=

Resource reserve category data dictionary

, figureFileSmall=null, figureFileBig=null, tableContent=
代码 名称
19001 保有资源储量
19002 累计查明资源储量
19004 开采量
19005 损失量
19006 勘查增减量
19008 重算或其他原因增减量
19009 审批压覆量
19012 年初保有资源储量
19013 年初累计资源储量
), ArticleFig(id=1171206553609748545, tenantId=1146029695717560320, journalId=1146123346816638986, articleId=1171165154826821759, language=CN, label=表2, caption=

资源储量类别数据字典

, figureFileSmall=null, figureFileBig=null, tableContent=
代码 名称
19001 保有资源储量
19002 累计查明资源储量
19004 开采量
19005 损失量
19006 勘查增减量
19008 重算或其他原因增减量
19009 审批压覆量
19012 年初保有资源储量
19013 年初累计资源储量
)], attaches=null, journal=Journal(id=1146119359820312588, delFlag=0, nameCn=铀矿冶, nameEn=Uranium Mining and Metallurgy, nameHistory1=null, nameHistory2=null, issn=1000-8063, eissn=, cn=11-1969/TL, coden=null, periodic=2, language=CN, oaType=0, ccby=null, superviseOffice=null, ownerOffice=null, pubOffice=null, editorOffice=null, officeType=null, aims=null, clcCode=null, officeProv=null, officeCity=null, officeAddr=null, officeZip=null, officeEmail=null, officePhone=null, editDirector=null, officeDirector=null, officeDirectorPhone=null, officeStaffNum=null, officeEmpNum=null, coverPicUrl=KmudR/G+rYvTqd4XcYqogQ==, journalPrice=null, startedYear=null, abbrevIsoEn=Uran Min Metal, journalRemark=null, publicationField=null, createdTime=null, updatedTime=1755587156394, createdBy=null, updatedBy=15831073675, firstLetterCn=U, firstLetterEn=U, subjectCode=Engineering, subjectName=工程, subjectCodeEn=Engineering, subjectNameEn=null, picCn=KmudR/G+rYvTqd4XcYqogQ==, picEn=9rbWk3ds8oZefNFxqqUVow==, jcr=null, cjcr=null, exts=[JournalExt(id=1164580199531238247, language=CN, name=铀矿冶, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=null, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=https://ykyi.cbpt.cnki.net/portal, createdTime=1755587156422, updatedTime=1755587156422, createdBy=15831073675, updatedBy=15831073675, submissionGuidelinesUrl=http://ykye.juqk.net/buy/, submissionAuthorUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=1, submissionEditorUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=3, submissionReviewUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""}), JournalExt(id=1164580199573181288, language=EN, name=Uranium Mining and Metallurgy, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=null, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=https://ykyie.cbpt.cnki.net/portal, createdTime=1755587156432, updatedTime=1755587156432, createdBy=15831073675, updatedBy=15831073675, submissionGuidelinesUrl=http://ykye.juqk.net/buy/, submissionAuthorUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=1, submissionEditorUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=3, submissionReviewUrl=https://ykyi.cbpt.cnki.net/EditorE3N/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""})], databaseList=null, tenantJournalId=1146123346816638986, websiteList=[Website(id=1148007952688087041, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1146123346816638986, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/yky/EN, language=EN, createTime=1751636024889, createBy=18614031015, updateTime=1753523175948, updateBy=18614031015, name=《铀矿冶》-英文站点, tplId=1146101810881728533, title=Uranium Mining and Metallurgy, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1155923533696983256, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148007952688087041, code=articleTextType, value=kx, createTime=1753523246454, updateTime=1753523246454, creator=18614031015, updator=18614031015), WebsiteProps(id=1155923533676011733, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148007952688087041, code=banner, value=null, createTime=1753523246449, updateTime=1753523246449, creator=18614031015, updator=18614031015), WebsiteProps(id=1155923533667623124, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148007952688087041, code=logo, value=https://castjournals.cast.org.cn/joweb/kjdb/CN/file/pic?fileId=MbrBQF5iwbqJZg/6eQNpYQ==, createTime=1753523246447, updateTime=1753523246447, creator=18614031015, updator=18614031015), WebsiteProps(id=1155923533688594647, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148007952688087041, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/kjdb/CN/file/pic, createTime=1753523246452, updateTime=1753523246452, creator=18614031015, updator=18614031015), WebsiteProps(id=1155923533680206038, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148007952688087041, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_cn_619/, createTime=1753523246450, updateTime=1753523246450, creator=18614031015, updator=18614031015)]), Website(id=1148243567316820393, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1146123346816638986, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/yky/CN, language=CN, createTime=1751692199786, createBy=18614031015, updateTime=1753523196222, updateBy=18614031015, name=《铀矿冶》-中文站点, tplId=1146099689490845704, title=铀矿冶, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1148623394028941377, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148243567316820393, code=articleTextType, value=kx, createTime=1751782757527, updateTime=1751782757527, creator=18614031015, updator=18614031015), WebsiteProps(id=1148623394003775550, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148243567316820393, code=banner, value=null, createTime=1751782757521, updateTime=1751782757521, creator=18614031015, updator=18614031015), WebsiteProps(id=1148623393991192637, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148243567316820393, code=logo, value=https://castjournals.cast.org.cn/joweb/kjdb/CN/file/pic?fileId=MbrBQF5iwbqJZg/6eQNpYQ==, createTime=1751782757518, updateTime=1751782757518, creator=18614031015, updator=18614031015), WebsiteProps(id=1148623394020552768, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148243567316820393, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/kjdb/CN/file/pic, createTime=1751782757525, updateTime=1751782757525, creator=18614031015, updator=18614031015), WebsiteProps(id=1148623394012164159, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1148243567316820393, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_cn_619/, createTime=1751782757523, updateTime=1751782757523, creator=18614031015, updator=18614031015)])], journalTitle=铀矿冶, weixinUrl=null, journalUrl=null, iacademicId=null, status=0, seqNo=null, journalTitleEn=Uranium Mining and Metallurgy, journalPhotoCn=KmudR/G+rYvTqd4XcYqogQ==, journalPhotoEn=9rbWk3ds8oZefNFxqqUVow==, journalFirstLetter=U, journalRecommend=null, journalNew=null, journalCollection=null, jcrJf=null, cjcrJf=null, jcrJfStr=null, cjcrJfStr=null, submissionFirstDecision=null, sciSubjectClassification=null, casSubjectClassification=null, citeScore=null, totalCitationFrequency=null, icpCode=null, psCode=null, advertisingLicenseCode=null, copyrightInformation=null, country=null, option=, provinceCode=null, provinceName=null, collectFlag=false), detailUrlCn=https://castjournals.cast.org.cn/joweb/yky/CN/10.13426/j.cnki.yky.2025.01.03, detailUrlEn=https://castjournals.cast.org.cn/joweb/yky/EN/10.13426/j.cnki.yky.2025.01.03, pdfUrlCn=https://castjournals.cast.org.cn/joweb/yky/CN/PDF/10.13426/j.cnki.yky.2025.01.03, pdfUrlEn=https://castjournals.cast.org.cn/joweb/yky/EN/PDF/10.13426/j.cnki.yky.2025.01.03, aliStartDate=null, aliEndDate=null, collectionFlag=false, citedCount=null, citedUrl=null, reference=null)
收藏切换
基于国情调查更新矿产资源储量数据的实现方法
收藏切换
PDF下载
戴立乾 1, 2 , 祝朝辉 1 , 闵元 3
铀矿冶 | 开采·选治 2025,44(3): 114-122
收起
收藏切换
铀矿冶 | 开采·选治 2025, 44(3): 114-122
基于国情调查更新矿产资源储量数据的实现方法
全屏
戴立乾1, 2, 祝朝辉1, 闵元3
作者信息
  • 1.河南省国土空间调查规划院,河南 郑州 450053
  • 2.河南省国土资源遥感监测重点实验室,河南 郑州 450053
  • 3.河南省地理信息院,河南 郑州 450000

    • 戴立乾(1976—),男,河南驻马店人,工程硕士,高级工程师,主要从事矿产资源调查和研究、数据库工作。

通讯作者:

祝朝辉(1978—),男,河南滑县人,博士,正高级工程师,主要从事矿产资源规划、开发利用与保护研究工作。
Realization Method of Updating Resource Reserve Data Based on National Survey Database of Mineral Resources
Liqian DAI1, 2, Chaohui ZHU1, Yuan MIN3
Affiliations
  • 1. Land and Spatial Survey and Planning Institute of Henan Province, Zhengzhou 450053, China
  • 2. Henan Key Laboratory of Land and Resources Remote Sensing Monitoring, Zhengzhou 450053, China
  • 3. Henan Institute of Geographic Information, Zhengzhou 450000, China
出版时间: 2025-09-10 doi: 10.13426/j.cnki.yky.2025.01.03
文章导航
收藏切换
摘要
收起

矿产资源储量数据是矿产资源储量管理的重要抓手,矿产资源国情调查是一项全国性、基础性的矿产资源调查工作。基于目前河南省已全面完成的矿产资源国情调查数据库,提出快速更新矿产资源储量数据库中资源储量数据的方法,以方便矿产资源管理部门高效使用。本方法对于解决储量库中的数据缺失、错误、冗余、时效性低等诸多问题和更好地进行矿产资源管理十分必要。通过设计计算机程序算法,对矿产资源国情调查数据库和矿产资源储量数据库中的资源储量数据记录按照相关字段进行自动对比,查找差异,分情况采取不同的程序代码,对储量库中资源储量数据实施更新。和日常储量管理中常采用的人工更新数据方法相比,本方法能更全面、快速、高效、准确地实现矿产资源储量数据库中资源储量数据的更新。

矿产资源  /  国情调查  /  国情调查数据库  /  储量数据库  /  储量管理  /  更新

The data of mineral resources reserves is the focus of the management of mineral resources reserves, and the national survey of mineral resources is a national and basic survey of mineral resources. Based on the national survey database of mineral resources in Henan Province, it is necessary to study and put forward a method to quickly update the resource reserve data in the mineral resources reserve database to facilitate the efficient use of the mineral resources management department, which is necessary to solve many problems such as data missing, error, redundancy and low timeliness in the reserve database and to better manage the mineral resources. By designing a computer program algorithm, the resource reserve data records in the national survey database of mineral resources and the mineral resource reserve database were automatically compared according to the relevant fields, and the differences were found. According to the differences, different program codes were adopted to update the resource reserve data in the reserve database. Compared with the method of manually updating data in daily reserves management, this method can update the resources and reserves data in the mineral resources and reserves database more comprehensively, quickly, efficiently and accurately.

mineral resources  /  national survey  /  national survey database of mineral resources  /  mineral reserves database  /  reserve management  /  update
戴立乾, 祝朝辉, 闵元. 基于国情调查更新矿产资源储量数据的实现方法. 铀矿冶, 2025 , 44 (3) : 114 -122 . DOI: 10.13426/j.cnki.yky.2025.01.03
Liqian DAI, Chaohui ZHU, Yuan MIN. Realization Method of Updating Resource Reserve Data Based on National Survey Database of Mineral Resources[J]. Uranium Mining and Metallurgy, 2025 , 44 (3) : 114 -122 . DOI: 10.13426/j.cnki.yky.2025.01.03
正文
收起
矿产资源是国家经济和资源安全的重要保障,是产业发展的基础[1]。矿产资源储量数据库(简称储量库)用于存储和管理矿产资源储量数据,是部、省、市、县四级国土资源管理部门宏观决策和对矿山监督管理的基础和依据,是矿产资源管理的重要抓手[2]。国土资源部于2007年开展全国矿产资源现状调查,对24个核查矿种进行了调查梳理[3-5]。在储量库日常管理中,每年度主要依靠人工更新部分矿山的资源储量数据,未进行系统、全面的数据梳理与更新,且库中资源储量数据存在数据缺失、数据错误、数据冗余、时效性低、数据呆账等诸多问题[6-7]。
矿产资源国情调查(简称国情调查)是2020年以来由自然资源部、中国地质调查局部署的一项全国性、基础性的矿产资源调查工作,通过国情调查摸清矿产资源家底,为国家实施宏观战略决策等提供依据和支撑[8]。矿产资源国情调查数据库(简称国情库)是国情调查的重要成果,通过国情调查工作成果数据库,更新资源储量数据,对于解决储量库中的诸多问题和更好地进行矿产资源管理是非常必要的。
目前,河南省已完成了对基于国情库更新储量库(简称两库衔接)的工作,两库衔接中的重点和难点是资源储量数据的更新,为实现基于国情库对资源储量数据的快速、批量更新,笔者通过设计计算机程序算法,对国情库和储量库中的资源储量数据记录按照相关字段进行自动对比,旨在找到全面、快速、高效、准确更新数据的方法。
1 更新思路
收起
矿产资源国情调查对各矿区/矿山的数量、质量、结构和空间分布均进行了详实、可靠的调查,真实反映了资源家底。因此,更新资源储量数据的思路是在国情库的基础上,以上一年度国情库中的资源储量数据为基准,更新当年储量库中的资源储量数据[9]。以两库均包含的KCL_ZYCL表的【矿区编号】【登记分类编号】【矿产代码】【统计对象】【矿石类型】【矿石品级】字段为关键字,逐记录进行对比,查找两表的差异;根据比对的5种差异情况,设计计算机程序进行资源储量数据的批量更新。更新完成后,按照储量库的资源储量数据的管理规则,进行资源储量数据的平衡调整。资源储量数据与矿种的质量指标紧密相关,在更新储量数据的同时,更新质量指标。最后,在相关字段中增加数据修改备注,以标注哪些数据是基于国情调查数据进行更新的。总的技术流程见图1。
2 数据库结构及管理规则
收起
国情库和储量库均采用ACCESS MDB数据库格式存储,MDB数据库是一种关系型数据库,库中由众多工作表组成,多张表相互关联,实现对数据分类、组织和存储,具有结构简单、易用性强等特点[10-12]。两库中均包含矿区/矿山表、资源储量表、矿山经济、坐标、地质条件、质量、采选环等多张表,用于存储矿区/矿山的诸多信息[13-15]。矿区/矿山的资源储量数据主要存储于资源储量表(KCL_ZYCL表)中,主要字段见表1。其中,字段矿区编号和登记分类编号,用于唯一标识矿区/矿山,矿区编号为9位编码,其中前6位为行政区代码,后3位为所在行政区的顺序号,登记分类编号为4位数字编码[16]。
2.1 资源储量数据字典
资源储量类型(ZYCLLX)分为证实储量(字典代码为ZS)、可信储量(KX)、探明资源量(TM)、控制资源量(KZ)、推断资源量(TD)、潜在资源量(QZ)。资源储量类别(ZYCLLB)主要包括12种类型,该字段的数据字典见表2。
2.2 资源储量数据的管理规则
储量数据库管理系统对资源储量质检规则:1)资源储量数据的年度平衡,即储量库中矿区/矿山上一年末的资源储量数据继承到下一年初;2)资源储量数据的年内平衡,即储量库中矿区/矿山年末累计资源储量=年初累计量+勘查增减量+重算增减量+审批压覆量;年初、年末的保有量通过5类变化量保持数据的平衡,即年末保有资源储量=年初保有量+勘查增减量+重算增减量+审批压覆量+其他-开采量-损失量。
3 技术实现方法
收起
3.1 导入数据
采用DoCmd.TransferDatabase()方法将国情库的KCL_ZYCL表导入到储量库中,以方便进行比对。由于两库中该表的名称一样,为加以区别,将国情库导入的资源储量表命名为KCL_ZYCL_国情库。
3.2 资源储量数据的更新
对国情库和储量库中的数据记录按照关键字段通过程序进行自动对比,根据比对的5种不同结果(图2中cl_update_1~cl_update_5),分为5种程序代码进行处理。
3.2.1 关键字段的值不完全相同的处理方法
根据关键字段,查找两库中同一矿区/矿山不完全相同的记录,根据两库的差异情况分别进行处理。1)储量库中有记录,而国情库中无记录。采用SQL语句查找储量库中存在的和国情库中对应的同一矿区/矿山(即两库矿区编号、登记分类编号相同的记录)记录中的矿产代码、统计对象、矿石类型、矿石品级不全相同的记录[17-18]。因国情库为最新调查数据,是矿区/矿山的最新状态,具有现势性;因此认为这些不完全相同的记录是由于储量库中的错误数据或冗余数据导致的,应将其从储量库中删除,见图2中cl_update_1所示行记录(cl_update_1为相应的处理程序代码过程名),应将储量库中某矿山的铅矿(伴生矿产)、锌矿(伴生矿产)所在行删除。根据2.2所述储量库的管理规则,当年资源储量数据的年初值继承自上一年度的数据,年初保有量、年初累计量不能修改和删除,故通过代码只将这些记录的年末保有量(KCL_ZYCL表中ZYCLLB字段的值19001所代表的记录)和年末累计量(KCL_ZYCL表中ZYCLLB字段的值19002所代表的记录)从KCL_ZYCL表中删除。cl_update_1处理过程模块部分代码见图3。图中rs1为查找出的储量库中冗余的记录集合。2)储量库中无记录,而国情库中有记录。采用SQL语句查找国情库和储量库对应的同一矿区/矿山(即两库的KCL_ZYCL表的矿区编号、登记分类编号相同)中的矿产代码、统计对象、矿石类型、矿石品级不完全相同的记录,表明这些记录为储量库中缺失的数据,应将国情库对应的记录添加到储量库中,见图2中cl_update_2模块拟处理的行记录所示;将符合条件的年末保有量、年末累计量的记录查找出来,然后逐条插入到KCL_ZYCL表中,该模块部分SQL语句代码见图4。
资源储量数据记录条数很多,要优化SQL语句以减少程序执行时间[19-20]。在更新时,要注意国情库存在的矿区/矿山的金属量、矿石量为0的记录(图5),SQL语句将之过滤,不添加到储量库,避免增加数据冗余。
3.2.2 关键字段值完全相同时的处理方法
若国情库和储量库中对应记录的各关键字段均相同,即两库中KCL_ZYCL表中的某条记录的矿区编号、登记分类编号、矿产代码、统计对象、矿石类型、矿石品级字段的值均相同,那么再判断资源储量类型是否相同。根据判断结果采取不同的代码,分以下3种情况处理。1)资源储量类型不同且储量库中有记录,而国情库中无记录。采用SQL语句查找储量库中存在的和国情库中对应的同一矿区/矿山(即两库的KCL_ZYCL表的矿区编号、登记分类编号相同的记录)记录中的矿产代码、统计对象、矿石类型、矿石品级相同,但资源储量类型不相同的记录,即这些记录为储量库中的错误数据或冗余数据,应将之删除,见图2中cl_update3所示行记录(cl_update_3为相应的处理程序代码过程)。根据储量库的管理规则,年初值不能修改和删除,因此程序代码只将这些记录的年末保有量(KCL_ZYCL表中ZYCLLB字段的值等于19001所代表的记录)和年末累计量(KCL_ZYCL表中ZYCLLB字段的值等于19002所代表的记录)从KCL_ZYCL表中删除。2)资源储量类型不同且储量库中无记录,而国情库中有记录。采用SQL语句查找国情库中和储量库中对应的同一矿区/矿山(即两库的KCL_ZYCL表的矿区编号、登记分类编号相同)记录中的矿产代码、统计对象、矿石类型、矿石品级相同,但资源储量类型不相同的记录,即表明这些记录为储量库中缺失的数据,应将国情库对应的记录添加到储量库中,见图2中cl_update_4所示行记录。3)资源储量类型相同。采用SQL语句查找储量库中和国情库中对应的同一矿区/矿山(即两库的KCL_ZYCL表的矿区编号、登记分类编号相同)记录中的矿产代码、统计对象、矿石类型、矿石品级、资源储量类型全相同的记录,则应先删除储量库中的年末值,并由国情库中对应记录的储量年末值替换,见图2中cl_update5所示行记录(cl_update_5为相应的处理程序代码)。部分代码见图6。
3.3 质量指标的更新
质量指标存储于储量库KCL_ZL表中,质量指标更新包括矿种、矿产组合类型、统计对象、矿石工业类型及品级、矿石组分的更新。更新完成后,要注意质量指标平均含量重复的记录,查找KCL_ZL表中平均含量超过1个的矿山,并生成均值计数表;根据计数表,删除多余的平均含量,同矿石类型同品级仅保留1个平均含量。
3.4 数据调整平衡
储量库质检规则要求资源储量数据的年内平衡。年内平衡检查规则如2.2所述。经过3.2更新资源储量数据后,会导致资源储量数据的不平衡,河南省压覆资源量为单独建库,审批压覆量暂不参与计算。将不平衡量赋值给【其他】字段,以使数据保持平衡,其他(不平衡量)=年末保有量-年初保有量+开采量+损失量-勘查增减量-重算增减量。若不平衡量等于零,则说明满足平衡关系。
编写函数get_zyl_sql()分别提取年初保有量(19012)、开采量(19004)、损失量(19005)、勘查增减量(19006)、重算增减量(19008)、年末保有量(19001)等字段的值,分别赋值给二维数组,数组[0]存放金属量,数组[1]存放矿石量。然后遍历KCL_ZYCL表中所有记录,求取每个记录的不平衡量,并赋值给【其他】字段。部分代码见图7。
3.5 增加备注
为了实现在资源储量管理中能够容易识别哪些数据是根据国情调查数据库进行的更新,将“根据国情调查成果数据进行了资源储量的调整”字符串追加到储量库中矿山表的备注信息中,进行明确标识(图8)。
3.6 清除冗余数据
清除冗余数据主要有:1)更新完成后对储量库中导入的国情库的有关表进行清除;2)对原储量库中部分资源储量数据重复显示的数据清除(图9)。重复显示是由于储量库中同一矿区/矿山的矿山表、质量表和资源储量表中的矿山编号不一致造成的,通过程序代码(图10)予以解决。
4 结语
收起
1)建立的方法能够全面、快速、高效、准确地利用国情库对储量库资源储量数据进行更新,解决了资源储量管理中采用人工更新部分数据时存在的问题。通过资源储量数据的更新,使储量库中资源储量数据能够具有较好的时效性、完整性、准确性和一致性,对矿产资源实施有效的保护、监督和合理利用提供了坚实的数据基础,更好地支撑矿产资源储量管理工作。
2)目前的储量库管理系统仍需优化,在实践中仍发现一些小问题。比如,在按表中标识进行删除时,存在部分矿区坐标丢失、矿区/矿山合并出现质量指标丢失、录入坐标不能实时校验,很容易输错(输错、输反等),以及矿山在只有1个矿种和需删除某矿种时仍然要求录入平均含量、未利用矿区未设矿业权而要求录入矿证号等问题。
3)尽管大部分工作通过程序能自动批量处理,但在实践中发现,通过程序合并矿区/矿山后,质检时经常出现数据不平衡问题。分成多个库,多人分工协作进行手工合并后,再合库也会出现不平衡问题,只有单人单库进行人工合并操作才不易出现不平衡问题。
4)由于资源储量数据量较大,程序代码要注意架构设计和代码优化。河南省储量库程序执行更新时间超过6 h;优化程序代码和SQL语句后,程序时间缩短为4 h。
基金
收起
  • 全国矿产资源国情调查与综合评价(中国地质调查局地质调查项目)(DD20190606)
文献
收起
参考文献 引证文献
排序方式：
[1]
赵超, 许安民, 李鹏, 等. 关于我国战略性矿产供应安全的思考[J]. 中国矿业, 2024, 33(S2):1-5.
ZHAO Chao, XU Anmin, LI Peng, et al. Thoughts on supply security of strategic mineral resources in China[J]. China Mining Magazine, 2024, 33(S2):1-5 (in Chinese).
[2]
胡波, 龙士清, 周康辉, 等. 矿产资源储量管理现状分析及对策建议[J]. 中国矿业, 2014, 23(2):24-26+39.
HU Bo, LONG Shiqing, ZHOU Kanghui, et al. Status analysis and suggestions of mineral resources and reserves management[J]. China Mining Magazine, 2014, 23(2):24-26+39 (in Chinese).
[3]
李晶晶, 杨武年, 鲁庆. 矿产资源两库衔接中各数据库对应关系清理[J]. 价值工程, 2013, 32(33):315-317.
LI Jingjing, YANG Wunian, LU Qing, et al. Arrangement of corresponding relationships among databases in the join between two database of mineral resources[J]. Value Engineering, 2013, 32(33):315-317 (in Chinese).
[4]
吴晓萍. 矿产资源利用现状调查成果与储量数据库衔接关键技术研究[D]. 成都: 成都理工大学, 2015.
[5]
黄礼霞, 耿艳辉. 关于矿产资源现状库与储量登记统计库衔接的几点思考[J]. 矿山测量, 2014(5):42-44+48.
HUANG Lixia, GENG Yanhui. Some thoughts on the connection between mineral resources database and reserve registration database[J]. Mine Surveying, 2014(5):42-44+48 (in Chinese).
[6]
陈敏, 孟刚, 苗琦, 等. 矿产资源储量统计管理现状与建议[J]. 山东国土资源, 2023, 39(2):62-68.
CHEN Min, MENG Gang, MIAO Qi, et al. Present situation and suggestions on statistical management of mineral resources reserves[J]. Shandong Land and Resources, 2023, 39(2):62-68 (in Chinese).
[7]
邓颂平, 李治君. 探明储量的矿产资源统一确权登记技术实现方法探讨[J]. 国土资源信息化, 2018(1):48-52+9.
DENG Songping, LI Zhijun. Discussions about the technical realization of the registrations for the unified confirmed authority of mineral resources with proved reserve[J]. Land and Resources Informatization, 2018(1):48-52+9 (in Chinese).
[8]
张照志, 李厚民, 潘昭帅, 等. 新发展阶段中国矿产资源国情调查与评价现状及其技术体系[J]. 中国矿业, 2022, 31(2):21-27.
ZHANG Zhaozhi, LI Houmin, PAN Zhaoshuai, et al. The present situation of national mineral resources conditions investigation and appraisal (NMRCIA) and its supporting technological systems in the new development stage,China[J]. China Mining Magazine, 2022, 31(2):21-27 (in Chinese).
[9]
戴立乾, 祝朝辉, 赵鸿燕, 等. 河南省矿产资源国情调查数据库与储量数据库衔接关键技术研究[J]. 煤炭技术, 2024, 43(11):227-231.
DAI Liqian, ZHU Chaohui, ZHAO Hongyan, et al. Research on key technologies for connecting national mineral resources survey datebase and reserve datebase in Henan Province[J]. Coal Technology, 2024, 43(11):227-231 (in Chinese).
[10]
李学刚. 加密数据库程序设计[J]. 电脑编程技巧与维护, 2011(3):35-37+42.
LI Xuegang. Encrypted database programming[J]. Computer Programming Skills & Maintenance, 2011(3):35-37+42 (in Chinese).
[11]
侯培杰. Access数据库技术及其应用研究[J]. 信息与电脑(理论版), 2024, 36(3):149-151.
HOU Peijie. Research on access database technology and its application[J]. Information & Computer, 2024, 36(3):149-151 (in Chinese).
[12]
吕兴琴. 基于LabVIEW的Access数据库访问常用方法研究[J]. 无线互联科技, 2022, 19(24):121-124+137.
LYU Xingqin. Research on common methods of access database access based on LabVIEW[J]. Wireless Internet Technology, 2022, 19(24):121-124+137 (in Chinese).
[13]
赵汀, 刘超, 李厚民, 等. 矿产资源国情调查数据库设计实现与大数据集成平台建设[J]. 城市地质, 2023, 18(1):9-16.
ZHAO Ting, LIU Chao, LI Houmin, et al. Big data integration and database on national mineral resources survey[J]. Urban Geology, 2023, 18(1):9-16 (in Chinese).
[14]
邓颂平, 武建飞, 李治君, 等. 非油气矿产资源国情调查成果数据库建设思路探讨[J]. 国土资源信息化, 2019(5):3-9.
DENG Songping, WU Jianfei, LI Zhijun, et al. Discussion about construction ideas on the national census of non-oil/gas mineral resources[J]. Land and Resources Informatization, 2019(5):3-9 (in Chinese).
[15]
赵汀, 邓颂平, 刘超, 等. 矿产资源国情调查数据库建设技术要求与系统开发[M]. 北京: 地质出版社, 2022.
[16]
邓颂平, 武建飞, 李治君, 等. 矿产资源储量数据库管理单元调整思路探讨[J]. 自然资源信息化, 2022(3):1-9.
DENG Songping, WU Jianfei, LI Zhijun, et al. Discussion on adjustment thinking of mineral resources reserves database management unit[J]. Natural Resources Informatization, 2022(3):1-9 (in Chinese).
[17]
王欣. SQL语法与范例详解词典[M]. 北京: 机械工业出版社, 2009.
[18]
姚堪, 刘琰洁. 基于Access的“两区”划定管护数据整合工具设计与实现[J]. 测绘, 2021, 44(1):24-26.
YAO Kan, LIU Yanjie. Design and implementation of data integration tool for the delineation of grain production functional areas and important agricultural product protection areas based on access[J]. Surveying and Mapping, 2021, 44(1):24-26 (in Chinese).
[19]
赵蓉城. 浅析数据库SQL应用性能优化处理[J]. 佳木斯大学学报(自然科学版), 2024, 42(5):34-38.
ZHAO Rongcheng. Analysis of database sql application performance optimization processing[J]. Journal of Jiamusi University(Natural Science Edition), 2024, 42(5):34-38 (in Chinese).
[20]
赵佳. SQL_Server性能优化的技术分析[J]. 中国高新科技, 2024(7):102-104+107.
ZHAO Jia. SQL_Server technical analysis of performance optimization[J]. China High-tech, 2024(7):102-104+107 (in Chinese).
2025年第44卷第3期
PDF下载
312
133
引用本文
BibTeX
文章信息
doi: 10.13426/j.cnki.yky.2025.01.03
  • 接收时间：2025-01-09
  • 首发时间：2025-09-06
  • 出版时间：2025-09-10
补充材料
相关文章
文章信息
作者
出版历史
  • 收稿日期：2025-01-09
基金
全国矿产资源国情调查与综合评价(中国地质调查局地质调查项目)(DD20190606)
作者信息
    1.河南省国土空间调查规划院,河南 郑州 450053
    2.河南省国土资源遥感监测重点实验室,河南 郑州 450053
    3.河南省地理信息院,河南 郑州 450000

通讯作者:

祝朝辉(1978—),男,河南滑县人,博士,正高级工程师,主要从事矿产资源规划、开发利用与保护研究工作。
参考文献
分享链接
https://castjournals.cast.org.cn/joweb/yky/CN/10.13426/j.cnki.yky.2025.01.03
分享至
全文二维码

扫描看全文

引用本文
BibTeX
本文的引用情况
2种不同金属材料的力学参数
科
Family		 属数
Number of
genus		 种数
Number of
species		 占总种数比例
Percentage of
total species (%)		 属
Genus		 种数
Number of
species		 占总种数比例
Percentage of total
species (%)
鹅膏菌科Amanitaceae 2 11 5.26 鹅膏菌属 Amanita 10 4.78
小菇科 Mycenaceae 2 12 5.74 丝盖伞属 Inocybe 5 2.39
多孔菌科 Polyporaceae 8 14 6.70 蜡蘑属 Laccaria 5 2.39
红菇科 Russulaceae 3 23 11.00 小皮伞属 Marasmius 6 2.87
小菇属 Mycena 11 5.26
光柄菇属 Pluteus 5 2.39
红菇属 Russula 17 8.13
栓菌属 Trametes 5 2.39
关闭全屏
相关链接
论文
最新文章
热读文章
热点专题
内参
蓝皮书
产业发展报告
传播力报告
期刊分级目录
资讯
学术新闻
行业新闻
学术会议
行业会议
关于
关于我们
联系我们
北京市海淀区学院南路86号
100081
010-62199257
qkjq@cast.org.cn

中国科学技术协会版权所有 京ICP 备10216604号-4 海淀分局备案 1101084647
科技导报社主办 中国科协信息中心技术支持