海量矿业权核查成果数据存储与访问的优化技术研究  

Study on Optimization Technology at the Sphere of Storing and Access to the Results of Audit Data in Term of the Mining Rights Massive Based on XML Binary Tree Index

作　　者：陈苗[1] 陈维斌[1] 洪欣[1] 

机构地区：[1]华侨大学计算机科学与技术学院,福建厦门361021

出　　处：《国土资源信息化》2011年第4期23-26,共4页Land and Resources Informatization

基　　金：福建省青年人才项目(2008F3065);华侨大学科研基金资助项目(08BS509)

摘　　要：针对矿业权核查单矿权成果数据具有文件小、数量多、异构、多源等特点,为了有效地存储这些数据到Oracle数据库中,实现快速提取及显示,并能够将一个矿业权的提取时长控制在1秒以内,本文给出了从建立数据库实体到查询、显示过程所涉及诸多问题的一个完整的优化方案。首先建立了一个完整的、科学的数据存储模型,并采用范围-列表分区模式对大型表进行分区,同时采用通过调整Oracle系统高速缓冲区、减少表连接、优化SQL查询语句、在客户端分页显示查询结果等优化方案,有效提升表中数据的查询速度,以达到优化目的。Taking into account the data mining rights list characterized by small file, large quantity, heterogeneous, multi-source, etc and in order to efficiently store data in an Oracle database, extract the mining rights to the control length of less than 1 second with display as fast, this paper demonstrates an optimal scenario which involves a lot of problems manifested in the creation of an entity on a database until in the process of search and display. The field - list of partitions to partition of a large table model by establishing a model of complete storage and scientific data has being used in the scenario with also the Oracle high-speed buffer to reduce a connection to the table, the query optimization of SQL （Structured Query Language） , the query optimization of display results to the client, so that the speed of query data in the table to reach the optimization may be effectively improved.

关 键 词：矿业权 海量数据 

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