Schema-Agnostic Data Processing for Cross-Database Analysis

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional data processing and analysis methods require prior knowledge of a database's organizational structure, limiting the ability to analyze data across multiple databases without reformatting or understanding their individual structures.

Innovation Solution

A system and method for processing medical data that is agnostic to database formats, enabling analysis across databases without requiring prior knowledge of their organizational schemes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If conventional data processing methods are used, then data analysis can be performed on a single database, but the ability to analyze data across multiple databases is limited and requires reformatting

Engineering Contradiction:

Improveability to analyze data across multiple databasesVSAvoidrequirement to understand and reformat database structures

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces a data processor as an intermediary component that receives data from multiple databases with different structures and transforms them into a unified format. This mediator abstracts the complexity of different database schemas, allowing the system to access and analyze data from diverse sources without requiring direct knowledge of each database's organizational scheme.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The data processor is designed with universal functionality to handle multiple database types and structures. It can ingest data from various database formats, interpret their different schemas, and process them through a common analysis framework, thereby achieving multi-functionality across different data sources without requiring separate processing logic for each database type.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If data is processed without knowledge of database structure, then cross-database analysis becomes possible, but data processing accuracy may be compromised

Engineering Contradiction:

Improvecross-database analysis capabilityVSAvoiddata processing accuracy

Core Design Contradiction:

Adaptability or versatilityVSMeasurement precision

Solution Approach 1:

The system performs preliminary structure detection and schema identification before data processing begins. By analyzing the organizational structure of each database in advance, the data processor can automatically determine appropriate processing parameters, data types, and relationships, ensuring accurate processing without requiring pre-programmed knowledge of specific database schemas.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The data processor incorporates feedback mechanisms that continuously monitor and validate data processing results. By comparing processed data against expected patterns and receiving feedback about data quality and structure, the system can automatically adjust processing parameters to maintain high accuracy across different database formats.

Inventive Principle:

Principle #23Feedback

3Stability of the object's composition

If databases are reformatted for uniformity, then data analysis consistency is improved, but time and resources are consumed

Engineering Contradiction:

Improvedata analysis consistencyVSAvoidtime for reformatting databases

Core Design Contradiction:

Stability of the object's compositionVSLoss of time

Solution Approach 1:

Instead of transforming data from multiple sources into a uniform format (the conventional approach), the patent inverts the approach by having the data processor adapt to each source database's native structure and translate it into the required analysis format internally. This eliminates the need for time-consuming reformatting operations while maintaining analysis consistency.

Inventive Principle:

Principle #13The other way round (Inversion)

Solution Approach 2:

The system dynamically changes processing parameters based on the detected characteristics of each database. By automatically adjusting data interpretation parameters, field mappings, and query structures according to the source database's schema, the system achieves consistent analysis results without requiring manual reformatting or standardization of the source databases.

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS20250316351A1Methods and systems processing data

Publication Date: 2025.10.09 CIGNA INTPROP

AI summary

Methods and systems for analyzing data are described. In one embodiment, a method comprises a processor receiving a data analysis algorithm over a network and executing the data analysis algorithm, the data analysis algorithm analyzing data stored in a database using machine learning to identify a database organizational format, the data analysis algorithm identifying one or more locations for a set of data stored on the database based on identifying the database organizational format, the data analysis algorithm parsing the set of data to identify whether any entries in the database associated with the set of data includes a particular value, and the data analysis algorithm communicating over the network at least a first number of entries in the database that include the particular value and a second number of entries in the database that do not include the particular value.