Filtering for data visualization techniques

• US 9,477,732 B2
• Filed: 07/05/2007
• Issued: 10/25/2016
• Est. Priority Date: 05/23/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Helfman, Jonathan, Goldberg, Joseph
• Primary Examiner(s): Ng, Amy
• Assistant Examiner(s): Muhebbullah, Sajeda
• Application Number:
  US11/773,916
• Publication Number:
  US 20090013271A1
• Time in Patent Office: 3,400 Days
• Field of Search: 715853-854, 345/440
• US Class Current: 1/1
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/287 Visualization; Browsing
• CPC Class Codes: G06F 16/9027 Trees
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• CPC Class Codes: G06F 40/14 Tree-structured documents parsing G06F40/205; validation G06F40/226
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Systems and methods in accordance with various embodiments of the present invention provide for representing data values of a data set as a plurality of graphical elements in a data visualization, where each data value is associated with a plurality of data dimensions. A first data visualization may be generated based on a first configuration of the dataset. The first data visualization and a first user interface are displayed on a data visualization display page. The first user interface includes the plurality of graphical elements in the first data visualization. A selection of a element of the plurality of graphical elements is received through the first user interface. Moreover, the data values based on the received selection are filtered. A second data visualization representing the data set excluding the filtered data values is displayed.

Claims

1. A method for representing data values of a hierarchical data set as graphical elements in a treemap visualization, each data value being associated with a plurality of data dimensions, the method comprising:

generating, with one or more processors associated with one or more computer systems, a first treemap visualization representing the hierarchical data set based on a first configuration of hierarchical depth levels of the hierarchical data set, the first treemap visualization having a first plurality of cells each corresponding to one or more data values in the hierarchical data set;

generating, with the one or more processors associated with the one or more computer systems, information configured for displaying the first treemap visualization and a first user interface on a treemap visualization display page;

receiving, at the one or more computer systems, a selection via the first treemap visualization of a treemap cell in the first plurality of cells to remove from the treemap visualization display page, the selected treemap cell corresponding to one or more data value outliers in the hierarchical data set;

filtering, with the one or more processors associated with the one or more computer systems, the one or more data value outliers in the hierarchical data set based on the selected treemap cell to generate a filtered hierarchical data set excluding the filtered data-value outliers;

determining a number of depth levels to display in a second treemap visualization based at least in part on a number of the hierarchical depth levels of the hierarchical data set;

identifying which of the determined number of depth levels of the hierarchical data set to display in the second treemap visualization based at least in part on user selections received through a user interface, at least one of the identified depth levels having a plurality of data values corresponding to one or more graphical elements of the hierarchical data set; and

generating, with the one or more processors associated with the one or more computer systems, the second treemap visualization based at least in part on the identified depth levels, the second treemap visualization representing the filtered hierarchical data set based at least in part on a proportion ratio that is determined for each of a plurality of non-excluded data values, the second treemap visualization having a second plurality of cells each corresponding to one or more of the plurality of non-excluded data values in the filtered hierarchical data set, and at least one of the second plurality of cells in the second treemap visualization having a distinguishable area from a corresponding treemap cell in the first treemap visualization while maintaining the first configuration of the hierarchical data set.

2. The method of claim 1, wherein filtering the one or more data value outliers in the hierarchical data set comprises setting a filter flag for one or more data values corresponding to the selected treemap cell.

3. The method of claim 2, further comprising:

determining aggregate values for each group of the hierarchical data set and for each level of hierarchy after receiving the selection of the treemap cell.

4. The method of claim 3, wherein determining the aggregate values further comprises excluding the data values with the set filter flag.

5. The method of claim 1, further comprising:

receiving a layout of the filtered hierarchical data set excluding the filtered data value outliers; and

generating information configured for displaying the second treemap visualization representing the filtered hierarchical data set excluding the filtered data value outliers on the treemap visualization display page according to the received layout.

6. A computer program product stored on a non-transitory computer-readable medium for representing data values of a hierarchical data set as graphical elements in a treemap visualization, each data value being associated with a plurality of data dimensions, the computer program product comprising:

code for generating a first treemap visualization representing the hierarchical data set based on a first configuration of hierarchical depth levels of the hierarchical data set, the first treemap visualization having a first plurality of cells each corresponding to one or more data values in the hierarchical data set;

code for displaying the first treemap visualization and a first user interface on a treemap visualization display page;

