Unified interactive data analysis system

• US 9,043,266 B2
• Filed: 02/24/2006
• Issued: 05/26/2015
• Est. Priority Date: 02/24/2006
• Status: Active Grant

• Current Assignee: Cloud Software Group
• Original Assignee: TIBCO Software Incorporated (Cloud Software Group)
• Inventors: Bauerle, Lars, Lehtipalo, Tobias, Thorsell, Magnus, Hergens, Johan, Fortes, Tommy
• Primary Examiner(s): Shmatov, Alexey
• Application Number:
  US11/361,697
• Publication Number:
  US 20070203902A1
• Time in Patent Office: 3,378 Days
• Field of Search: 707600-603, 707/798, 707/612
• US Class Current: 707/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

A system for analyzing data from a data set is disclosed. The system includes analysis logic responsive to a dimensional analysis control and an attribute analysis control for the same data. This logic can incrementally update the state of a data presentation from an existing state to a new state, and then remain responsive in the new state to further user input via the dimensional data analysis control and further user input via the attribute analysis control to further incrementally update the presentation.

Claims

1. A computer-based system comprising a processor and a storage device including instructions that are operative to run on the processor for analyzing data from a data set, comprising:

a presentation selection control operative to select a first presentation format and a second presentation format from a plurality of different presentation formats,

presentation logic operative to simultaneously present a dimensional data presentation to a user using the first presentation format and a attribute data presentation to a user using the second presentation format,

a dimensional analysis control responsive to user input to navigate dimensionally organized data fields in the data set according to its dimensional organization in the dimensional data presentation,

an attribute analysis control responsive to user input to analyze the same dimensionally organized data fields in the data set according to its attributes in the attribute data presentation, wherein the dimensional analysis control and the attribute analysis control include at least one control responsive to position-based user interaction, and

interactive analysis logic that is responsive to the dimensional analysis control and to the attribute analysis control for the same dimensionally organized data fields, and is responsive to user input via the dimensional data analysis control to update the attribute data presentation and to user input via the attribute analysis control to update the dimensional data presentation, wherein the interactive analysis logic remains responsive to further user input via the dimensional data analysis control and to further user input via the attribute analysis control to further update the presentations.

2. The system of claim 1 wherein user input via the dimensional analysis control causes the dimensional analysis control to transition between one of at least three states, wherein user input via the attribute analysis control causes the attribute analysis control to transition between one of at least three states, and wherein each state transition generates one of a series of different successive queries to the data set.

3. The system of claim 1 further including aggregation measure control logic operative to aggregate data sets defined using the dimensional control according to different aggregation measures.

4. The system of claim 1 wherein a same type of control can be used for dimensionally organized data and non-dimensionally organized data.

5. The system of claim 1 wherein the dimensional analysis control is substantially continuously adjustable.

6. The system of claim 1 wherein the dimensional analysis control and the attribute analysis control are responsive to actuation by a same pointing device.

7. The system of claim 1 wherein the dimensional analysis control includes a slider.

8. The system of claim 1 wherein the dimensional analysis control includes a filter control.

9. The system of claim 8 wherein the dimensional analysis control includes a hierarchically organized filter control.

10. The system of claim 1 wherein the dimensional analysis control includes a tree-based control.

11. The system of claim 1 wherein the dimensional analysis control for one dimension and a further dimensional access control for another dimension are associated with the same visualization.

12. The system of claim 1 wherein the system includes logic operative to recognize dimensional organization in the data set.

13. The system of claim 1 wherein the system includes dimension input logic operative to retrieve external stored dimensions for the data set.

14. The system of claim 1 wherein the system includes dimension input logic operative to retrieve external stored dimensions for the data set from local storage.

15. The system of claim 1 wherein the system includes dimension input logic operative to retrieve external stored dimensions for the data set from an external system.

16. The system of claim 1 wherein dimensional and attribute information is stored in a centrally managed model that can be shared among many users.

17. The system of claim 1 wherein the dimensionally organized data are organized according to a hierarchy.

18. The system of claim 17 wherein the system includes stored logic to handle predetermined types of hierarchies.

19. The system of claim 17 wherein the system includes stored logic to handle a plurality of the following types of hierarchies:

time-based hierarchies, money-based hierarchies, and distance-based hierarchies.

20. The system of claim 1 wherein the data analysis system includes spreadsheet functionality.

21. The system of claim 1 wherein the data analysis system includes interactive data visualization logic operative to include graphical visualizations in the data presentation.

