INTEGRATED TRANSACTIONAL AND DATA WAREHOUSE BUSINESS INTELLIGENCE ANALYSIS SOLUTION

• US 20130073518A1
• Filed: 09/20/2011
• Published: 03/21/2013
• Est. Priority Date: 09/20/2011
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: German Bertot, Manish Srivastava, Suman Guha, Yu Lung Ng
• Inventors: SRIVASTAVA, Manish, BERTOT, German, GUHA, Suman, QUEK, Lee Hian, NG, Yu Lung, GLANVILLE, Jeff
• Application Number:
  US13/237,865
• Publication Number:
  US 20130073518A1
• Time in Patent Office: Days
• US Class Current: 707/607
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system, computer-implemented method, and computer program product for performing integrated transactional and data warehouse business intelligence analysis using a correlated report constructed from data correlations between current transactional data and historical data from a data warehouse. The method commences by retrieving a transactional data record from an online transactional processing (OLTP) system, the transactional data record comprising at least one OLTP business intelligence value of a particular business intelligence attribute, then receiving from a storage system, results of a query to a data warehouse, the results comprising a historical business intelligence value of the same business intelligence attribute. Modules within the system (e.g., a business intelligence application) perform processing to combine the OLTP business intelligence value with the historical business intelligence value to form a correlated report and transmit the correlated report for displaying on a single surface.

Claims

1. A computer-implemented method for performing integrated transactional and data warehouse business intelligence analysis, the method comprising:

retrieving a transactional data record from an online transactional processing (OLTP) system, the transactional data record comprising at least one OLTP business intelligence value of a first business intelligence attribute;

receiving, from a storage system, a result set of a query to a data warehouse, the result set comprising a historical business intelligence value of the first business intelligence attribute;

processing, in an application server, a business intelligence application, the business intelligence application to combine the OLTP business intelligence value with the historical business intelligence value to form a correlated report; and

displaying the correlated report on a single surface.

2. The method of claim 1, further comprising:

reformatting the correlated report to display at least one trend line, the trend line comprising at least one point being the OLTP business intelligence value, and at least one point being the historical business intelligence value.

3. The method of claim 1, further comprising:

reformatting the correlated report to display on a mobile device.

4. The method of claim 3, further comprising:

transmitting the reformatted correlated report to the mobile device.

5. The method of claim 1, further comprising:

caching the result set in a cache; and

using the cache to access at least one of, the OLTP business intelligence value, and the historical business intelligence value.

6. The method of claim 1, wherein receiving from a storage system comprises receiving from at least one of, a relational database, a cloud, and a storage device.

7. The method of claim 1, further comprising:

processing, in an application server, a business intelligence application, the business intelligence application to combine a second OLTP business intelligence value with a second historical business intelligence value to form a correlated report.

8. A computer system for performing integrated transactional and data warehouse business intelligence analysis, the computer system comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions, in which the program code instructions comprises program code,

to perform retrieving a transactional data record from an online transactional processing (OLTP) system, the transactional data record comprising at least one OLTP business intelligence value of a first business intelligence attribute;

to perform receiving, from a storage system, a result set of a query to a data warehouse, the result set comprising a historical business intelligence value of the first business intelligence attribute;

to perform processing, in an application server, a business intelligence application, the business intelligence application to combine the OLTP business intelligence value with the historical business intelligence value to form a correlated report; and

to perform displaying the correlated report on a single surface.

9. The computer system of claim 8, further comprising:

to perform reformatting the correlated report to display at least one trend line, the trend line comprising at least one point being the OLTP business intelligence value, and at least one point being the historical business intelligence value.

10. The computer system of claim 8, further comprising program code:

to perform reformatting the correlated report to display on a mobile device.

11. The computer system of claim 10, further comprising program code:

to perform transmitting the reformatted correlated report to the mobile device.

12. The computer system of claim 8, further comprising program code:

to perform caching the result set in a cache; and

to use the cache to access at least one of, the OLTP business intelligence value, and the historical business intelligence value.

13. The computer system of claim 8, wherein receiving from a storage system comprises receiving from at least one of, a relational database, a cloud, and a storage device.

14. The computer system of claim 8, further comprising program code:

to perform processing, in an application server, a business intelligence application, the business intelligence application to combine a second OLTP business intelligence value with a second historical business intelligence value to form a correlated report.

15. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method to implement integrated transactional and data warehouse business intelligence analysis, the method comprising:

retrieving a transactional data record from an online transactional processing (OLTP) system, the transactional data record comprising at least one OLTP business intelligence value of a first business intelligence attribute;

receiving, from a storage system, a result set of a query to a data warehouse, the result set comprising a historical business intelligence value of the first business intelligence attribute;

processing, in an application server, a business intelligence application, the business intelligence application to combine the OLTP business intelligence value with the historical business intelligence value to form a correlated report; and

displaying the correlated report on a single surface.

16. The computer program product of claim 15, further comprising:

instructions for reformatting the correlated report to display at least one trend line, the trend line comprising at least one point being the OLTP business intelligence value, and at least one point being the historical business intelligence value.

17. The computer program product of claim 15, further comprising:

instructions for reformatting the correlated report to display on a mobile device.

18. The computer program product of claim 17, further comprising:

instructions for transmitting the reformatted correlated report to the mobile device.

19. The computer program product of claim 15, further comprising:

instructions for caching the result set in a cache; and

instructions for using the cache to access at least one of, the OLTP business intelligence value, and the historical business intelligence value.

20. The computer program product of claim 15, wherein receiving from a storage system comprises receiving from at least one of, a relational database, a cloud, and a storage device.