Data Aging in SAP HANA

Ask Your Question Here

What is Data Aging in SAP S/4HANA?

Data Aging is a suite-tailored data management concept for reducing the SAP HANA memory footprint, based on a Data Aging Framework provided by SAP NetWeaver ABAP.

Data Aging is available for SAP S/4HANA and offers the option of moving large amounts of data within SAP HANA in order to gain more working memory.

Data Aging differentiates between operationally relevant data (Hot/Current), and data that is no longer accessed during normal operation (Cold/Historical).  The data temperature can be used to horizontally partition the tables (taking part in Data Aging) for optimising resource consumption and performance, moving data between the different partitions (i.e. from hot to cold partitions).

Hot data is stored within SAP HANA main memory, cold data stays primarily stored on disk, but remains accessible via SQL upon request.

What is the difference between Archiving and Data Aging in SAP S/4HANA?

In SAP HANA, Data Aging is different than Archiving in the sense that cold data is still kept within the SAP HANA Database and remains accessible via SQL, in the very same table as the hot data (yet in another partition).

Whereas archived data (strictly read-only) is written to an archive file and deleted from the database and needs additional access paths (address information or archive indexes) to be read.

Aging targets the main memory footprint reduction whereas archiving is the basis for ILM, covering the full life cycle up to the destruction of information.

Data Aging offers the option of moving operationally less relevant data within a database so as to gain more working memory.  Using the relevant SAP applications, particularly data aging objects to move data from the current area to the historical area.  The move influences the visibility when data is accessed. This also means that you can perform queries of large amounts of data in a current area in a shorter time.  To be able to apply Data Aging to data, there is a need to fulfill certain requirements regarding the database and the application.

Data Archiving is used to remove data from the database and store it outside in a consistent and secure manner.  The archived data is stored in a file system and from there can be moved to other, more cost-efficient and long-term storage system.

Privacy & Cookie Notice  | © Copyright 2020 Proceed Group | Web design by Union 10 Design