DATABASE ARCHIVING METHOD AND DEVICE FOR CREATING INDEX INFORMATION AND METHOD AND DEVICE OF RETRIEVING ARCHIVED DATABASE INCLUDING INDEX INFORMATION

摘要

Provided is a database archiving method for creating index information. According to the exemplary embodiment of the present invention, a database archiving method for creating index information includes selecting at least one record group including a plurality of records from an original table in which data is archived, based on information on a field value; storing group compression data compressed to be created for every record group and a stored key value uniquely assigned to every group compression data, with respect to each of at least one record group, in a compression table; storing the field value and the stored key value corresponding to each of at least one record group, in a group index table; and deleting a plurality of records included in at least one selected record group from the original table.