Data analysis engine

• US 9,690,840 B2
• Filed: 07/22/2014
• Issued: 06/27/2017
• Est. Priority Date: 07/23/2013
• Status: Active Grant

• Current Assignee: Aware Incorporated (Crowley Holdings Preferred LLC)
• Original Assignee: Aware Incorporated (Crowley Holdings Preferred LLC)
• Inventors: Cialdea, Jr., James Giulio, Liu, Boshu
• Primary Examiner(s): Boccio, Vincent F
• Application Number:
  US14/337,650
• Publication Number:
  US 20150032730A1
• Time in Patent Office: 1,071 Days
• Field of Search: 707722, 707805
• 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: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system and method of analyzing data receives a user-specified selection of a data source, a user-specified selection of a type of data representation, and a user-specified description of a view to be constructed in accordance with the user-specified selection of the type of data representation. An application program interface (API) function generates a multidimensional query based on the user-specified type of data representation and the user-specified description of the view to be constructed, and submits the multidimensional query to the an On-line Analytical Processing (OLAP) server. The application program interface (API) function receives a multidimensional response from the OLAP server containing results acquired by the multidimensional query of the data source, and generates the view based on the results contained in the multidimensional response and in accordance with the user-specified selection of the type of data representation and the user-specified description of the view.

Claims

1. A method of analyzing biometric or medical data, comprising:

receiving a user-specified selection of a data source, the data source including the biometric or medical data;

receiving a user-specified selection of a type of data representation;

receiving a user-specified description of a view to be constructed in accordance with the user-specified selection of the type of data representation;

generating, by an application program interface (API) function and processor, a multidimensional query based on the user-specified type of data representation and the user-specified description of the view to be constructed;

submitting, by the API function, the multidimensional query to an On-line Analytical Processing (OLAP) server for searching the data source;

receiving, by the application program interface (API) function and processor, a multidimensional response from the OLAP server containing results acquired by the multidimensional query of the data source;

simplifying, by the application program interface (API) function and processor, the multidimensional response, the simplifying of the multidimensional response including the API function mapping dimensional modeling terminology of the multidimensional response into non-multidimensional terminology understood by a user interface, the simplified multidimensional response including at least one reference level corresponding to a target region in the biometric or medical data, the at least one reference level not being a part of the multidimensional space and defined by a reference level set which identifies a cube with which a particular reference level is associated, a set of members that need to be matched for the at least one reference value to apply and a reference level value; and

generating the view, for display on the user interface, based on the results contained in the simplified multidimensional response and in accordance with the user-specified selection of the type of data representation and the user-specified description of the view, the view further including the at least one reference level for a query response that matches a cell.

2. The method of claim 1, wherein the user-specified selection of a type of data representation includes one or more of a pie chart, histogram, bar chart, line chart, donut chart, or table.

3. The method of claim 1, wherein the user-specified description of the view to be constructed includes one or more measures selected for presentation and one or more group dimensions for grouping values associated with the selected measures.

4. The method of claim 1, further comprising:

determining that a reference level is available for a user-specified description of the view; and

presenting the reference level with the search results within the presented view.

5. The method of claim 1, further comprising defining a schema with a set of cubes, each cube defining one or more dimensions and one or more measures, at least one measure of a given cube being represented multiple times in the given cube, each representation corresponding to a different possible aggregation of that measure.

6. The method of claim 1, further comprising providing a configuration file that defines a basic unit of a cube for use generating histograms and a measure that provides the basic unit.

7. The method of claim 1, further comprising calculating a table of related results for use in constructing line chart and bar chart data representations.

8. The method of claim 1, further comprising calculating proportions of a total amount for use in constructing pie chart and donut chart data representations.

9. The method of claim 1, further comprising calculating a distribution of events in a cube for use in a histogram.

10. Computer program product for analyzing data, the computer program product comprising:

a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising;

computer readable program code that, if executed, receives a user-specified selection of a data source, the data source including the biometric or medical data;

computer readable program code that, if executed by a processor, receives a user-specified selection of a type of data representation;

computer readable program code that, if executed, receives a user-specified description of a view to be constructed in accordance with the user-specified selection of the type of data representation;

computer readable program code that, if executed, generates a multidimensional query based on the user-specified type of data representation and the user-specified description of the view to be constructed;

computer readable program code that, if executed, submits the multidimensional query to an On-line Analytical Processing (OLAP) server for searching the data source;

