Business intelligence performance analysis system

• US 9,183,529 B2
• Filed: 08/01/2012
• Issued: 11/10/2015
• Est. Priority Date: 08/01/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Gluzman Peregrine, Vladimir, Popp, John Benjamin, Ishikawa, Leigh, Furtado, Jason, Michaylov, Spiro, Albright, Richard Lawrence, Haque, Mohammad, Zhu, Tianyu
• Primary Examiner(s): Richardson, James E
• Application Number:
  US13/564,192
• Publication Number:
  US 20140040306A1
• Time in Patent Office: 1,196 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A performance analysis system that analyzes the performance of a business intelligence analytics application is provided. The performance analysis system logs data associated with one or more queries of a database within the database. The performance analysis system further generates performance data based on an analysis of the logged data, where the performance data includes data associated with one or more performance metrics of each query. The performance analysis system further generates one or more performance queries of the performance data, where a response to each performance query includes at least a portion of the one or more performance metrics stored within the database.

Claims

1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to analyze a performance of a business intelligence analytics application, the instructions comprising:

receiving one or more queries from a user of the business intelligence analytics application;

generating, a response to each business intelligence analytics application query, wherein each response comprises a record from the intelligence analytics application that includes one or more attributes stored within a database, and wherein each query is associated with a user, a modular component, and an action;

in response to the receipt of the one or more queries from the user, automatically;

logging data associated with each of the one or more queries within the database, wherein the logged data comprises the user, the modular component, and the action;

generating performance data based on an analysis of the logged data, wherein the performance data comprises data associated with one or more performance metrics of each query, and wherein the performance data is stored within one of the database or a second database;

generating one or more performance queries of the performance data, wherein a response to each performance query comprises at least a portion of the one or more performance metrics stored within the database; and

delivering the portion of the one or more performance metrics to the user.

2. The computer-readable medium of claim 1, wherein each of the logged data and the performance data further comprises at least one query of the one or more queries, the instructions further comprising:

re-executing at least one query of the one or more queries included within the performance data against the database; and

providing additional performance data not previously presented in the portion of the one or more performance metrics.

3. The computer-readable medium of claim 2, wherein the at least one query is stored in an extensible markup language format.

4. The computer-readable medium of claim 2, wherein each of the logged data and the performance data further comprises, for each query of the at least one query, a query arrival time and a query completion time.

5. The computer-readable medium of claim 1, wherein the database comprises a hybrid search-analytical database.

6. The computer-readable medium of claim 5, wherein the hybrid search-analytical database comprises a plurality of records, and wherein each record comprises its own self-describing schema.

7. The computer-readable medium of claim 1, wherein the performance data is aggregated by at least one of:

query, modular component, action, or user session.

8. The computer-readable medium of claim 1, wherein the one or more performance metrics comprise, for each query of the one or more queries, at least one of:

query time, system utilization, system contention, percentage of system used, or query content.

9. The computer-readable medium of claim 1, wherein the logged data further comprises metadata associated with at least one query of the one or more queries.

10. The computer-readable medium of claim 9, wherein the metadata comprises at least one of:

a hypertext transfer protocol header, a percentage of data stores that were selected, one or more attributes related to the data stores, or one or more threads used to complete at least one query of the one or more queries.

11. A computer-implemented method for analyzing a performance of a business intelligence analytics application, the computer-implemented method comprising:

receiving one or more queries from a user of the business intelligence analytics application;

generating a response to each business intelligence analytics application query, wherein each response comprises a record from the intelligence analytics application that includes one or more attributes stored within a database, and wherein each query is associated with a user, a modular component, and an action;

logging data associated with each of the one or more queries within the database, wherein the logged data comprises the user, the modular component, and the action;

in response to the receipt of the one or more queries from the user, automatically;

generating performance data based on an analysis of the logged data, wherein the performance data comprises data associated with one or more performance metrics of each query, and wherein the performance data is stored within one of the database or a second database;

generating one or more performance queries of the performance data, wherein a response to each performance query comprises at least a portion of the one or more performance metrics stored within the database; and

delivering the portion of the one or more performance metrics to the user.

12. The computer-implemented method of claim 11, wherein each of the logged data and the performance data further comprises at least one query of the one or more queries, the method further comprising:

re-executing at least one query of the one or more queries included within the performance data against the database; and

providing additional performance data not previously generated.

13. The computer-implemented method of claim 11, wherein each of the logged data and the performance data further comprises, for each query of the at least one query, a query arrival time and a query completion time.

14. The computer-implemented method of claim 11, wherein the performance data is aggregated by at least one of:

query, modular component, action, or user session.

15. The computer-implemented method of claim 11, wherein the one or more performance metrics comprise, for each query of the one or more queries, at least one of:

query time, system utilization, system contention, percentage of system used, or query content.

16. A performance analysis system, comprising:

a processor;

a query receiving module configured to receive one or more queries from a user of the business intelligence analytics application, that generates a response to each business intelligence analytics application query, wherein each response comprises a record from the intelligence analytics application that includes one or more attributes stored within a database, and wherein each query is associated with a user, a modular component, and an action;

a logging module configured to log in response to the receipt of the one or more queries from the user, data associated with each of the one or more queries within the database, wherein the logged data comprises the user, the modular component, and the action;

a performance module configured to generate, in response to the receipt of the one or more queries from the user, performance data based on an analysis of the logged data, wherein the performance data comprises data associated with one or more performance metrics of each query, and wherein the performance data is stored within one of the database or a second database;

a performance query module configured to generate, in response to the receipt of the one or more queries from the user, one or more performance queries of the performance data, wherein a response to each performance query comprises at least a portion of the one or more performance metrics stored within the database; and

delivering the portion of the one or more performance metrics to the user.

17. The performance analysis system of claim 16, wherein each of the logged data and the performance data further comprises at least one query of the one or more queries, the performance analysis system further comprising:

a query execution module configured to re-execute at least one query of the one or more queries included within the performance data against the database and to provide additional performance data not previously generated.

18. The performance analysis system of claim 16, wherein each of the logged data and the performance data further comprises, for each query of the at least one query, a query arrival time and a query completion time.

19. The performance analysis system of claim 16, wherein the performance data is aggregated by at least one of:

query, modular component, action, or user session.

20. The performance analysis system of claim 16, wherein the one or more performance metrics comprise, for each query of the one or more queries, at least one of:

query time, system utilization, system contention, percentage of system used, or query content.