城市工程地质勘察钻孔数据库结构设计

Structural Design of Borehole Database of Geological Survey for Urban Engineering

为了转变传统地质资料服务方式,达到高效利用工程地质勘察钻孔数据的目的,论文通过建立数据概念模型,设计数据逻辑结构,完成数据分类与属性表设置、属性表关联与数据索引、属性表内容设计等工作,最终利用大量钻孔资料建立了关系型数据库,开发了钻孔数据机检的功能,实现了海量钻孔数据的有序管理、规范处理和质量控制。可供其他城市开展类似工程提供参考。

To change the mode of traditional geological data service and achieve the purpose of efficient use of engineering geological survey borehole,by establishing the concept of data model,designing data logic structure,the paper completed the data classification and the property sheet setting,the property sheet correlation and the data index,the property sheet content design,and so on,finally used a large amount of drilling data to establish a relational database,and develop the function of borehole data quality inspection by the computer.It makes orderly management,normalized process,quality control of the massive borehole data come ture.The method can be used for reference in the similar projects.