Content management framework for use with a system for application development

• US 7,305,656 B2
• Filed: 02/14/2003
• Issued: 12/04/2007
• Est. Priority Date: 02/14/2002
• Status: Active Grant

• Current Assignee: Thomson Reuters Enterprise Centre GmbH (The Woodbridge Co. Ltd.)
• Original Assignee: Hubbard Feeds Incorporated
• Inventors: Gilchrist, Amy M., Wolf, Benjamin R., Hartley, Daniel A., Dorn, Matthew C., Wolf, Michael D., Fish, John D.
• Primary Examiner(s): Dam; Tuan
• Assistant Examiner(s): ROMANO, JOHN J
• Application Number:
  US10/367,261
• Publication Number:
  US 20030222906A1
• Time in Patent Office: 1,754 Days
• Field of Search: 717/105, 717/109, 717/121
• US Class Current: 717/105
• CPC Class Codes: G06F 8/20 Software design

Abstract

A dynamic data-modeling system and a content management framework combined into a high-level application development framework is disclosed. In one embodiment, the system for application development, comprises a data-modeling framework configured to enable a user to define a logical data model. The data-modeling framework dynamically translates the logical data model into a corresponding physical data model. The changes to the logical data model are automatically adjusted in the physical data model accordingly. A content management framework is coupled to the data-modeling framework. The content management framework is configured to provide tools to enable the user to manage content associated with the physical data model based on the logical data model.

Claims

1. A system for application development, comprising a processing unit which executes sequences of computer program instructions which are stored in a machine-readable storage memory, the instructions comprising:

a data-modeling framework configured to enable a user to define a logical data model, the data-modeling framework dynamically translating the logical data model into a corresponding physical data model, and to dynamically optimize the corresponding physical data model based on the defined logical data model, wherein changes to the logical data model are automatically adjusted in the physical data model accordingly in response to a command received from the user via the data modeling framework without having to invoke another database development framework external to the data modeling framework, such that the physical data model is automatically updated in response to the defined logical data model;

application framework integrated with the data modeling framework to enable the user to develop an enterprise application to access one or more databases represented by the physical data model, wherein the application framework is able to access the physical data model while the data modeling framework is able to substantially concurrently access the physical data model through the logical data model; and

a content management framework integrated with the data-modeling framework and the application framework, the content management framework configured to provide tools to enable the user to manage content developed via the application framework and associated with the physical data model based on the logical data model, wherein the content management framework includes

a data access layer to allow a user to generate an output query using one or more conditions, attribute bundles, and order information, wherein the output query is used to retrieve information stored in the system and information is returned in a data shape including a record set within another record set,

a data manipulation layer to allow the user to generate an update query using workflow information, history information, and one or more business rules, wherein the update query is used to create an interface for entering information into the system, and

a presentation layer having a content tool and a navigation unit, wherein the content tool is configured to provide content screens or presentation templates that include functionalities required to display a summary list of records being managed, wherein the navigation unit includes an interface to allow the user to build a navigation structure for the enterprise application without coding, wherein each navigation item is dynamically generated and linked to the update query, the output query, or a page, wherein the system automatically generates necessary code to manage and display the navigation structure, and

wherein updated features represented by the updated physical data model are automatically available to the user via the application framework or the content management framework, and wherein the enterprise application being developed using the application framework automatically reflects the updated features which can be manipulated via the content management framework.

2. The system of claim 1, wherein the enterprise application is a Web page used by a law firm, wherein the Web application comprises a first field for displaying information regarding one or more attorneys of the law firm, and a second field for displaying information regarding the law firm in general, wherein the information associated with the one or more attorneys and the law firm is stored in the one or more databases represented by the physical data model which is defined and manipulated via the logical data model using the data modeling framework, and wherein content of the Web page can be manipulated via the content management framework.

3. The system of claim 1, further comprising a security modeling framework that integrates workflow and navigation with access to the content being managed.

4. The system of claim 1, wherein the content management framework automatically generates code for displaying histories, summaries, edit screens, navigation, and workflow.

5. The system of claim 1, further comprising metadata that defines relationships between the logical data model and the physical data model.

6. The system of claim 5, wherein one or more text boxes, buttons, and drop-down lists on a GUI (graphical user interface) are dynamically generated based on a data type defined in the logical data model.

7. A method for use with an application development system, comprising:

providing a data-modeling framework configured to enable a user to define a logical data model, the data-modeling framework dynamically translating the logical data model into a corresponding physical data model, and to dynamically optimize the corresponding physical data model based on the defined logical data model, wherein changes to the logical data model are automatically adjusted in the physical data model accordingly in response to a command received from the user via the data modeling framework without having to invoke another database development framework external to the data modeling framework, such that the physical data model is automatically updated in response to the defined logical data model;

providing application framework integrated with the data modeling framework to enable the user to develop an enterprise application to access one or more databases represented by the physical data model, wherein the application framework is able to access the physical data model while the data modeling framework is able to substantially concurrently access the physical data model through the logical data model; and

providing a content management framework integrated with the data-modeling framework and the application framework, the content management framework configured to provide tools to enable the user to manage content developed via the application framework and associated with the physical data model based on the logical data model, wherein the content management framework includes

a data access layer to allow a user to generate an output query using one or more conditions, attribute bundles, and order information, wherein the output query is used to retrieve information stored in the system and information is returned in a data shape including a record set within another record set,

