Database Integration Framework Using Link Data Items
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for integrating information across different databases are limited, as they either focus on data transfer formats or specific tool integration, failing to provide a systematic solution for maintaining data integrity and enabling set operations across multiple data sources.
Innovation Solution
A database system with an extended schema that includes rules for accessing and managing data items from multiple databases, using a marker field to indicate replica items and creating links between primary and secondary items, allowing for systematic integration and replication while maintaining data integrity.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If data elements are replicated into another database to enable access and set operations, then access speed and set operation capability are improved, but data integrity cannot be maintained and the system complexity increases
Solution Approach 1:
The patent introduces a special data item type called 'link' that acts as an intermediary between the primary database and secondary database. This link data item contains a reference to the secondary database and its data item identifier, enabling access to external data without breaking data integrity. The link serves as a mediator that connects local and external data sources while maintaining referential integrity through the database management system's control.
2Ease of operation
If simple linking between databases is implemented to enable access, then ease of operation is improved, but data integrity cannot be maintained and backward tracing is not possible
Solution Approach 1:
The patent implements feedback mechanisms through the link data item structure that includes a reference to the secondary database. This enables the database management system to trace backward from the primary database through the link to the secondary database, verifying data integrity and maintaining referential constraints. The feedback loop allows the system to detect and prevent integrity violations.
3Adaptability or versatility
If replication is performed from each database to another to achieve systematic integration, then access capability is improved, but the system complexity and management overhead increase significantly
Solution Approach 1:
The patent creates a universal link data item type that can be used across different database types and configurations. This single link structure serves multiple functions: storing references to external databases, enabling access to external data items, supporting set operations, and maintaining data integrity. The universal link type eliminates the need for separate replication mechanisms for different database pairs, reducing system complexity.
Data Source
AI summary
A database system comprising a first database including a database manager and a schema with set of rules enabling the database manager to store and access data items in the first database, and a second database storing a plurality of data items. The schema further including rules to enable the database manager to access at least a subset of the data items in the second database. The first database further includes a first link pointing from the primary item to a replica of the secondary item stored in the first database, and a second link pointing from the replica to the secondary item in the second database.