Federated API Gateway for Distributed Mutation Consistency

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current methods for federated API mutation lack mechanisms to ensure consistency across multiple data sources and manage failures effectively, as they do not provide techniques to guarantee that all data source mutations are successful or handle scenarios where some mutations fail.

Innovation Solution

The solution involves annotating data source schemas to advertise capabilities and rollback mechanisms, generating a federated API that aggregates endpoints, and using a gateway to orchestrate transactions and manage rollbacks, ensuring that data sources are rolled back to their previous state in case of errors.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If federated API mutation is performed across multiple data sources, then data consistency and reliability are improved, but system complexity increases due to the need for transaction orchestration and rollback mechanisms

Engineering Contradiction:
Improvedata consistencyVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent introduces a gateway as an intermediary component that orchestrates distributed transactions across multiple data sources. The gateway receives mutation requests, coordinates the transaction protocol (2PC or SAGAS), manages commit/rollback operations, and ensures data consistency without requiring each data source to implement complex transaction logic independently.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments the transaction management functionality by separating concerns between the gateway (which handles transaction coordination) and data sources (which handle data operations). This segmentation allows each component to focus on its specific function, reducing overall system complexity while maintaining reliability through specialized roles.

Inventive Principle:
Principle #1Segmentation

2Reliability

If distributed transaction protocols are implemented across multiple data sources, then mutation reliability is improved, but operation complexity increases due to coordination overhead

Engineering Contradiction:
Improvemutation reliabilityVSAvoidoperation complexity
Core Design Contradiction:
ReliabilityVSEase of operation

Solution Approach 1:

The gateway acts as a mediator that simplifies operation for clients by providing a unified interface for distributed mutations. Clients only need to interact with the gateway, which automatically handles the complex coordination of transaction protocols across multiple data sources, making the system easier to operate despite the underlying complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent merges multiple data source operations into a single federated API endpoint. This allows clients to perform distributed mutations through a single call, combining the complexity of coordinating multiple data sources into one unified operation interface, thereby improving ease of operation.

Inventive Principle:
Principle #5Merging (Combining)

3Reliability

If rollback mechanisms are added to handle mutation failures, then system reliability is improved, but device complexity increases due to additional endpoints and protocols

Engineering Contradiction:
Improvefailure managementVSAvoidendpoint complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The gateway serves as an intermediary that manages rollback mechanisms centrally. Instead of each data source requiring independent rollback capabilities, the gateway coordinates rollbacks by invoking compensating transactions on failed data sources, reducing the complexity burden on individual components while maintaining reliable failure management.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent implements preliminary action by establishing transaction contexts and tracking mutation states before failures occur. The gateway maintains information about which mutations have succeeded and which have failed, enabling efficient rollback coordination without requiring complex real-time decision-making, thus reducing operational complexity.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS12164975B2Federated distributed mutation
Publication Date: 2024.12.10 SALESFORCE INC
  • US12164975B2 patent drawing
  • US12164975B2 patent drawing
  • US12164975B2 patent drawing

AI summary

Methods, systems, and devices for data processing are described. The method may include generating a federated application programming interface (API) from a plurality of data sources. One or more of the plurality of data sources may include an annotated data schema that defines one or more API endpoints for performing a distributed mutation of the plurality of data sources according to a supported distributed transaction protocol. The method may include receiving, via a single call to a single field of the federated API, a request at the federated API to perform a distributed mutation on the plurality of data sources. The method may include orchestrating, via a federation management service and the one or more API endpoints, a plurality of mutation calls to the plurality of data sources according to the distributed transaction protocol.