Query Result Conversion System Schema Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Interoperability and compatibility issues arise due to differences in data formats and metadata schemas used by various computing entities, leading to challenges in retrieving and processing query results from multiple query services.
Innovation Solution
A system that receives query results from multiple query services, maps elements and identifiers between different schemas, and converts the results to a common format usable by the issuing computing system, facilitating the use of multiple query services.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If query results are retrieved from multiple query services with different data formats and metadata schemas, then the ability to access diverse query services is improved, but the complexity of processing and integrating these results increases
Solution Approach 1:
The patent introduces an intermediary system that receives query results from multiple query services with different formats and schemas, then automatically transforms and standardizes these results into a unified format before presenting them to the user. This intermediary layer handles the complexity of format conversion, schema mapping, and data normalization, allowing the user interface to remain simple while supporting diverse query services.
2Ease of operation
If manual conversion of query results between different formats is performed, then format compatibility is achieved, but time consumption and manual intervention increase
Solution Approach 1:
The system implements automated self-service functionality that performs format conversion and schema mapping without requiring manual intervention. The intermediary system automatically detects the source format of query results, applies appropriate transformation rules, and outputs standardized results, eliminating the need for manual conversion operations and significantly reducing time consumption.
Solution Approach 2:
The patent establishes predefined mapping configurations and transformation templates that are prepared in advance for common query service formats. When query results are received, the system matches them against these pre-configured templates and applies the corresponding transformations automatically, eliminating the need for real-time manual format conversion and speeding up the integration process.
3Ease of operation
If standardized data formats are used across all query services, then interoperability is improved, but the flexibility to accommodate different service formats decreases
Solution Approach 1:
The patent segments the query result processing into distinct layers: a standardized output layer that ensures interoperability, and a flexible transformation layer that adapts to different source formats. The intermediary system maintains a mapping configuration that separates the standardized schema from the variable source schemas, allowing each query service to maintain its own format while the system presents a unified interface to users.
Data Source
AI summary
A system can receive an identifier for a query used by a query service of one or more query services and an identifier for the query used by an issuing computer system. The query service and the computer system that issued the query can use different schemas for query results. A mapping can be established that maps elements of one schema to the other schema. This mapping, and a mapping of the query identifiers, can be used to convert query results to a format useable by the computing system that issued the query. By converting query results from multiple query services, which may have different formats, to a common format of the issuing computing system, the use of multiple query services is facilitated.