System and method for rapid development of software applications

• US 8,904,342 B2
• Filed: 04/27/2008
• Issued: 12/02/2014
• Est. Priority Date: 05/25/2007
• Status: Active Grant

• Current Assignee: Zoot Enterprises, Inc.
• Original Assignee: Zoot Enterprises, Inc.
• Inventors: Bauder, Warren White, Quinlan, Peter Andrew, Banfill, Robert Lee, Fletcher, Kevin R., Bauder, Gretchen Andes, Sasser, Ryan G., Johnson, Thomas H.
• Primary Examiner(s): Do, Chat
• Assistant Examiner(s): JEON, JAE UK
• Application Number:
  US12/529,057
• Publication Number:
  US 20110016448A1
• Time in Patent Office: 2,410 Days
• Field of Search: 717/104, 717/105
• US Class Current: 717/104
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06F 8/34 Graphical or visual programming

Abstract

The present invention is a system and method for rapid development of software applications comprising; a field composer; a design composer; and a design repository; wherein the field composer is used to create field trees; wherein the design composer is used to create designs; wherein a design is a partial or complete configuration of a software application; wherein one or more data models is/are derived from one or more existing databases; and wherein the design repository stores designs, field trees, and data models.

Claims

1. A system for rapid development of software applications comprising:

(a) a memory and a processor;

(b) a field composer run on a local computer;

(c) a design composer run on a local computer; and

(d) a design repository that is used to test the software applications before they are deployed to a runtime environment;

(d) a central server; and

(e) a deployment tool that interacts with the design repository and the runtime environment to deploy instances of server software along with a design and associated artifacts;

wherein the field composer creates a hierarchical view of a relational data model for subsequent use in the design composer, the relational data model comprises a relational data model structure, and the field composer comprises a persistence layer that interrogates the relational data model structure and displays the relational data model structure in a data model view of the field composer;

wherein the relational data model created by the field composer corresponds to a relational data model of a database, and the field composer connects to the database using the relational data model created by the field composer and analyzes entity classes within an object model of the database along with database metadata available from the database to derive entities and fields to present in the data model view;

wherein after a user selects desired fields from the relational data model created by the field composer, the selected fields are saved and grouped according to the relational data model of the database;

wherein the field composer creates field trees, each field tree comprises one or more relational data models, each relational data model is represented by a new root in the field tree, each relational data model is derived from a database schema corresponding to a database schema for a database that is used in the runtime environment, each field tree comprises a certain number of relational data models, the runtime environment comprises a certain number of databases, and the certain number of relational data models in the field tree corresponds to the certain number of databases in the runtime environment;

wherein the design composer is used to create designs using the field trees created by the field composer and provides an ability to create frames for use across multiple pages;

wherein the fields selected by the user with the field composer are displayed in a field tree window of the design composer;

wherein the user creates a page of an automated business system by selecting fields from the field tree window and placing them onto a canvas;

wherein a design is a partial or complete configuration of a software application;

wherein the design repository stores the designs, the field trees, and the relational data models created by the field composer;

wherein the persistence layer allows the central server to communicate with the database(s) in the runtime environment and translates data entered by the user into the automated business system back to the database(s);

wherein after the data modeling standard is used to automatically infer the structure of the database schema of the database corresponding to the relational data model created by the field composer, the relational data model is derived using a reverse engineering tool;

wherein the relational data model is updated by updating the database schema from which the relational data model is derived and recreating the relational data model to include changes to the database schema;

wherein the system automatically generates all database interactions based on fields placed on a page by the user and allows users to define individual page layout, page groupings, and page navigation;

wherein a customer database has a native database query format, and wherein the persistence layer translates the data entered by an end user to the native database query format of the customer database;

wherein the relational data models are derived from different types of databases;

wherein the persistence layer is an application programming interface that communicates with an object model persistence application programming interface; and

wherein the runtime environment provides for user permissions, and wherein the user permissions include permissions for accessing the application.

