Developing applications using configurable patterns

• US 7,953,767 B2
• Filed: 10/05/2004
• Issued: 05/31/2011
• 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): Vu; Bai D
• Application Number:
  US10/959,280
• Publication Number:
  US 20060075382A1
• Time in Patent Office: 2,429 Days
• Field of Search: None
• US Class Current: 707/805
• CPC Class Codes: G06F 8/34 Graphical or visual programming

Abstract

Methods, systems, and computer program products, implementing techniques for developing applications using configurable patterns. The techniques include determining the functionality of a pre-existing application; selecting one or more patterns based on the functionality of the pre-existing application, and configuring the patterns so that the patterns execute similar functionality as the pre-existing application. The patterns comprise multiple pattern elements including prearranged user interface elements. The patterns specify predefined actions that can be performed using the user interface elements. The predefined actions match actions performed by the pre-existing application. Configuring the patterns includes importing database structure from a database used by the pre-existing application, generating a visual model of a query performed on the database by the pre-existing application, converting the visual model of a query into a query statement, and configuring the patterns to use the query statement.

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:

developing a pattern-based application that matches the functionality of a preexisting application by;

receiving user instructions to select a pattern from a set of application development patterns, the selected pattern comprising prearranged user interface elements;

importing database structure from a database used by the pre-existing application;

receiving user instructions to generate a visual model of a query performed on the database, the visually modeled query having input fields processed by the query to generate an output, the input fields corresponding to sets of values;

generating code for the visually modeled query based on the visual model;

receiving user instructions specifying a subset of the input fields of the visually modeled query for display in the user interface elements of the selected pattern; and

configuring the selected pattern based on the imported database structure to;

display the specified subset of input fields of the visually modeled query in the user interface elements of the selected pattern; and

use the visually modeled query for accessing the database used by the pre-existing application, the database having sets of values corresponding to the specified subset of input fields of the visually modeled query.

2. The product of claim 1, wherein the database structure is imported by communicating with the database through a generic interface layer that provides a generic way to communicate with different types of back-end databases developed by different database vendors.

3. The product of claim 2, wherein the generic interface layer uses JDBC (Java Database Connectivity) technology.

4. The product of claim 1, wherein the visual model is generated using a visual query modeler, the visual query modeler being a tool that generates visual models of queries and allows a user to modify the queries by manipulating the visual models.

5. The product of claim 4, wherein the visual query modeler is an on-line tool that runs in a web browser.

6. The product of claim 1, wherein configuring the selected pattern to use the visually modeled query includes adapting the selected pattern to display the query output.

7. The product of claim 1, further comprising automatically generating one or more additional queries based on the selected pattern.

8. A computer-implemented method for developing a pattern-based application that matches the functionality of a pre-existing application, the method comprising the steps implemented by a computer of:

receiving user instructions to select a pattern from a set of application development patterns, the selected pattern comprising prearranged user interface elements;

importing database structure from a database used by the pre-existing application;

receiving user instructions to generate a visual model of a query performed on the database, the visually modeled query having input fields processed by the query to generate an output, the input fields corresponding to sets of values;

generating code for the visually modeled query based on the visual model;

receiving user instructions specifying a subset of the input fields of the visually modeled query for display in the user interface elements of the selected pattern; and

configuring the selected pattern based on the imported database structure to;

display the specified subset of input fields of the visually modeled query in the user interface elements of the selected pattern; and

use the visually modeled query for accessing the database used by the pre-existing application, the database having sets of values corresponding to the specified subset of input fields of the visually modeled query.

9. The method of claim 8, wherein the database structure is imported by communicating with the database through a generic interface layer that provides a generic way to communicate with different types of back-end databases developed by different database vendors.

10. The method of claim 9, wherein the generic interface layer uses JDBC (Java Database Connectivity) technology.

11. The method of claim 8, wherein the visual model is generated using a visual query modeler, the visual query modeler being a tool that generates visual models of queries and allows a user to modify the queries by manipulating the visual models.

12. The method of claim 11, wherein the visual query modeler is an on-line tool that runs in a web browser.

13. The method of claim 8, wherein configuring the selected pattern to use the visually modeled query includes adapting the selected pattern to display the query output.

14. The method of claim 8, further comprising generating one or more additional queries automatically based on the selected patterns.

15. The method according to claim 8, further comprising presenting a user option to select one of a plurality of databases, the selected database being the database used by the pre-existing application.

16. The method according to claim 8, wherein the selected pattern is an object identification pattern for searching for objects in the database, and the object identification pattern is configured to run the visually modeled query when a search is executed in the object identification pattern.

17. An apparatus for developing a pattern-based application that matches the functionality of a pre-existing application, the apparatus comprising:

means for receiving user instructions to select a pattern from a set of application development patterns, the selected pattern comprising prearranged user interface elements;

means for importing database structure from a database used by the pre-existing application;

means for receiving user instructions to generate a visual model of a query performed on the database, the visually modeled query having input fields processed by the query to generate an output, the input fields corresponding to sets of values;

means for generating code for the visually modeled query based on the visual model;

means for receiving user instructions specifying a subset of the input fields of the visually modeled query for display in the user interface elements of the selected pattern;

means for configuring the selected pattern based on the imported database structure to;

display the specified subset of input fields of the visually modeled query in the user interface elements of the selected pattern; and

use the visually modeled query for accessing the database used by the pre-existing application, the database having sets of values corresponding to the specified subset of input fields of the visually modeled query; and

a processor for implementing at least the means for configuring.