Method and apparatus for a report cache in a near real-time business intelligence system

• US 8,577,989 B2
• Filed: 06/14/2007
• Issued: 11/05/2013
• Est. Priority Date: 09/06/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Broda, Tal
• Primary Examiner(s): Dollinger, Tonia L
• Assistant Examiner(s): Murray, Daniel C
• Application Number:
  US11/763,134
• Publication Number:
  US 20080077656A1
• Time in Patent Office: 2,336 Days
• Field of Search: 709/217, 709/227, 705/7.11, 711/128, 714/748, 715/201
• US Class Current: 709/217
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: H04L 67/54 Presence management, e.g. monitoring or registration for receipt of user log-on information, or the connection status of the users
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54
• CPC Class Codes: H04L 67/5651 Reducing the amount or size of exchanged application data
• CPC Class Codes: H04L 67/568 Storing data temporarily at an intermediate stage, e.g. caching

Abstract

A method of optimizing the delivery of a set of data elements from a first device to a second device. The method includes retrieving from a data source the set of data elements, including a first subset of the set of data elements, a second subset of the set of data elements, and a third subset of the set of data elements. The method also includes transferring the first subset of the set of data elements to the second device. The method further includes selecting a fourth subset of the set of data elements, wherein the fourth subset can be comprised of data elements from the first subset and the second subset, or wherein the fourth subset can be comprised of data elements from the second subset and the third subset. The method also includes transferring a fourth subset of the set of data elements to the second device.

Claims

1. An apparatus for facilitating presentation of data on at least one client device, the apparatus comprising:

a first cache, communicatively coupled with an active data platform that supplies active data to the first cache, and configured to provide one or more datasets and one or more viewsets;

a second cache coupled to the first cache and configured to receive and store the one or more viewsets; and

a server coupled to the first cache and second cache, the server configured to;

receive the one or more datasets from the first cache and to receive the one or more viewsets from the second cache, the server further configured to convert at least a portion of the one or more datasets and the one or more viewsets into formatted data for dynamic rendering to an application of the at least one client device, the formatted data being forwarded to the at least one client device;

detect loss of a connection and subsequent reestablishment of the connection between the server and the at least one client device;

receive, from the at least one client device, a request for a last-forwarded formatted data; and

retransmit the last-forwarded formatted data to the at least one client device upon reestablishment of the connection based on retrieving data from the second cache,

wherein the one or more datasets represent one or more dynamic de-normalized representations of at least a first portion of the active data that correspond to one or more sequential elements that at least partially form a basis of a data stream, and

the one or more viewsets represent one or more static de-normalized representations of at least a second portion of the active data and include an initial snapshot of a recordset.

2. The apparatus of claim 1 wherein the one or more viewsets further include a plurality of periodic data updates.

3. The apparatus of claim 1 wherein the reestablishment of the connection between the server and the at least one client device is performed passively by the application of the at least one client device.

4. The apparatus of claim 1 wherein the first cache is coupled to a plurality of data sources.

5. The apparatus of claim 1 wherein the viewsets are stored as memory-mapped files.

6. The apparatus of claim 1 wherein the second cache is further configured to scale with a number of simultaneously opened viewsets on the at least one client device.

7. The apparatus of claim 1 wherein the server is further configured to scale with a number of users of the at least one client device.

8. The apparatus of claim 1 wherein the first cache is implemented using a forward-moving cursor scheme, and the second cache is configured for random access.

9. The apparatus of claim 1 wherein the second cache is implemented using an asynchronous I/O scheme.

10. The apparatus of claim 1 wherein at least one of the one or more datasets and the one or more viewsets are stored in files of a fixed size.

11. A method for facilitating presentation of data on at least one client device, the apparatus comprising:

transmitting one or more datasets from a first cache to a server, the first cache communicatively coupled with an active data platform that supplies active data to the first cache;

transmitting one or more viewsets from the first cache to a second cache storing the one or more viewsets in the second cache;

transmitting the one or more viewsets from the second cache to the server;

converting at least a portion of the one or more datasets and the one or more viewsets into formatted data for dynamic rendering to an application of the at least one client device; and

transmitting the formatted data to the at least one client device;

detecting loss of a connection and subsequent reestablishment of the connection between the server and the at least one client device;

receive, from the at least one client device, a request for a last-forwarded formatted data; and

retransmitting the last-forwarded formatted data to the at least one client device upon reestablishment of the connection based on retrieving data from the second cache,

wherein the one or more datasets represent one or more dynamic de-normalized representations of at least a first portion of the active data that correspond to one or more sequential elements that at least partially form a basis of a data stream, and

the one or more viewsets represent one or more static de-normalized representations of at least a second portion of the active data and include an initial snapshot of a recordset.

12. The method of claim 11 wherein the one or more viewsets further include a plurality of periodic data updates.

13. The method of claim 11 wherein the reestablishment of the connection between the server and the at least one client device is performed passively by an application running on the at least one client device.

14. The method of claim 11 further comprising coupling the first cache to a plurality of data sources.

15. The method of claim 11 wherein the viewsets are stored as memory-mapped files.

16. The method of claim 11 further comprising scaling the second cache according to a number of simultaneously opened viewsets on the at least one client device.

17. The method of claim 11 further comprising scaling the server according to a number of users of the at least one client device.

18. The method of claim 11 further comprising:

implementing the first cache using a forward-moving cursor scheme; and

configuring the second cache for random access.

19. The method of claim 11 further comprising implementing the second cache using an asynchronous I/O scheme.

20. The method of claim 11 further comprising storing at least one of the one or more datasets and the one or more viewsets in files of a fixed size.