Intelligent data archiving
First Claim
1. A computer-implemented method for archiving an active record in a database, the method comprising:
- creating an auxiliary table in the database, the auxiliary table being operable to store metadata information about active records to be archived and deleted from the database;
selecting an active record to be deleted from the database;
storing metadata information for the selected active record in the auxiliary table;
archiving the selected active record into a data storage device; and
deleting the selected active record from the database, based on update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database.
1 Assignment
0 Petitions
Accused Products
Abstract
Methods and apparatus, including computer program products, implementing and using techniques for archiving an active record in a database. An auxiliary table is created in the database. The auxiliary table can store metadata information about active records to be archived and deleted from the database. An active record to be deleted from the database is selected. Metadata information is stored in the auxiliary table for the selected active record. The selected active record is archived into a data storage device. The selected active record is deleted from the database, based on the update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database.
30 Citations
18 Claims
-
1. A computer-implemented method for archiving an active record in a database, the method comprising:
-
creating an auxiliary table in the database, the auxiliary table being operable to store metadata information about active records to be archived and deleted from the database; selecting an active record to be deleted from the database; storing metadata information for the selected active record in the auxiliary table; archiving the selected active record into a data storage device; and deleting the selected active record from the database, based on update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer program product for archiving an active record in a database, the computer program product comprising:
-
a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising; computer readable program code configured to create an auxiliary table in the database, the auxiliary table being operable to store metadata information about active records to be archived and deleted from the database; computer readable program code configured to select an active record to be deleted from the database; computer readable program code configured to store metadata information for the selected active record in the auxiliary table; computer readable program code configured to archive the selected active record into a data storage device; and computer readable program code configured to delete the selected active record from the database, based on update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A system for archiving an active record in a database, the system comprising:
-
a data storage device operable to archive active records obtained from a database for long-term storage; a computing device hosting a database with active records, the computing device including a processor and a memory storing instructions operable to cause the processor to perform the following operations; creating an auxiliary table in the database, the auxiliary table being operable to store metadata information about active records to be archived and deleted from the database; selecting an active record to be deleted from the database; storing metadata information for the selected active record in the auxiliary table; archiving the selected active record into the data storage device; and deleting the selected active record from the database, based on update information in the auxiliary table, without comparing column data for the archived record in the data storage device and the active record in the database prior to deletion of the active record from the database. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification