Automatic Data Relationship Creation via Drag-and-Drop
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users face a steep learning curve when creating data relationships in relational database management systems, which can deter non-technical users from utilizing these systems, leading to avoidance or costly professional intervention.
Innovation Solution
The implementation allows for automatic and transparent creation of data relationships through user-generated trigger events, such as drag-and-drop actions, which generate and store relationship information in background tables, enabling users to relate data sources without manual intervention.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual creation of data relationships is used in traditional RDBMS, then data integrity and relationship management are maintained, but the learning curve becomes steep and operation complexity increases
Solution Approach 1:
The system automatically creates data relationships by detecting user actions (such as drag-and-drop operations) and autonomously generating the necessary relationship definitions and background tables, eliminating the need for users to manually configure complex relationship settings while maintaining data integrity
Solution Approach 2:
The patent introduces an intermediary automatic relationship creation mechanism that sits between the user interface and the database engine, translating simple user actions into proper relational database relationships without requiring users to understand the underlying complexity
2Ease of operation
If automatic relationship creation is implemented, then ease of operation improves and professional intervention is reduced, but system complexity increases
Solution Approach 1:
The patent extracts the complexity of relationship management into separate background tables that are automatically generated and maintained by the system, keeping the user interface simple while handling the complex relationship logic in the background without exposing it to users
3Manufacturing precision
If professional intervention is required to create relationships, then data relationship accuracy is ensured, but cost increases
Solution Approach 1:
The system performs automatic relationship creation with high accuracy by intelligently detecting user intent through actions like drag-and-drop operations and automatically generating appropriate relationship definitions, eliminating the need for expensive professional intervention while maintaining precision
Data Source
AI summary
The disclosed implementations allow automatic and transparent creation of data relationships in a database application or other application in response to user generated trigger events. Related data records can be stored and displayed in layouts, screens, forms and user interfaces provided by the database application or other application. Additional or extended information corresponding to the related data can be stored and displayed.