基于JSP技术的钻井液网络数据库设计  

Design of JSP-Based Drilling Fluid Web Database

作　　者：李谦[1] 朱文鉴 段隆臣[1] 

机构地区：[1]中国地质大学工程学院,武汉430074 [2]北京探矿工程研究所,北京100083

出　　处：《地质科技情报》2013年第4期185-190,共6页Geological Science and Technology Information

基　　金：科技部深部探测技术与实验研究专项"爆破孔钻探技术及超深井钻探技术方案预研究"(SinoProbe-05-06)

摘　　要：钻井液工艺、材料的日新月异使钻井液的管理日益重要,针对目前国内外的钻井液管理系统设计上的缺陷,设计了基于JSP动态网页技术的钻井液网络数据库,该数据库无需安装客户端,通过浏览器即可操作,也可有效地解决数据同步更新的问题。从数据安全、易于管理维护上考虑,逻辑上本数据库设计了2种操作权限,普通用户可自由查询各钻井液的基本信息,如体系、配方、性能等,也可通过地层查询对应的钻井液信息;管理员则负责维护数据库操作,负责添加、删除和编辑数据。从数据库使用效率上考虑,物理上本数据库设计了6个相互关联的表,由于关联的双向性通过任意表都能查询其他表的所有信息。Drilling fluid management becomes more important than before with the fast updated drilling fluid technology and material.Compare with the current drilling fluid design and management software,the drilling web database introduced in this paper is based on JSP dynamic web pages technology,which could be operated just by browser instead of client,and the unified web database is also an effective solution to the problem of data synchronized updates.Considering the data safety and management,two operating authority were designed as following.Ordinary users could only inquire the data,including basic information,formula and property,as well as obtain the correlated drilling liquid information through stratigraphy inquiry.And authorized administrators were in charge of adding,deleting and editing data.Considering the database utilizing efficiency,six interrelated tables were set,which made users could query any data from any tables by the bilateral associate of tables.

关 键 词：钻井液 JSP 网络数据库 

分 类 号：P628.4[天文地球—地质矿产勘探] TE254[天文地球—地质学]