Automated Information Lifecycle Management Using Low Access Patterns

1. A method comprising: a database management system receiving a structured query language (SQL) statement that comprises clauses specifying: one or more database objects defined in a database dictionary of a database managed by the database management system, an activity-level condition based on one or both of read access or write access to the one or more database objects, and an archiving action; in response to receiving the statement, storing policy data in association with the one or more database objects, the policy data specifying the activity-level condition and the archiving action; wherein the one or more database objects are stored in a plurality of data blocks; the database management system determining, based at least on statistics tracking access to the plurality of data blocks, that the activity-level condition is satisfied for a particular database object of the one or more database objects; in response to determining that the activity-level condition is satisfied, the database management system performing the archiving action on one or more particular data blocks that store the particular database object; wherein the method is performed by one or more computing devices.

2. The method of claim 1 wherein the database management system comprises a plurality of storage tiers, each storage tier of the plurality of storage tiers being associated with a different set of performance characteristics, and wherein the archiving action comprises moving the one or more particular data blocks to a particular storage tier of the plurality of storage tiers.

3. The method of claim 2 wherein each storage tier, of the plurality of storage tiers, corresponds to a different storage medium.

4. The method of claim 3 wherein the determining is further based on one or more costs of moving the one more particular data blocks to a storage medium corresponding to the particular storage tier.

5. The method of claim 2 wherein each storage tier, of the plurality of storage tiers, corresponds to a different compression level.

6. The method of claim 5 wherein the determining is further based on one or more costs of changing a current compression level of the one or more particular data blocks to a compression level corresponding to the particular storage tier.

7. The method of claim 1 wherein determining that the activity-level condition is satisfied is further based on access statistics tracking access to the one or more database objects.

8. The method of claim 7 wherein the access statistics include one or more of: a number of data manipulation language (DML) statements, a number of row accesses, a number of table scans, or a number of index lookups.

9. The method of claim 1 wherein the statistics are derived based, at least in part, on a block-level heatmap.

10. The method of claim 1 wherein determining that the activity-level condition is satisfied is further based on a segment-level heatmap.

11. One or more non-transitory computer-readable media storing one or more sequences of instructions that, when executed by one or more processors, cause performing of: a database management system receiving a structured query language (SQL) statement that comprises clauses specifying: one or more database objects defined in a database dictionary of a database managed by the database management system, an activity-level condition based on one or both of read access or write access to the one or more database objects, and an archiving action; in response to receiving the statement, storing policy data in association with the one or more database objects, the policy data specifying the activity-level condition and the archiving action; wherein the one or more database objects are stored in a plurality of data blocks; the database management system determining, based at least on statistics tracking access to the plurality of data blocks, that the activity-level condition is satisfied for a particular database object of the one or more database objects; in response to determining that the activity-level condition is satisfied, the database management system performing the archiving action on one or more particular data blocks that store the particular database object.

12. The one or more non-transitory computer-readable media of claim 11 wherein the database management system comprises a plurality of storage tiers, each storage tier of the plurality of storage tiers being associated with a different set of performance characteristics, and wherein the archiving action comprises moving the one or more particular data blocks to a particular storage tier of the plurality of storage tiers.

13. The one or more non-transitory computer-readable media of claim 12 wherein each storage tier, of the plurality of storage tiers, corresponds to a different storage medium.

14. The one or more non-transitory computer-readable media of claim 13 wherein the determining is further based on one or more costs of moving the one more particular data blocks to a storage medium corresponding to the particular storage tier.

15. The one or more non-transitory computer-readable media of claim 12 wherein each storage tier, of the plurality of storage tiers, corresponds to a different compression level.

16. The one or more non-transitory computer-readable media of claim 15 wherein the determining is further based on one or more costs of changing a current compression level of the one or more particular data blocks to a compression level corresponding to the particular storage tier.

17. The one or more non-transitory computer-readable media of claim 11 wherein determining that the activity-level condition is satisfied is further based on access statistics tracking access to the one or more database objects.

18. The one or more non-transitory computer-readable media of claim 17 wherein the access statistics include one or more of: a number of data manipulation language (DML) statements, a number of row accesses, a number of table scans, or a number of index lookups.

19. The one or more non-transitory computer-readable media of claim 11 wherein the statistics are derived based, at least in part, on a block-level heatmap.

20. The one or more non-transitory computer-readable media of claim 11 wherein determining that the activity-level condition is satisfied is further based on a segment-level heatmap.