Data archiving approach leveraging database layer functionality

摘要

A data archiving approach exploits functionality already existing within a database layer, utilizing additional information received from an application layer. Rather than writing archive-eligible records to a separate archive layer, a central module of an application layer receives from the database layer, the name of the database table to which stored records belong. This central module determines primary key fields of the table, and extracts values of those primary key fields. The central module may then leverage an existing capability (e.g. data aging, table partitioning) of the database layer, informing it of the eligible records (identified by table name and primary key values). The database layer may then move the archive-eligible records (e.g. in an asynchronous manner) to an appropriate level within a data storage hierarchy of the database layer. In some embodiments, the eligible records may be moved to lower cost (e.g. read-only) storage medium within the storage hierarchy.