基于Oracle复杂油藏数据统计查询方法与实际案例  

Complicated Reservoir Data Statistics and Query Based on Oracle Database and the Practical Cases

作　　者：王顺才[1] 樊长江 

机构地区：[1]大庆油田有限责任公司勘探开发研究院 [2]中国石油勘探开发研究院

出　　处：《石油工业计算机应用》2015年第2期40-43,4,共4页Computer Applications Of Petroleum

摘　　要：本文基于Oracle阐述了一种复杂油藏数据统计与查询的方法以及最常用、应用范围最广的Select语句灵活巧妙的应用技术,实现了15张表同时关联、31个数据项抽取分组、数值累加的数据统计查询。文章从案例需求出发,通过剖析问题所在,确定各种逻辑关系与实现思路,最后用很长的程序语句成功实现,再配以注释,展示了数据统计的完整过程以及Select语句灵活运用的技术细节,起到了抛砖引玉与触类旁通的作用;该典例的成功实现在油田某重大科研攻关项目研究中发挥了重要作用。This paper introduces one kind of complicated data statistic and query method based on Oracle database and some smart application skills for Select Statements which are most frequently and extensively used.It realizes data statistic query of 15 tables,31data items grouping and numerical summation.In this paper,according to the practical requirements,the problems encountered during application have been analyzed.Logical relationships and realization ideas of the complicated statistics and query have been defined.Finally the complicated data statistics and query based on Oracle database is realized by very long statements.Besides,detailed annotations in practical process,demonstration of the whole process of data statistics and technical details for skillful application of Select statement are presented,which is hoped to arouse some new ideas of computer engineers and helps them understand some relevant problems in the practical application of Oracle database.The success of this practical case has played a significant role in a scientific and research project of Daqing oilfield.

关 键 词：ORACLE数据库 油藏数据 复杂数据统计与查询 表达式嵌套 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]