22. The system of claim 1 wherein the data analysis system is a statistical package that includes a plurality of advanced statistical functions.

23. The system of claim 1 wherein the data analysis system is an OLAP system and wherein the dimensional analysis control is an OLAP control.

24. The system of claim 1 wherein the data analysis system is a reporting system.

25. The system of claim 1 wherein the data set is accessed from a commercial relational database.

26. The system of claim 25 wherein the data analysis system is built into the commercial relational database.

27. The system of claim 1 wherein the data analysis system is built into a larger product and provides one or more data analysis views that relate to the functions of the larger product.

28. The system of claim 1 wherein a plurality of further analysis controls is available to the user.

29. The system of claim 1, further including a dimension assignment control responsive to input from a user to assign dimensions for a dimensional organization for the data set.

30. The system of claim 29 wherein the dimension assignment control is operative to assign new dimensions that are different from any dimensions defined by a dimensional structure of the data set.

31. The system of claim 1 wherein the interactive analysis logic is operative to simultaneously update the state of both the attribute data presentation and the dimensional data presentation in response to input from either the attribute analysis control or the dimensional analysis control.

32. The system of claim 1 wherein the dimensional analysis control includes a portion of the data presentation that is responsive to user actuation.

33. The system of claim 1 wherein the dimensional analysis control includes a field selector.

34. The system of claim 1 wherein the attribute analysis control includes a portion of the data presentation that is responsive to user actuation.

35. The system of claim 1 wherein the data set and its attributes are stored in one database, and dimensions are stored in another database.

36. The system of claim 1 wherein the data set and its attributes and dimensions are stored in a cache.

37. A method for analyzing data from a data set, comprising:

receiving a selection of a first one of a plurality of different presentation formats,

receiving a selection of a second one of the plurality of different presentation formats,

simultaneously presenting a dimensional data presentation to a user using the first presentation format and an attribute data presentation to the user using the second presentation format,

receiving at least one attribute analysis command from a user to analyze the data in the dimensionally organized data set according to its attributes,

updating the state of both the attribute data presentation and the dimensional data presentation in response to the attribute analysis command received in the step of receiving an attribute analysis command,

receiving at least one dimensional analysis command from a user to navigate dimensionally organized data in the data set according to its dimensional organization,

updating the state of the dimensional data presentation and the attribute data presentation in response to the dimensional analysis command received in the step of receiving a dimensional analysis command,

remaining responsive to further attribute analysis commands and to further dimensional analysis commands to further update the presentations after each of the steps of updating, and

wherein at least one of the attribute analysis command and the dimensional analysis command is based on position-based interaction.

38. The method of claim 37 wherein the step of updating takes less than one second.

39. The method of claim 37 wherein the graphical attribute analysis command and the graphical dimensional analysis command are received from a pointing device.

40. The method of claim 37 wherein parameters of the dimensional analysis command are responsive to changes in data selection based on the attribute analysis command.

41. The method of claim 37 wherein parameters of the attribute analysis command are responsive to navigation through hierarchies based on the dimensional command.

42. The method of claim 37 further including receiving an aggregation measure command and changing an aggregation measure for the data set based on the aggregation measure command.

43. The method of claim 37 wherein the dimensionally organized data are organized according to a hierarchy.

44. The method of claim 37 wherein a same data subset can be treated as an attribute or a dimension.

45. A computer-based system comprising a processor and a storage device including instructions that are operative to run on the processor for analyzing data from a data set, comprising:

means for receiving a selection of a first presentation format and a second presentation format from a plurality of different presentation formats,

means for simultaneously presenting a dimensional data presentation to a user using the first presentation format and an attribute data presentation to the user using the second presentation format,

means for receiving attribute analysis commands from a user to analyze the data in the data set according to its attributes,

means for updating the state of both the attribute data presentation and the dimensional data presentation in response to the attribute analysis command received by the means for receiving an attribute analysis command,

means for receiving dimensional analysis commands from a user to navigate dimensionally organized data in the data set according to its dimensional organization,

means for updating both the state of the dimensional data presentation and the attribute data presentation in response to the dimensional analysis command received by the means for receiving a dimensional analysis command,

means for remaining responsive to further graphical attribute analysis commands and to further graphical dimensional analysis commands to further update the presentations, and

wherein at least one of the means for receiving an attribute analysis command and the means for receiving a dimensional analysis command is responsive to position-based user input.