Regional Job Status Replication for Parallel Cloud Workflows

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional relational database management systems (RDBMS) are limited to single-region deployments and require extensive reconfigurations for multi-regional configurations, necessitating adaptations for non-sequential Globally Unique Identifiers (GUIDs) and database referential integrity to support multi-regional multi-master datastores.

Innovation Solution

Implementing a system that executes jobs in parallel across regional cloud-based servers, while locally monitoring the status of parallel jobs using respective local instances of a status database, which replicates modifications across regional instances to synchronize job statuses, enabling parallel execution across multiple regions without relying on external data stores prone to communication and uptime interruptions.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If conventional RDBMS are used for single-region deployment, then system simplicity is maintained, but multi-regional capability is lost

Engineering Contradiction:

Improvemulti-regional capabilityVSAvoidsystem configuration complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the centralized database system into multiple regional database instances, each capable of independent operation. Each region maintains its own database instance with local GUID generation and referential integrity enforcement, eliminating the need for extensive reconfiguration while enabling multi-regional deployment.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent implements local quality by allowing each regional database instance to independently generate GUIDs and enforce referential integrity rules locally. This local autonomy enables each region to operate independently while maintaining overall system consistency, resolving the contradiction between multi-regional capability and system complexity.

Inventive Principle:

Principle #3Local quality

2Productivity

If jobs are executed in parallel across multiple regions, then processing efficiency is improved, but coordination complexity increases

Engineering Contradiction:

Improveprocessing efficiencyVSAvoidjob coordination complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent applies preliminary action by pre-configuring each regional database instance with the necessary GUID generation capabilities and referential integrity enforcement mechanisms before parallel job execution begins. This preliminary setup eliminates the need for complex real-time coordination during parallel processing, as each region is self-sufficient.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

Each regional database instance serves itself by independently generating GUIDs and enforcing referential integrity without requiring external coordination. This self-service capability enables parallel job execution across multiple regions while minimizing coordination complexity, as each region operates autonomously.

Inventive Principle:

Principle #25Self-service

3Reliability

If external data stores are used for job status monitoring, then centralized control is achieved, but communication interruptions may occur

Engineering Contradiction:

Improvejob status monitoring reliabilityVSAvoidcommunication interruptions

Core Design Contradiction:

ReliabilityVSObject-affected harmful factors

Solution Approach 1:

The patent extracts the job status monitoring function from external data stores and embeds it directly within each regional database instance. This extraction eliminates the need for communication with external data stores, thereby removing the source of communication interruptions and improving monitoring reliability.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The regional database instances act as intermediaries that locally monitor and track job statuses without requiring external data stores. This intermediary role eliminates the harmful factor of communication interruptions while maintaining centralized control through the coordination framework.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS20250370988A1Multi-Region Workflow Management

Publication Date: 2025.12.04 CAPITAL ONE SERVICES LLC

AI summary

Techniques for performing parallel processing jobs across regionally-distributed servers may include executing a requested job in parallel across two or more regional cloud-based servers, the status of parallel jobs may be locally monitored using respective local instances of a status-tracking database. The multiple instances may replicate modifications of one instance of the status database to other instances of the status database to synchronize the status of regional jobs. Replicating modifications across the respective regional instances of the status database facilitates the parallel executing of the jobs across regions while reducing or avoiding unrecoverable delays if the tasks/job hangs or otherwise fails.