Uniform Identifier Generation for Cross-Database Data Linking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods fail to effectively link data across different database systems due to the lack of proper context, requiring significant manual effort and domain coordination, and existing domain classification does not fully capture the context necessary for meaningful data reuse.
Innovation Solution
A computer-implemented method and system that selects a domain based on user input, generates uniform identifiers for data elements, and correlates these identifiers to link data across databases, utilizing semantic web technology to capture schema-related information and provide context.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If data dictionaries and ontologies are used to provide context for linking data across databases, then data context and meaning are improved, but the time and manual effort required to develop and maintain definitions increases significantly
Solution Approach 1:
The system performs self-service by automatically generating uniform identifiers and linking data elements across databases without requiring manual definition development. The contextual information is derived automatically from the data itself and its relationships, eliminating the need for manual ontology creation and maintenance while preserving data context and meaning.
Solution Approach 2:
The patent replaces the manual mechanical process of creating and maintaining data dictionaries and ontologies with an automated computational system. The system uses algorithms to automatically generate uniform identifiers, correlate data elements, and establish contextual relationships, substituting human effort with automated processing while maintaining data context.
2Adaptability or versatility
If domain classification is used to define context for data elements, then data organization is improved, but the context information is incomplete and does not fully capture the purpose of data in different applications
Solution Approach 1:
The patent adds another dimension to domain classification by introducing uniform identifiers that incorporate contextual information about data purpose and usage across different applications. Instead of relying solely on domain categories, the system enriches the classification with additional contextual dimensions derived from data relationships and usage patterns, providing more complete context while maintaining organization.
3Stability of the object's composition
If manual coordination between consultants is used to ensure consistent data element definitions, then data consistency is improved, but the complexity and effort of coordination increases
Solution Approach 1:
The system implements a universal mechanism for ensuring data consistency across databases through automatically generated uniform identifiers. These identifiers serve multiple functions: they uniquely identify data elements, establish relationships across databases, and ensure consistent interpretation without requiring manual coordination. This universal approach replaces complex multi-party coordination with a standardized automated process.
Data Source
AI summary
According to an example of the present disclosure, a system and a computer-implemented method of linking data in one or more databases are disclosed. The method includes selecting at least one domain based on a user input, where the domain is indicative of a class of data elements. Further, the method includes generating a plurality of uniform identifiers, based on the at least one domain and the one or more databases, where each of the plurality of uniform identifiers corresponds to an instance of the at least one domain. The method further includes correlating the plurality of uniform identifiers to link the instances corresponding to the plurality of uniform identifiers for linking the data stored in one or more databases.