Automatic Screen Generation Device for Database Access

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing methods for constructing and modifying database access screens require programming expertise, are time-consuming, and lack user customization and authority management features, limiting their efficiency and flexibility.

Innovation Solution

An automatic screen generation device that uses a user-side database, setting storage database, and utilization-form-specific screen programs to generate database access screens without programming, allowing users to set and modify screen layouts and functionality through a setting interface, enabling non-expert users to create and modify screens efficiently.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If programming languages and database manipulation languages are used to construct database access screens, then the screens can be built with full functionality, but the construction time increases to several days and requires professional programmer expertise

Engineering Contradiction:

Improvescreen construction speedVSAvoidprogramming complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent introduces an automatic screen generation device as an intermediary between the user and the database access screen construction process. This device automatically generates screens based on database definitions and user specifications, eliminating the need for users to directly use programming languages while still producing fully functional database access screens.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system enables self-service screen construction by allowing users to define screens through simple specifications (such as specifying database tables and desired screen layout) without requiring programming expertise. The automatic generation device then handles the complex programming tasks autonomously.

Inventive Principle:

Principle #25Self-service

2Productivity

If existing automatic generation methods are used, then screen construction time is reduced, but the methods can only generate single-pattern screens and require external program calls for database output

Engineering Contradiction:

Improvescreen construction efficiencyVSAvoidscreen layout flexibility

Core Design Contradiction:

ProductivityVSAdaptability or versatility

Solution Approach 1:

The patent implements dynamic screen generation capability where the system can adaptively generate different screen patterns (single-sheet form, detailed list form, etc.) based on user specifications. The screen generation is not fixed to a single pattern but dynamically adjusts to user needs while maintaining automatic generation efficiency.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The system changes parameters such as screen pattern type, display fields, and layout configurations based on user input specifications. By allowing parameter changes in the generation process, the system maintains both automation and flexibility for different screen requirements.

Inventive Principle:

Principle #35Parameter changes

3Ease of operation

If simple setting interfaces are used for screen construction, then ease of operation improves, but the screens lack authority management and transition functions between screens

Engineering Contradiction:

Improvescreen construction simplicityVSAvoidscreen functionality completeness

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The automatic screen generation device provides multi-functionality by incorporating authority management, screen transition, and database access control features into the generated screens. A single generation system produces screens that handle multiple functions including user authorization, navigation between screens, and data manipulation.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system performs preliminary actions by pre-defining authority settings, screen transition rules, and database access permissions during the screen generation process. These essential functions are built into the screens beforehand, so users obtain complete functionality without needing to configure complex settings manually.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS10303668B2Automatic screen generation device, automatic screen generation program, and automatic screen generation method

Publication Date: 2019.05.28 HOIPOI CO LTD

AI summary

According to a conventional method, there is only one kind of a database access screen pattern (single sheet format), the screen layout cannot be changed from one user to another, a portion that produces an output to a database needs to make an external program call, and, there is no user-by-user utilization right which is generally required for a database access screen, not is there a function provided for transitioning from database access screen A to database access screen B involving value transfer. The present invention is provided with two kinds of screen patterns of a single sheet format and a list format, eliminates the need for a programming language and a database operation language, and is further provided with user-by-user utilization right and a function for transitioning from data access screen A to data access screen involving value transfer on the basis of a setting made by a setting person without requiring programming. Further, in accordance with a setting content by the setting person is stored, and a database access screen corresponding to a utilization mode is automatically generated in accordance with the setting content selected by the user and a screen program.