Colvir Online Automated Archiving automatically transfers inactive data from the primary database to an archive database. Archiving runs in the background without requiring core banking system downtime, helping control production database growth, maintain system performance, and reduce infrastructure costs.
Online Automated Archiving
Product advantages
Uninterrupted system operation
Data is transferred continuously in the background. Users can continue working with the system while archiving is in progress.
Automation instead of manual data pruning
The selection, tagging, copying, integrity verification, and deletion of inactive and obsolete data are automated. Reporting and process monitoring are also provided.
Automation instead of manual data pruning
The selection, tagging, copying, integrity verification, and deletion of inactive and obsolete data are automated. Reporting and process monitoring are also provided.
Database growth control
Database growth is fully eliminated for tables configured for online archiving.*
*Provided that the volume of archived data is configured to match the daily volume of newly generated data.
Functional Online Automated Archiving
- Automatic background transfer of inactive data from the primary database to an archive database without interrupting system operation.
- Configuration of archived data selection criteria by object type, period, and other parameters.
- Automation of the complete archiving lifecycle: selecting inactive and obsolete data, tagging obsolete records, copying them to the archive database, verifying the integrity of transferred data, and deleting it from the primary database.
- Archiving process management, including start, pause, monitoring, and stop functions, as well as stage-by-stage execution tracking.
- Configuration of online archiving parameters, including master table keys and the number of parallel processing threads.
- Process monitoring through a dashboard displaying statistics on processed data volumes and statuses, with error tracking during archiving.
- Logging of the archiving process and retention of the history of changes to archiving conditions and user actions.
- Generation of archiving reports containing information about applied filters and the number of archived and deleted records.
- Ability to restore archived records and access the archive database through the Colvir application.
- Time-based partitioning of archived data to simplify its storage, transfer, and deletion.
- Support for multi-user operation in the Online Archiving administration application.
implemented projects
What has been done
- Colvir Online Archiving was implemented with “quiet” background archiving and configurable data cleansing depth.
- The solution was seamlessly integrated with the Colvir platform and adapted to the bank’s data structure.
- Extensive data validation checks are performed before the transfer to the archive begins.
- A key benefit was the ability to reduce the size of the primary transactional database without system downtime.
What benefits have accrued to the customer
- More than 40 person-days saved by automating database pruning.
- Database growth was reduced to a minimum.
- Continuous system availability during data transfer.
Outcome
-
Performance
Eliminating production database growth helps maintain system performance as the business expands. Obsolete data is transferred regularly to the archive database, freeing up resources in the primary database. -
Continuity
Archiving runs in the background without interrupting the core banking system. Users continue working with the system during data transfer, reducing archiving-related system downtime to zero hours. -
Optimization
Archiving automation reduces manual operations and the cost of maintaining a growing database. Freed storage space can be reused, backup copies do not require additional storage capacity, and less powerful infrastructure can be used for the archive database.
Product news
Top executives of Kazakhstan bank IT departments have paid a visit to the event organized by Colvir Software Solutions – the largest fintech solution developer in the region
The Colvir Online Archiving solution enables “quiet” archiving with a configurable data cleansing depth
Advantages Colvir Software Solutions
Reliability
100% successful Projects
Simplicity
Product modules are independent of the kernel
Spot-on Relevance
International practice focused on banking products and services
Great Potential
We invest 100% of our earnings in further system development
Popularity
Localized throughout CIS
User-Friendliness
Flexible and customer-oriented
Any questions left?
Submit your request right now — our consultant will get in touch with you soonest, and will tell you about Colvir products in more detail