基于关系数据库和WebGIS的中国东部地球化学科学数据库

马维峰; 王晓蕊; 高山

基于关系数据库和WebGIS的中国东部地球化学科学数据库

1.
中国地质大学研究生院, 湖北武汉 430074
2.
中国地质大学地质过程与矿产资源国家重点实验室, 湖北武汉 430074

基金项目:

国家自然科学基金 40521001

详细信息

作者简介:
马维峰(1976—), 博士研究生, 研究方向为地理信息系统. E-mail: mweifeng@gmail.com

中图分类号: P28
计量
- 文章访问数: 3698
- HTML全文浏览量: 100
- PDF下载量: 53
- 被引次数: 0
出版历程
- 收稿日期: 2008-02-20
- 刊出日期: 2008-05-25

Geochemistry Science Database System for East China Based on Relational Database and WebGIS

1.
Graduate School, China University of Geosciences, Wuhan 430074, China
2.
State Key Laboratory of Geological Processes and Mineral Resources, China University of Geosciences, Wuhan 430074, China

摘要

摘要: 如何高效管理、利用中国东部已有地球科学研究数据是急需解决的问题.在地球化学数据模型研究基础上, 应用关系数据库和WebGIS技术, 建立了中国东部地球化学科学数据库(ECGD).ECGD深度整合WebGIS技术, 研究者可利用ECGD基于Web对地球化学数据进行检索、分析、输出和空间可视化, 查询结果可以标注于基于WebGIS的网络地图, 生成分类、分级专题图, 并对查询结果进行地球化学图解等专业分析.ECGD是第一个基于Web, 集成了数据检索、空间数据可视化和数据分析功能的地球化学科学数据库, 为地学工作者提供了一个地球化学数据管理、共享、获取、交流的协作平台, 具有重要的实用价值.
- 华北克拉通 /
- 数据模型 /
- 关系数据库 /
- WebGIS
Abstract: How to efficiently manage and reuse the existeing geoscience data of eastern China is an urgent problem.Based on the geochemical data model, we established the East China geochemical science database (ECGD) that applied the relational database and WebGIS technology.Using the ECGD, researchers can query, analyze, output and implement spatial visualization to the geochemical data via a website.Because integration of WebGIS technology, the query results can be mapped on digital map based on WebGIS and can generate classification thematic maps.Meanwhile, researchers can make online analysis of the query results using offered geochemical diagram.ECGD is the first web-based geochemical science database that integrated the functions of data retrieval, spatial visualization and online analysis, and it provides a geochemical data sharing, access and exchange collaboration platform for researchers.
- North China craton /
- data model /
- relational database /
- WebGIS

HTML全文

图 1 ECGD中地球化学数据的关系数据模型

“Sample”、“Sample_Reference”和“Reference”表格说明了数据库的基本组成和概念.储存在表中的数据包括“字段”和“记录”.每个表中有唯一的识别标记“主键”.3个表中的主键分别为各个表中的“Id”.所有表之间的关系通过“外键”建立

Fig. 1. The relational database model of geochemical data in ECGD

下载: 全尺寸图片幻灯片

图 2 ECGD数据库结构图

a.ECGD数据库模式(schematic) 设计; b.ECGD各数据表关联关系示意图

Fig. 2. Structure of ECGD database

下载: 全尺寸图片幻灯片

图 3 ECGD层次架构与组成示意图

Fig. 3. Composition and architecture of ECGD

下载: 全尺寸图片幻灯片

图 4 四合屯地区火山岩的Nb分级专题图(据Wang et al., 2006)

Fig. 4. Classification thematic map of Nb in Sihetun volcanic rocks

下载: 全尺寸图片幻灯片

表 1 ECGD的主要功能模块

Table 1. Major function modules of ECGD

参考文献(33)

