On which Technologies is Data Aging based in SAP HANA?

Thursday, July 12th, 2018

Data Aging in SAP HANA uses:

  • Time selection partitioning: The column, _DATAAGING, is used to split tables into one hotand some cold partitions
  • No uniqueness checks: The uniqueness checks on the cold data is switched off (the application will enforce uniqueness) to improve performance
  • Page-loadable columns/Paged attributes: The memory management of an attribute is based on pages so that partitions can partially be loaded into memory (used to store data in the cold partitions)