AR Database Modeling With ML Attribute Suggestion
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Creating a database model has become tedious and time-consuming due to increasing data dependency issues in large organizations, necessitating an intelligent database modelling system.
Innovation Solution
A system utilizing augmented reality and machine learning to assist users in designing database models by capturing user drawings, suggesting entities and attributes, and generating conceptual and physical database models through machine learning algorithms.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If traditional manual database modelling is used, then complete access and reporting can be provided, but the process becomes tedious and time consuming
Solution Approach 1:
The patent replaces manual mechanical database modelling with an augmented reality system that uses machine learning algorithms to automatically generate database models. The AR application captures user drawings and the ML model processes these inputs to create database models automatically, eliminating the tedious manual process while maintaining complete access and reporting capabilities.
Solution Approach 2:
The system enables self-service database modelling where the machine learning model autonomously generates database models from user drawings without requiring manual intervention for each modelling decision. The system self-corrects and refines models through iterative processing, reducing both time and manual effort while preserving data integrity.
2Productivity
If intelligent automation is introduced to reduce manual effort, then productivity improves, but system complexity increases
Solution Approach 1:
The patent introduces an augmented reality application as an intermediary layer between the user and the machine learning model. This AR application simplifies the complex ML system by providing an intuitive drawing interface and automatically handling the complexity of model generation, making the system easier to use while maintaining high productivity.
Solution Approach 2:
The system uses augmented reality to create virtual copies of database models that users can interact with and visualize. These AR representations simplify the complex underlying data structures into intuitive visual formats, reducing the perceived complexity while enabling efficient model creation and manipulation.
Data Source
AI summary
Systems, computer program products, and methods are described herein for intelligent database modelling. The present invention is configured to capture, using the augmented reality application, a drawing made by the user on a medium; initiate a first machine learning model on the drawing; determine that the user is attempting to design a database model; extract at least a first entity from the drawing; determine, using the first machine learning model, one or more attributes for the first entity; initiate, via the augmented reality application, a first push notification for display on the computing device of the user; electronically receive, via the augmented reality application, a user selection of a subset of attributes from the one or more attributes; generate, using the augmented reality application, a conceptual database model based on at least the first entity and the subset of attributes.