Path DFA for Managing Data Schema Differences

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Managing data schema differences across multiple versions in information processing systems is challenging due to the lack of linear version history and concurrent schema version combinations, which can lead to compatibility issues and inefficient data migration.

Innovation Solution

The method involves combining deterministic finite automata (DFAs) associated with different schema versions to create a new path DFA that can handle multiple schema versions, allowing for the tracking of metadata and managing schema differences without migrating data to a single version, using algorithms to compute new vectors of states and merge metadata while ensuring compatibility.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If data schema is modified to add new features, then functionality and adaptability are improved, but compatibility with existing data and migration complexity increase

Engineering Contradiction:
Improveschema functionalityVSAvoidmigration complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The schema is segmented into different versions (e.g., schema v1, schema v2) with distinct feature sets. Each version is independently managed and validated, allowing selective migration of only the necessary portions rather than requiring complete schema replacement. This segmentation reduces migration complexity by enabling incremental updates.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

A path DFA (path deterministic finite automaton) is introduced as an intermediary mechanism that mediates between different schema versions. The path DFA validates and transforms data between schema versions by tracking metadata paths, ensuring compatibility without requiring direct complex migration logic between each version pair.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If multiple schema versions are supported concurrently, then adaptability is improved, but data compatibility and validation complexity increase

Engineering Contradiction:
Improveconcurrent schema version supportVSAvoiddata compatibility
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The path DFA serves multiple functions simultaneously: it validates data against schema constraints, tracks metadata paths across versions, determines applicable schema versions, and guides data transformation. This multi-functionality consolidates what would otherwise be separate complex systems into a single reliable mechanism that handles concurrent schema versions.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system implements feedback mechanisms where the path DFA continuously validates data against the current schema version and provides feedback on compatibility issues. This feedback loop ensures data integrity by immediately identifying and preventing incompatible data transformations, maintaining reliability across concurrent schema versions.

Inventive Principle:
Principle #23Feedback

3Reliability

If schema validation is performed against all version combinations, then data compatibility is improved, but processing time and validation complexity increase

Engineering Contradiction:
Improvedata compatibilityVSAvoidvalidation time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The path DFA is pre-configured with the metadata paths and validation rules for all schema versions before data validation occurs. This preliminary setup allows the system to efficiently validate data against the appropriate schema version without needing to perform complex analysis during validation, significantly reducing validation time while maintaining comprehensive compatibility checking.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The validation process is made dynamic by using the path DFA to adaptively select which schema version(s) to validate against based on the data content and context. Rather than statically checking all version combinations, the system dynamically determines the relevant schema versions, reducing validation time while maintaining reliability.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS11805001B2Managing data schema differences by path deterministic finite automata
Publication Date: 2023.10.31 FORCEPOINT LLC
  • US11805001B2 patent drawing
  • US11805001B2 patent drawing

AI summary

A method for migrating a data schema comprising combining a first deterministic finite automaton with a second deterministic finite automaton to generate a modified deterministic finite automation. Identifying a state of the modified deterministic finite automaton without computed followers. Computing a new vector of original states for each state of the modified deterministic finite automaton corresponding to the identified state.