Relation-Type Form Database Creation via Visual Scanning
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database creation methods are complex, costly, and require professional expertise, limiting their accessibility and efficiency, especially for small and medium enterprises due to reliance on outdated hardware and software technologies.
Innovation Solution
A method and device for creating a relation-type form database using advanced computer hardware, allowing users to scan forms and create database structures with simple mouse operations, eliminating the need for programming and professional intervention by employing dynamic parallel and cross relations between data areas.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If conventional database creation methods are used, then database structure can be created, but the process requires programming expertise and complex definitions, making it inaccessible to non-professionals
Solution Approach 1:
The patent uses scanned form images as templates to copy the visual structure directly into the database interface. Users draw frames on the form image background, and the system automatically creates corresponding database fields and structures, eliminating the need for manual programming and complex definitions.
Solution Approach 2:
The patent replaces the mechanical programming process with a visual graphical interface. Instead of requiring users to write code or perform complex configuration, the system allows users to interactively draw on form images and automatically generates the database structure, substituting manual programming mechanics with automated visual operations.
2Reliability
If professional database software like Oracle or MS SQL is used, then robust database functionality is achieved, but high costs and requirement for professional maintenance personnel result
Solution Approach 1:
The patent enables non-professional users to create and maintain their own databases through the visual form-based interface. Users can independently perform database creation, field definition, and relationship establishment without requiring professional database administrators, making the system self-serviceable and eliminating maintenance costs.
Solution Approach 2:
The patent creates a universal database creation platform that works with any form template and can handle various database structures through the same visual interface. The system provides robust database functionality comparable to professional software but through a simplified unified approach that eliminates the need for specialized expensive tools.
3Productivity
If traditional character terminal interface is used for database creation, then compatibility with older systems is maintained, but inability to utilize high resolution displays and scanners results in inefficient creation process
Solution Approach 1:
The patent transitions from static character terminal interfaces to dynamic graphical interfaces that utilize modern hardware capabilities. The system dynamically displays high-resolution form images, allows interactive drawing operations, and adapts to various display resolutions, maximizing the utility of contemporary hardware while improving creation efficiency.
Data Source
AI summary
The present invention provides a method and device for creating a relation-type form database, the method comprising: displaying an existing form as a background image on a screen; drawing frames on predetermined positions of the background image with an operation means to create multiple data areas; and creating parallel relations and/or cross relations among the multiple data areas to form a relation-type database of the existing form. The operations of the present invention are easy and low-cost, which enable widely spreading of the application of databases.