Metadata Exposure Service for Database Artefact Federation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The increasing complexity of managing metadata across various data systems, particularly in large databases, makes it difficult to replicate or federate data effectively without access to metadata, as manual recreation is time-consuming and error-prone.
Innovation Solution
A metadata exposure service that allows a target system to request and retrieve metadata from a source system using standardized APIs, enabling automatic identification and transfer of metadata extensions for database artefacts, thereby facilitating data replication and federation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If manual recreation of metadata is performed in the target system, then complete metadata can be obtained, but the process becomes extraordinarily time consuming
Solution Approach 1:
The patent implements automated copying of metadata from the source system to the target system through API-based retrieval. Instead of manually recreating metadata, the system automatically copies metadata definitions, extensions, and contextual information from the source database system to the target system, dramatically reducing recreation time while maintaining completeness
Solution Approach 2:
The patent performs preliminary actions by establishing API connections and metadata retrieval mechanisms in advance. The system proactively identifies and retrieves metadata extensions before they are needed for data replication or federation operations, ensuring metadata is ready when required without adding delays to the main workflow
2Loss of information
If manual recreation of metadata is performed, then metadata can be transferred, but the process becomes error-prone
Solution Approach 1:
The automated copying mechanism ensures exact replication of metadata from source to target system through API-based retrieval. The system copies metadata definitions, extensions, and contextual information with high fidelity, eliminating manual transcription errors and ensuring accurate representation of source system metadata in the target system
Solution Approach 2:
The patent implements feedback mechanisms through standardized APIs that allow the target system to verify metadata retrieval success and completeness. The API responses provide confirmation that metadata has been accurately transferred, enabling error detection and correction while ensuring metadata integrity throughout the transfer process
3Ease of operation
If all metadata is manually recreated in the target system, then complete context is available, but the complexity of the process increases
Solution Approach 1:
The patent introduces an intermediary layer in the form of standardized APIs that mediate between the source system's metadata repository and the target system. This intermediary simplifies the complex task of metadata retrieval by providing a standardized interface, automatically handling the complexity of metadata identification, retrieval, and transfer while making the process accessible and manageable for users
Data Source
AI summary
Techniques and solutions are described for storing and processing metadata. A target system sends a request to a source system to identify extensions to one or more specified database artefacts. The source system identifies one or more software objects that include metadata extensions to the one or more specified database artefacts and sends at least a portion of such metadata elements to the target system in response to the request. The source system can expose APIs, such as APIs in a standard format, to the target system to assist in requesting and retrieving metadata from the source system.