关系型地质数据库动态建立及批量数据灌制

来源期刊：中南大学学报(自然科学版)2002年第1期

论文作者：王月平 贾明涛

文章页码：14 - 17

关键词：地质数据;关系数据库;结构化查询语言;管理技术

Key words：geological data; relationship database; SQL; management technology

摘    要：地质数据库在矿床建模中具有基础性的地位,传统地质数据管理方法具有效率低、对网络数据处理能力弱的不足.为此,作者应用支持结构化查询语言的单文件型数据库系统INTERBASE在DELPHI开发环境下,研究了地质数据库的建立、批量数据输入等方法与技术.其步骤是:首先,通过对地质数据特点的分析,提出了利用INTERBASE动态建立地质数据库需进行的2项工作———数据库文件及其参数的创建,数据表的创建;其次,通过对数据批量输入时文本文件特点的分析,提出了具体的数据查错策略及灌制技术.基于上述分析,编制了相应的数据库动态建立及数据批量灌制所需要的函数.应用结果表明:该技术有效地解决了矿床模型系统运行时动态创建地质数据库以及大批量数据智能化自动灌制问题,这对整个系统其他数据库的建立及数据管理提供了借鉴.

Abstract: Geology database is the foundation of the deposit modeling. The traditional management methods of the geology data have many shortcomings that are becoming more and more evident. In this paper, we mainly discussed the techniques of the creation of the geological database, the perfusion of the numerous data and so on, in the development environment of DELPHI using INTERBASE that support SQL. Firstly, the necessary two tasks in dynamically creation of the geology database by means of INTERBASE, via analysis of the characters of the geology data are put forward. The two tasks are the creation of the database and its parameters, the creation of the table. The former work ensures the latter work. Secondly, through the analysis of the character of the text file used for batch data input, we proposed a detailed error-check principle and perfusing techniques. Based on the former analysis, the relative functions are described that are necessary for dynamic database creation and batch data input. Finally, we did some tests using the developed software,which shows that the dynamic creation of the database in the environment of the whole system and the intellectualization,self-motion perfusion of the data are primly resolved. Meanwhile this paper has given a very good support for the creation and the data management of all the other databases among the whole system.