Resource Compatibility Engine for Schema Import Validation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current methods for importing and updating schemas and definitions with external resource links are cumbersome, inefficient, and prone to causing project failures due to broken links and inconsistencies, leading to potential database corruption.

Innovation Solution

A resource compatibility engine is implemented to verify and ensure compatibility of resource files by analyzing dependencies, validating references, and performing multilevel compatibility verification, preventing catalog corruption and providing feedback on import and update operations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If manual download and bundling of schemas and dependencies is performed, then external schemas can be introduced into the application, but the import process becomes extremely cumbersome and inefficient

Engineering Contradiction:
Improveability to introduce external schemasVSAvoidimport process complexity
Core Design Contradiction:
Adaptability or versatilityVSEase of operation

Solution Approach 1:

The system performs automatic download, validation, and bundling of schemas and dependencies without requiring manual user intervention. The import engine automatically resolves external references, downloads required resources, validates compatibility, and bundles everything into a self-contained project package.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary validation of external resource links, schema compatibility, and dependency resolution before the actual import process. This includes checking URL accessibility, verifying schema syntax, and ensuring type compatibility in advance, so that the actual import can proceed smoothly without manual intervention.

Inventive Principle:
Principle #10Preliminary action

2Adaptability or versatility

If external reference URLs are used in schemas, then remote resources can be accessed, but broken resource links cause project failures

Engineering Contradiction:
Improveability to access remote resourcesVSAvoidproject stability
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The system performs preliminary validation of external resource links by checking URL accessibility, downloading schemas to verify they can be parsed successfully, and ensuring all dependencies are resolvable before committing the import. This prevents broken links from causing project failures later.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system provides feedback about the status of external resource links, including warnings about potentially broken links, errors in schema parsing, or compatibility issues. This allows users to address problems before they cause project failures.

Inventive Principle:
Principle #23Feedback

3Productivity

If new resources or existing resources are updated without compatibility verification, then the import process is faster, but inconsistencies in project operation occur

Engineering Contradiction:
Improveimport speedVSAvoidproject consistency
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The system performs preliminary compatibility verification by comparing the types and structures of new or updated resources against existing project resources. This includes checking schema syntax validity, type compatibility, and dependency consistency before allowing the import or update to proceed, thus preventing operational inconsistencies.

Inventive Principle:
Principle #10Preliminary action

4Ease of operation

If existing prior art methods import objects of the same type, then the import process is simplified, but database and catalog corruption occurs

Engineering Contradiction:
Improveimport process simplicityVSAvoiddata integrity
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The system performs preliminary checks to identify whether imported objects have the same type as existing objects in the database or catalog. Before completing the import, it alerts the user to potential conflicts and provides options to resolve them, such as renaming, skipping, or overwriting with compatibility checks, thus preventing data corruption while maintaining simple operation.

Inventive Principle:
Principle #10Preliminary action

5Reliability

If manual resolution of mapping conflicts is required, then developers can resolve issues, but the process becomes time consuming and inefficient

Engineering Contradiction:
Improveconflict resolution capabilityVSAvoidresolution time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system automatically resolves many mapping conflicts by analyzing schema structures, inferring compatible mappings, and applying resolution rules without requiring manual developer intervention. Only complex or ambiguous conflicts require user input, significantly reducing resolution time while maintaining reliable conflict handling.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system provides detailed feedback about mapping conflicts, including the nature of the conflict, suggested resolutions, and the impact of each option. This enables developers to quickly understand and resolve issues when manual intervention is necessary, reducing overall resolution time.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS10540397B2Algorithm to check compatibility of business object types to prevent business catalog corruption on resource update
Publication Date: 2020.01.21 ORACLE INT CORP
  • US10540397B2 patent drawing
  • US10540397B2 patent drawing
  • US10540397B2 patent drawing

AI summary

Implementations include a resource compatibility engine and method configured to verify resource compatibility when importing schemas and formats such as XSD and WSDL into a database table such as a business catalog. The resource compatibility engine may be configured to prevent possible catalog corruption from importing file types that do not match. The resource compatibility engine may also be employed to identify which are the resource file types that need to be overwritten in case of an update and provides useful feedback in case the import is not successful.