导　　师： 刘宝林;胡远彪

学科专业： 081803

授予学位： 硕士

作　　者： ;

机构地区： 中国地质大学北京

摘　　要： 本文通过对石油钻井、地质岩心钻探、科学超深井钻探相关规范及多种钻井或钻探设备、工具和材料手册的总结、分析和整理，运用计算机网络和数据库技术开发了一套基于Web的钻探数据库系统。该基于Web的钻探数据库系统不仅可以为相配套的钻探辅助设计软件提供数据支持，同时还可以为钻探设计施工人员、采购贸易人员、相关教学人员等提供一个访问方便、查询便捷的平台。其中本文主要内容如下。 （1）通过大量国内外文献的查阅和有关钻探辅助设计软件实例的分析，确定了目前钻探数据库及其采用技术的优缺点和现状问题，提出了基于Web的钻探数据库的构建与开发的理论方向。 （2）根据石油钻井规范、地质岩心钻探规程及相应的钻探设备、工具和材料手册，确定了适合该钻探数据库系统的有关钻探设备、工具和材料的分类类别，为钻探数据库中数据条理性、规范性及其使用提供了保障。 （3）创建了一套适用于该钻探数据库系统开发的钻探设备、工具和材料分类编码，并完成了所有类别的钻探设备、工具和材料的基础物理表格和辅助物理表格的结构及其物理表间关联等数据库的最底层设计内容。 （4）根据钻探数据库的使用目的及其特点，完成了钻探数据库的功能，主要分为前台展示查询系统和后台管理系统整体功能设计；根据前后台相应的功能组合，完成了前后台中各部分功能模块设计，主要集中于钻探设备、工具和材料的数据管理和查询功能模块。 （5）运用JSP+Java+MySQL平台开发出了基于Web运行的钻探数据库系统,该系统具有操作简捷、管理方便、界面友好、数据分类类别清晰、数据扩展性强、数据应用范围广等特点。管理人员和普通用户通过浏览器在互联网环境下即可进行对该数据库中所有钻探设备、工具和材料数据的管理和查询。 This article introduced the architecture and development of drilling database on webthrough analysing and summarizing the drilling specifications or standards and lots ofdrilling equipments, tools, materials manuals. This drilling database which workingon web can not only provide the data about dirlling equipments, tools, materials forscientific drilling aided design software which matching the database, but also providea plantform of drilling equipments, tools, materials for all kinds of people. 1. This article make sure the advantages and disadvantages about the drillingdatabase’s technical features and problems which be used usually at now through thereading of documents, the summarizing and analysing of drilling aided software homeand abroad. It provides the derection of reasearch for the drilling database on web. 2. According to the specifications of well drilling, core drilling, scientific drilling andmanuals of drilling equipments, tools, materials, the author created a categoryclassification about drilling equipments, tools, materials which suit for the drillingdatabase. 3. The author created a set of codes for the category classification about drillingequipments, tools, materials which are used for the development of drilling databaseand finished the design of the basic physical table’s and accessible table’s structures.That’s the most important step of the database’s development. 4. The author finished the design of functions of drilling database through the purposeand usage of drilling database. The functions are comprised of foreground andbackground system. The author finished the development of drilling database on web,which most important function is can provide the management and query of drillingdata for user. 5. The technical features of drlling database on web are developed on the platform ofJSP+Java+MySQL. There are many advantages about the drilling database on web,such as esay to opreate and management, Friendly interface, Clear classifications,wide ranges of applications. Users can visit the drilling database just through internetto query the data of drilling equipments, tools, materials easily.

关 键 词： 钻探 数据库 数据管理 数据查询

分 类 号： [P628.4 P634]

领　　域： [天文地球] [天文地球] [天文地球] [天文地球]