computer readable program code that, if executed, receives a multidimensional reply from the OLAP server containing results acquired by the multidimensional query of the data source;

simplifying, by the application program interface (API) function and processor, the multidimensional response, the simplifying of the multidimensional response including the API function mapping dimensional modeling terminology of the multidimensional response into non-multidimensional terminology understood by a user interface, the simplified multidimensional response including at least one reference level corresponding to a target region in the biometric or medical data, the at least one reference level not being a part of the multidimensional space and defined by a reference level set which identifies a cube with which a particular reference level is associated, a set of members that need to be matched for the at least one reference value to apply and a reference level value; and

computer readable program code that, if executed, generates the view, for display on the user interface, based on the results contained in the simplified multidimensional response and in accordance with the user-specified selection of the type of data representation and the user-specified description of the view, the view further including the at least one reference level for a query response that matches a cell.

11. Computer program product of claim 10, wherein the user-specified selection of a type of data representation includes one or more of a pie chart, histogram, bar chart, line chart, donut chart, or table.

12. Computer program product of claim 10, wherein the user-specified description of the view to be constructed includes one or more measures selected for presentation and one or more group dimensions for grouping values associated with the selected measures.

13. Computer program product of claim 10, further comprising:

computer readable program code that, if executed, determines that a reference level is available for a user-specified description of the view;

computer readable program code that, if executed, presents the reference level with the search results within the presented view.

14. Computer program product of claim 10, further comprising computer readable program code that, if executed, defines a schema with a set of cubes, each cube defining one or more dimensions and one or more measures, at least one measure of a given cube being represented multiple times in the given cube, each representation corresponding to a different possible aggregation of that measure.

15. Computer program product of claim 10, further comprising computer readable program code that, if executed, provides a configuration file that defines a basic unit of a cube for use generating histograms and a measure that provides the basic unit.

16. Computer program product of claim 10, further comprising computer readable program code that, if executed, calculates a table of related results for use in constructing line chart and bar chart data representations.

17. Computer program product of claim 10, further comprising computer readable program code that, if executed, calculates proportions of a total amount for use in constructing pie chart and donut chart data representations.

18. Computer program product of claim 10, further comprising computer readable program code that, if executed, calculates a distribution of events in a cube for use in a histogram.

19. A computer system for analyzing data, the computer system comprising:

a non-transitory memory storing program code used for analyzing data and generating reports;

a processor, in communication with the memory, executing the program code to receive a user-specified selection of a data source, the data source including the biometric or medical data, a user-specified selection of a type of data representation, and a user-specified description of a view to be constructed in accordance with the user-specified selection of the type of data representation, the processor further executing the program code to generate a multidimensional query based on the user-specified type of data representation and the user-specified description of the view to be constructed, to submit the multidimensional query to an On-line Analytical Processing (OLAP) server, to receive a multidimensional reply from the OLAP server containing results acquired by the multidimensional query of the data source, the processor further simplifying the multidimensional response, the simplifying of the multidimensional response including an API function mapping dimensional modeling terminology of the multidimensional response into non-multidimensional terminology understood by a user interface, the simplified multidimensional response including at least one reference level corresponding to a target region in the biometric or medical data, the at least one reference level not being a part of the multidimensional space and defined by a reference level set which identifies a cube with which a particular reference level is associated, a set of members that need to be matched for the at least one reference value to apply and a reference level value; and

to generate, for display on the user interface, the view based on the results contained in the multidimensional response and in accordance with the user-specified selection of the type of data representation and the user-specified description of the view, the view further including the at least one reference level for a query response that matches a cell.

20. The computer system of claim 19, wherein the stored program code includes a query application program interface (API).

21. The computer system of claim 20, wherein the query API includes an API function for calculating a table of related results for use in constructing line chart and bar chart data representations.

22. The computer system of claim 20, wherein the query API includes an API function for calculating proportions of a total amount for use in constructing pie chart and donut chart data representations.

23. The computer system of claim 20, wherein the query API includes an API function for calculating a distribution of events in a cube for use in a histogram.

24. The computer system of claim 20, wherein the processor further executes the program code to:

determine that a reference level is available for a user-specified description of the view; and

present the reference level with the search results within the presented view.

25. The computer system of claim 20, wherein the stored program code includes a schema defining a set of cubes, each cube having one or more dimensions and one or more measures, at least one measure of a given cube being represented multiple times in the given cube, each representation corresponding to a different possible aggregation of that measure.