ANALYSIS OF DATASETS WITHOUT PREDEFINED DIMENSIONS
Embodiments of systems, methods, and computer-readable mediums for analysis of datasets without predefined dimensions are generally described herein. In some embodiments, analysis of datasets without predefined dimensions may include receiving a selection of multiple dimensions of information from a database to be used for data analysis; receiving a selection for a type of report; and dynamically generating a query statement based on the selection of the multiple dimensions. Further embodiments may include the dynamically generated query statement including multiple iterative join clauses as a function of the selected dimensions; executing the query statement against an in-memory database; and displaying columns of information obtained from execution of the query statement.
1 . A method comprising:
receiving a selection of multiple dimensions of information from a database to be used for data analysis;
receiving a selection for a type of report; and
dynamically generating a query statement based on the selection of the multiple dimensions.
2 . The method of claim 1 , further comprising:
executing the query statement against an in-memory database; and
displaying columns of information obtained from execution of the query statement.
3 . The method of claim 2 , wherein the columns of information displayed are selected as a function of the type of report selected.
4 . The method of claim 2 , wherein the columns of information displayed are selected as a function of the dimensions selected.
5 . The method of claim 2 , wherein the columns of information displayed are selected as a function of the type of report selected and the dimensions selected.
6 . The method of claim 1 , wherein the dimensions are selected from a list of characteristics.
7 . The method of claim 1 , wherein the dynamically generated query statement comprises multiple iterative join clauses as a function of the selected dimensions.
8 . A system, comprising:
at least one processor programmed to receive a selection of multiple dimensions of information from a database to be used for data analysis;
wherein the at least one processor is further programmed to receive a selection for a type of report; and
wherein the at least one processor is further programmed to generate dynamically a query statement based on the selection of the multiple dimensions.
9 . The system of claim 8 , further comprising:
the at least one processor programmed to execute the query statement against an in-memory database;
wherein the at least one processor is further programmed to execute the query statement to obtain columns of information; and
wherein the at least one processor causes the columns of information to be displayed.
10 . The system of claim 9 , wherein the columns of information displayed are selected by the at least one processor as a function of the type of report.
11 . The system of claim 9 , wherein the columns of information displayed are selected by the at least one processor as a function of the dimensions selected.
12 . The system of claim 9 , wherein the columns of information displayed are selected by the at least one processor as a function of the type of report selected and the dimensions selected.
13 . The system of claim 8 , wherein the dynamically generated query statement comprises multiple iterative join clauses as a function of the selected dimensions.
14 . The system of claim 8 , wherein the type of report is selected from a list of reports.
15 . A computer-readable medium comprising a plurality of instructions that, in response to being executed on a computing device, cause the computing device to:
receive a selection of multiple dimensions of information from a database to be used for data analysis;
receive a selection for a type of report; and
dynamically generate a query statement based on the selection of the multiple dimensions.
16 . The computer-readable medium of claim 15 , wherein the plurality of instructions, when executed on the computing device, causes the computing device to:
execute the query statement against an in-memory database; and
display columns of information obtained from execution of the query statement.
17 . The computer-readable medium of claim 16 , wherein the columns of information displayed are selected as a function of the type of report selected.
18 . The computer-readable medium of claim 16 , wherein the columns of information displayed are selected as a function of the dimensions selected.
19 . The computer-readable medium of claim 16 , wherein the columns of information displayed are selected as a function of the type of report selected and the dimensions selected.
20 . The computer-readable medium of claim 15 , wherein the dynamically generated query statement comprises multiple iterative join clauses as a function of the selected dimensions.