Geohazards Data Warehouse Design and Development of the Three Gorges Reservoir Area
-
摘要: 在地学数据仓库的设计中, 应当充分考虑地学数据自身的空间特点, 采用区域维、时间维及属性维等多个维度, 按不同主题所涉及的数据要求, 进行相应的粒度与度量的定义, 以建立不同特点的多维数据模型.以三峡库区地质灾害数据仓库的设计为例, 对三峡库区时空范围各异的各类数据进行集成与融合, 按5个主题对数据进行了归类.实验表明, 该数据仓库可依不同灾害类型的、不同预警级别及不同分级对信息进行重组, 能适应快速检索查询的需要; 另一方面, 利用库中的数据挖掘工具能在海量数据中挖掘地质灾害体的变化规律, 从而使预测预报决策过程更加科学、准确、迅速.Abstract: Space-based design features eological data warehouse, unlike the traditional warehouse based on time. The key concept in the design of the multi-dimension model is to choose suitable multi-dimensions, such as spatial, temporal and attribute dimensions, and determine the granularity and measure, according the data requirements of the subject involved. A geohazards data warehouse of the Three Gorges Reservoir Area is built on 5 subjects to integrate the mass data in different space and time scales; the experiments show that the warehouse makes the geohazards prediction more accurate and rapid in two ways: Firstly, it enables fast search of the data since the data are re-organized by geohazards type, alarm levels and data layers; Secondly, it facilitates the discovery of the geohazards laws from data warehouse through the data mining tools.
-
Key words:
- data warehouse /
- geohazards /
- Three Gorges Reservoir Area /
- data mining
-
[1] Bell, R.W., 2000. Data warehouse for the national water-quality assessment program of the U.S. geological survey. In: The 34th Annual Meeting of Geological Society of America, South-Central Section. USA: Geological Society of America. [2] Cohen, S., 1999. NAWQA results on the web. Ground Water Monitoring and Remediation, 19(4): 47-49. doi: 10.1111/j.1745-6592.1999.tb00238.x [3] FGDC, 1996. National spatial data infrastructure: 1996 Framework Demonstration Project Program. http://www.fgdc.gov/publications/documents/cooperativeagreements/fundingprograms/96fdpp.pdf [4] Glorio, O., Trujillo, J., 2008. An MDA approach for the development of spatial data warehouses. Data Warehousing and Knowledge Discovery, 5182: 23-32. doi: 10.1007/978-3-540-85836-2_3 [5] Hu, G.D., 1999. Several issues in design of geological data warehouse. Earth Science—Journal of China University of Geosciences, 24(5): 522-524 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DQKX199905020.htm [6] Hu, G.D., Chen, J.G., 1998. Design of the metallic mineral resources assessment and analysis system. Geological Science and Technology Information, 17(1): 45-49 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DZKQ801.010.htm [7] Hu, G.D., Li, Z.H., 2002. Basic platform of land and resources information system based on data center and its technical questions. Earth Science—Journal of China University of Geosciences, 27(3): 306-310 (in Chinese with English abstract). [8] Inmon, W.H., 1992. EIS and the data warehouse: a simple approach to building an effective foundation for EIS. Database Programming and Design, 5(11): 70-73. [9] Inmon, W.H., 1993. Building the data warehouse. John Wiley and Sons, New York. [10] Jia, P.H., Zhu, D.K., Ma, J.S., et al., 2007. Spatial data warehouse establishment for "Digital South China Sea". Remote Sensing Information, (4): 66-77 (in Chinese with English abstract). [11] Li, Z.H., Hu, G.D., Chen, J.G., 1999. Geological data warehouse features and data organization. Earth Science—Journal of China University of Geosciences, 24(5): 536-538 (in Chinese with English abstract). [12] Li, Z.H., Hu, G.D., Wang, S.H., 2002. Preliminary design and development of a geological data warehouse. Geology and Prospecting, 38(5): 67-70 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DZKT200205013.htm [13] Li, Z.H., Hu, G.D., Zhang, Z.F., 2003. Development of geological data warehouse. Journal of China University of Geosciences, 14(3): 261-264. http://www.cqvip.com/Main/Detail.aspx?id=8387338 [14] Malinowski, E., Zimanyi, E., 2007. Logical representation of a conceptual model for spatial data warehouses. Geoinformatica, 11(4): 431-457. doi: 10.1007/s10707-007-0022-3 [15] Park, J.M., Hwang, C.S., 2005. A design and practical use of spatial data warehouse. In: IGARSS 2005, IEEE International. Geoscience and Remote Sensing Symposium, 726-729. doi: 10.1109/IGARSS.2005.1525209? [16] Tviti, F., Hoogendoorn, S.P., Immers, L.H., et al., 2008. National data warehouse: how the Netherlands is creating a reliable, widespread, accessible data bank for traffic information, monitoring, and road network control. Transportation Research Record: Journal of the Transportation Research Board, 2049: 176-185. doi: 10.3141/2049-21 [17] Wang, S.H., Hu, G.D., Li, Z.H., 2004. Geological data warehouse system design and its key techniques. Computing Techniques for Geophysical and Geochemical Exploration, 26(4): 351-354 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-WTHT200404014.htm [18] 胡光道, 1999. 地质数据仓库设计中的几个问题. 地球科学——中国地质大学学报, 24(5): 522-524. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX199905020.htm [19] 胡光道, 陈建国, 1998. 金属矿产资源评价分析系统设计. 地质科技情报, 17(1): 45-49. https://www.cnki.com.cn/Article/CJFDTOTAL-DZKQ801.010.htm [20] 胡光道, 李振华, 2002. 基于数据中心的国土资源信息系统基础平台的构建及技术问题. 地球科学——中国地质大学学报, 27(3): 306-310. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200203016.htm [21] 贾培宏, 朱大奎, 马劲松, 等, 2007. "数字南海"空间数据仓库构建技术研究. 遥感信息, (4): 66-77. https://www.cnki.com.cn/Article/CJFDTOTAL-YGXX200704017.htm [22] 李振华, 胡光道, 陈建国, 1999. 地质数据仓库的特点及其数据组织. 地球科学——中国地质大学学报, 24(5): 536-538. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX199905024.htm [23] 李振华, 胡光道, 王淑华, 2002. 一个地学数据仓库的初步设计与实现. 地质与勘探, 38(5): 67-70. doi: 10.3969/j.issn.0495-5331.2002.05.014 [24] 王淑华, 胡光道, 李振华, 2004. 地学数据仓库系统的设计及关键技术问题. 物探化探计算技术, 26(4): 351-354. doi: 10.3969/j.issn.1001-1749.2004.04.014 -
下载:
点击查看大图
图(6)
计量
- 文章访问数: 2962
- HTML全文浏览量: 198
- PDF下载量: 111
- 被引次数: 0
