Source: Avendata |
Because cold data is stored in the SAP HANA Database and is not available through SQL in the same table as the hot data, data ageing is very different from data archiving (yet in another partition). However, read-only data that is archived is printed to an archive file before being removed from the database.
Additional access pathways are needed, which are address information or archive indexes that are intended for reading. In order to fully cover the whole life cycle up until the point at which all information is deleted, archiving serves as the basis for ILM Aging objectives and the main memory footprint reduction.
In order to free up additional working memory, Data Aging offers the suggestion of moving the less useful data to a different operational location in a database.
SAP applications that are less important tend to be those that deal with objects for data aging—moving data from the current area to the historical area.
When data is accessed, the visibility is changed. This also implies that queries of vast volumes of data in the present region will perform more quickly. Applying data ageing to your data is done in order to meet certain database and application needs.
Data archiving is a technique used to remove data from a database and then store it securely and reliably outside the system.
The archived data is kept in a file system and may then be transferred to another that is unquestionably more cost-effective and has a long-term storage system.
No comments:
Post a Comment