数字化信息平台Oracle数据库空闲碎片整合研究

Research on the integration of idle fragments in Oracle Database

为解决传统方法吞吐量会随数据量的升高而降低,导致数据恢复速度慢的问题,提出了一种新的数字化信息平台Oracle数据库空闲碎片整合方法。对数据块结构进行解析,并分析了空闲碎片的形成过程,依据自由空间碎片索引值判断是否出现空闲碎片。在剩余容量低于阈值的情况下,进行空闲碎片整合处理。引入速率因子概念,采用最小分支搜索方法作为空闲碎片整合方法,对数字化信息平台Oracle数据库剩余容量进行检查与分解,计算每个候选码分支的代价函数,获取各子系码所需的重分配次数,确定最小代价函数分支,令该分支为空,从而实现数字化信息平台Oracle数据库空闲碎片整合。经实验验证,采用所提方法进行空闲碎片整合,Oracle数据库数据恢复速度快,误差小,碎片整合效果好。

In order to solve the problem that the throughput of traditional methods will decrease with the increase of data volume,which leads to the slow recovery of data,a new method of Oracle database idle fragmentation integration for digital information platform is proposed.The data block structure is analyzed,and the formation process of free fragments is analyzed.In the case that the remaining capacity is below the threshold,idle fragment consolidation is carried out.Introducing concept of rate factor,USES the smallest branch search method as pieces of free integration method,inspection on digital information platform of the residual capacity of Oracle database and decomposition,computational cost function of each candidate code branch,for each department to code the required number of redistribution,determine the minimum cost function branch,to the branch is empty,so as to realize digital information integration platform free Oracle database fragments.Experimental results show that the proposed method can restore Oracle database data quickly,reduce errors and achieve good results.