2. The system of claim 1, wherein a design comprises programmer-created pages, programmer-created frames, tool-created pages, and/or tool-created frames.

3. The system of claim 1, further comprising a client,

wherein the client displays in a runtime environment the software application that is created in the design composer;

and

wherein an end user enters, edits and/or reviews data through the client using the software application that is created in the design composer.

4. The system of claim 3, wherein the customer database is used by the software application to store and retrieve data entered by the end user through the client.

5. The system of claim 1, wherein more than one relational data model is used per software application created in the design composer.

6. The system of claim 1, wherein a data modeling standard is used to automatically infer the structure of the database schema of the database corresponding to the relational data model created by the field composer.

7. The system of claim 1, wherein the field composer comprises a data model view and a field view;

wherein each relational data model created by the field composer comprises fields;

wherein the data model view is automatically populated with the fields from the relational data model(s) created by the field composer; and

wherein to create a field tree in the field composer, a business user drags and drops data elements from the data model view to the field view of the field composer.

8. The system of claim 7, wherein the field tree created in the field composer and displayed in the field tree window of the design composer maps the data elements to one or more customer databases.

9. The system of claim 1, wherein the persistence layer is an application programming interface that communicates directly with one or more relational data models.

10. The system of claim 1, wherein the persistence layer is used within the field composer to create a hierarchical view of a relational data model.

11. The system of claim 10, wherein the hierarchical view of the relational data model is displayed in the data model view of the field composer.

12. The system of claim 1, wherein each relational data model created by the field composer comprises fields, and wherein the field composer allows business users to select relational data model(s) and specific fields from a relational data model for use on specific pages of the software application.

13. The system of claim 12, wherein the field composer comprises a data model view and a field view, wherein all available fields within a selected relational data model appear in the data model view of the field composer, and wherein the selected fields appear in the field view.

14. The system of claim 1, wherein a single field tree is created for each software application, and wherein the design composer is used to build the software application using the field tree that is created in the field composer.

15. The system of claim 1, wherein the software application comprises one or more pages, wherein each page comprises a visual display, and wherein the design composer is used to configure the visual display of the pages in the software application.

16. The system of claim 1, wherein the design composer comprises a properties window, a field tree window, a pages window, and a palette window.

17. The system of claim 16, wherein the design composer further comprises a frames window.

18. The system of claim 16, wherein the software application comprises one or more pages, and wherein the canvas is where business users design, build and modify the pages of the software application.

19. The system of claim 16, wherein the software application comprises one or more pages, wherein the pages comprise design elements, and wherein the properties window is used to format the design elements of the pages.

20. The system of claim 16, wherein the software application has a page flow, and wherein the page flow is defined in the properties window.

21. The system of claim 16, wherein the software application has a page flow, and wherein page flow is controlled by events on buttons that have been dragged and dropped onto the canvas from the palette window.

22. The system of claim 16, wherein the software application comprises one or more pages, and wherein the pages window is used to add, delete, modify and rename pages.

23. The system of claim 22, wherein the pages window allows a business user to add programmer-created pages to the software application.

24. The system of claim 16, wherein the software application comprises one or more pages, and wherein the palette window is used to add design elements to a page.

25. The system of claim 24, wherein the design elements that are added from the palette window are arranged and sized on the canvas.

26. The system of claim 25, wherein a user selects a button from the palette window, drags and drops the button onto the canvas, and selects an action from the properties window to apply to the button.

27. The system of claim 26, wherein the software application comprises one or more pages, and wherein the frames window is used to add one or more frames to a page.

28. The system of claim 27, wherein each frame comprises one or more design elements, and wherein when a design element in a frame is modified, the modification propagates to every place in a design in which the frame is used.

29. The system of claim 1, wherein the fields placed onto the canvas form a layout, and wherein the layout displayed on the canvas is identical to that which will appear to an end user in a runtime environment.

30. The system of claim 1, wherein when a design is completed, the design is saved to the design repository.