[1]	Alexander, S. S., Gray, J., Ani, R. T., et al., 2000. The SDSS SkyServer-Public access to the sloan digital Sky Server data. Technical report. Microsoft Corporation, USA.
[2]	Barclay, T., Slutz, D. R., Gray, J., 2000. "TerraServer: A spatial data warehouse. "Proc. ACM SIGMOD, 307-318.
[3]	Gao, S., Rudnick, R. L., Yuan, H. L., et al., 2004. Recycling lower continental crust in the North China craton. Nature, 432: 892-897. doi: 10.1038/nature03162
[4]	Gray, J., David, T. L., 2005. Scientific data management in the coming decade. Technical report. Microsoft Corporation, USA.
[5]	Hu, G. D., Li, Z. H., 2002. Basic platform of land and resources information systembased on data center and its technical questions. Earth Science-Journal of China University of Geosciences, 27(3): 306-310(in Chinese with English abstract). doi: 10.1007/s11769-002-0045-5
[6]	Li, J. H., Niu, X. L., Cheng, S. H., et al., 2006. The Early Precambrian tectonic evolution of continental craton: A case study from North China. Earth Science-Journal of China University of Geosciences, 31(3): 285-293(in Chinese with English abstract). doi: 10.1007/s11442-006-0415-5
[7]	Liu, R. Y., Wu, K. L., Jin, C. H., et al., 1994. Geochemical exploration database for all regions in China. Computing Techniques for Geophysical and Geochemical Exploration, 16(2): 102-146(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-WTHT402.002.htm
[8]	Liu, Y. S., Gao, S., 2007. High Nb/Ta ratios of the Mesozoic basalts from North China: Records of continental crustrecycling. Bulletin of Mineralogy, Petrology and Geochemistry, 26(1): 19-28(in Chinese with English abstract).
[9]	Nohl, U., Sarbas, B., 1999. GEOROC, the MPI geochemical rock database: Introduction of the web interface (abstract). EOS Trans. AGU, Fall Meeting, 80(46): F1177.
[10]	Sarbas, B., Jochum, K. P., Nohl, U., et al., 1999. GEOROC, the MPI geochemical rock database: A new tool for geochemists (abstract). EOS Trans. AGU, Fall Meeting, 80(46): F1184.
[11]	Shang, R. X., Zeng, G. Y., Li, D. X., 1989. The management system and application program of volcanic lithological and geochemical database. Acta Petrologica et Mineralogica, (4): 331-337(in Chinese with English ab-stract).
[12]	Shi, C. Y., Zhang, J. H., 2001. Regional geochemical database of main large-middle gold and copper polymetallic orefields and deposits of China. Geology and Prospecting, 37(3): 41-44(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DZKT200103010.htm
[13]	Sun, J. L., Li, S., 2002. Geo-data sharing and data-grid. Earth Science-Journal of China University of Geosciences, 27(5): 539-543(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DQKX200205010.htm
[14]	Wang, X. R., Gao, S., Liu, X. M., et al., 2006. Geochemistry of high-Mg andesites from the Early Cretaceous Yixian Formation, western Liaoning: Implications for lower crustal delamination and Sr/Y variations. Science in China (Ser. D), 49: 904-914. doi: 10.1007/s11430-006-2016-7
[15]	Wei, W. B., Ye, G. F., Jin, S., et al., 2007. Three dimensional P-wave velocity structure of the crust of North China. Earth Science-Journal of China University of Geosciences, 32(4): 441-452(in Chinese with English abstract).
[16]	Wu, C. L., 1998. Development and application of geological and mineral resources point-source information system (GMPIS). Earth Science-Journal of China University of Geosciences, 23(2): 193-198(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DQKX802.018.htm
[17]	Wu, X. C., Wu, L., 2006. Service-oriented distributed spatial information supporting system. Earth Science-Journal of China University of Geosciences, 31(5): 585-589(in Chinese with English abstract).
[18]	Zheng, G. Z., 1998. Application of geographic information system in geology. Earth Science-Journal of China University of Geosciences, 23(4): 420-423(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DQKX804.028.htm
[19]	Zheng, J. P., Lu, F. X., Yu, C. M., et al., 2006. Peridotitic petrochemistry of the eastern North China: Significance for lithospheric mantle evolution. Earth Science-Journal of China University of Geosciences, 31(1): 49-56(in Chinese with English abstract).
[20]	Zhou, X. H., Zhang, H. F., 2006. Highly chemical heterogeneity of subcontinental lithosphere mantle beneath North China and its major transformation. Earth Science-Journal of China University of Geosciences, 31(1): 8-13(in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DQKX200601002.htm
[21]	胡光道, 李振华, 2002. 基于数据中心的国土资源信息系统基础平台的构建及技术问题. 地球科学——中国地质大学学报, 27(3): 306-310. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200203016.htm
[22]	李江海, 牛向龙, 程素华, 等, 2006. 大陆克拉通早期构造演化历史探讨: 以华北为例. 地球科学——中国地质大学学报, 31(3): 285-293. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200603000.htm
[23]	刘如英, 邬宽廉, 金淳浩, 等, 1994. 全国区域化探数据库(REG-291). 物探化探计算技术, 16(2): 102-146. https://www.cnki.com.cn/Article/CJFDTOTAL-WTHT402.002.htm
[24]	刘勇胜, 高山, 2007. 华北地区中生代玄武岩高Nb/Ta值对地壳岩石再循环的直接记录. 矿物岩石地球化学通报, 26(1): 19-28. doi: 10.3969/j.issn.1007-2802.2007.01.003
[25]	尚如相, 曾广瑜, 李德兴, 1989. 火山岩岩石化学、地球化学数据库管理系统及应用程序. 岩石矿物学杂志, (4): 33-337. https://www.cnki.com.cn/Article/CJFDTOTAL-YSKW198904004.htm
[26]	史长义, 张金华, 2001. 全国主要大中型金铜多金属矿区域地球化学数据库. 地质与勘探, 37(3): 41-44. doi: 10.3969/j.issn.0495-5331.2001.03.011
[27]	孙九林, 李爽, 2002. 地球科学数据共享与数据网格技术. 地球科学——中国地质大学学报, 27(5): 539-543. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200205010.htm
[28]	魏文博, 叶高峰, 金胜, 等, 2007. 华北地区地壳P波三维速度结构. 地球科学——中国地质大学学报, 32(4): 441-452. https://www.cnki.com.cn/Article/CJFDTOTAL-DQWJ201403003.htm
[29]	吴冲龙, 1998. 地质矿产点源信息系统的开发与应用. 地球科学——中国地质大学学报, 23(2): 193-198. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX802.018.htm
[30]	吴信才, 吴亮, 2006. 面向服务的分布式空间信息支撑平台. 地球科学——中国地质大学学报, 31(5): 585-589. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200605001.htm
[31]	郑贵洲, 1998. 地理信息系统(GIS) 在地质学中的应用. 地球科学——中国地质大学学报, 23(4): 420-423. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX804.028.htm
[32]	郑建平, 路凤香, 余淳梅, 等, 2006. 华北东部橄榄岩岩石化学特征及其岩石圈地幔演化意义. 地球科学——中国地质大学学报, 31(1): 49-56. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200601007.htm
[33]	周新华, 张宏福, 2006. 中生代华北岩石圈地幔高度化学不均一性与大陆岩石圈转型. 地球科学——中国地质大学学报, 31(1): 8-13. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200601002.htm