Homogeneous Database Conversion via Unified Boundary Entities

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems face challenges in integrating independently designed databases due to lack of metadata and data set commonality, leading to isolated data sets and increased integration complexity and costs.

Innovation Solution

The development of standardized homogeneous databases through the creation of unified boundary data entities and summary database tables, which provide metadata commonality and data set integration, enabling the conversion of independent heterogeneous databases into a unified format.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If independently designed databases are integrated without standardization, then database independence and design flexibility are maintained, but data integration complexity and costs increase significantly

Engineering Contradiction:

Improvedatabase independenceVSAvoidintegration complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent applies homogeneity by converting heterogeneous independently designed databases into standardized homogeneous databases through a unified data model. This standardization enables consistent data structures, metadata formats, and integration protocols across all databases, thereby reducing integration complexity while maintaining adaptability through the standardized interface layer

Inventive Principle:

Principle #33Homogeneity

2Productivity

If standardized homogeneous databases are created through conversion, then data integration efficiency and metadata commonality improve, but conversion complexity and initial implementation costs increase

Engineering Contradiction:

Improvedata integration efficiencyVSAvoidconversion complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent implements preliminary action by pre-defining standardized data models, metadata schemas, and conversion protocols before the actual database conversion process. This preparation phase includes creating template structures and transformation rules that streamline the subsequent conversion of heterogeneous databases, reducing overall conversion complexity despite the initial setup effort

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary standardized data model layer that acts as a mediator between heterogeneous source databases and the target integrated database system. This intermediary layer handles the complexity of conversion through standardized transformation rules, enabling efficient data integration while isolating the conversion complexity within the intermediary translation layer

Inventive Principle:

Principle #24Intermediary (Mediator)

3Speed

If data redundancy and aggregation are used in data warehouses, then data retrieval speed improves, but data storage requirements and system complexity increase

Engineering Contradiction:

Improvedata retrieval speedVSAvoiddata storage requirements

Core Design Contradiction:

SpeedVSQuantity of substance

Solution Approach 1:

The patent applies segmentation by organizing data into structured hierarchical levels within the standardized database model, separating raw data, aggregated data, and derived data into distinct segments. This segmentation enables efficient retrieval of specific data types while managing storage requirements through selective aggregation only where performance benefits outweigh storage costs

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS10545937B2Method and apparatus for converting heterogeneous databases into standardized homogeneous databases

Publication Date: 2020.01.28 MACK ROBERT

AI summary

A method, an apparatus, and a system for configuring, designing, and/or implementing database tables are detailed that provides a framework into which a remainder of database tables is developed. Also detailed is a method to develop this framework of database tables. This so developed framework provides a platform for converting multiple independent heterogeneous databases into standardized homogeneous databases.