Database Language Re-Issuance Across Varying Table Definitions

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database language re-issue devices require specific database definitions for each system, making it impossible to appropriately obtain data when different definitions exist in data obtainment targets.

Innovation Solution

A database language re-issue device that includes an obtainment target information extracting unit, update information obtaining unit, table definition information obtaining unit, database language changing unit, database querying unit, and database query result merging unit to adapt queries to data obtainment targets, request periods, and data items.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If a specific database definition is made for each system, then the existing database language issue device can be used, but it becomes impossible to appropriately obtain data when different database definitions exist in data obtainment targets

Engineering Contradiction:

Improveadaptability to different database definitionsVSAvoidcomplexity of database definition management

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent creates a universal database language re-issue device that can handle multiple database definitions through automatic translation. The system maintains a translation rule database that stores mapping relationships between different database definitions, allowing a single device to serve multiple database types without requiring separate systems for each definition.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent introduces a translation rule database as an intermediary component between the query issuance unit and the database. This intermediary layer contains translation rules that automatically convert queries between different database definitions, eliminating the need for manual adaptation and enabling seamless data retrieval from databases with varying definitions.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Reliability

If manual adaptation of queries is performed for different database definitions, then data can be obtained from specific databases, but the operation becomes complex and time-consuming

Engineering Contradiction:

Improveaccuracy of data retrievalVSAvoidease of query execution

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The patent implements automatic translation functionality where the database language re-issue device autonomously translates queries between different database definitions without requiring manual intervention. The translation rule database enables the system to self-adapt to different database types, ensuring accurate data retrieval while eliminating the operational burden of manual query modification.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent pre-stores translation rules in the translation rule database for various database definitions. These translation rules are prepared in advance, allowing the system to automatically and accurately translate queries when encountering different database types, ensuring reliable data retrieval without requiring real-time manual adaptation.

Inventive Principle:

Principle #10Preliminary action

3Stability of the object's composition

If the database definition is fixed for each system, then system stability is maintained, but the system cannot accommodate varying definitions across different data obtainment targets

Engineering Contradiction:

Improvestability of database definitionVSAvoidflexibility to handle different definitions

Core Design Contradiction:

Stability of the object's compositionVSAdaptability or versatility

Solution Approach 1:

The patent transforms the static database definition approach into a dynamic one by introducing automatic translation capabilities. The system maintains stable internal structures while dynamically adapting to different database definitions through the translation rule database, allowing it to handle varying definitions across different data obtainment targets without compromising system stability.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The patent enables parameter changes in database definitions by storing multiple translation rules that map different database definition parameters. The system can switch between different parameter sets based on the target database, maintaining stability for each individual system while achieving versatility across multiple systems with different definitions.

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS12360986B2Database language re-issue device

Publication Date: 2025.07.15 MITSUBISHI ELECTRIC BUILDING SOLUTIONS CORP

AI summary

There is provided a database language re-issue device capable of appropriately obtaining data from a database. The database language re-issue device extracts a data obtainment target, a data request period and a data item from a query issued by an application, obtains information about a collection program of the extracted data obtainment target for the data request period, obtains definition information of a table for the obtained collection program, changes the data item in the query to a data item for the data request period based on the obtained definition information of the table, executes a query to a database based on the changed data item, and returns obtained data from the database to the application, the data being based on the executed query.