Database Merging via Metadata Identifiers
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Merging data from multiple databases is challenging due to the inability to distinguish between different types of data with the same name identifier, leading to incorrect combination of data fields.
Innovation Solution
The method involves assigning metadata identifiers to data sets in one database and comparing them with identifiers in another database to ensure accurate matching and combination of data types, allowing for the addition or merging of data based on identical metadata identifiers.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If data fields with the same name identifier from separate databases are combined into a single data field, then the merging process is simplified, but different types of data may be incorrectly combined
Solution Approach 1:
The patent introduces a metadata identifier as an intermediary element that mediates between the name identifier and the actual data type. This metadata identifier serves as a bridge that provides additional classification information, allowing the system to distinguish between different types of data even when they share the same name identifier, thus preventing incorrect data combination while maintaining the simplicity of the merging process
Solution Approach 2:
The patent adds another dimension of identification by introducing metadata identifiers that exist in a separate dimension from the name identifiers. This dimensional addition allows the system to differentiate data types without complicating the original name identifier structure, enabling accurate data type discrimination while preserving the ease of merging operations
2Measurement precision
If metadata identifiers are assigned to all data sets to enable precise matching, then data type accuracy is improved, but the complexity of the database structure increases
Solution Approach 1:
The metadata identifier structure is designed to be universal and multi-functional, serving both as a data type classifier and as a matching key for data merging operations. This universal structure allows the same metadata identifier to perform multiple functions (identification, classification, and matching) without requiring separate mechanisms, thereby improving data matching precision while minimizing the increase in database structure complexity
Data Source
AI summary
A method of merging data from one database into another database uses metadata identifiers to indicate the type of data. One of the databases can be stored on a medical device, and the other of the databases can be stored on a computer. When transferring data from the first database to the second database, the metadata identifiers are used to identify and merge common data types.