摘要
采用数据库日期分区策略,成功解决了大规模应用中的批量数据清理的问题,对于行宽超过32K,记录数超过200万行的大数据量库表数据的清理操作,处理时间由过去的(4~6)h,缩短到2s钟以内,消除了批量处理过程对生产系统的影响,保证系统实现24h不间断运行。该方案应用透明,方便应用系统的方案改造升级,具有极高的推广价值。
By using fragmentation on date, a large number of data successfully be could deal with. To deal with the number above 2000000 of data in the table of the database, the width above 32 K, the process will be done in 2 seconds , while it could take (4 -6) hours before. The result of using fragmentation is that which can eliminate the affect of process dealing with a large numbers of datas, to protect the system can run uninterruptedly. The project has such strongpoint as clarity of application, the convenience which is easy to upgrade or rebuild the system of application, as a result, it gets the value of extending.
出处
《科学技术与工程》
2007年第13期3289-3291,共3页
Science Technology and Engineering