XML Generation via Database Wildcarding and Blockchain Validation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Generating correctly formatted XML from a subset of data in a database is error-prone and time-consuming, especially when dealing with complex data structures, and there is a lack of verification that the generated XML contains all necessary information for its intended purpose.

Innovation Solution

A method and system for dynamically generating correctly formatted XML files using an XML generator program that collects and modifies data from existing sources, employs wildcarding to optimize file size and structure, and stores the derivation process in a blockchain for immutable validation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If manual XML generation is performed from database data, then flexibility in handling complex data structures is improved, but error rate increases and time consumption increases

Engineering Contradiction:
Improveflexibility in handling complex data structuresVSAvoiderror rate
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The system enables self-service automated XML generation by allowing users to input a simple subset identifier, and the system automatically collects data, applies wildcarding transformations, generates XML files, and creates immutable records without manual intervention in the complex transformation processes

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system changes the parameter of data representation by transforming concrete database records into wildcarded patterns (e.g., changing specific part numbers to wildcard representations), which reduces data complexity while maintaining structural accuracy and enabling automated processing

Inventive Principle:
Principle #35Parameter changes

2Adaptability or versatility

If manual XML generation is performed from database data, then flexibility in handling complex data structures is improved, but time consumption increases

Engineering Contradiction:
Improveflexibility in handling complex data structuresVSAvoidtime consumption
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The system performs preliminary actions by pre-defining wildcarding rules and data collection parameters in advance, so that when XML generation is needed, the system can quickly retrieve and transform data using pre-configured templates and rules

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The automated system performs all transformation and generation tasks without human intervention, reducing time consumption from hours or days of manual work to seconds of automated processing

Inventive Principle:
Principle #25Self-service

3Productivity

If automated XML generation is implemented, then productivity is improved, but verification capability deteriorates

Engineering Contradiction:
ImproveXML generation speedVSAvoidverification capability
Core Design Contradiction:
ProductivityVSDifficulty of detecting and measuring

Solution Approach 1:

The system implements feedback by creating immutable records that store the complete derivation chain from source data to generated XML, allowing verification of whether the XML contains all necessary information by tracing back to the original database subset through the blockchain record

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The immutable record acts as an intermediary between the automated generation process and verification needs, providing a trusted intermediary layer that proves the XML was correctly derived from the source data without requiring manual verification

Inventive Principle:
Principle #24Intermediary (Mediator)

4Quantity of substance

If wildcarding is applied to optimize file size, then XML file size is reduced, but data specificity is lost

Engineering Contradiction:
ImproveXML file sizeVSAvoiddata specificity
Core Design Contradiction:
Quantity of substanceVSLoss of information

Solution Approach 1:

The system changes the parameter of data representation by transforming concrete database records into wildcarded patterns (e.g., changing specific part numbers to wildcard representations), which reduces data complexity while maintaining structural accuracy and enabling automated processing

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS11755647B2XML production through database mining and blockchain
Publication Date: 2023.09.12 BETA BIONICS INC
  • US11755647B2 patent drawing
  • US11755647B2 patent drawing
  • US11755647B2 patent drawing

AI summary

In an approach for dynamically generating correctly formatted Extensible Markup Language (XML) based off of a subset of data from a database, a processor receives an input pointing to a subset of data. A processor collects the subset of data from existing sources. A processor modifies the subset of data using wildcarding to generate a modified subset of data. A processor generates a set of XML files from the modified subset of data. A processor creates an immutable record of the subset of data, the modified subset of data, and the set of XML files. A processor outputs the set of XML files.