Database Structure Generation from Scanned Drawings

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing methods for creating database structures from data models are time-consuming, requiring extensive coding or GUI input, which delays the development of database interaction code.

Innovation Solution

A method and system that process scanned drawings to identify and implement features of the desired database structure, utilizing a feature recognition module and database structure generator to automate the creation of database structures.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Manufacturing precision

If database structures are created using coding commands or GUI input, then the database structure can be created with precision, but the time required to create the basic structure increases significantly

Engineering Contradiction:

Improvedatabase structure accuracyVSAvoidtime to create database structure

Core Design Contradiction:

Manufacturing precisionVSLoss of time

Solution Approach 1:

The system creates a digital copy of the database structure by scanning and processing an image or drawing of the desired database layout. The feature recognition module extracts database elements (tables, fields, relationships) from the scanned image and automatically generates the corresponding database structure, eliminating the need for manual coding or GUI input while preserving structural accuracy.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The database structure is designed and visualized in advance as a scanned drawing or image, which serves as a template. This preliminary visual representation is then processed by the system to automatically generate the actual database structure, allowing the design phase to be separated from the implementation phase and significantly reducing the time required for structure creation.

Inventive Principle:

Principle #10Preliminary action

2Adaptability or versatility

If manual methods are used to create database structures, then flexibility in design is maintained, but productivity decreases due to the time-consuming nature of the process

Engineering Contradiction:

Improvedesign flexibilityVSAvoiddatabase creation speed

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The system accepts scanned images or drawings as input, which can represent any database design the user wishes to create. This copying approach maintains design flexibility because users can sketch any structure they desire, while the automated processing significantly increases productivity by eliminating manual entry tasks.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The feature recognition module automatically identifies and extracts database elements from the scanned image without requiring manual intervention. The system self-services the entire process of converting the visual representation into an actual database structure, maintaining design freedom while dramatically improving creation speed.

Inventive Principle:

Principle #25Self-service

Data Source

PatentUS10430393B2Generating a database structure from a scanned drawing

Publication Date: 2019.10.01 INTERNATIONAL BUSINESS MACHINE CORPORATION

AI summary

A method of generating a database structure from a scanned drawing of a desired database structure is provided. The method comprises: processing the scanned drawing to identify features of the desired database structure; and implementing the identified features to generate the desired database structure.