Visual query modeling for configurable patterns
View Patent ↗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.
1. A computer program product, tangibly embodied in a machine-readable storage device, the computer program product being operable to cause a data processing apparatus to perform operations comprising:
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;
generating code for the query based on the visual model of the query;
incorporating the query into a pattern-based application, the pattern-based application being an application that is developed by selecting a pattern from a set of patterns and configuring the pattern to perform application-specific functionality, the pattern comprising multiple pattern elements including prearranged user interface elements, the pattern specifying predefined actions that can be performed using the user interface elements; and
automatically generating one or more additional queries based on a first selected pattern once the first selected pattern is linked to a second selected pattern.
2. The product of claim 1 , wherein the code is SQL (Structured Query Language) code.
3. The product of claim 1 , wherein the user input creating a visual model of a query includes input specifying a query structure, query inputs and query outputs.
4. The product of claim 1 , wherein
incorporating the query into a pattern-based application includes configuring the pattern to use the query.
5. The product of claim 4 , wherein:
the query takes as input one or more input fields and produces as a output one or more output fields; and
configuring the pattern to use the query includes selecting which input fields and output fields to be displayed by the pattern.
6. The product of claim 4 , wherein configuring the pattern to use the query includes adapting the query to include one or more additional output fields selected based on the relations in the database.
7. The product of claim 4 , wherein configuring the pattern to use the query includes configuring the pattern to perform one or more data operations on the output of the query.
8. A method comprising:
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;
generating code for the query based on the visual model of the query;
incorporating the query into a pattern-based application, the pattern-based application being an application that is developed by selecting a pattern from a set of patterns and configuring the pattern to perform application-specific functionality, the pattern comprising multiple pattern elements including prearranged user interface elements, the pattern specifying predefined actions that can be performed using the user interface elements; and
automatically generating one or more additional queries based on a first selected pattern once the first selected pattern is linked to a second selected pattern.
9. The method of claim 8 , wherein the code is SQL (Structured Query Language) code.
10. The method of claim 8 , wherein the user input creating a visual model of a query includes input specifying a query structure, query inputs and query outputs.
11. The method of claim 8 , wherein
incorporating the query into a pattern-based application includes configuring the pattern to use the query.
12. The method of claim 11 , wherein:
the query takes as input one or more input fields and produces as a output one or more output fields; and
configuring the pattern to use the query includes selecting which input fields and output fields to be displayed by the pattern.
13. The method of claim 11 , wherein configuring the pattern to use the query includes adapting the query to include one or more additional output fields selected based on the relations in the database.
14. The method of claim 11 , wherein configuring the pattern to use the query includes configuring the pattern to perform one or more data operations on the output of the query.
15. Apparatus comprising:
means for 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;
means for receiving in the web browser user input creating a visual model of a query into the database;
means for generating code for the query based on the visual model of the query;
means for incorporating the query into a pattern-based application, the pattern-based application being an application that is developed by selecting a pattern from a set of patterns and configuring the pattern to perform application-specific functionality, the pattern comprising multiple pattern elements including prearranged user interface elements, the pattern specifying predefined actions that can be performed using the user interface elements; and
means for automatically generating one or more additional queries based on a first selected pattern once the first selected pattern is linked to a second selected pattern.