code for receiving through the first treemap visualization a selection of a treemap cell in the first plurality of cells to remove from the treemap visualization display page, the selected treemap cell corresponding to one or more data value outliers in the hierarchical data set;

code for filtering the one or more data value outliers in the hierarchical data set based on the selected treemap cell to generate a filtered hierarchical data set excluding the filtered data value outliers;

code for determining a number of depth levels to display in a second treemap visualization based at least in part on a number of the hierarchical depth levels of the hierarchical data set;

code for identifying which of the determined number of depth levels of the hierarchical data set to display in the second treemap visualization based at least in part on user selections received through a user interface, at least one of the identified depth levels having a plurality of data values corresponding to one or more graphical elements of the hierarchical data set; and

code for displaying the second treemap visualization based at least in part on the identified depth levels, the second treemap visualization representing the filtered hierarchical data set based at least in part on a proportion ration that is determined for each of a plurality of non-excluded data values, the second treemap visualization having a second plurality of cells each corresponding to one or more of the plurality of non-excluded data values in the filtered hierarchical data set, and at least one of the second plurality of cells in the second treemap visualization having a distinguishable area from a corresponding treemap cell in the first treemap visualization while maintaining the first configuration of the hierarchical data set.

7. The computer program product according to claim 6, wherein the code for filtering the one or more data value outliers in the hierarchical data set comprises code for setting a filter flag for one or more data values corresponding to the selected treemap cell.

8. The computer program product according to claim 7, further comprising:

code for determining aggregate values for each group of the hierarchical data set and for each level of hierarchy after receiving the selection of treemap cell.

9. The computer program product according to claim 8, wherein determining the aggregate values further comprises excluding the data values with the set filter flag.

10. The computer program product according to claim 6, further comprising:

code for receiving a layout of the filtered hierarchical data set excluding the filtered data-value outliers; and

code for displaying the second treemap visualization representing the filtered hierarchical data set excluding the filtered data value outliers on the treemap visualization display page according to the received layout.

11. A system for representing data values of a hierarchical data set as graphical elements in a treemap visualization, each data value being associated with a plurality of data dimensions, the system comprising:

a processor; and

a memory coupled to the processor, the memory configured to store a plurality of code modules which when executed by the processor cause the processor to;

generate a first treemap visualization representing the hierarchical data set based on a first configuration of hierarchical depth levels of the hierarchical data set, the first treemap visualization having a first plurality of cells each corresponding to one or more data values in the hierarchical data set;

generate information configured for displaying the first treemap visualization and a first user interface on a treemap visualization display page;

receive through the first treemap visualization a selection of a treemap cell in the first plurality of cells to remove from the treemap visualization display page, the selected treemap cell corresponding to one or more data value outliers in the hierarchical data set;

filter the one or more data value outliers in the hierarchical data set based on the selected treemap cell to generate a filtered hierarchical data set excluding the filtered data value outliers;

determine a number of depth levels to display in a second treemap visualization based at least in part on a number of the hierarchical depth levels of the hierarchical data set;

identify which of the determined number of depth levels of the hierarchical data set to display in the second treemap visualization based at least in part on user selections received through a user interface, at least one of the identified depth levels having a plurality of data values corresponding to one or more graphical elements of the hierarchical data set; and

generate the second treemap visualization based at least in part on the identified depth levels, the second treemap visualization representing the filtered hierarchical data based at least in part on a proportion ratio that is determined for each of a plurality of non-excluded data values, the second treemap visualization having a second plurality of cells each corresponding to one or more of the plurality of non-excluded data values in the filtered hierarchical data set, at least one of the second plurality of cells in the second treemap visualization having a distinguishable area from a corresponding treemap cell in the first treemap visualization while maintaining the first configuration of the hierarchical data set.

12. The system of claim 11, further comprising additional code modules which when executed by the processor cause the processor to:

set a filter flag for one or more data values corresponding to the treemap cell.

13. The system of claim 12, further comprising additional code modules which when executed by the processor cause the processor to:

determine aggregate values for each group of the hierarchical data set and for each level of hierarchy after receiving the selection of the treemap cell.

14. The system of claim 11, further comprising additional code modules which when executed by the processor cause the processor to:

receive a layout of the filtered hierarchical data set excluding the filtered data value outliers; and

generate information configured for displaying the second treemap visualization representing the filtered hierarchical data set excluding the filtered data value outliers on the treemap visualization display page according to the received layout.