| 海量矿业权核查成果数据存储与访问的优化技术研究 |
| |
| 引用本文： | 陈苗,陈维斌,洪欣.海量矿业权核查成果数据存储与访问的优化技术研究[J].国土资源信息化,2011(4). |
| |
| 作者姓名： | 陈苗 陈维斌 洪欣 |
| |
| 作者单位： | 华侨大学计算机科学与技术学院; |
| |
| 基金项目： | 福建省青年人才项目(2008F3065); 华侨大学科研基金资助项目(08BS509) |
| |
| 摘 要： | 针对矿业权核查单矿权成果数据具有文件小、数量多、异构、多源等特点,为了有效地存储这些数据到Oracle数据库中,实现快速提取及显示,并能够将一个矿业权的提取时长控制在1秒以内,本文给出了从建立数据库实体到查询、显示过程所涉及诸多问题的一个完整的优化方案。首先建立了一个完整的、科学的数据存储模型,并采用范围-列表分区模式对大型表进行分区,同时采用通过调整Oracle系统高速缓冲区、减少表连接、优化SQL查询语句、在客户端分页显示查询结果等优化方案,有效提升表中数据的查询速度,以达到优化目的。
|
| 关 键 词： | 矿业权 海量数据 |
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 |
| |
| Chen Miao,Chen Weibin,Hong Xin.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[J].Land and Resources Informatization,2011(4). |
| |
| Authors: | Chen Miao Chen Weibin Hong Xin |
| |
| Institution: | Chen Miao,Chen Weibin,Hong Xin (College of Computer Science and Technical,Huaqiao University,Fujian,Xiamen 361021) |
| |
| Abstract: | 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 mo... |
| |
| Keywords: | Mining right Massive data Binary tree index |
| 本文献已被 CNKI 等数据库收录！ |
|
