Dynamic Query Building for Multi-Database Compliance Data Retrieval

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional methods for monitoring compliance with product specifications and regulatory data requirements in manufacturing are tedious, require manual input, and lack data integrity, making it difficult to efficiently aggregate and analyze data across dispersed sources and multiple batches.

Innovation Solution

A system that allows for the creation of generic queries with dynamic query parameters, enabling efficient data retrieval from multiple databases by tagging process and measured parameters, allowing for consistent data aggregation and compliance monitoring without manual programming.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual data entry and comparison methods are used to monitor compliance, then data can be collected and organized, but the process becomes tedious and time-consuming

Engineering Contradiction:

Improvedata collection efficiencyVSAvoidtime for manual data entry

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system enables self-service data collection by automatically querying multiple databases using generic queries with dynamic parameters. The system retrieves, aggregates, and analyzes compliance data without requiring manual intervention, allowing the data collection process to serve itself through automated workflows and pre-configured query templates.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent implements a universal query system that can retrieve data from multiple different databases using a single generic query template. The dynamic parameters allow the same query structure to adapt to various data sources and compliance requirements, eliminating the need for separate manual processes for each database or data type.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Ease of operation

If conventional searching techniques are used in complex databases, then data can be retrieved, but the process requires IT expertise and is time-consuming

Engineering Contradiction:

Improveease of data retrievalVSAvoidtime for data searching

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system introduces an intermediary layer between the user and complex databases. Generic queries with dynamic parameters act as mediators that translate user-friendly search criteria into database-specific queries. This intermediary handles the complexity of database structures and retrieval logic, making data search accessible to non-IT experts while maintaining efficiency.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent uses parameter changes to adapt a single generic query template to different databases and search scenarios. By dynamically modifying query parameters based on the target database and search requirements, the system maintains ease of operation while efficiently retrieving data from diverse sources without requiring separate query structures for each case.

Inventive Principle:

Principle #35Parameter changes

3Adaptability or versatility

If separate queries are created for each data set, then specific data retrieval needs can be met, but the complexity of query management increases

Engineering Contradiction:

Improvequery adaptability to different data setsVSAvoidquery management complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system implements a universal query template that can adapt to multiple data sets and databases through dynamic parameters. This single multi-functional query structure replaces the need for numerous separate queries, maintaining versatility across different data sets while significantly reducing query management complexity through standardization.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent employs dynamic parameters within the generic query template that automatically adapt to different data sets and databases. This dynamic behavior allows the query to transform itself based on the target data source and retrieval requirements, providing adaptability without requiring manual creation or management of separate static queries for each scenario.

Inventive Principle:

Principle #15Dynamics

4Reliability

If data is stored in Excel spreadsheets for compliance monitoring, then data can be organized, but data integrity and change tracking requirements are not met

Engineering Contradiction:

Improvedata integrityVSAvoidease of data organization

Core Design Contradiction:

ReliabilityVSEase of manufacture

Solution Approach 1:

The system replaces the mechanical Excel spreadsheet system with an automated database query and retrieval system. This substitution ensures data integrity through controlled access and automated tracking, while maintaining ease of data organization through structured database schemas and automated aggregation processes that eliminate manual spreadsheet manipulation.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS12579146B2Assisted query building and data retrieval

Publication Date: 2026.03.17 ID BUSINESS SOLUTIONS INC

AI summary

A generic query having a dynamic query parameter may be executed for a specified process. One or more expected parameters for the query are determined based on the dynamic query parameter and the process, where the one or more expected parameters are tagged to the dynamic query parameter for the process. One or more measured parameters are accessed based on the one or more expected parameters from one or more databases accessible over a network. The one or more measured parameters are returned responsive to the query.