Automated Purge-Request Module for Financial Database Data Consistency

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current methods for purging client records in Financial Institute databases after exceeding the retention period lead to data inconsistency due to missed dependent data and lack of validation for active transactions or relationships, resulting in manual errors and inaccurate detection.

Innovation Solution

A computerized system with a purge-request module that automates data loading and validation by retrieving references and links, presenting conditions for user selection via a GUI, and executing batch processes for purging, while generating statistical reports in tabular or pie-chart formats to ensure accurate data removal.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If manual data loading is used to populate source database tables for purging, then flexibility in selecting purging conditions is improved, but data inconsistency increases due to missed dependent data and manual errors

Engineering Contradiction:

Improveflexibility in selecting purging conditionsVSAvoiddata consistency

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system performs self-service by automatically populating source database tables with dependent data from the customer information database without requiring manual intervention. The automated data loading process retrieves customer details, transactions, accounts, and alerts, ensuring complete and consistent data population while maintaining the flexibility to select different purging conditions through the GUI.

Inventive Principle:

Principle #25Self-service

2Productivity

If automated data loading is implemented to reduce manual efforts, then productivity is improved, but device complexity increases due to additional validation modules and processes

Engineering Contradiction:

Improvepurging process efficiencyVSAvoidsystem structure

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The system merges multiple functions into a unified automated purging module that combines data loading, validation, and purging operations. The module integrates population of multiple source database tables (customer details, transactions, accounts, alerts) and executes validation of purging conditions within a single cohesive process, improving productivity while managing complexity through functional integration.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The system performs preliminary actions by automatically populating all necessary source database tables with dependent data before the purging operation begins. This pre-population step ensures that all validation checks can be performed on complete data sets, enabling accurate determination of whether clients meet purging conditions without requiring manual data gathering.

Inventive Principle:

Principle #10Preliminary action

3Reliability

If validation of purging conditions is performed, then data consistency is improved, but processing time increases due to additional checking steps

Engineering Contradiction:

Improvedata consistencyVSAvoidpurging processing time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system maintains continuity of useful action by performing validation checks in an integrated, continuous flow within the automated purging process. Rather than separate manual validation steps that would add time, the validation of purging conditions is embedded within the automated data loading and processing sequence, allowing the system to continuously move through data retrieval, validation, and purging operations without interruption.

Inventive Principle:

Principle #20Continuity of useful action

4Measurement precision

If manual lookup of client relations is performed, then accuracy in detecting active transactions is improved, but loss of time increases due to extensive manual searching

Engineering Contradiction:

Improvedetection accuracyVSAvoidsearch time

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The system replaces the manual mechanical process of looking up client relations with an automated electronic data retrieval mechanism. The automated purging module queries the customer information database and source database tables programmatically to retrieve all dependent data (customer details, transactions, accounts, alerts) and validate purging conditions, eliminating manual searching while maintaining complete and accurate detection of active transactions and relationships.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS20230359597A1System and method for reducing data inconsistency after purging client records, in financial institute (FI) databases, when exceeding retention period

Publication Date: 2023.11.09 ACTIMIZE LIMITED

AI summary

A computerized-method for reducing data inconsistency after purging client records, in Financial Institute (FI) databases, when exceeding retention period, is provided herein. The computerized-method includes operating a purge-request module. The purge-request module includes a. receiving a file including one or more customer identifications (ID); b. for each client in the received file: (i) retrieving references and links from the one or more customer-information databases to populate one or more tables with customer details based on the customer IDs; (ii) presenting a list of one or more conditions via a Graphical User Interface (GUI) of the application to enable a user to select one or more conditions for validation before purging; (iii) checking each selected condition; (iv) when the selected conditions for validation before purging are met marking the client for batch process purging; and c. purging all marked clients via a batch process.