My first Abstract accepted in IBM event.

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.