Collaborative data mining and analysis

• US 10,366,066 B2
• Filed: 06/20/2012
• Issued: 07/30/2019
• Est. Priority Date: 11/11/2011
• Status: Active Grant

• Current Assignee: QlikTech International AB (Qlik Technologies)
• Original Assignee: QlikTech International AB (Qlik Technologies)
• Inventors: Wolge, Hakan, Linsefors, Tobias
• Primary Examiner(s): Lee, Justin S
• Application Number:
  US13/528,534
• Publication Number:
  US 20130159882A1
• Time in Patent Office: 2,596 Days
• Field of Search: 715733
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• 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: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

Abstract

Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to facilitate dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.

Claims

1. A method for collaborative computing comprising:

providing a single state space for collaborative real-time data analysis to a first user and a second user, wherein the single state space is a view of a dataset that represents a selection state and is represented by at least a first list box and a second list box separate from the first list box, wherein the first list box comprises first list items retrieved from one or more tables of the dataset, and wherein the second list box comprises second list items retrieved from the one or more tables of the dataset;

receiving a selection of a first item of the first list box by either the first user or the second user;

modifying, based on the selection of the first item of the first list box, the selection state and a representation of a second list item in the second list box;

generating an identifier associated with the modified selection state and the modified representation of the second list item;

generating a note associated with the modified selection state and the modified representation of the second list item; and

associating the identifier with the note, wherein selection of the note by either the first user or the second user causes, based on the association of the note with the identifier, a current state of the single state space to be modified to reflect the modified selection state and the modified representation of the second list item.

2. The method of claim 1, further comprising:

initiating a primary session for the first user; and

initiating a secondary session for a second user.

3. The method of claim 2, further comprising requesting collaboration from the second user by providing the second user a URL configured to allow the second user to view the secondary session.

4. The method of claim 2, wherein initiating a primary session for the first user comprises generating a first user interface, and wherein initiating a secondary session for the second user comprises generating a second user interface.

5. The method of claim 1, wherein at least a portion of the dataset is retrieved from a database and converted into an intermediate data structure for analysis and display.

6. The method of claim 5, wherein the intermediate data structure comprises values of the dataset mapped to respective coded values, wherein a coded value is generated for each unique data value for a data type.

7. The method of claim 5, wherein the intermediate data structure comprises at least two tables from the dataset aggregated into a single table based on a relationship between the at least two tables.

8. The method of claim 5, wherein the intermediate data structure comprises an evaluation of a formula using data from the dataset.

9. The method of claim 5, wherein the single state space is based on the intermediate data structure.

10. The method of claim 5, wherein the intermediate data structure is generated based on data types, data values, and/or a combination thereof indicated as selected in the selection state.

11. A system, comprising:

one or more processors; and

a memory having embodied thereon processor executable instructions that, when executed by the one or more processors, cause the at least one computing device to;

provide a single state space for collaborative real-time data analysis to a first user and a second user, wherein the single state space is a view of a dataset that represents a selection state and is represented by at least a first list box and a second list box separate from the first list box, wherein the first list box comprises first list items retrieved from one or more tables of the dataset, and wherein the second list box comprises second list items retrieved from the one or more tables of the dataset;

receive a selection of a first item of the first list box by either the first user or the second user;

modify, based on the selection of the first item of the first list box, the selection state and a representation of a second list item in the second list box;

generate an identifier associated with the modified selection state and the modified representation of the second list item;

generate a note associated with the modified selection state and the modified representation of the second list item; and

associate the identifier with the note, wherein selection of the note by either the first user or the second user causes, based on the association of the note with the identifier, a current state of the single state space to be modified to reflect the modified selection state and the modified representation of the second list item.

12. The system of claim 11, further comprising:

initiating a primary session for the first user; and

initiating a secondary session for a second user.

13. The system of claim 12, further comprising requesting collaboration from the second user by providing the second user a URL configured to allow the second user to view the secondary session.

14. The system of claim 12, wherein initiating a primary session for the first user comprises generating a first user interface, and wherein initiating a secondary session for the second user comprises generating a second user interface.

15. The system of claim 11, wherein at least a portion of the dataset is retrieved from a database and converted into an intermediate data structure for analysis and display.

16. The system of claim 15, wherein the intermediate data structure comprises values of the dataset mapped to respective coded values, wherein a coded value is generated for each unique data value for a data type.

17. The system of claim 15, wherein the intermediate data structure comprises at least two tables from the dataset aggregated into a single table based on a relationship between the at least two tables.

18. The system of claim 15, wherein the intermediate data structure comprises an evaluation of a formula using data from the dataset.

19. The system of claim 15, wherein the single state space is based on the intermediate data structure.

20. The system of claim 15, wherein the intermediate data structure is generated based on data types, data values, and/or a combination thereof indicated as selected in the selection state.