SYSTEM AND METHOD FOR HANDLING ITEM LISTINGS WITH GENERIC ATTRIBUTES

• US 20070088722A1
• Filed: 11/09/2006
• Published: 04/19/2007
• Est. Priority Date: 04/24/2000
• Status: Active Grant

• Current Assignee: eBay Inc.
• Original Assignee: eBay Inc.
• Inventors: Wang, Hsiaozhang
• Granted Patent: US 7,536,402 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/288 Entity relationship models
• 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: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: Y10S 707/962 Entity-attribute-value
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system for storing a plurality of items across different categories in a database including a database that stores a data structure that has item entries for items of different categories. Each item entry includes one or more associated attributes. The attributes may be shared by multiple items across more than one category.

Claims

1. A system for searching a database of item listings comprising:

a database component including a data structure that stores items with associated attributes, the items being represented in a plurality of categories and at least one attribute being shared by a plurality of items across at least two categories.

2. The system of claim 1, wherein the database component includes a data structure that associates an identifier of an attribute with an entry selected from a group of entries comprising an attribute name, attribute type and a site identifier.

3. The system of claim 1, wherein the database component includes a data structure that stores the items, and associated attributes, represented in the plurality of categories.

4. The system of claim 1, wherein the database component includes a data structure that translates attributes based on parameters associated with an item of the items, including category.

5. The system of claim 1, wherein the database component includes a data structure that defines allowable values for each attribute.

6. A method for searching a database of item listings comprising:

receiving search parameters including an attribute associated with a category of items searched;

locating a first plurality of items that match the attribute, the plurality of items being stored within a data structure containing items belonging to more than one category;

selectively removing, from the first plurality of items, items from different categories than the category of items searched, to generate a second plurality of items; and

presenting the second plurality of items to a user.

7. The method of claim 6, including:

validating the search parameters against valid attribute values stored within a data structure.

8. The method of claim 6, including:

utilizing a translation data structure to determine category specific display characteristics of the attribute selected from a group comprising display position, display length, and attribute position.

9. The method of claim 6, wherein the items searched include items from a plurality of sites.

10. The method of claim 9, wherein the selective removal includes matching both the category of items searched and a site of the plurality of sites.

11. A system for storing items in a database, the system comprising:

an interface module to receive data; and

a database component including;

a data structure that stores a plurality of items, each with one or more associated attributes, the items being categorized into a plurality of categories and at least one attribute being shared by the plurality of items across at least two different categories of the plurality of categories; and

a data structure that translates attributes being shared by the plurality of categories into category specific attributes.

12. The system of claim 11, including a data structure that stores valid values for each attribute.

13. The system of claim 12, wherein the valid values for each attribute are represented by a minimum and maximum value.

14. The system of claim 12, wherein a valid value of each attribute is represented by one or more specific values.

15. The system of claim 11, including a data structure that associates an identifier of an attribute with a name and a type of the attribute.

16. A method for storing items in a database, the method comprising:

receiving a data entry including an item with an attribute;

validating the attribute against a data structure containing valid values for the attribute; and

storing the item in a data structure containing items from a plurality of categories, and the attribute is being shared across two categories;

17. The method of claim 16, wherein the valid values for the attribute include a minimum and maximum value.

18. The method of claim 16, wherein the valid values for the attribute include a plurality of specific values.

19. The method of claim 16, including storing attribute mapping information in a data structure, wherein the data structure includes a plurality of elements selected from a group comprising:

attribute position;

attribute display length;

attribute display position;

attribute identification; and

a search flag.

20. The method of claim 19, wherein the mapping information is used to determine how the attribute will be displayed when used within a particular category.