Systems and methods for active column filtering

• US 10,019,431 B2
• Filed: 09/19/2016
• Issued: 07/10/2018
• Est. Priority Date: 05/02/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Grossman, Jack, Thompson, James
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US15/269,534
• Publication Number:
  US 20170011022A1
• Time in Patent Office: 659 Days
• Field of Search: None
• 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 in the table; and

provide a first interface based on a selection of the provided first filter location indicator, the first interface indicating a distribution of data values associated with the first column, the first interface further including one or more user-adjustable elements defining a range of values included in the indicated distribution of data values.

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

3. 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:

acquire a first filter input entered into the first interface, wherein the first filter input comprises a string of characters; and

provide a filtered table for displaying based on the first filter input, wherein providing the filtered 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 determined data values in the first column.

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

provide a second interface;

acquire a second filter input entered into the second interface;

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

update an 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 3, wherein the first filter input comprises a range of values, and providing the filtered 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;

acquire a first filter input entered into the first interface;

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

provide a filtered table for displaying 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; and

providing a first interface based on a selection of the provided first filter location indicator, the first interface indicating a distribution of data values associated with the first column, the first interface further including one or more user-adjustable elements defining a range of values included in the indicated distribution of data value.

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

11. The method of claim 9, further comprising:

acquiring a first filter input entered into the first interface, wherein the first filter input comprises a string of characters; and

providing a filtered table for displaying based on the first filter input, wherein providing the filtered 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.

12. The method of claim 11,

further comprising:

providing a second interface;

acquiring a second filter input entered into the second interface;

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

updating an 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 11, 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;

acquiring a first filter input entered into the first interface;

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

providing a filtered table for displaying 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:

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

determine a location visually associated with the first column, wherein the location is determined based on determining that a distance between the first column and the location is lower than distances between any other column and the location;

provide a first interface based on a selection of the provided first filter location indicator.

18. 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:

acquiring a first filter input entered into the first interface, wherein the first filter input comprises a string of characters; and

providing a filtered table for displaying based on the first filter input, wherein providing the filtered 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 determined data values in the first column.

19. The non-transitory computer-readable medium of claim 18, 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;

acquiring a second filter input entered into the second interface;

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

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

20. The non-transitory computer-readable medium of claim 17, wherein the distance between the first column and the location is a horizontal distance.