Systems and methods for active column filtering

• US 9,009,171 B1
• Filed: 05/02/2014
• Issued: 04/14/2015
• Est. Priority Date: 05/02/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Thompson, James, Grossman, Jack
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US14/268,964
• Time in Patent Office: 347 Days
• Field of Search: None
• US Class Current: 707/754
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/908 using metadata automatically derived from the content
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/177 of tables; using ruled lines

Abstract

Systems and methods are disclosed for active column filtering. In accordance with one implementation, a method is provided for active column filtering. The method includes providing a table having data values arranged in rows and columns, providing a first filter location indicator whose location is visually associated with a first column, and providing a first interface based on a selection of the first filter location indicator, wherein the first interface'"'"'s location is visually associated with the first column. The method also includes acquiring a first filter input entered into the first interface, filtering the table based on the acquired first filter input, providing the filtered table for displaying, and providing an applied filter indicator, whose location is visually associated with the first column, the applied filter indicator including at least the first filter input.

Claims

1. An electronic device comprising:

one or more computer-readable storage media configured to store instructions; and

one or more processors configured to execute the instructions to cause the electronic device to;

provide a table having data values arranged in rows and columns;

provide a first filter location indicator at a location that is visually associated with a first column, wherein the location of the provided first filter location indicator is visually associated with the first column based on the provided first filter location indicator being closer in proximity to the first column than to another column in the table;

provide a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquire a first filter input entered into the first interface;

filter the table based on the acquired first filter input;

provide the filtered table for displaying; and

provide an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

2. The electronic device of claim 1, wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

3. The electronic device of claim 1, wherein the first filter input comprises a string of characters, and the filtering of the table comprises determining in the first column data values comprising the string of characters and removing from the table one or more rows that do not comprise the determined data values in the first column.

4. The electronic device of claim 1, wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a second interface, wherein the second interface'"'"'s location is visually associated with the first column;

acquire a second filter input entered into the second interface;

further filter the table based on the acquired second filter input; and

update the applied filter indicator to comprise the first and the second filter inputs.

5. The electronic device of claim 4, wherein the first interface and the second interface are Graphical User Interface (GUI) widgets of different types.

6. The electronic device of claim 1, wherein the first filter input comprises a range of values, and the filtering of the table comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column.

7. The electronic device of claim 6, wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.

8. The electronic device of claim 1, wherein the one or more processors are further configured to execute the instructions to cause the electronic device to:

provide a second filter location indicator whose location is visually associated with a second column;

provide a second interface based on a selection of the second filter location indicator, wherein the second interface'"'"'s location is visually associated with the second column;

acquire a second filter input entered into the second interface; and

filter the table based on the acquired first and second filter inputs.

9. A method for active column filtering, the method being performed by one or more processors and comprising:

providing a table having data values arranged in rows and columns;

providing a first filter location indicator at a location that is visually associated with a first column, wherein the provided first filter location indicator is visually associated with the first column based on the provided first filter location indicator being closer in proximity to the first column than to another column in the table;

providing a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquiring a first filter input entered into the first interface;

filtering the table based on the acquired first filter input;

providing the filtered table for displaying; and

providing an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

10. The method of claim 9, wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

11. The method of claim 9, wherein the first filter input comprises a string of characters, and the filtering step comprises determining in the first column data values comprising the string of characters and removing from the table one or more rows that do not comprise the determined data values in the first column.

12. The method of claim 9, further comprising:

providing a second interface, wherein the second interface'"'"'s location is visually associated with the first column;

acquiring a second filter input entered into the second interface;

further filtering the table based on the acquired second filter input; and

updating the applied filter indicator to comprise the first and the second filter inputs.

13. The method of claim 12, wherein the first interface and the second interface are Graphical User Interface (GUI) widgets of different types.

14. The method of claim 9, wherein the first filter input comprises a range of values, and the process of filtering comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column.

15. The method of claim 14, further comprising:

providing a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.

16. The method of claim 9, further comprising:

providing a second filter location indicator whose location is visually associated with a second column;

providing a second interface based on a selection of the second filter location indicator, wherein the second interface'"'"'s location is visually associated with the second column;

acquiring a second filter input entered into the second interface; and

filtering the table based on the acquired first and second filter inputs.

17. A non-transitory computer-readable medium storing a set of instructions that are executable by one or more electronic devices, each having one or more processors, to cause the one or more electronic devices to perform a method, the method comprising:

providing a table having data values arranged in rows and columns;

providing a first filter location indicator at a location that is visually associated with a first column, wherein the provided first filter location indicator is visually associated with the first column based on the provided first location indicator being closer in proximity to the first column than to another column in the table;

providing a first interface based on a selection of the provided first filter location indicator, wherein the first interface is at a location that is visually associated with the first column;

acquiring a first filter input entered into the first interface;

filtering the table based on the acquired first filter input;

providing the filtered table for displaying; and

providing an applied filter indicator at a location that is visually associated with the first column, the applied filter indicator comprising at least the first filter input.

18. The non-transitory computer-readable medium of claim 17, wherein the filter location indicator, the first interface, and the applied filter indicator are provided inside or substantially adjacent to a header of the first column.

19. The non-transitory computer-readable medium of claim 17, further comprising instructions executable by the one or more electronic devices to cause the one or more electronic devices to perform:

providing a second interface, wherein the second interface'"'"'s location is visually associated with the first column;

acquiring a second filter input entered into the second interface;

further filtering the table based on the acquired second filter input; and

updating the applied filter indicator to comprise the first and the second filter inputs.

20. The non-transitory computer-readable medium of claim 17, wherein the first filter input comprises a range of values, and the filtering of the table comprises determining in the first column data values corresponding to the range of values and removing from the table one or more rows that do not comprise the determined data values in the first column, the non-transitory computer-readable medium further comprising instructions executable by the one or more electronic devices to cause the one or more electronic devices to perform:

providing a chart representing distribution of data values in the first column, the chart comprising one or more user-adjustable handles defining the range of values.