a data manipulation layer to allow the user to generate an update query using workflow information, history information, and one or more business rules, wherein the update query is used to create an interface for entering information into the system, and

a presentation layer having a content tool and a navigation unit, wherein the content tool is configured to provide content screens or presentation templates that include functionalities required to display a summary list of records being managed, wherein the navigation unit includes an interface to allow the user to build a navigation structure for the enterprise application without coding, wherein each navigation item is dynamically generated and linked to the update query, the output query, or a page, wherein the system automatically generates necessary code to manage and display the navigation structure, and

wherein updated features represented by the updated physical data model are automatically available to the user via the application framework or the content management framework, and wherein the enterprise application being developed using the application framework automatically reflects the updated features which can be manipulated via the content management framework.

8. The method of claim 7, wherein providing a content management framework comprises:

defining sets with one or more associated attributes;

defining relationships between the sets;

creating queries by selecting fields in a query display;

defining workflow stages associated with the queries; and

assigning one or more navigation items to the queries.

9. The method of claim 8, further comprising:

providing an editing/entry template that automatically generates an edit/entry screen for adding, editing, deleting, approving, resetting and saving content;

displaying an editing/entry screen;

providing a summary template that automatically generates a summary list containing content managed by the system;

displaying the summary list;

providing an edit-history template that automatically generates an edit-history screen; and

displaying the edit-history screen;

providing a workflow template that automatically generates a workflow screen;

displaying the workflow screen; and

updating the physical data model automatically.

10. The method of claim 9, further comprising providing a security modeling framework that integrates workflow and navigation with access to the content being managed.

11. The method of claim 10, wherein the content management framework automatically generates code for displaying the edit-history screen, the summary list, the editing/entry screen, and the workflow screen.

12. The method of claim 11, further comprising providing metadata that defines relationships between the logical data model and the physical data model.

13. The method of claim 12, wherein one or more text boxes, buttons, and drop-down lists on the edit-history screen, the summary list, the editing/entry screen, and the workflow screen are dynamically generated based on a data type defined in the logical data model.

14. A system for application development, comprising a processing unit which executes sequences of computer program instructions which are stored in a machine-readable storage memory, the instructions comprising:

means for data-modeling by enabling a user to define a logical data model, the data-modeling framework dynamically translating the logical data model into a corresponding physical data model, and to dynamically optimize the corresponding physical data model based on the defined logical data model, wherein changes to the logical data model are automatically adjusted in the physical data model accordingly in response to a command received from the user via the data modeling framework without having to invoke another database development framework external to the data modeling framework, such that the physical data model is automatically updated in response to the defined logical data model;

means for application development by integrating an application framework with the data modeling framework to enable the user to develop an enterprise application to access one or more databases represented by the physical data model, wherein the application framework is able to access the physical data model while the data modeling framework is able to substantially concurrently access the physical data model through the logical data model; and

means for content managing by providing tools to enable the user to manage content associated with the physical data model based on the logical data model, wherein the content managing means is coupled to the data-modeling means, wherein means for content managing includes

a data access layer to allow a user to generate an output query using one or more conditions, attribute bundles, and order information, wherein the output query is used to retrieve information stored in the system and information is returned in a data shape including a record set within another record set,

a data manipulation layer to allow the user to generate an update query using workflow information, history information, and one or more business rules, wherein the update query is used to create an interface for entering information into the system, and

a presentation layer having a content tool and a navigation unit, wherein the content tool is configured to provide content screens or presentation templates that include functionalities reciuired to display a summary list of records being managed, wherein the navigation unit includes an interface to allow the user to build a navigation structure for the enterprise application without coding. wherein each navigation item is dynamically generated and linked to the update query, the output query, or a page, wherein the system automatically generates necessary code to manage and display the navigation structure, and

wherein updated features represented by the updated physical data model are automatically available to the user via the means for application development or the means for content managing, and wherein the enterprise application being developed using the means for application development automatically reflects the updated features which can be manipulated via the means for content managing.

15. The system of claim 14, wherein the content management means:

means for defining sets with one or more associated attributes;

means for defining relationships between the sets;

means for creating queries by selecting fields in a query display;

means for defining workflow stages associated with the queries; and

means for assigning one or more navigation items to the queries.

16. The system of claim 15, further comprising:

means for providing an editing/entry template that automatically generates an edit/entry screen for adding, editing, deleting, approving, resetting and saving content;

means for displaying an editing/entry screen;

means for providing a summary template that automatically generates a summary list containing content managed by the system;

means for displaying the summary list;

means for providing an edit-history template that automatically generates an edit-history screen; and

means for displaying the edit-history screen;

means for providing a workflow template that automatically generates a workflow screen;

means for displaying the workflow screen; and

means for updating the physical data model automatically.

17. The system of claim 16, further comprising means for providing a security model that integrates workflow and navigation with access to the content being managed.

18. The system of claim 17, wherein the content management means automatically generates code for displaying the edit-history screen, the summary list, the editing/entry screen, and the workflow screen.

19. The system of claim 18, further comprising providing metadata that defines relationships between the logical data model and the physical data model.

20. The system of claim 19, wherein one or more text boxes, buttons, and drop-down lists on the edit-history screen, the summary list, the editing/entry screen, and the workflow screen are dynamically generated based on a data type defined in the logical data model.