Database System for Integrating Data Items from Multiple Sources
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems face challenges in efficiently matching and integrating data items from multiple sources, especially when relationships between data items are not explicitly known, and in preserving user access control to ensure data privacy and security.
Innovation Solution
A database system that automatically determines relationships between data items from multiple sources in real-time using search rules, integrates them efficiently, and uses associations to store and manage access, allowing for secure and privacy-controlled access based on user dependencies.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If data items from multiple databases are integrated and matched automatically, then productivity and efficiency are improved, but device complexity and algorithm complexity increase
Solution Approach 1:
The system segments the data integration process into distinct modules: data collection from multiple sources, relationship determination using search rules, matching algorithms, and result integration. Each module handles a specific aspect of the complex task, making the overall system more manageable and maintainable while achieving high productivity
Solution Approach 2:
The patent introduces intermediary components such as search rules and matching algorithms that act as mediators between different data sources. These intermediaries facilitate the automatic determination of relationships without requiring direct complex interactions between all data elements, thereby reducing system complexity while maintaining integration efficiency
2Loss of time
If relationships between data items are determined automatically in real-time, then loss of time is reduced, but use of energy and computational resources increase
Solution Approach 1:
The system performs preliminary actions by pre-defining search rules and matching criteria before real-time data integration. These pre-established rules enable the system to quickly evaluate relationships without performing complex computations from scratch, reducing both time and energy consumption during actual data processing
Solution Approach 2:
The patent utilizes parameter changes in the matching process, where the system adjusts matching thresholds and search parameters based on data characteristics. This allows the system to optimize computational energy consumption while maintaining real-time relationship determination by adapting the complexity of processing to the specific data context
3Reliability
If user access control is implemented to secure data privacy, then reliability and security are improved, but ease of operation decreases
Solution Approach 1:
The system implements self-service access control where users can manage their own data access permissions and view which data items they have contributed. This automated self-management approach maintains strong security controls while reducing the operational burden on administrators, as the system automatically handles access requests and permissions based on data ownership and relationships
Data Source
AI summary
Embodiments of the present disclosure relate to a database system for collecting and integrating electronic data items from multiple data sources. Embodiments of the present disclosure also relate to a database system for determining the relationships between related data items from multiple data sources, so that the related data items may be integrated in a way that protects the privacy of those data items. The system may, for example, identify related data items by matching data items between the multiple data sources according to a pre-defined matching process. The related data items may be selectively integrated and stored across one or more databases. The relationship between the related data items may be preserved by generating associations between the related data items and storing those associations with those data items. This allows related data items to be easily located through the associations, which essentially allows for the grouping of data items to be performed across multiple databases. The associations may also be used to restrict user access to data items that are relevant to the user, which can be used to prevent unauthorized access to certain data items and secures their privacy.