Visual query modeling for configurable patterns

• US 7,366,723 B2
• Filed: 10/05/2004
• Issued: 04/29/2008
• Est. Priority Date: 10/05/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Shaburov, Victor V.
• Primary Examiner(s): Wong; Leslie
• Application Number:
  US10/959,244
• Publication Number:
  US 20060074967A1
• Time in Patent Office: 1,302 Days
• Field of Search: 707/3, 707/6, 707/10, 707/104.1, 345/619, 345/621
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

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.

Claims

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.