31. The system of claim 30, wherein modified designs are saved as new versions, and wherein both new and prior versions are available for use in the design composer.

32. The system of claim 1, wherein when a design is completed and ready to be run in a runtime environment, the design is deployed from the design repository to the central server.

33. The system of claim 1, wherein the designs, fields trees and relational data models that are stored in the design repository are shared across multiple platforms and between end users.

34. The system of claim 1, wherein the user permissions include permissions for accessing specific pages and permissions for accessing specific fields.

35. A method for rapid development of software applications comprising:

(a) providing a field composer run on a local computer;

(b) providing a design composer run on a local computer; and

(c) providing a design repository that is used to test the software applications before they are deployed to a runtime environment;

(d) providing a server; and

(e) providing a deployment tool that interacts with the design repository and the runtime environment to deploy instances of server software along with a design and associated artifacts;

wherein the field composer creates a hierarchical view of a relational data model for subsequent use in the design composer, the relational data model comprises a relational data model structure, and the field composer comprises a persistence layer that interrogates the relational data model structure and displays the relational data model structure in a data model view of the field composer;

wherein the relational data model created by the field composer corresponds to a relational data model of a database, and the field composer connects to the database using the relational data model created by the field composer and analyzes entity classes within an object model of the database along with database metadata available from the database to derive entities and fields to present in the data model view;

after a user selects desired fields from the relational data model created by the field composer, the selected fields are saved and grouped according to the relational data model of the database;

wherein the field composer creates field trees, each field tree comprises one or more relational data models, each relational data model is represented by a new root in the field tree, each relational data model is derived from a database schema corresponding to a database schema for a database that is used in the runtime environment, each field tree comprises a certain number of relational data models, the runtime environment comprises a certain number of databases, and the certain number of relational data models in the field tree corresponds to the certain number of databases in the runtime environment;

wherein the design composer is used to create designs using the field trees created by the field composer and provides an ability to create frames for use across multiple pages;

wherein the fields selected by the user with the field composer are displayed in a field tree window of the design composer;

wherein the user creates a page of an automated business system by selecting fields from the field tree window and placing them onto a canvas;

wherein a design is a partial or complete configuration of a software application;

wherein the design repository stores the designs, the field trees, and the relational data models created by the field composer;

wherein the persistence layer allows the central server to communicate with the database(s) in the runtime environment and translates data entered by the user into the automated business system back to the database(s);

wherein after the data modeling standard is used to automatically infer the structure of the database schema of the database corresponding to the relational data model created by the field composer, the relational data model is derived using a reverse engineering tool;

wherein the relational data model is updated by updating the database schema from which the relational data model is derived and recreating the relational data model to include changes to the database schema;

wherein the system automatically generates all database interactions based on fields placed on a page by the user and allows users to define individual page layout, page groupings, and page navigation;

wherein a customer database has a native database query format, and wherein the persistence layer translates the data entered by an end user to the native database query format of the customer database;

wherein the relational data models are derived from different types of databases;

wherein the persistence layer is an application programming interface that communicates with an object model persistence application programming interface; and

wherein the runtime environment provides for user permissions, and wherein the user permissions include permissions for accessing the application.

36. The method of claim 35, wherein a design comprises programmer-created pages, programmer-created frames, tool-created pages, and/or tool-created frames.

37. The method of claim 35, further comprising providing a client,

wherein the central server connects to the design repository and retrieves designs, field trees and relational data model(s) created by the field composer;

wherein the client displays in a runtime environment the software application that is created in the design composer; and

wherein an end user enters, edits and/or reviews data through the client using the software application that is created in the design composer.

38. The method of claim 37, wherein the customer database is used by the software application to store and retrieve data entered by the end user through the client.

39. The method of claim 35, wherein more than one relational data model is used per software application created in the design composer.

40. The method of claim 35, wherein a data modeling standard is used to automatically infer the structure of the database schema of the database corresponding to the relational data model created by the field composer.

