Multidimensional dataset query processing

• US 9,646,072 B2
• Filed: 03/03/2014
• Issued: 05/09/2017
• Est. Priority Date: 03/03/2013
• Status: Active Grant

• Current Assignee: Panorama Software Limited
• Original Assignee: Panorama Software Limited
• Inventors: Averbuch, Yaacov
• Primary Examiner(s): Stevens, Robert
• Application Number:
  US14/194,827
• Publication Number:
  US 20140250053A1
• Time in Patent Office: 1,163 Days
• Field of Search: 707600, 707748, 707722, 707737
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method of processing a query. The method comprises providing at least one multidimensional dataset having at least three dimensions formed according to a plurality of data tables associating between a plurality of persons and a plurality of roles and comprising a plurality of cells, receiving a query defining at least one factual value coordinated by at least one of the plurality of cells, the at least one factual value representing a measure defined in at least one of the plurality of data tables, deriving at least one person from the plurality of persons, the at least one person being associated with the with multidimensional dataset with the at least one cell, and outputting an indication of the at least one person in response to the query.

Claims

1. A computer-implemented method for processing a query, comprising executing on a processor the steps of:

providing at least one multidimensional dataset comprising at least one online analytical processing (OLAP) cube and having at least three dimensions formed according to a plurality of data tables and comprising a plurality of cells, said plurality of data tables associating between a plurality of persons and a plurality of roles;

receiving a query defining at least one factual value, said at least one factual value representing a measure defined in at least one of said plurality of data tables;

searching through said at least one multidimensional dataset to identify at least one cell of said plurality of cells, coordinating said at least one factual value;

identifying at least person from said plurality of persons in said at least one multidimensional dataset, said at least one person being associated with said at least one cell coordinating said at least one factual value; and

outputting an indication of said at least one person in response to said query.

2. The method of claim 1, further comprising deriving at least one another person from said plurality of persons, said at least one another person being associated with said multidimensional dataset with said at least one cell;

and further comprising

outputting an indication of said at least one another person in response to said query.

3. The method of claim 2, wherein said outputting comprises presenting said at least one person and said at least one another person as points in a diagram to demonstrate a relative contribution of each said at least one person and said at least one another person to said at least one factual value.

4. The method of claim 2, wherein said deriving at least one person comprises calculating per each said person a trend representing a relative contribution of a respective said person to said at least one factual value in relation to said at least one another person.

5. The method of claim 1, wherein said receiving comprises monitoring said plurality of cells during a monitoring period to identify when said at least one cell coordinates said at least one factual value and forwarding at least one notification to at least one user in response to said identification.

6. The method of claim 5, wherein said at least one person comprises a person having a predefined role, said at least one notification being forwarded to said at least one user.

7. The method of claim 1, wherein said outputting comprises establishing a communication connection between a user and said at least one person.

8. The method of claim 1, wherein said outputting comprises acquiring data pertaining to said at least person and adding said data to said indication.

9. A non-transitory computer readable medium comprising computer executable instructions adapted to perform the method of claim 1.

10. A computer-implemented method for monitoring a multidimensional dataset, comprising executing on a processor the steps of:

providing at least one rule which defines at least one of a value threshold, a value trend threshold, and a value range;

scanning a plurality of cells of at least one multidimensional dataset comprising at least one online analytical processing (OLAP) cube and having at least three dimensions formed according to a plurality of data tables, said plurality of data tables associating between a plurality of persons and a plurality of roles;

identifying a group of said plurality of cells which coordinate at least one value that complies with said at least one rule;

identifying at least one person associated with a plurality of members of said group of said plurality of cells; and

generating a notification indicating said at least one person.

11. The method of claim 10, wherein said scanning is performed iteratively.

12. The method of claim 10, further comprising forwarding said notification to said at least one person.

13. The method of claim 10 further comprising identifying at least one another person associated with said plurality of members of said group;

wherein said identifying at least one person comprises identifying for each said person a relative contribution of a respective said person to the compliance with said at least one rule in relation to another relative contribution of said at least one another person;

and further comprising

generating a notification indicative of said at least one another person.

14. The method of claim 13 wherein said at least one person and said at least one another person are at least one of ranked, scored and ordered according to said relative contribution.

15. The method of claim 10 further comprising identifying at least one another person associated with said plurality of members of said group;

further comprising presenting said at least one person and said at least another person as points in a diagram to demonstrate a relative contribution of each said persons to a compliance with said at least one rule; and

further comprising

generating a notification indicative of said at least one another person.

16. The method of claim 10, wherein each of said at least one of said value threshold, said value trend threshold and said value range is associated with at least one of an exceptional value, an irregular value, an anomaly and a desired value.

17. A system for processing a query, comprising:

a database which stores at least one multidimensional dataset comprising at least one online analytical processing (OLAP) cube and having at least three dimensions formed according to a plurality of data tables and comprising a plurality of cells, said plurality of data tables associating between a plurality of persons and a plurality of roles;

a user interface module installed in a client terminal and comprising executable code executed by said client terminal for receiving a query defining at least one factual value coordinated by at least one of said plurality of cells, said at least one factual value representing a measure defined in at least one of said plurality of data tables;

a server having a processor and a search module which uses said processor, wherein said search module comprising executable code executed by said processor for processing said at least one multidimensional dataset, for searching through said at least one multidimensional dataset to identify said at least one cell coordinating said at least one factual value and for identifying at least person from said plurality of persons in said at least one multidimensional dataset, said at least one person being associated with said at least one cell coordinating said at least one factual value; and

wherein said server forwards an indication of said at least one person to said client terminal in response to said query.

18. The system of claim 17 wherein said user interface module installed in said client terminal further comprising executable code executed by said client terminal for requesting for missing information associated with said at least one person from a directory services.