Database build for web delivery

• US 6,983,287 B1
• Filed: 01/29/2003
• Issued: 01/03/2006
• Est. Priority Date: 07/01/2002
• Status: Active Grant

• Current Assignee: Zhigu Holdings Limited
• Original Assignee: Microsoft Corporation
• Inventors: Jayanti, Harish, Anderson, Christopher W.
• Primary Examiner(s): Alam, Shahid Al
• Application Number:
  US10/355,654
• Time in Patent Office: 1,070 Days
• Field of Search: 707/4, 707/6, 707/10, 707/102, 707/101, 707/103.Y, 707/104.1, 705/39, 709/203, 709/246, 715/209, 715/513, 715/522, 715/530, 715/531, 715/532
• US Class Current: 1/1
• CPC Class Codes: G06F 16/48 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: Y10S 707/917 Text
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

Prestructuring disparate content data types prior to receiving any access requests to provide fast retrieval, assembly, and delivery of content data. Source content data are obtained from a source data structure that is readily created and editable by an author who does not have programming skills. The source content data are transformed into a predefined output structure that enables efficient access to the content data over a network. Predefined classes and entities of metadata indicate subsets of the content data that are deliverable and indicate relationships between elements of the content data. The content data and controlling metadata are preformatted for display and stored in fields of the output structure. The content data are also cross referenced by a plurality of categories within various areas of interest to create a hierarchical structure of interrelationships that is stored in the output structure, enabling a user to browse through related content data.

Claims

1. A method for transforming content data from a source structure that is readily created and editable by an author without requiring that the author have programming skills, into an output structure that enables efficient access of the content data, so that the content data can be quickly retrieved, delivered, and accessed over a network by a user in response to a search request, comprising the steps of:

(a) prior to receiving the search request, predefining the output structure to have a plurality of fields for storing portions of the content data that will be accessible by the user over the network in response to the search request;

(b) predefining metadata for the content data, said metadata indicating a subset of the content data that is deliverable over the network for access by the user and indicating relationships between elements of the content data;

(c) within the metadata, defining a plurality of entities and a plurality of classes of the content data, wherein each class of the plurality of classes indicates the portions of the content data that are to be included in the output structure, and wherein the plurality of entities defines format and delivery characteristics of individual content data items of the content data to be formatted in the output structure for access by the user;

(d) as a function of the metadata, determining in which fields of a plurality of fields of the output structure the portions of the content data are to be stored;

(e) obtaining the portions of the content data from the source structure in accord with the plurality of classes and the plurality of entities of the metadata; and

(f) storing the portions of the content data in the plurality of fields of the output structure as determined by the metadata.

2. The method of claim 1, further comprising the step of preformatting the portions of the content data in the output structure for access by the user.

3. The method of claim 1, wherein the content data comprises a plurality of content data items, and each content data item is identified by a reference identifier.

4. The method of claim 1, wherein the plurality of fields comprises at least one of:

(a) a class identifier field that stores an identifier of one of the plurality of classes;

(b) a main field that identifies other fields to be accessed for content of an individual content data item to be provided for access by the user;

(c) a text data field that stores text of a content data item, wherein the text is formatted for access by the user;

(d) a forward field that stores alternate content data related to a content data item, wherein the alternate content data are formatted for access by the user;

(e) a related articles field that stores a reference to a text article related to the content data item, if such a text article is available;

(f) an outline field that stores data defining an outline of a content data item, wherein said data are formatted for access by the user;

(g) an online free field that stores an indication of whether a content data item may be accessed by the user at no cost; and

(h) a title field that stores a title of a content data item, wherein the title is formatted for access by the user.

5. The method of claim 1, wherein the plurality of classes comprises at least one of an article class for text articles, a photo class for a photographs, a tables class for tables, a video class for moving visuals, a fact class for brief facts related to a content data item;

an image class for images, an audio class for audio media, a sidebar class for sidebar information, a weblink class for links to other content available through a network, a quotation class for notable quotations, an author class for author information, and a biography class for biographical information.

6. The method of claim 1, further comprising the step of determining where to place supplemental content within the content data.

7. The method of claim 1, further comprising the step of accessing a plurality of predefined areas of interest that subdivide the content data.

8. The method of claim 7, further comprising the steps of:

(a) associating at least one of the plurality of predefined areas of interest and at least one of a plurality of predefined categories with a selected portion of the content data; and

