Dynamic publication of information from a database

• US 7,962,844 B2
• Filed: 09/10/2007
• Issued: 06/14/2011
• Est. Priority Date: 10/25/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Dunn-Ballinger, Robert, Knotz, Christopher J., Everhart, Dan, Landon, Thomas R., Lachance, Scott
• Primary Examiner(s): Hutton; Doug
• Assistant Examiner(s): Hillery; Nathan
• Application Number:
  US11/852,872
• Publication Number:
  US 20070299853A1
• Time in Patent Office: 1,373 Days
• Field of Search: 715/522, 715/517, 715/513
• US Class Current: 715/209
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Systems and methods for electronic management can be configured so that content is stored apart from the information for formatting the content. A data structure for the content may be initially defined, and content items may be stored in the data structure. Formatting information may be stored separately from the content in the form of a template. To publish formatted content, the stored content may be merged with the template. Specialized tags may be included in the template to permit added publishing functionality. In this manner, the system can easily manage large volumes of content and deliver the content to a variety of specialized target devices.

Claims

1. An integrated and modular content and format handling publishing system comprising a computer network including various sites connected by communication links, and various corresponding storage devices having computer-readable code embodied therein, including the following program components:

(a) a content handling program component, comprising

(i) a content definition editor that receives a content definition including one or more data types and one or more parameters for each data type, and being based on one or more content item properties each having an assigned ID and property type and being generated for each property in accordance with the property type and a property action;

(ii) a data structure generator that produces a content data structure, the content data structure corresponding to the content definition;

(iii) a content item editor that receives content item information, handles each said content item property, and provides the content item information for storage in the content data structure, and in connection with a same content item, the content definition editor and the content item editor are configured for implementation on a display in one or more network browser windows;

(b) a format handling program component, comprising a template editor that generates formatting information for the content item information and stores the formatting information separately from the content item information;

(c) a publisher program component that generates a formatted output based on a combination of the separately stored content item information and formatting information; and

(d) a workflow system component for managing created content items for routing them each to one or more of various sources based on at least one of enumeration properties of the content items, workflow metadata defining properties of the content items to be tracked, and content search results, and

(e) wherein a particular content item is published by the publisher program component according to a set of predetermined publication criteria.

2. The system of claim 1, wherein the content definition editor

provides a blank content definition form to a user and receives the content definition from the user, and the data structure generator automatically produces the content data structure based on the content definition entered by the user.

3. The system of claim 1, wherein the content item editor provides a content item form to a user, the form corresponding to the content data structure and accepting content items that correspond to the content data structure.

4. The system of claim 1, wherein the content item and the formatting information are stored in separate databases.

5. The system of claim 1, wherein the content items are stored in the same database as the formatting information.

6. The system of claim 1, wherein the content definition editor permits the content data structure to be changed after the content data structure has been created and after one or more content items have been stored in the content data structure.

7. The system of claim 1, wherein the content item editor is accessible through a naked web browser.

8. The system of claim 7, wherein the content item editor is accessible through a public internet kiosk.

9. The system of claim 1, wherein the content item editor is accessible through a personal wireless device.

10. The system of claim 1, wherein the content definition editor, the content item editor, and the template editor are each accessible through a naked web browser.

11. The system of claim 1, wherein the template editor comprises a file import program component that receives the formatting information and transforms the formatting information into a form that is compatible with the system.

12. The system of claim 1, wherein the workflow system is managed by one or more enumeration properties, workflow data or content searches in a manner depending on said content definition, said content item information, a choice made by a content creator, or by rules, or combinations thereof.

13. The system of claim 1, wherein the publication criteria are generated automatically in response to parameters that are accessed from outside the system.

14. The system of claim 1, wherein the content item information refers to two or more different content items, thereby producing one or more links between the content items.

15. The system of claim 1, wherein the content item information is stored in multiple databases and is consolidated by the publisher.

16. A method of publishing formatted content including separately handling and formatting the content using a computer network including various sites connected by communication links, and various corresponding storage devices having computer-readable code embodied therein, the method comprising:

(a) providing a content handling program component for

(i) providing content definition parameters to a content definition editor that are based on one or more content item properties each having an assigned ID and types and each being generated in accordance with the property type and a property action;

(ii) producing a content data structure in a database corresponding to the content definition parameters; and

(iii) providing content item information to the content data structure, the content item information representing an instance of content that corresponds to the content definition parameters, and in connection with a same content item, the content definition parameters and the content item information are viewable on a display in one or more network browser windows; and

(b) providing a format handling program component for

(iv) generating and storing formatting information separately from the content item information;

(c) providing a publisher program component for

(v) consolidating multiple portions of content item information that are respectively stored in multiple databases; and

(vi) publishing the content item information by combining the content item information and formatting information so as to present the content item information in a formatted manner; and

(d) providing a workflow system component for

