A Universal Method to Clean Up Database
Songzheng Zhao · Jisuanji gongcheng · 2004
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.