Data Management of Object Type Geological Features on Control Dictionary
-
摘要: 传统地质数据管理与应用是参照数据库的外模式来设计数据结构和数据访问接口，在业务逻辑没有发生大的变动情况下，外模式发生更改后，需要修改应用程序才能适应新的数据库结构.鉴于此弊，在关系数据库视图机制的启发下，通过分析不同地质专业地质属性数据的特征，对地质数据库外模式的高度概括，形成用于地质业务分析评价所需的关键属性组成的元组集——控制字典表，基于控制字典抽象出面向地质行业的对象式数据模型、映射数据模型与地质数据的关系，并参照控制字典表的“数据结构”来设计数据访问接口，最终实现地质数据库的动态扩展，无需再修改应用程序，需要做的仅仅是修改控制字典与外模式之间的映射关系，以不变应万变.控制字典作为一个中间件，将用户对地质数据的操作和计算机对地质数据的处理分离开来，充分保证了程序和数据层的逻辑独立性.Abstract: The structure and access interfaces of data are designed by reference to external schema changes in traditional management and application of geological data, for which application programs have to be modified in case of any external schema changes, even if there are not much variations in business logic. To tackle the issue, control dictionary tables are proposed in this study by analyzing the characteristics of different geological attribute data and generalizing external schema of geological databases based on view mechanism of relation databases, which is used in character-set formed from determinant attributes needed for geological business analysis and evaluation. Meanwhile, data access interfaces are designed according to the data structures of the control dictionary tables which abstract the object-oriented data model of geological professions and map the relation between the data model and geological data. It is shown that it is only necessary to modify the mapping relations between control dictionary and external schema rather than applications to realize the expansion of geological databases dynamically, in which the control dictionary separates the operation of geological data by users and from the processing by computers as a middleware, thus ensuring the logic independence of program and data layers.
-
Key words:
- control dictionary /
- geological object /
- user table /
- data table /
- mapping /
- information science
-
[1] Cheng, L., 2009. Production Research of Data Dictionary on Geographic Information System. Science & Technology Information, (20): 1 (in Chinese with English abstract). [2] Dai, G.Y., Bao, Z.Y., Zhang, J.Z., 2000. Development of Mining Spatial Database by GIS. Computing Techniques for Geophysical and Geochemical Exploration, 22(1): 78-81 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-WTHT200001016.htm [3] Guo, W.N., Mao, X.C., Chen, Z., 2009. Development of the Design and Management System of Generalized Geological Database Structure. Metal Mine, (6): 136-139 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-JSKS200906046.htm [4] He, J.X., Lu, L.J., Liu, Y.Q., 2008. New Framework of 4D Geological Information System. Science Technology and Engineering, 8(2): 534-536 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-KXJS200802055.htm [5] He, S.F., Wang, S.J., 2003. Building and Application of Geoscience Database of Canada. Marine Geology Letters, 19(1): 22-25 (in Chinese). [6] Jiang, W.P., 2008. The Incipient Research of the Standardized Management of Geological Data. Resources Environment & Engineering, 22(1): 103-106 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-HBDK200801029.htm [7] Liu, R., Yan, S.W., Zhang, M.Y., et al., 2002. Development of a Database for Soil Investigation of Tianjin Port. China Harbour Engineering, (5): 14-18 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-GKGC200205004.htm [8] Lu, X.Q., Mao, X.C., Fan, J.C., 2009. Study of Comprehensive Geological Database System Structure on Technology of Intelligent Client (Dissertation). Central South University, Changsha, 16-19 (in Chinese with English abstract). [9] Luo, M.L., 1991. Storage Structure and Management Requirement of Geological Data Classification and Kinds of Data. Computer Application on Geology in International Discussion Paper Set, 607-611 (in Chinese). [10] Ma, X.G., Wang, X.Q., Wu, L.H., et al., 2007. Implement of Universal Information Models for Multi-Source Geology Spatial Database Management Based on Data Dictionary. Mining Research & Development, 27(1): 37-40 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-KYYK200701013.htm [11] Mao, X.Y., Kong, L.S., 2008. Integrated Method and Application on Multi-Source Heterogeneous Database. Database and Information Management, 2(16): 1197-1199 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-DNZS200816011.htm [12] Ren, J., Mao, X.C., 2007. Study of Geological Mineral Basic Database and Spatial Database (Dissertation). Central South University, Changsha, 1-3, 12-17 (in Chinese with English abstract). [13] Shi, Q.J., Hu, W.S., Liu, D.P., 2007. Study on Ground Data Model of Drill Hole Information and Database. Rock and Soil Mechanics, 28(4): 758-762 (in Chinese with English abstract). http://www.researchgate.net/publication/290538515_Study_on_ground_data_model_of_drill_hole_information_and_database [14] Wang, C.N., Shang, W., Chen, P.Z., 2005. Construction of Geological Data Management System. Land and Resources Informatization, (1): 18-23 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-GTZX200501005.htm [15] Wang, Y.P., Jia, M.T., 2002. The Dynamic Creation and Numerous Data Perfusion of the Relational Geological Database. Journal of Central South University of Technology (Natural Science), 33(1): 14-17 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-ZNGD200201003.htm [16] Wu, Z.X., Pan, M., Qu, H.G., et al., 2008. Urban Geological Domain Information Management and Service System Architecture. Computer Engineering, 34(22): 247-249 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-JSJC200822090.htm [17] Xiao, J.H., Liu, H.Y., Luan, X.Y., 2006. Data Dictionary Design in Geo-Database. Engineering of Surveying and Mapping, 15(2): 40-44 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-CHGC200602011.htm [18] Xu, Z.P., Chen, J.Q., Xiao, J.Y., et al., 2008.3D Visual Borehole Management System—Taking Quaternary Boreholes in the Kunming Basin as an Example. Geology and Prospecting, 44(2): 101-104 (in Chinese with English abstract). http://www.cnki.com.cn/Article/CJFDTotal-DZKT200802020.htm [19] Yang, X., Huang, J.Z., Yuan, D., et al., 2005. Development of Basic Hydro-Geologic Data Management System Based on GIS. Computer Applications and Software, 22(3): 19-21, 36 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-JYRJ200503007.htm [20] Zhang, J., Cheng, X.L., 2009. Application of Data Integration of Multi-Source Heterogeneous. Journal of Chengdu University of Information Technology, 24(3): 254-258 (in Chinese with English abstract). http://en.cnki.com.cn/Article_en/CJFDTOTAL-CDQX200903007.htm [21] Zheng, K., Hou, W.S., Liu, X.G., 2006. Database Designed for Urban 3D Geological Investigations. Earth Science—Journal of China University of Geosciences, 31(5): 678-682 (in Chinese with English abstract). http://gateway.proquest.com/openurl?res_dat=xri:pqm&ctx_ver=Z39.88-2004&rfr_id=info:xri/sid:baidu&rft_val_fmt=info:ofi/fmt:kev:mtx:article&genre=article&jtitle=Earth%20Science&atitle=Database%20designed%20for%20urban%203D%20geological%20investigations [22] Zhu, L.F., Wu, X.C., Liu, X.G., 2004. Study on the Framework of Management and Service System for Urban 3D Geological Data. Journal of Earth Sciences and Environment, 26(1): 69-75 (in Chinese with English abstract). http://www.en.cnki.com.cn/Article_en/CJFDTOTAL-XAGX200401016.htm [23] 程雷, 2009. 地理信息系统数据字典生产研究. 科技资讯, (20): 1. doi: 10.3969/j.issn.1672-3791.2009.20.001 [24] 戴刚毅, 鲍征宇, 张锦章, 2000. 基于GIS的矿山空间数据库的建立. 物探化探计算技术, 22(1): 78-81. doi: 10.3969/j.issn.1001-1749.2000.01.017 [25] 郭伟娜, 毛先成, 陈振, 2009. 综合地质数据库结构设计与管理系统开发. 金属矿山, (6): 136-139. doi: 10.3321/j.issn:1001-1250.2009.06.039 [26] 贺金鑫, 路来君, 刘雅琴, 2008. 一种新的四维地质信息系统架构. 科学技术与工程, 8(2): 534-536. doi: 10.3969/j.issn.1671-1815.2008.02.054 [27] 何书锋, 王圣洁, 2003. 加拿大地学数据库建设和应用. 海洋地质动态, 19(1): 22-25. doi: 10.3969/j.issn.1009-2722.2003.01.008 [28] 蒋卫萍, 2008. 地质资料规范化管理初探. 资源环境与工程, 22(1): 103-106. doi: 10.3969/j.issn.1671-1211.2008.01.025 [29] 刘润, 闫澍旺, 张美燕, 等, 2002. 天津港工程地质数据管理系统的开发与研制. 中国港湾建设, (5): 14-18. doi: 10.3969/j.issn.1003-3688.2002.05.005 [30] 卢晓琴, 毛先成, 樊俊昌, 2009. 基于智能客户端技术的综合地质数据库体系结构的研究与实现(硕士学位论文). 长沙: 中南大学, 16-19. [31] 罗明亮, 1991. 地质数据分类和各类数据的存贮结构与管理要求. 计算机在地学中的应用国际讨论会论文摘要集, 607-611. [32] 马小刚, 汪新庆, 毋丽红, 等, 2007. 应用数据字典实现多源地质空间数据的通用管理. 矿业研究与开发, 27(1): 37-40. doi: 10.3969/j.issn.1005-2763.2007.01.014 [33] 毛晓燕, 孔玲爽, 2008. 多源异构数据库的集成的研究. 数据库与信息管理, 2(16): 1197-1199. https://www.cnki.com.cn/Article/CJFDTOTAL-DNZS200816011.htm [34] 任佳, 毛先成, 2007. 地质矿产基础数据库与空间数据库的研究与开发(硕士学位论文). 长沙: 中南大学, 1-3, 12-17. [35] 史秋晶, 胡伍生, 刘丹萍, 2007. 工程地质钻孔信息模型及数据库研究. 岩土力学, 28(4): 758-762. doi: 10.3969/j.issn.1000-7598.2007.04.024 [36] 王春宁, 尚武, 陈培章, 2005. 地质资料管理系统建设研究. 国土资源信息化, (1): 18-23. https://www.cnki.com.cn/Article/CJFDTOTAL-GTZX200501005.htm [37] 王月平, 贾明涛, 2002. 关系型地质数据库动态建立及批量数据灌制. 中南工业大学学报(自然科学版), 33(1): 14-17. https://www.cnki.com.cn/Article/CJFDTOTAL-ZNGD200201003.htm [38] 吴自兴, 潘懋, 屈红刚, 等, 2008. 城市地质领域信息管理与服务系统体系结构. 计算机工程, 34(22): 247-249. doi: 10.3969/j.issn.1000-3428.2008.22.087 [39] 肖计划, 刘海砚, 栾晓岩, 2006. 地理信息数据库中数据字典的设计. 测绘工程, 15(2): 40-44. doi: 10.3969/j.issn.1006-7949.2006.02.011 [40] 许哲平, 陈建强, 肖景义, 等, 2008. 三维可视化钻孔管理系统——以昆明盆地第四系钻孔为例. 地质与勘探, 44(2): 101-104. https://www.cnki.com.cn/Article/CJFDTOTAL-DZKT200802020.htm [41] 杨旭, 黄家柱, 袁丁, 等, 2005. 基于GIS的水文地质基础数据管理系统的开发. 计算机应用与软件, 22(3): 19-21, 36. doi: 10.3969/j.issn.1000-386X.2005.03.008 [42] 张靖, 程希来, 2009. 多源异构数据整合应用研究. 成都信息工程学院学报, 24(3): 254-258. doi: 10.3969/j.issn.1671-1742.2009.03.008 [43] 郑坤, 侯卫生, 刘修国, 2006. 城市三维地质调查数据库. 地球科学——中国地质大学学报, 31(5): 678-682. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200605020.htm [44] 朱良峰, 吴信才, 刘修国, 2004. 城市三维地质数据管理与服务系统框架研究. 地球科学与环境学报, 26(1): 69-75. doi: 10.3969/j.issn.1672-6561.2004.01.016 -
下载:
点击查看大图
图(3)
计量
- 文章访问数: 2728
- HTML全文浏览量: 97
- PDF下载量: 285
- 被引次数: 0
