基于数据库的综合地层柱状图编制技术研究与实现

区域地质调查工作一般离不开综合地层柱状图的绘制,但目前在综合地层柱状图编制方式中,没有一种很通用的方案,其中的主要问题是数据源的选择问题,数据源问题很重要但到目前尚未很好解决,本研究吸取了传统地层柱状图制作中的先进之处,提出基于数据库的综合地层柱状图制作方式,是一种通用的解决方案。并以“计算机辅助区域地质调查系统”的“野外地质数据采集子系统”为基础库,采用SQL语言提取数据,以ADO技术实现数据的访问,编写基于Visual Basic综合柱状图编制模块,实现了该技术,是对传统综合地层柱状图编制方式的一种改进。

THE STUDY AND REALIZATION ON SYNTHETICAL STRATUM HISTOGRAM DRAWING BASED ON DATABASE

It is very important to draw a piece of stratum histogram drawing in Regional Geological Survey work, but there is not a universal scheme in several methods of drawing synthetical stratum histogram at present. The main problem is the selection of Data Source. The Data Source is very important but has not been resolved now. Based on the virtue of the traditional study of stratum histogram drawing, this study puts forward the working pattern of the synthetical stratum histograms based on the database, which is a universal resolving scheme. The scheme uses the field geology data-collecting sub-system of the Computer-aided Regional Geology Survey System as a basic database, obtains the data by "SQL", accesses the data by "ADO", develops a synthetical stratum histogram drawing model under VB environment and at last realizes this technology.