User-friendly search results display system, method, and computer program product

• US 7,124,148 B2
• Filed: 07/31/2003
• Issued: 10/17/2006
• Est. Priority Date: 07/31/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Sauermann, Volker
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US10/630,921
• Publication Number:
  US 20050027694A1
• Time in Patent Office: 1,174 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206
• US Class Current: 707/740
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/962 Entity-attribute-value
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

If search result records from a database search have an attribute that at least two of the search result records share, but which was not used in the query, then categories are created to correspond to values of the shared attribute. The categories can be displayed in a user-friendly manner, as can a list of the search result records associated with a selected category.

Claims

1. A computer-implemented method for presenting a plurality of search result records from a query comprising:

defining a shared attribute, that was not used in the query, based on values common to a plurality of search result records,

wherein defining includes;

determining a first set of defined values for a first attribute,

determining a second set of defined values for a second attribute, and

classifying the first attribute and the second attribute as a single shared attribute if the first set of defined values and the second set of defined values share a common set of defined values;

creating a category corresponding to a value of the shared attribute,

wherein creating a category includes;

determining a first number of search result records corresponding to a first category,

determining a second number of search result records corresponding to a second category, and

combining the first category and the second category into a new category if the sum of the first number and the second number is less than a predetermined threshold;

displaying the category; and

displaying a list of the search result records associated with the displayed category.

2. The method of claim 1, wherein displaying the category further comprises:

displaying the category as a labeled tab.

3. The method of claim 1, wherein displaying the category further comprises:

displaying the category as a labeled button.

4. The method of claim 1, wherein a search result record having a value of null for the identified attribute is associated with the category.

5. The method of claim 1, wherein combining includes:

combining the first category and the second category into a new category if the sum of the first number and the second number are less than a third number of records in a third category.

6. A system for presenting a plurality of search result records from a query comprising:

means for defining a shared attribute, that was not used in the query, based on values common to a plurality of search result records,

wherein the means for defining an attribute includes;

means for determining a first set of defined values for a first attribute,

means for determining a second set of defined values for a second attribute, and

means for classifying the first attribute and the second attribute as a single shared attribute if the first set of defined values and the second set of defined values share a common set of defined values;

means for creating a category corresponding to a value of the shared attribute,

wherein the means for creating a category includes;

means for determining a first number of search result records corresponding to a first category,

means for determining a second number of search result records corresponding to a second category, and

means for combining the first category and the second category into a new category if a sum of the first number and the second number is less than a predetermined threshold;

means for displaying the category; and

means for displaying a list of the search result records associated with the displayed category.

7. The system of claim 6, wherein the means for displaying the category further comprises:

means for displaying the category as a labeled tab.

8. The system of claim 6, wherein the means for displaying the category further comprises:

means for displaying the category as a labeled button.

9. The system of claim 6, wherein a search result record having a value of null for the identified attribute is associated with the category.

10. The system of claim 6, wherein the means for combining includes:

means for combining the first category and the second category into a new category if the sum of the first number and the second number are less than a third number of search result records in a third category.

11. A computer readable storage medium for presenting a plurality of search result records from a query comprising code for causing a processor to perform the steps of:

defining a shared attribute, that was not used in the query, based on values common to a plurality of search result records,

wherein defining an attribute includes;

determining a first set of defined values for a first attribute,

determining a second set of defined values for a second attribute, and

classifying the first attribute and the second attribute as a single shared attribute if the first set of defined values and the second set of defined values share a common set of defined values;

creating a category corresponding to a value of the shared attribute,

wherein creating a category includes;

determining a first number of search result records corresponding to a first category,

determining a second number of search result records corresponding to a second category, and

combining the first category and the second category into a new category if the sum of the first number and the second number is less than a predetermined threshold;

displaying the category; and

displaying a list of the search result records associated with the displayed category.

12. The medium of claim 11, wherein displaying the category further comprises:

displaying the category as a labeled tab.

13. The medium of claim 11, wherein displaying the category further comprises:

displaying the category as a labeled button.

14. The medium of claim 11, wherein combining includes:

combining the first category and the second category into a new category if the sum of the first number and the second number are less than a third number of records in a third category.