新型钻井数据库设计

Design of new drilling database

随着数据库开发技术的发展和钻井工艺技术的进步,基于以前数据库行业标准设计的钻井数据库已满足不了新的要求。因此,设计新型钻井数据库及开发新的数据库管理系统具有重要的现实意义。新型钻井数据库按照标准化、规范化、灵活性、开放性等原则设计,大大提高了钻井数据库的性能。新型钻井数据库具有优化的数据结构,以井眼作为贯穿整个结构的主线,数据表间结构合理,符合钻井工艺流程,满足多分支井、丛式井等各种井型的要求;数据项齐全,以满足目前需要为前提,考虑可能存在的扩充;字段遵循规范的英文命名原则,方便数据库的开发、维护和多语言显示;利用规范的编码表,规范数据录入,保证统计分析准确;强大的内置计算功能,减少人工输入量,保证数据的准确性和完整性;良好的兼容性和安全性,保证数据库之间的数据共享和数据安全。

With the development of database technology and drilling techniques,the drilling database designed by the former industry standard can not meet the new demands now.Therefore,it is very significant to design a new drilling database and develop a new database management system.With the standardized,flexible and open principles,the performance of new drilling database has been greatly improved.Taking wellbore as the master line of the entire structure,datasheets are reasonable in structure,which provides an optimized data structure for a new database that fits the drilling draft and satisfy the different demands of various well types,such as multilateral wells and cluster wells.Complete data items are preconditions to meet current requests and it is still considering expansion.Field follows the guidelines of English name which gives conveniences to develop,maintain the database and show in multiple languages.It norms the input of data by standardized encoding table to make sure precise statistical analysis.Strong built-in calculating function reduces manual inputs and ensures the accuracy and completeness of data.The better compatibility and security of the new database has guaranteed the data sharing and data security among databases.