Database Application Cogeneration via Visual Design Tool
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database design complexities hinder non-trained individuals in creating effective database applications and databases, as they struggle to differentiate between data and views, and current approaches require manual coding and data design steps.
Innovation Solution
A user-centric designer tool that allows users to create database applications and databases without a data design step, enabling users to place visual representations of application elements, which automatically generate the necessary database schema elements and code, supporting relational and hierarchical datasets.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If manual database design and coding is performed, then database applications can be created, but the process is complex and requires trained expertise
Solution Approach 1:
The patent introduces a designer tool as an intermediary between the user and the database system. This tool automatically generates database schema elements and application code based on visual representations placed by the user, eliminating the need for users to directly interact with complex database design processes while maintaining the ability to create functional database applications
Solution Approach 2:
The patent replaces manual mechanical coding and data design processes with automated code generation. The designer tool translates visual representations into executable code and database schema elements, substituting the mechanical process of manual programming with an automated system that handles the complexity of database construction
2Ease of operation
If visual representations are used to control datasets, then user interaction is simplified, but automatic code generation is required
Solution Approach 1:
The designer tool performs self-service by automatically generating and executing the necessary code and database schema elements in response to visual representations placed by the user. The system serves itself by translating user actions into automated code generation without requiring manual programming intervention
3Manufacturing precision
If data model design is performed manually, then detailed data models can be created, but the process requires specialized training
Solution Approach 1:
The designer tool acts as an intermediary that translates simple visual representations into detailed data models. Users place visual representations without needing to understand complex data modeling concepts, while the tool automatically generates the detailed schema elements and relationships, maintaining precision while eliminating the need for specialized training
Data Source
AI summary
User experience in a designer tool manages cogeneration of a database application and a database accessible through the application. A user places a visual representation of an application element designed to control a relational or hierarchical dataset. Code is automatically called to add the application element to the application, and automatically invoked to create database schema elements designed to implement the dataset in the database under application element control. Users verify that an application element has been automatically added, and confirm that database schema elements implementing the dataset(s) under control of the application element have been automatically created. A tutorial illustrates a workflow utilizing a designer tool to cogenerate a database application and a database without a data design step. A wizard utilizes the designer tool to cogenerate a database application and a database that collectively implement a calendar, a diagram, a tree, a wiki, and/or a list.