摘要： 数据库系统中的数据量随时间的延长增大,从而导致系统性能下降,对此文章提出了一种通用的数据整理方法。该方法基于触发器机制和从数据库数据到文本数据的转换技术,将满足条件的数据迁移到另一结构相同的数据库中,既保证了原信息系统的运行性能,又不损失系统的历史数据,而且在数据整理的同时兼有数据备份功能。该方法在实际应用中使开发者选择数据迁移过程简单化,对于有删除关联关系的多个表,只须考虑父表的情况,其所有子表的数据整理过程随父表自动完成。

关键词: 数据库, 触发器, 备份

Abstract: With the time extened, the data in database system will be expanded, which declines the system capability. To solve the problem, this paper presents a universal method to clean up the data in database. Based on trigger mechanism and data transform technology from database to text, the method moves the data to the database that is the same data structure as the original information system database. It ensures not only system capability, but also reserves the historical data and possesses the backup data function. The method is simiple to actualize because developers only consider the top table for hierarchical relative tables, and the process to move data for all other tables will be done automatically.

中图分类号: 

• TP311.13