索引及分裂大表技术在油井数据维护系统的应用
首发时间:2008-04-18
摘要:本文通过在油井数据维护系统的开发应用过程中,对数据库查询进行优化的研究和实践,介绍了索引技术[1]和分裂大表技术[2]和这两个技术在油井数据维护系统中的具体应用,以及他们对系统查询响应性能影响的量化分析。索引技术在合理利用的条件下,可以使响应时间缩短至原来的几十甚至几千分之一,而分裂大表技术则可以在没有大量增加额外空间的基础上,把系统的查询时间缩短为原来的1/n,甚至是1/n2(其中n为分裂的子表数目)。
For information in English, please click here
Index and Separating Great Table Technology in Application on the Well Data Maintenance System
Abstract:This article implies the study and practice on database query optimization during developing the well data maintenance system and gives a brief on index technology and separating great table technology as well as their application on the well data maintenance system and the quantitative analysis about these two technologies. Using index reasonable can reduce the querying time to one-tenth or even Less than 0.1% of before. Separating great table can bring us that the querying time can be shorted to 1/n even 1/n2 than before without any large addition storage space needed (n is the number of sub-tables separated).
Keywords: Wells data. Query Optimization. Index. Separating great table. Quantitative analysis
基金:
论文图表:
引用
No.2066122172712085****
同行评议
勘误表
索引及分裂大表技术在油井数据维护系统的应用
评论
全部评论0/1000