Jobs Synchronize Framework for Database Archiving Latency

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Database systems with proprietary components are incompatible, leading to inefficiencies and time delays when archiving output data, as existing solutions require brute force methods that detract from the efficiency advantages of other systems and are not easily adjustable to changing circumstances.

Innovation Solution

Implementing a Jobs Synchronize Framework using shell scripts to synchronize the migration of output data between incompatible database systems, allowing for timely and cost-effective archiving by executing shell scripts that monitor and trigger archival tasks based on the status of operational tasks, thereby reducing de-synchronization and latency.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If brute force solutions are used to store data outputs from the first database system in the second database system, then data archiving is eventually achieved, but significant time delay occurs and efficiency advantages are lost

Engineering Contradiction:

Improvedata archiving completionVSAvoidtime delay

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent implements a feedback mechanism where the job synchronization framework continuously monitors the status of operational tasks in the first database system and automatically triggers archival tasks in the second database system when data is ready, eliminating the time delay associated with brute force periodic checking while ensuring reliable data archiving

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The framework enables the first database system to self-synchronize with the second database system by automatically detecting when operational tasks complete and triggering corresponding archival tasks without external intervention, reducing time delay while maintaining archiving reliability

Inventive Principle:

Principle #25Self-service

2Reliability

If brute force solutions are used to synchronize data between incompatible database systems, then data migration is achieved, but efficiency advantages of the second database system are lost

Engineering Contradiction:

Improvedata migration completionVSAvoidsystem efficiency

Core Design Contradiction:

ReliabilityVSProductivity

Solution Approach 1:

The patent introduces a job synchronization framework as an intermediary layer between the two incompatible database systems that translates operational task completions into archival task triggers, enabling efficient data migration while preserving the efficiency advantages of the second database system by avoiding brute force synchronization methods

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If proprietary components are used in the first database system for efficient data analysis, then data processing efficiency is improved, but compatibility with the second database system deteriorates

Engineering Contradiction:

Improvedata processing efficiencyVSAvoidsystem compatibility

Core Design Contradiction:

ProductivityVSAdaptability or versatility

Solution Approach 1:

The job synchronization framework serves as a mediator that bridges the compatibility gap between the first database system with proprietary components and the second database system, allowing the proprietary components to maintain their efficiency advantages while enabling seamless integration and data archiving through standardized interfaces

Inventive Principle:

Principle #24Intermediary (Mediator)

4Reliability

If prior art solutions are used for data archiving, then data storage is achieved, but adaptability to changing circumstances is reduced

Engineering Contradiction:

Improvedata storage completionVSAvoidadjustability

Core Design Contradiction:

ReliabilityVSAdaptability or versatility

Solution Approach 1:

The patent implements a dynamic job synchronization framework that can adapt to changing circumstances by monitoring operational task statuses in real-time and automatically adjusting archival task triggers, maintaining reliable data storage while providing flexibility to respond to changing business goals and data generation patterns

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS11372675B2Jobs synchronize framework

Publication Date: 2022.06.28 BANK OF AMERICA CORP

AI summary

Current systems for synchronizing multiple database systems suffer from technical drawbacks. For example, archive jobs run on a second database system are typically started independently of operational jobs that are run on a first database system and generate the output data that needs to be archived. The lack of synchronization between first and second database systems delays access to the output data from within the second database system. Apparatus and methods described herein synchronize migration of output data generated by a first database system into a second database system, despite incompatibility between the first and second database systems. Apparatus and methods may synchronize the second database system such that it archives output data generated by the first database system within a target time of successful generation of output data by the first database system.