Database Table Mapping With Automatic Structure Type Alignment

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Accessing a database table by aligning columns with structure members manually is time-consuming, as it requires individual correspondence, which is inefficient.

Innovation Solution

A control system with acquisition, setting, and determination means to automatically acquire column information, define corresponding structure members, and determine data types, facilitating easy alignment and data processing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If manual correspondence between database columns and structure members is performed, then data structure alignment is achieved, but time consumption increases significantly

Engineering Contradiction:

Improvedata structure alignment accuracyVSAvoidtime for establishing column-member correspondence

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The system performs automatic data type determination where the determination unit autonomously identifies and assigns data types to structure members based on column information, eliminating the need for manual user intervention in the correspondence process while ensuring accurate data structure alignment

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system pre-establishes the correspondence relationship between database columns and structure members by automatically determining data types before actual data processing occurs, so that when data access is needed, the alignment is already in place and ready for use

Inventive Principle:

Principle #10Preliminary action

2Productivity

If automatic data type determination is implemented, then productivity is improved, but system complexity increases

Engineering Contradiction:

Improvespeed of establishing column-member correspondenceVSAvoidcomplexity of control system

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The control system is divided into distinct functional units: an acquisition unit that gathers column information, a determination unit that performs data type analysis, and a setting unit that establishes correspondences. This segmentation allows each unit to perform its specific function efficiently while keeping the overall system manageable through clear separation of concerns

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The determination unit acts as an intermediary between the acquisition unit and the setting unit, translating raw column information into structured data type definitions that can be directly applied to structure members, thereby simplifying the overall data flow and system architecture

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentEP4224333A1Control system, information processing apparatus, and information processing program

Publication Date: 2023.08.09 OMRON CORP

Figure 1
Figure 2
Figure 3

AI summary

A control system includes a database configured to hold one or more tables, and a control apparatus configured to execute a control program and access the database. The control system acquires a number of columns of a table and a data type of each column, the table being selected from among the one or more tables. The control system defines a structure that includes a number of members corresponding to the acquired number of columns and that is available in the control program. The control system determines a data type of each member of the structure in correspondence with the acquired data type of each column.