Real time datamining

• US 8,874,502 B2
• Filed: 08/29/2008
• Issued: 10/28/2014
• Est. Priority Date: 08/29/2008
• Status: Active Grant

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Williamson, Eric J.
• Primary Examiner(s): Cao, Phuong Thao
• Application Number:
  US12/202,085
• Publication Number:
  US 20100057684A1
• Time in Patent Office: 2,251 Days
• Field of Search: 707/999.102, 707/603, 707/776
• US Class Current: 707/603
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: Y10S 707/956 Hierarchical

Abstract

A method and apparatus for real time datamining. In one embodiment, the method includes receiving a user request for datamining with respect to a value from a report associated with a specific pyramid level, identifying a datamining function to be performed for statistical analysis of lower level data pertaining to the value from the report, identifying dimensions to be used as variables for the statistical analysis, and determining criteria for selecting the lower level data associated with the value from the report. The method may further include submitting a request to one or more source databases, the request reflecting the identified dimensions and the determined criteria, performing the datamining function on a data set received from the source databases, and creating a datamining report based on a result of the performed datamining function.

Claims

1. A method comprising:

determining a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels;

identifying criteria for retrieving lower level data associated with a value from a first report corresponding to one of the plurality of pyramid levels;

submitting to a database, by a processing device, a request for a dataset, wherein the request is in view of the plurality of dimensions and the criteria;

receiving the dataset in response to the request;

applying to the dataset, by the processing device, a user-selected statistical function; and

creating, by the processing device, a second report in view of the user-selected statistical function.

2. The method of claim 1, wherein the user-selected statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

3. The method of claim 1, wherein determining the plurality of dimensions comprises:

displaying a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

displaying a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receiving a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

4. The method of claim 1, wherein the lower level data is transactional data from one or more a transactional database.

5. The method of claim 1, further comprising identifying, in view of a user input, the user-selected statistical function.

6. The method of claim 1 further comprising:

receiving a datamining request from a user;

in response to receiving the datamining request, determining whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notifying the user that the datamining is currently unavailable.

7. The method of claim 6 further comprising:

when the reporting system is currently linked to the database management system, determining whether any databases of the database management system are inactive; and

when any databases are inactive, blocking options associated with the inactive databases.

8. The method of claim 1 wherein the datamining request is a databases query or a database application programming interface (API) call.

9. The method of claim 1, wherein each of the plurality of dimensions is associated with a pyramid level.

10. The method of claim 1, wherein the reporting pyramid model comprises a top and a bottom, the top of the pyramid comprising a lesser amount of detail than the bottom of the pyramid.

11. A system comprising:

a memory to store a first report and a second report; and

a processing device to;

determine a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels,

identify criteria for retrieving lower level data associated with a value from the first report corresponding to one of the plurality of pyramid levels,

submit a request for a dataset to a database, wherein the request is in view of the plurality of dimensions and the criteria,

receive the dataset in response to the request,

apply to the dataset a user-selected statistical function, and

create the second report in view of the user-selected statistical function.

12. The system of claim 11, wherein the user-selected statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

13. The system of claim 11, wherein when determining the plurality of dimensions, the processing device is to:

display a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

display a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receive a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

14. The system of claim 11, wherein the processing device is further to:

receive a datamining request from a user;

in response to receiving the datamining request, determine whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notify the user that datamining is currently unavailable.

15. A non-transitory computer readable storage medium including instructions that, when executed by a processing device, cause the processing device to perform operations comprising:

determining a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels;

identifying criteria for retrieving lower level data associated with a value from a first report corresponding to one of the plurality of pyramid levels;

submitting to a database, by the processing device, a request for a dataset, wherein the request is in view of the plurality of dimensions and the criteria;

receiving the dataset in response to the request;

applying to the dataset by the processing device, a user-selected statistical function; and

creating, by the processing device, a second report based on the statistical function.

16. The non-transitory computer readable storage medium of claim 15, wherein the statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

17. The non-transitory computer readable storage medium of claim 15, wherein determining the plurality of dimensions comprises:

displaying a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

displaying a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receiving a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

18. The non-transitory computer readable storage medium of claim 15, wherein the lower level data is transactional data from a transactional database.

19. The non-transitory computer readable storage medium of claim 15, wherein the operations further comprise:

receiving a datamining request from a user;

in response to receiving the datamining request, determining whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notifying the user that datamining is currently unavailable.

20. The non-transitory computer readable storage medium of claim 19, wherein the operations further comprise:

when the reporting system is currently linked to the database management system, determining whether any databases of the database management system are inactive; and

when any of the databases are inactive, blocking options associated with the inactive databases.