摘要
本文基于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.
出处
《石油工业计算机应用》
2015年第2期40-43,4,共4页
Computer Applications Of Petroleum