41. The method of claim 40, wherein after the data modeling standard is used to automatically infer the structure of the database schema of the database corresponding to the relational data model created by the field composer, the relational data model is derived using a reverse engineering tool.

42. The method of claim 35, wherein the field composer comprises a data model view and a field view;

wherein each relational data model created by the field composer comprises fields;

wherein the data model view is automatically populated with the fields from the relational data model(s) created by the field composer; and

wherein to create a field tree in the field composer, a business user drags and drops data elements from the data model view to the field view of the field composer.

43. The method of claim 42, wherein the field tree created in the field composer and displayed in the field tree window of the design composer maps the data elements to one or more customer databases.

44. The method of claim 35, wherein the persistence layer is an application programming interface that communicates directly with one or more relational data models.

45. The method of claim 35, wherein the persistence layer is used within the field composer to create a hierarchical view of a relational data model.

46. The method of claim 45, wherein the hierarchical view of the relational data model is displayed in the data model view of the field composer.

47. The method of claim 35, wherein each relational data model created by the field composer comprises fields, and wherein the field composer allows business users to select relational data model(s) and specific fields from a relational data model for use on specific pages of the software application.

48. The method of claim 47, wherein the field composer comprises a data model view and a field view, wherein all available fields within a selected relational data model appear in the data model view of the field composer, and wherein the selected fields appear in the field view.

49. The method of claim 35, wherein a single field tree is created for each software application, and wherein the design composer is used to build the software application using the field tree that is created in the field composer.

50. The method of claim 35, wherein the software application comprises one or more pages, wherein each page comprises a visual display, and wherein the design composer is used to configure the visual display of the pages in the software application.

51. The method of claim 35, wherein the design composer comprises a properties window, a field tree window, a pages window, and a palette window.

52. The method of claim 51, wherein the design composer further comprises a frames window.

53. The method of claim 51, wherein the software application comprises one or more pages, and wherein the canvas is where business users design, build and modify the pages of the software application.

54. The method of claim 51, wherein the software application comprises one or more pages, wherein the pages comprise design elements, and wherein the properties window is used to format the design elements of the pages.

55. The method of claim 51, wherein the software application has a page flow, and wherein the page flow is defined in the properties window.

56. The method of claim 51, wherein the software application has a page flow, and wherein page flow is controlled by events on buttons that have been dragged and dropped onto the canvas from the palette window.

57. The method of claim 51, wherein the software application comprises one or more pages, and wherein the pages window is used to add, delete, modify and rename pages.

58. The method of claim 57, wherein the pages window allows a business user to add programmer-created pages to the software application.

59. The method of claim 51, wherein the software application comprises one or more pages, and wherein the palette window is used to add design elements to a page.

60. The method of claim 59, wherein the design elements that are added from the palette window are arranged and sized on the canvas.

61. The method of claim 51, wherein a user selects a button from the palette window, drags and drops the button onto the canvas, and selects an action from the properties window to apply to the button.

62. The method of claim 52, wherein the software application comprises one or more pages, and wherein the frames window is used to add one or more frames to a page.

63. The method of claim 62, wherein each frame comprises one or more design elements, and wherein when a design element in a frame is modified, the modification propagates to every place in a design in which the frame is used.

64. The method of claim 35, wherein the fields placed onto the canvas form a layout, and wherein the layout displayed on the canvas is identical to that which will appear to an end user in a runtime environment.

65. The method of claim 35, wherein when a design is completed, the design is saved to the design repository.

66. The method of claim 65, wherein modified designs are saved as new versions, and wherein both new and prior versions are available for use in the design composer.

67. The method of claim 35, wherein when a design is completed and ready to be run in a runtime environment, the design is deployed from the design repository to the central server.

68. The method of claim 35, wherein the designs, fields trees and relational data models that are stored in the design repository are shared across multiple platforms and between end users.

69. The method of claim 35, wherein the user permissions include permissions for accessing specific pages and permissions for accessing specific fields.