Author – Akash Pramanik
Abstract Topic
– Simplifying
data life cycle using Automatic Data Optimization (Heat Map)
An in memory heat map tracks access to segments and blocks
ü
Data is periodically written to disk
ü
Information is accessible by views or stored
procedures
Database Administrators can attach policies to tables to
compress or tier data based on access to data
ü
Tables or Partitions can be moved between
compression levels whilst data is still being accessed.
Let us assume Database Administrators apply policies like:
1. Compress
Partitions with row compression if they haven’t been modified in 30 days.
2. Compress
Partitions with columnar compression if they haven’t been modified in 180 days.
A heat map tracks the activity of segments and blocks.
Reduce storage footprint by applying policies to tables.
Finally providing a to the storage requirements.
Benefits – Can solve the memory problem to a large extent.
Save dollars by reducing server space requirement. Shall soon replace third
party archiving solutions.
