Data analysis engine

• US 10,002,176 B2
• Filed: 06/02/2017
• Issued: 06/19/2018
• 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:
  US15/612,486
• Publication Number:
  US 20170270177A1
• Time in Patent Office: 382 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 to analyze biometric or medical data, comprising:

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

receiving, from the input device, a user-specified selection of a type of data representation;

receiving, from the input device, 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, processor and memory, 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, processor and memory, at least a multidimensional response from the OLAP server containing results obtained based on the multidimensional query of the data source;

simplifying, by the application program interface (API) function, processor and memory, 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 compatible with 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 being defined by a reference level set which identifies a cube with which a particular reference level is associated and 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. A non-transitory computer readable information storage medium having stored thereon computer readable program code, the computer readable program code comprising instructions to perform a method comprising:

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

receiving, from the input device, a user-specified selection of a type of data representation;

receiving, from the input device, 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, processor and memory, 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, processor and memory, at least a multidimensional response from the OLAP server containing results obtained based on the multidimensional query of the data source;

simplifying, by the application program interface (API) function, processor and memory, 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 compatible with 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 being defined by a reference level set which identifies a cube with which a particular reference level is associated and 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.

11. The media 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. The media 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. The media 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. The media 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. The media 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. The media 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. The media 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. The media 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 memory, executing the program code to;

receive, from an input device, a user-specified selection of a data source, the data source including the biometric or medical data;

receive, from the input device, a user-specified selection of a type of data representation;

receive, from the input device, a user-specified description of a view to be constructed in accordance with the user-specified selection of the type of data representation;

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

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

receive, by the application program interface (API) function, processor and memory, at least a multidimensional response from the OLAP server containing results obtained based on the multidimensional query of the data source;

simplify, by the application program interface (API) function, processor and memory, 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 compatible with 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 being defined by a reference level set which identifies a cube with which a particular reference level is associated and a set of members that need to be matched for the at least one reference value to apply and a reference level value; and

generate 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 query API includes one or more of:

an API function for calculating a table of related results for use in constructing line chart and bar chart data representations,

an API function for calculating proportions of a total amount for use in constructing pie chart and donut chart data representations, and/or

an API function for calculating a distribution of events in a cube for use in a histogram.