ANALYSIS OF DATASETS WITHOUT PREDEFINED DIMENSIONS

• US 20140236884A1
• Filed: 02/15/2013
• Published: 08/21/2014
• Est. Priority Date: 02/15/2013
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Clark, Mitchell, da Silveira, Celso, Ogando, Julian
• Application Number:
  US13/768,952
• Publication Number:
  US 20140236884A1
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• 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
• CPC Class Codes: H04W 52/027 by controlling a display operation or backlight unit
• CPC Class Codes: Y02D 30/70 in wireless communication networks

Abstract

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.

Claims

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.