(b) storing the at least one of the plurality of predefined areas of interest, the at least one of the plurality of predefined categories, and the selected portion of the content data in a browse table to define a hierarchical structure that the user can access to retrieve the selected portion of the content data.

9. The method of claim 8, wherein the plurality of predefined areas of interest and the plurality of predefined categories are associated with the plurality of entities for each of the plurality of classes of the content data, thereby associating the plurality of predefined areas of interest and the plurality of predefined categories with individual content data items.

10. The method of claim 1, wherein the content data conforms to extensible Markup Language (XML) standards.

11. A memory medium having machine instructions stored thereon for carrying out the steps of claim 1.

12. A system for transforming content data from a source structure that is readily created and editable by an author without requiring that the author have programming skills, into an output structure that enables efficient access of the content data, so that the content data can be quickly retrieved, delivered, and accessed over a network by a user in response to a search request, comprising:

(a) a processor;

(b) a network interface in communication with the processor and enabling communication with a remote device operated by a user; and

(c) a memory in communication with the processor and storing machine instructions, said machine instructions causing the processor to carry out a plurality of functions, including;

(i) prior to receiving the search request, predefining the output structure to have a plurality of fields for storing portions of the content data that will be accessible by the user via the network interface in response to the search request;

(ii) accessing predefined metadata for the content data, said metadata indicating a subset of the content data that is deliverable via the network interface for access by a user and indicating relationships between elements of the content data;

(iii) within the metadata, defining a plurality of entities and a plurality of classes of the content data, wherein each class of the plurality of classes indicates the portions of the content data that are to be included in the output structure, and wherein the plurality of entities defines format and delivery characteristics of individual content data items of the content data to be formatted in the output structure for access by a user via the network interface;

(iv) as a function of the metadata, determining in which fields of a plurality of fields of the output structure the portions of the content data are to be stored;

(v) obtaining the portions of the content data from the source structure in accord with the plurality of classes and the plurality of entities of the metadata; and

(vi) storing the portions of the content data in the plurality of fields of the output structure as determined by the metadata.

13. The system of claim 12, wherein said machine instructions further cause the processor to carry out the function of preformatting the portions of the content data in the output structure for access by the user via the network interface.

14. The system of claim 12, wherein the content data comprises a plurality of content data items, and each content data item is identified by a reference identifier.

15. The system of claim 12, wherein the plurality of fields comprises at least one of:

(a) a class identifier field that stores an identifier of one of the plurality of classes;

(b) a main field that identifies other fields to be accessed for content of an individual content data item to be provided for access by the user;

(c) a text data field that stores text of a content data item, wherein the text is formatted for access by the user;

(d) a forward field that stores alternate content data related to a content data item, wherein the alternate content data are formatted for access by the user;

(e) a related articles field that stores a reference to a text article related to the content data item, if such a text article is available;

(f) an outline field that stores data defining an outline of a content data item, wherein said data are formatted for access by the user;

(g) an online free field that stores an indication of whether a content data item may be accessed by the user at no cost; and

(h) a title field that stores a title of a content data item, wherein the title is formatted for access by the user.

16. The system of claim 12, wherein the plurality of classes comprises at least one of an article class for text articles, a photo class for a photographs, a tables class for tables, a video class for moving visuals, a fact class for brief facts related to a content data item;

an image class for images, an audio class for audio media, a sidebar class for sidebar information, a weblink class for links to other content available through a network, a quotation class for notable quotations, an author class for author information, and a biography class for biographical information.

17. The system of claim 12, wherein said machine instructions further cause the processor to carry out the function of determining where to place supplemental content within the content data.

18. The system of claim 12, wherein said machine instructions further cause the processor to carry out the function of accessing a plurality of predefined areas of interest that subdivide the content data.

19. The system of claim 18, wherein said machine instructions further cause the processor to carry out the functions of:

(a) associating at least one of the plurality of predefined areas of interest and at least one of a plurality of predefined categories with a selected portion of the content data; and

(b) storing the at least one of the plurality of predefined areas of interest, the at least one of the plurality of predefined categories, and the selected portion of the content data in a browse table to define a hierarchical structure that a user can access via the network interface to retrieve the selected portion of the content data.

20. The system of claim 19, wherein the plurality of predefined areas of interest and the plurality of predefined categories are associated with the plurality of entities for each of the plurality of classes of the content data, thereby associating the plurality of predefined areas of interest and the plurality of predefined categories with individual content data items.