Dynamic Federated Database Relationship Discovery

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

In federated databases, determining relationships between data elements from multiple autonomous databases is challenging due to lack of documented information and the dynamic nature of databases, leading to inefficiencies in information integration and reuse.

Innovation Solution

A method and system that dynamically analyze data manipulation language in query transactions to establish and display relationships between data elements, using a server with a status management unit, data processing unit, and data relation output unit to classify and convey these relationships in a visual format, without requiring data movement or copying across platforms.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If data elements are distributed across multiple autonomous databases in a federated database, then data autonomy and distributed storage are improved, but the ability to determine relationships between data elements deteriorates

Engineering Contradiction:

Improvedata autonomyVSAvoidrelationship determination

Core Design Contradiction:

Adaptability or versatilityVSDifficulty of detecting and measuring

Solution Approach 1:

The patent introduces an intermediary mechanism that captures and analyzes data manipulation language (DML) statements executed across distributed databases. This intermediary layer dynamically tracks relationships between data elements by monitoring DML operations without requiring changes to the autonomous databases themselves, thus resolving the contradiction between maintaining data autonomy and enabling relationship detection.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system implements feedback by continuously monitoring DML statements executed on distributed databases and using this information to dynamically build and update relationship models. The feedback loop captures actual data access patterns and relationship usage, allowing the system to adaptively determine relationships between data elements while preserving database autonomy.

Inventive Principle:

Principle #23Feedback

2Measurement precision

If relationship information is documented statically at application development time, then initial relationship accuracy is improved, but the ability to reflect dynamic database changes deteriorates

Engineering Contradiction:

Improverelationship accuracyVSAvoiddynamic adaptation

Core Design Contradiction:

Measurement precisionVSAdaptability or versatility

Solution Approach 1:

The patent transforms static relationship documentation into a dynamic system by continuously monitoring and analyzing DML statements executed in the federated database. The relationship information is updated in real-time based on actual data access patterns, allowing the system to adapt to changing database structures and relationships while maintaining accurate relationship information.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The system performs preliminary analysis of DML statements to identify potential relationships before they are fully established or used. By proactively capturing and analyzing data manipulation patterns, the system can anticipate and document relationships before they become critical, ensuring accurate relationship information is available when needed.

Inventive Principle:

Principle #10Preliminary action

3Productivity

If data elements are accessed across distributed databases, then information integration capability is improved, but the complexity of managing relationships between elements increases

Engineering Contradiction:

Improveinformation integrationVSAvoidrelationship management complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent extracts relationship information from complex DML statements by analyzing and parsing the data manipulation language. This extraction process separates relationship identification from the overall data access complexity, allowing the system to manage relationships independently while maintaining high information integration capability across distributed databases.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The intermediary mechanism serves as a mediator between distributed databases and the relationship management system. It captures DML statements, analyzes them for relationship information, and presents processed relationship data to the application layer, thereby reducing the complexity of direct relationship management while enabling effective information integration.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS8019771B2Method for dynamically finding relations between database tables

Publication Date: 2011.09.13 DOMO

AI summary

A method and system are provided for dynamically relating tables in a federated database based upon a data manipulation language in a query transaction. After the start of a transaction has been detected, a data manipulation language from the transaction is extracted and evaluated to determine the table(s) and column(s) referenced by the transaction language. The data relation output unit determines the relationship(s) between the extracted table(s) and column(s) in real-time and conveys this information through a visual display.