Visual Query Modeling for Legacy Application Migration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Companies face challenges in migrating legacy applications to a portal environment, as this often requires rewriting application code, a process that is time-consuming and inefficient.
Innovation Solution
The implementation of visual query modeling techniques allows for the creation and configuration of pattern-based applications through a web browser, enabling the generation of SQL code and automatic query generation based on visual models, without the need for manual coding or client installation, facilitating quick and declarative query modeling and application migration.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If legacy applications are migrated to portal environment by rewriting application code, then the applications can be accessed through a unified interface, but the migration process is time-consuming and inefficient
Solution Approach 1:
The patent uses visual query modeling to create a graphical representation of database schemas and queries. Users can visually define queries by selecting tables, fields, and relationships in a graphical interface, and the system automatically generates the corresponding SQL code. This copying approach allows legacy applications to be migrated to the portal environment by generating application code from visual models rather than manual rewriting, significantly reducing migration time while achieving unified interface access.
2Manufacturing precision
If manual coding is used for query creation, then precise control over query logic is achieved, but development time and complexity increase
Solution Approach 1:
The patent replaces the mechanical process of manual coding with a visual modeling system. Users interact with a graphical user interface to define queries by selecting and connecting visual elements representing tables, fields, and relationships. The system automatically translates this visual model into executable SQL code, eliminating the need for manual coding while maintaining precise control over query logic through intuitive graphical selections and automatic code generation.
3Productivity
If visual query modeling is implemented, then query creation becomes faster and more accessible, but the system complexity increases
Solution Approach 1:
The patent segments the database schema into distinct visual elements such as tables, fields, and relationships, each represented as separate graphical objects. Users can selectively define queries by working with these individual segments rather than dealing with the entire complex system at once. The visual query modeler processes these segmented elements automatically to generate queries, reducing the perceived system complexity while maintaining high productivity in query creation.
Data Source
AI summary
Methods, systems, and computer program products, implementing techniques for visual query modeling. In one aspect, the techniques include displaying in a web browser a visual model of a database, the visual model including one or more graphical objects representing one or more tables in the database and relations between the tables, receiving in the web browser user input creating a visual model of a query into the database, and generating code for the query based on the visual model of the query.