METHOD AND APPARATUS FOR CREATION AND MAINTENANCE OF DATABASE STRUCTURE

• US 20090006220A1
• Filed: 06/04/2008
• Published: 01/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, Couch, Dale, Tryzbiak, Timothy, Schrader, David M., Crossmier, David A. III, Wight, Robert, Griffin, Josh, Benson, Edward H. III
• Granted Patent: US 7,885,982 B2
• Time in Patent Office: Days
• US Class Current: 705/27
• 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 offering products and services for sale, the method comprising:

(a) establishing a first list of goods or services on a server of a manufacturer related to a website of the manufacturer;

b) establishing a direct link from the first list to a second list of goods and services on a server of a retailer related to a website of the retailer;

(c) presenting at least a portion of the first list of goods or services to a consumer at the website of the manufacturer;

(d) receiving an indication of interest in a good or service; and

(e) linking directly to the second list of goods and services at the website of the retailer without leaving the website of the manufacturer.

2. The method of claim 1, further comprising:

(f) automatically updating the first list of goods or services on the server of the manufacturer when the second list is updated.

3. The method of claim 1 wherein the first list of goods or services includes a first list object, wherein the first list object includes a first list field.

4. The method of claim 1 wherein the good or service corresponds to a first list object in the first list of goods or services.

5. The method of claim 4 wherein the first list object corresponds to a second list identifier, wherein the second list identifier is associated with the second list of goods and services.

6. The method of claim 3 wherein the establishing of (b) includes:

i) generating a second list identifier corresponding to the second list of goods and services; and

ii) associating the second list identifier with the first list object.

7. The method of claim 6 wherein the second list identifier is unique.

8. The method of claim 3 wherein the first list object is a copy of at least a portion of a second list object contained in the second list of goods or services.

9. The method of claim 3 wherein the first list field contains a pointer referencing a second object in the second list of goods or services.

10. The method claim 2 wherein the updating of (f) occurs each time the first list of goods or services is accessed.

11. The method of claim 1, further comprising:

g) establishing a first plurality of additional lists of products or services at the manufacturer server;

h) establishing a plurality of direct links from the first plurality of additional lists to a second plurality of additional lists of goods and services on a plurality of retail servers; and

(i) associating each of the first list and the first plurality of additional lists with a corresponding list identifier.

12. The method of claim 11 wherein each list identifier is associated with a particular product.

13. A system for offering products or services, the system comprising:

(a) a manufacturer server, the manufacturer server storing a first list of goods or services;

(b) a vendor server, the vender server storing a second list of goods or services, wherein a direct link is established from the first list to the second list;

(c) a manufacturer website that presents at least a portion of the first list responsive to the request of a user; and

(d) a vendor website, related to the second list, wherein when a request is received at the manufacturer website from the user, at least a portion of the vendor website is displayed according to the direct link and the user remains at the manufacturer website.

14. The system of claim 13 wherein the first list of goods or services includes a first list object, wherein the first list object includes a first list field.

15. The system of claim 14 wherein the direct link is formed by:

i) generating a second list identifier corresponding to the second list of goods and services; and

ii) associating the second list identifier with the first list object.

16. The system of claim 15 wherein the second list identifier is unique.

17. The system of claim 13 wherein the first list is automatically updated according to a change in the second list.

19. The method of claim 13 wherein the first list includes a first list object, wherein the first list object includes a first list field.

20. The method of claim 14 wherein the first direct link is formed by:

i) generating a second list identifier corresponding to the second list; and

ii) associating the second list identifier with the first list object.

18. A method for a manufacturer to link to products for sale through manufacturer websites, the method comprising:

(a) establishing a list database on a manufacturer server, the list database including a first plurality of lists, each associated with a corresponding list identifier, the first plurality of lists including a first list associated with a first list identifier, wherein each list identifier and each list of the first plurality relates to a product;

b) establishing a plurality of direct links from the first plurality of lists to a second plurality of lists on a plurality of vendor servers related to a plurality of vendors, wherein the first list has a first direct link to a second list;

(c) receiving an indication, from a consumer at a manufacturer website, related to a desired product corresponding to the first list; and

(d) linking directly to the second list according to the first direct link, wherein the user remains at the manufacturer website.

21. The method of claim 18 wherein the associating includes storing the second list identifier in the first list field.

22. A method implemented by a server computer operatively coupled across a network to a client computer, the method comprising:

(a) responsive to receipt of data from a management tool executing on the client computer, establishing a first list associated with the user on a list database, said list database including a plurality of lists, each associated with a corresponding list identifier, the first list being associated with a first list identifier;

b) receiving the first list identifier from the client computer system;

(c) responsive to receiving the first list identifier;

i) retrieving the first list from the list database; and

ii) communicating the first list to the management tool for presentation to the user, the management tool allowing the user to revise the first list to generate a revised first list; and

(d) responsive to receiving data from the client computer corresponding to the revised first list, updating the first list in the list database to reflect the revised first list.