Method and apparatus for creation and maintenance of database structure

• US 7,584,210 B2
• Filed: 02/28/2005
• Issued: 09/01/2009
• Est. Priority Date: 12/28/2001
• Status: Active Grant

• Current Assignee: myList Corp.
• Original Assignee: Channel Intelligence Incorporated (Alphabet Inc.)
• Inventors: Santiago, Anibal, Tryzbiak, Timothy, Couch, Dale, Schrader, David M., Crossmier, David A. III, Wight, Robert, Griffin, Josh, Benson, Edward H. III
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US11/068,424
• Publication Number:
  US 20050149547A1
• Time in Patent Office: 1,646 Days
• Field of Search: 707/100, 707/101, 707/1, 707103 R-103 Z, 707/200, 707 3- 5, 707/10, 705/26
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0623 Item investigation
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The invention provides a method for configuring a database system to store information regarding a plurality of items, the method comprising: establishing a database on a computer system; establishing within the database a first object corresponding to a first item of the plurality of items; generating within the first object at least one field; associating a field identifier with each the field; and storing at least a portion of the information within each the field; the database system configured to store information regarding a plurality of items, each item in the plurality of items having at least one item attribute, the database system comprising a computer having memory, a database stored in said memory, a first object in said database corresponding to one item of the plurality of items, said first object corresponding to the first item, at least one field in said first object, a field identifier associated with each said field, and information regarding said first item stored in said first object.

Claims

1. A method for configuring a database system to store information regarding a plurality of items for purchase in electronic commerce, said method comprising:

establishing a database on a computer system;

establishing within said database a first product object corresponding to a first item of the plurality of items;

generating within said first product object a plurality of product object fields;

associating a product object field identifier with each product object field of said plurality of product object fields;

capturing information related to a second item;

determining, based on querying said database, whether said information related to said second item corresponds said first product object;

responsive to determining that said information related to said second item corresponds to said first product object, creating, in said database, a vendor object corresponding to said information related to said second item;

establishing within said vendor object a plurality of vendor object fields; and

associating said vendor object with said first product object, said database configured, in response to a change to at least one field of said plurality of product object fields of said first product object, to update said vendor object.

2. The method of claim 1, further comprising:

generating a product object attribute for each one of said plurality of product object fields, said product object attribute describing a type of information stored in a corresponding product object field.

3. The method of claim 2 wherein the vendor object only contains fields relevant to the information related to the second item.

4. The method of claim 1, further comprising:

generating a vendor object attribute for each one of said plurality of vendor object fields, the vendor object attribute describing a type of information stored in a corresponding vendor object field.

5. The method of claim 1 wherein said first item and said second item are versions of the same product.

6. A method of configuring a database system to store information regarding a plurality of items, the method comprising:

(a) receiving information related to a first plurality of items;

(b) providing a template database, storing a plurality of item templates, each of the plurality of item templates corresponding to an information structure;

(c) determining an information structure for each item of the first plurality of items;

(d) retrieving a template of the plurality of templates for each item of the first plurality of items based on the information structure of each item of the first plurality of items;

(e) applying the template related to each item to parse the information related to each item; and

(f) capturing the parsed information.

7. The method of claim 6 wherein the capturing of (f) includes:

i) creating an object for each of the first plurality of items wherein each item of the plurality has at least one attribute; and

ii) creating a field for each of at least one attribute of each item of the plurality.

8. The method of claim 7 wherein each field has an associated field identifier.

9. The method of claim 8 wherein each field identifier defines the type of information to be stored within a field associated with the field identifier.

10. The method of claim 8 wherein the capturing of (f) includes:

iii) generating within a first object at least one object field;

iv) associating an object field identifier with each said object field;

v) defining at least one attribute of the plurality of items;

vi) creating an attribute field identifier corresponding to each defined attribute of the plurality of items, said attribute field identifiers comprising a set of attribute field identifiers; and

vii) utilizing said first object, said object field, said object field identifier, said attribute, and said set of attribute field identifiers to efficiently store said portion of said information regarding said plurality of items in said object fields.

11. The method of claim 6, further comprising:

(g) establishing an item database on a server computer system, the item database storing information relating to a second plurality of items.

12. The method of claim 11, further comprising:

(h) comparing the captured parsed information to the item database.

13. The method of claim 12, further comprising:

(i) responsive to a pre-established rule, revising the information stored in said item database relating to the second plurality of items to include the information relating to the first plurality of items.

14. A method of adding information about items to a database holding information concerning a plurality of items, the method comprising:

a) detecting and capturing information about a product from a provider computer system;

(b) querying a product database to determine whether the product database contains a product object corresponding to the product;

(c) determining that the product database does not include the product object corresponding to the product; and

(d) creating a new product object corresponding to the information about the product.

15. The method of claim 14, further comprising:

(e) creating a new vendor object corresponding to the information about the product.

16. The method of claim 14, further comprising:

(f) verifying the information detected and captured in (a).