System and method for serving pre-generated presentation views of requested data

• US 6,816,879 B1
• Filed: 12/02/2000
• Issued: 11/09/2004
• Est. Priority Date: 12/02/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Chang, Benjamin, Scardina, Mark, Kiritzov, Stefan
• Primary Examiner(s): Meky, Moustafa M.
• Application Number:
  US09/728,891
• Time in Patent Office: 1,438 Days
• Field of Search: 709/200, 709/201, 709/203, 709/217, 709/218, 709/219, 707/2, 707/3, 707/4, 707/102, 707/200
• US Class Current: 709/200
• CPC Class Codes: G06F 16/2393 Updating materialised views
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A system and method are provided for generating presentation views of data in advance of a request for, or an operation involving, the data. A trigger initiates the generation of a presentation view after the passage of a predetermined period of time, when the data is altered or replaced, or in response to some other recognizable situation or event. The amount of system resources (e.g., processor time, memory) expended to satisfy a request may thus be decreased in comparison to a system in which presentation views are generated each time data is retrieved. One trigger may apply to any number of data items and may employ different trigger criteria (e.g., time periods) for different items. Multiple presentation views (e.g., in different formats) may be generated for a data item so as to serve multiple types of devices. A trigger may be customized for a particular device or type of device, and its profile (e.g., how many presentation views are generated) may change over time.

Claims

1. A method of responding to a data request, the method comprising:

receiving at a first server a request for data;

querying a database containing said data;

retrieving a pre-generated presentation view of said data;

serving said presentation view in response to said request;

recognizing the passage of a pre-determined period of time;

generating an updated presentation view of said data, regardless of whether said data has changed; and

replacing said presentation view with said updated presentation view.

2. The method of claim 1, further comprising:

detecting a change made to said data;

generating an updated presentation view of said data; and

replacing said presentation view with said updated presentation view.

3. The method of claim 1, wherein said request is received from a browser and said presentation view is configured to be displayable by said browser.

4. The method of claims 3, wherein said request is formatted according to the Hypertext Transport Protocol and said presentation view is formatted according to Hypertext Markup Language.

5. A method of serving data, comprising:

maintaining a database containing data responsive to data requests;

in response to a time-based trigger, composing a presentation view of a first data item in said database;

storing said presentation view;

receiving a first request for said first data item;

retrieving said stored presentation view; and

serving said presentation view in response to said first request even if said presentation view of said first data item is stale.

6. The method of claim 5, wherein said time-based trigger comprises the passage of a period of time.

7. The method of claim 6, wherein said trigger comprises the passage of said period of time after a change in said first data item.

8. The method of claim 5, wherein said storing occurs before said receiving.

9. The method of claim 5, wherein said composing comprises formatting said first data item according to the Extensible Markup Language.

10. The method of claim 5, wherein said composing comprises formatting said first data item according to the Hypertext Markup Language.

11. The method of claim 5, wherein said composing comprises applying a style sheet to said first data item.

12. A database server, comprising:

a first database configured to store data items, wherein said database is searchable by queries;

a second database configured to store presentation views of said data items; and

a database engine configured to generate said presentation views in response to a time-based trigger;

wherein a first presentation view of a first data item is retrieved in response to a query configured to search said first database for said first data item.

13. The database server of claim 12, wherein said trigger comprises the passage of a predetermined period of time.

14. The database server of claim 13, wherein said trigger comprises the passage of said predetermined period of time after a change to said first data item.

15. The database server of claim 12, wherein said first database comprises said second database.

16. The database server of claim 12, wherein said database engine is configured to apply a style sheet to said first data item.

17. The database server of claim 12, wherein said presentation view is configured to be displayable by an originator of said query.

18. A server configured to serve data in response to data requests, comprising:

request means configured to receive a first request for a first data item stored in a database;

query means configured to query said database for said first data item;

retrieval means configured to receive a presentation view of said first data item in response to said query; and

response means configured to serve said presentation view in response to said first request even if said presentation view of said first data item is stale;

wherein said presentation view was generated prior to said receipt of said first request.

19. The server of claim 18, wherein said database and said presentation view are stored on a data server.

20. The server of claim 19, wherein said presentation view is replaced by an updated presentation view generated in accordance with a trigger.

21. The server of claim 20, wherein said trigger comprises the passage of a predetermined period of time.

22. The server of claim 20, wherein said trigger comprises a change to said first data item.

23. A computer readable storage medium storing instructions that, when executed by a computer, cause the computer to perform a method of responding to a data request, the method comprising:

maintaining a database containing data responsive to data requests;

in response to a time-based trigger, composing a presentation view of a first data item in said database;

storing said presentation view;

receiving a first request for said first data item;

retrieving said stored presentation view; and

serving said presentation view in response to said first request even if said presentation view of said first data item is stale.

24. A computer readable storage medium containing a data structure configured to store data to server in response to data requests, the data structure comprising:

a set of data items searchable in response to data requests; and

a presentation view of one of said data items, wherein said presentation view is generated according to a time-based trigger in anticipation of a data request for said one data item;

wherein said presentation view is configured to be displayable by an originator of said data request; and

said presentation view is displayable even if said presentation view of said one data item is stale.