# US 2012/0254800 A1 · Independent attribute filtering

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0254800 A1
- Document ID: US20120254800A1
- Status: Published application
- Kind: A1
- Application number: 13/075,906
- Filed: 2011-03-30
- Published: 2012-10-04
- Earliest claimed: 2011-03-30
- Assignees: Teradata US, Inc.
- Inventors: Paul Richard Kristoff; Harold Lee; Jason Stone; Henry Fu; Marcus Philip Tidwell
- Web page: https://patentgrep.com/patent/US20120254800A1

## CPC

- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A graphical user interface (GUI) tool is presented to a user for interacting with an underlying database. The GUI tool includes a field selection and attribute selections for the field. The user selects a field and an attribute for that field and is presented with a first list of values retrieved from the database for the selected attribute. Next, the user selects a filter for the attribute within the GUI tool and a second reduced list of values is presented to the user within the GUI tool representing the filtered first list of values acquired by applying the filter.

## Claims

### Claim 1

A method implemented and programmed within a non-transitory computer-readable storage medium and processed by a processor, the processor configured to execute the method, comprising:
presenting a graphical user interface (GUI) tool to a user, the GUI tool acting as an interface for the user to access a database;
receiving, from the user, a field selection for a field of the database within the GUI tool;
obtaining, from the user, an attribute selection for an attribute assigned to the field within the GUI tool;
displaying within the GUI tool a first list of attribute values retrieved from the database and assigned to the attribute for the field;
acquiring, from the user, an attribute filter; and
filtering the first list to present a reduced second list of attribute values within the GUI tool by applying the filter against the first list.

### Claim 2 (depends on 1)

The method of claim 1, wherein presenting further includes providing the GUI tool as a marketing segmentation tool that is used for assisting in developing custom segments for marketing campaigns of an enterprise.

### Claim 3 (depends on 1)

The method of claim 1, wherein receiving further includes detecting a drop down menu activation from the user within the GUI tool that presents a field list for available fields to the user, the user selects the field from the field list.

### Claim 4 (depends on 1)

The method of claim 1, wherein obtaining further includes presenting an attribute list for available attributes within the GUI tool based on the user selection of the field.

### Claim 5 (depends on 4)

The method of claim 4, wherein obtaining further includes inspecting metadata associated with the selected field to determine the attribute list.

### Claim 6 (depends on 1)

The method of claim 1, wherein displaying further includes querying the database with the field and the attribute to acquire the attribute values for populating the first list.

### Claim 7 (depends on 1)

The method of claim 1, wherein acquiring further includes presenting a filter list to the user within the GUI tool based on selection of the attribute.

### Claim 8 (depends on 7)

The method of claim 7, wherein acquiring further includes inspecting metadata associated with the selected attribute to determine the filter list.

### Claim 9 (depends on 1)

The method of claim 1, wherein filtering further includes presenting a total count for the second list that identifies a total number of attribute values within the second list, the total count presented within the GUI tool to the user.

### Claim 10

A method implemented and programmed within a non-transitory computer-readable storage medium and processed by a processor, the processor configured to execute the method, comprising:
providing a graphical user interface (GUI) tool to a user;
presenting a field selection mechanism within the GUI tool to the user;
displaying an attribute selection mechanism within the GUI tool based on a field selection of the user for a particular field, via the field selection mechanism;
presenting an attribute filter mechanism within the GUI tool based on an attribute selection of the user for a particular attribute;
filtering attribute values associated with the particular attribute based on a filter selection of the user for a particular filter; and
presenting the filtered attribute values within the GUI tool to the user for further review and selection within the GUI tool by the user.

### Claim 11 (depends on 10)

The method of claim 10, wherein providing further includes providing the GUI tool as a front-end interface to an enterprise data warehouse.

### Claim 12 (depends on 10)

The method of claim 10, wherein presenting the field selection mechanism further includes providing the field selection mechanism as a drop down menu listing within the GUI tool for available fields of a particular database table.

### Claim 13 (depends on 10)

The method of claim 10, wherein displaying further includes providing a selectable list of available attributes for the particular field within the GUI tool.

### Claim 14 (depends on 10)

The method of claim 10, wherein displaying further includes displaying an original list of attribute values assigned in a database to the particular attribute within the GUI tool based on the attribute selection for the particular attribute.

### Claim 15 (depends on 14)

The method of claim 14, wherein presenting the attribute filter mechanism further includes presenting the attribute filter mechanism based on comparison of a size for the original list of attribute values against a threshold number where the size exceeds the threshold number.

### Claim 16 (depends on 15)

The method of claim 15, wherein presenting the attribute filter mechanism further includes selecting the threshold number based on the attribute selection for the particular attribute.

### Claim 17 (depends on 15)

The method of claim 15, wherein presenting the attribute filter mechanism further includes selecting the threshold number based on a profile associated with the user that defines the threshold number.

### Claim 18

A processor-implemented system, comprising:
a graphical user interface (GUI) tool programmed within a non-transitory computer-readable medium and to execute on a processor; and
an attribute manager programmed within a non-transitory computer-readable medium and to execute on the processor;
the GUI tool is configured to be presented to a user and provide access to a database, the GUI tool presents a field selection mechanism and an attribute selection mechanism to the user, the attribute manager configured to monitor selections of the user and provide within the GUI tool an attribute filtering mechanism to the user based on a particular attribute selection, the attribute manager is also configured to filter original attribute values assigned in the database to the particular attribute selection to produce a reduced and filtered list of attribute values based on a filter selection from the attribute filtering mechanism.

### Claim 19 (depends on 18)

The system of claim 18, wherein the attribute manager is also configured to resolve and to present within the GUI tool a list of available attributes for the user to make the particular attribute selection based on a field selection for a particular field made by the user via the field selection mechanism of the GUI tool.

### Claim 20 (depends on 18)

The system of claim 18, wherein the GUI tool is a marketing segmentation tool.
