Data Archiving Approach Leveraging Database Layer Functionality
2 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
26 Claims
-
1-2. -2. (canceled)
-
3. A computer-implemented method comprising:
-
causing an archiving framework of an application layer, to obtain from a database layer, a name of a database table in which a record is stored; causing the archiving framework to determine a primary key field of the database table; causing the archiving framework to extract a value of the primary key field; communicating the table name and the primary key value from the archiving framework to the database layer; and altering the database table to create a new column including a new field having a value used to determine whether or not the record is moved to a data storage hierarchy of the database layer, such that an existing functionality of the database layer moves the record identified by the primary key field from the database to the data storage hierarchy of the database layer based upon the new field, wherein the existing functionality of the database layer comprises a table partitioning functionality. - View Dependent Claims (4, 5, 6, 7, 23, 24)
-
-
8-9. -9. (canceled)
-
10. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
-
causing an archiving framework of an application layer, to obtain from a database layer, a name of a database table in which a record is stored; causing the archiving framework to determine a primary key field of the database table; causing the archiving framework to extract a value of the primary key field; communicating the table name and the primary key value from the archiving framework to the database layer; and altering the database table to create a new column including a new field having a value used to determine whether or not the record is moved to a data storage hierarchy of the database layer, such that an existing functionality of the database layer moves the record identified by the primary key field from the database to the data storage hierarchy of the database layer based upon the new field, wherein the existing functionality of the database layer comprises a table partitioning functionality. - View Dependent Claims (11, 12, 13, 14, 25, 26)
-
-
15-16. -16. (canceled)
-
17. A computer system comprising:
-
one or more processors; a software program, executable on said computer system, the software program configured to; cause an archiving framework of an application layer, to obtain from a database layer, a name of a database table in which a record is stored; cause the archiving framework to determine a primary key field of the database table; cause the archiving framework to extract a value of the primary key field; communicate the table name and the primary key value from the archiving framework to the database layer; and alter the database table to create a new column including a new field having a value used to determine whether or not the record is moved to a data storage hierarchy of the database layer, such that an existing functionality of the database layer moves the record identified by the primary key field from the database to [[a]] the data storage hierarchy of the database layer based upon the new field, wherein the existing functionality of the database layer comprises a table partitioning functionality. - View Dependent Claims (18, 19, 20, 21, 22)
-
Specification