(vii) managing created content items for routing them each to one or more of various sources based on at least one of enumeration properties of the content items, workflow metadata defining properties of the content items to be tracked, and content search results, and

(viii) controlling when a particular content item is published by the published program component according to a set of predetermined publication criteria.

17. The method of claim 16, further comprising providing a hyperlink between a first set of content item information and a second set of content item information.

18. One or more processor readable storage devices having processor readable code embodied thereon, said processor readable code for programming one or more processors to perform a method of publishing formatted content including separately handling and formatting the content using a computer network including various sites connected by communication links, and various corresponding storage devices having computer-readable code embodied therein, the method comprising:

(i) providing content definition parameters to a content definition editor that are based on one or more content item properties each having an assigned ID and types and each being generated in accordance with the property type and a property action;

(ii) producing a content data structure in a database corresponding to the content definition parameters; and

(iii) providing content item information to the content data structure, the content item information representing an instance of content that corresponds to the content definition parameters, and in connection with a same content item, the content definition parameters and the content item information are viewable on a display in one or more network browser windows; and

(iv) generating and storing formatting information separately from the content item information;

(v) consolidating multiple portions of content item information that are respectively stored in multiple databases; and

(vi) publishing the content item information by combining the content item information and formatting information so as to present the content item information in a formatted manner; and

(vii) managing created content items for routing them each to one or more of various sources based on at least one of enumeration properties of the content items, workflow metadata defining properties of the content items to be tracked, and content search results;

(viii) controlling when a particular content item is published according to a set of predetermined publication criteria.

19. The one or more storage devices of claim 18, wherein the method further comprises providing a hyperlink between a first set of content item information and a second set of content item information.

20. A method of operating an integrated and modular content and format handling publishing system using a computer network including various sites connected by communication links, and various corresponding storage devices having computer-readable code embodied therein, the method comprising:

(a) handling content with a content handling program component, comprising;

(i) providing content definition information that is based on one or more content item properties each having an assigned ID and property type and each being generated in accordance with the property type and a property action, and automatically producing a content data structure based on the content definition information,

(ii) entering content item information to an input form that corresponds to the content definition information,

(iii) submitting the content item information to a database, and in connection with a same content item, the content definition information and the content item information are viewable on a display in one or more network browser windows, and

(iv) handling each said content item property;

(b) handling formatting with a format handling program component, comprising generating formatting information for the content item information and storing the formatting information separately from the content item information, and

(c) with a publisher program component, publishing the content item information to an electronic medium by combining the separately stored content item information and content format information; and

(d) a workflow system component for managing created content items for routing them each to one or more of various sources based on at least one of enumeration properties of the content items, workflow metadata defining properties of the content items to be tracked, and content search results,

(e) with a publication scheduler, controlling when a particular content item is published by the publisher according to a set of predetermined publication criteria.

21. A method as in claim 20, wherein the providing of content definition information comprises (i) accessing a naked web browser, (ii) selecting a predefined content definition, and wherein the publishing of content item information comprises (iii) combining the content item information with a predefined template so that the content item information is published in a formatted manner.

22. One or more processor readable storage devices having processor readable code embodied thereon, said processor readable code for programming one or more processors to perform a method of operating an integrated and modular content and format handling and publishing system, the method comprising:

(a) handling content with a content handling program component, comprising;

(i) providing to a tabular form content definition information that are based on a list of one or more content item properties having assigned IDs and types and that are generated for each property in accordance with a property type and a property action, and automatically producing a content data structure based on the content definition information,

(ii) entering content item information to an input form that corresponds to the content definition information,

(iii) submitting the content item information to a database, and in connection with a same content item, the content definition information and the content item information are viewable on a display in more than one separate network browser windows, and

(iv) handling each said content item property; and

(b) with a format handling program component, generating content format information for the content item information and storing the content format information, and

(c) with a publisher program component, publishing the content item information to an electronic medium by combining the content item information with the content format information; and

(d) with a workflow system component, managing created content items for routing them each to one or more of various sources based on at least one of enumeration properties of the content items, workflow metadata defining properties of the content items to be tracked, and content search results,

(e) with a publication scheduler, controlling when a particular content item is published by the publisher according to a set of predetermined publication criteria.

23. The one or more storage devices of claim 22, wherein the providing of content definition information comprises (i) accessing a naked web browser, (ii) selecting a predefined content definition, and wherein the publishing of content item information comprises (iii) combining the content item information with a predefined template so that the content item information is published in a formatted manner.

24. The one or more storage devices of claim 22, wherein the workflow system component itself is managed by one or more of enumeration properties, workflow data or content searches in a manner depending on at least one of said content definition, said content item information, and a choice made by a content creator, or by rules.

25. The one or more storage devices of claim 22, wherein the formatting information comprises extensible mark-up language (XML) fragments.