Common Data Attributes for Cross-Database Entity Relationships
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data modeling and database technologies do not allow for the declaration of data entity relationships between data entities located in different data model databases, nor do they enforce referential integrity or support database access paths between multiple databases.
Innovation Solution
The method enhances data models by introducing common data attributes that function as unique keys across multiple data entities, enabling the declaration of common entity relationships and common index integrity rules, allowing for the design of multiple databases within a single data model, and populating common database tables with a common set of master data values.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data entity relationships are declared between data entities in different data model databases, then data integration and consistency across multiple databases are improved, but system complexity and implementation difficulty increase
Solution Approach 1:
The patent segments the data model into multiple data model databases, each containing specific data entities. Common data attributes that serve as unique keys are identified and separated as shared elements across databases. This segmentation allows relationships to be declared between data entities in different databases while maintaining manageable system complexity through modular organization.
Solution Approach 2:
The patent introduces common data attributes that function as unique keys across multiple data entities in different data model databases. These common attributes serve multiple purposes: they act as primary keys in their respective data entities, enable peer-to-peer relationships between databases, and provide a basis for declaring data entity relationships across database boundaries. This multi-functionality resolves the contradiction by providing a universal mechanism for cross-database integration.
2Reliability
If common data attributes functioning as unique keys are declared across multiple data entities, then data entity relationships and referential integrity can be enforced, but data model complexity increases
Solution Approach 1:
The patent merges the functionality of unique key enforcement across multiple data entities by declaring common data attributes that serve as unique keys in multiple data entities simultaneously. Instead of implementing separate integrity constraints in each data entity, the common attribute declaration provides a unified mechanism that enforces referential integrity across all related data entities, reducing overall data model complexity while maintaining reliability.
3Adaptability or versatility
If database access paths are enabled between multiple databases, then data integration and interoperability are improved, but system complexity and maintenance difficulty increase
Solution Approach 1:
The patent introduces common data attributes as intermediary elements that mediate relationships between data entities in different data model databases. These common attributes act as a bridge, enabling database access paths and data integration without requiring direct complex connections between all databases. The intermediary common attributes simplify the system architecture by providing standardized connection points across database boundaries.
Data Source
AI summary
A method, an apparatus, and a system for configuring, designing, and/or implementing common metadata and common data is detailed as a new type of data relationship, within and between databases.