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

Design of JSP-Based Drilling Fluid Web Database

钻井液工艺、材料的日新月异使钻井液的管理日益重要,针对目前国内外的钻井液管理系统设计上的缺陷,设计了基于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.