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

• US 20080046536A1
• Filed: 03/17/2003
• Published: 02/21/2008
• 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
• Granted Patent: US 7,899,879 B2
• Time in Patent Office: Days
• 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 forth subset of the set of data elements, wherein the forth subset can be comprised of data elements from the first subset and the second subset; or wherein the forth subset can be comprised of data elements from the second subset and the third subset. The method also includes transferring a forth subset of the set of data elements to the second device.

Claims

1-19. -19. (canceled)

20-39. -39. (canceled)

40. In a network including a first device coupled to a client device, said first device including a first cache and a second cache, a method of optimizing the delivery of a set of data elements from said first device to said client device, the method comprising:

retrieving from a data source within the network said set of data elements, including a first subset of said set of data elements, a second subset of said set of data elements, and a third subset of said set of data elements;

caching in the first cache the retrieved set of data elements, the first cache being optimized for sequential access;

determining a plurality of viewsets based on the retrieved set of data elements;

transferring said first subset of said set of data elements to said client device;

providing the plurality of viewsets to the second cache;

caching the plurality of viewsets in the second cache, the second cache being optimized for non-sequential access;

receiving a request from said client device for a fourth subset of the said set of data, in response to receiving the request;

selectively retrieving from said second cache a viewset of the plurality of viewsets corresponding to the fourth subset of said set of data elements, wherein said fourth subset is comprised of non-sequential data elements from at least two of said first subset of said set of data elements, said second subset of said set of data elements and said third subset of said set of data elements; and

transferring said viewset corresponding to the requested fourth subset to said client device.

41. The method of claim 40, where said client device includes a rich client.

42. The method claim 40, where said client device includes a web browser.

43. The method of claim 40, wherein said set of data elements further comprises DHTML.

44. The method of claim 40, wherein said set of data elements further comprises XML.

45. The method of claim 40, wherein said set of data elements further comprises active data.

46. The method of claim 45, wherein said active data includes datasets and viewsets.

47. The method of claim 40, wherein said network further comprises a packet network.

48. The method of claim 40, wherein said network further comprises a wireless network, and the method further comprising:

verifying if the transfer of said viewset corresponding to the requested fourth subset to said client device has completed; and

retransferring said viewset corresponding to the requested fourth subset if the transfer to the client device was not completed.

49. An apparatus for optimizing the delivery of a set of data elements in a network, comprising:

a processor for determining a plurality of viewsets based on the set of data elements;

a first device having a first cache for storing a first subset of said set of data elements, a second subset of said set of data elements, and a third subset of said set of data elements, wherein said first subset, said second subset and said third subset are retrieved from a data source, and a second cache for storing the plurality of viewsets, the first cache optimized for sequential access and the second cache optimized for non-sequential access;

a client device; and

a network connection for coupling said first device to said client device, wherein upon request by said client device for a fourth subset of the said set of data, said first device selectively retrieves from said second cache a viewset of the plurality of viewsets corresponding to the fourth subset of said set of data elements, wherein said fourth subset is comprised of non-sequential data elements from at least two of said first subset of said set of data elements, said second subset of said set of data elements and said third subset of said set of data elements; and

said first device transfers said viewset corresponding to the requested fourth subset to said client device.

50. The apparatus of claim 49, where said client device includes a rich client.

51. The apparatus of claim 49, where said client device includes a web browser.

52. The apparatus of claim 49, wherein said set of data elements further comprises DHTML.

53. The apparatus of claim 49, wherein said set of data elements further comprises XML.

54. The apparatus of claim 49, wherein said set of data elements further comprises active data.

55. The apparatus of claim 54, wherein said active data includes datasets and viewsets.

56. The apparatus of claim 49, wherein said network further comprises a packet network.

57. The apparatus of claim 49, wherein said network further comprises a wireless network, and wherein said first device verifies if the transfer of said viewset corresponding to the requested fourth subset to said client device has completed, and said first device retransfers said viewset corresponding to the requested fourth subset if the transfer to the client device was not completed.