GUI SQL Code Generation for Database Syntax Compatibility

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Managing large databases requires significant time and effort for SQL coding, and different database systems have compatibility issues with varying SQL syntax, necessitating a method to simplify and ensure syntax correctness and maintainability of SQL commands.

Innovation Solution

An electronic device and method that uses a graphic user interface to provide drop-down menus and graphic blocks for selecting objects, allowing users to generate SQL code by dragging and dropping blocks, with a lookup table to map objects to source codes, adapting to different database systems.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If managers manually code SQL commands to handle complex query requests in large databases, then the database management task can be completed, but the time and energy required increases significantly

Engineering Contradiction:

ImproveSQL code generation efficiencyVSAvoidTime spent coding SQL commands

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The patent replaces manual mechanical coding of SQL commands with an automated code generation system. The system uses a graphical interface where users select objects and operations visually, and the system automatically generates the corresponding SQL code, eliminating the need for manual typing and reducing errors.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The patent introduces an intermediary code generation system that acts as a mediator between the user's graphical selections and the final SQL code. This intermediary automatically translates visual selections into properly formatted SQL commands, reducing the cognitive load and time required for manual coding.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Reliability

If managers manually write SQL commands, then database queries can be executed, but syntax correctness cannot be effectively checked and maintainability becomes difficult

Engineering Contradiction:

ImproveSQL syntax correctnessVSAvoidSQL code maintainability

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent implements feedback mechanisms where the system automatically validates the generated SQL code against the target database system's syntax rules. The system provides real-time feedback on syntax correctness and allows users to review and modify the generated code before execution, ensuring reliability.

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The patent performs preliminary validation and code generation before the user needs to execute the SQL commands. The system pre-generates the code with proper syntax based on the selected graphical elements, and users can review the code before final execution, preventing syntax errors.

Inventive Principle:

Principle #10Preliminary action

3Adaptability or versatility

If different database systems are used, then diverse data management capabilities are achieved, but compatibility issues arise due to different SQL syntax and rules

Engineering Contradiction:

ImproveDatabase system compatibilityVSAvoidSQL syntax variation

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent creates a universal code generation interface that can adapt to multiple database systems. The system allows users to select the target database system, and automatically adjusts the generated SQL code to comply with that specific system's syntax rules, making the tool universally applicable across different database platforms.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent implements dynamic code generation where the SQL syntax and rules are automatically adjusted based on the selected database system. The system dynamically modifies the generated code to match the specific requirements of MySQL, PostgreSQL, Oracle, or other database systems, ensuring compatibility without requiring users to manually adapt the code.

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS20250321956A1Electronic device and method of generating structured query language code

Publication Date: 2025.10.16 TATUNG UNIVERSITY

AI summary

An electronic device and a method of generating a structured query language (SQL) code are provided. A processor of the electronic device is configured to: provide a plurality of first level objects through a graphic user interface, and receive a first user command through a transceiver to select a first object from the plurality of first level objects; in response to selecting the first object, provide a plurality of second level objects corresponding to the first object through the graphic user interface; receive a second user command through the transceiver to select a second object from the plurality of second level objects; and generate the SQL code according to the first object and the second object, and output the SQL code through the transceiver, in which the SQL code includes a first source code corresponding to the first object and a second source code corresponding to the second object.