Overview

Archiving involves moving older, less frequently accessed data from the primary database to a more cost-effective storage solution while ensuring it remains accessible when needed.

Data Lifecycle Management (DLM) is an archival solution for Temenos Transact. With DLM, a second database is incorporated into the database layer of the Transact deployment architecture to host the archived data.

In this setup, the existing Transact database is referred to as LIVEDB, while the second archive database is referred to as DLMDB. The LIVEDB tables that are identified for archiving have their associated one-to-one tables in the DLMDB, sharing the same name with a suffix - #RO.

• The data eligible for archiving is selected based on business and retention rules and then transferred from the archive candidate tables in LIVEDB to their associated RO tables in DLMDB.
• The archived data in the #RO table remains seamlessly accessible to the application, which functions without the awareness of whether the data was fetched from the LIVEDB or DLMDB.
• When the data in the #RO table is no longer required by the business, that is, when its age exceeds the retention period, it is moved to another set of tables suffixed with #ARC before being permanently purged.