Collecting and valuating used items for sale

• US 7,152,778 B2
• Filed: 06/18/2004
• Issued: 12/26/2006
• Est. Priority Date: 06/23/2003
• Status: Expired due to Fees

• Current Assignee: Worldwide Creative Techniques, LLC
• Original Assignee: Bitstocks Co.
• Inventors: Hartenstine, Troy A.
• Primary Examiner(s): Stcyr, Daniel
• Assistant Examiner(s): Labaze, Edwyn
• Application Number:
  US10/870,158
• Publication Number:
  US 20040267818A1
• Time in Patent Office: 921 Days
• Field of Search: 235/375, 235/379, 235/385, 235/487, 235/485, 705/1, 705 26- 29
• US Class Current: 235/375
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0605 Supply or demand aggregation

Abstract

Data is collected and aggregated regarding a particular used item for sale, e.g., automobiles, which is in turn validated and normalized with respect to pre-determined identification models. A historical report may be generated to provide an assessment of value based on qualitative information such as mileage and/or location, and may be presented in a multi-axis graphic format. Data records are collected from a plurality of sources over the Internet, and are validated by comparing data field entries in the aggregate data records with data field entries in an established validation database. The validated data records are normalized with respect to a predetermined set or sets of fields by assigning an identification unit to each validated data record. A web crawler to seek out suitable data records relating to the used items that are sought, a search engine is queried to derive a list of suitable high probability target URLs.

Claims

1. A method of aggregating a database of items for sale, comprising:

activating a web crawler into a plurality of different network sites;

collecting a plurality of data records corresponding to said items for sale from said plurality of different network sites;

validating each of said plurality of data records to confirm that it is a item of the desired type for sale;

normalizing each of said plurality of data records with one of a pre-defined list of identification units; and

providing a user with market price information for a particular condition of a particular item for sale from said items for sale, said market price information based on said plurality of data records from said plurality of different network sites.

2. The method of aggregating a database of items for sale according to claim 1, wherein said normalizing comprises:

identifying at least one of a make and model of said item for sale.

3. The method of aggregating a database of items for sale according to claim 1, wherein said normalizing comprises:

identifying a year of said item for sale.

4. The method of aggregating a database of items for sale according to claim 1, wherein said collecting comprises:

querying at least one search engine for the identity of network sites of items corresponding to a search term relevant to finding said items for sale.

5. The method of aggregating a database of items for sale according to claim 1, further comprising:

for any of said plurality of data records that could not be validated, moving said data record to a discard administration database.

6. The method of aggregating a database of items for sale according to claim 1, further comprising:

moving each of said plurality of data records that are successful in both validating and normalizing to a normalized database.

7. The method of aggregating a database of items for sale according to claim 6, wherein said normalized database comprises:

a plurality of data records corresponding to items currently for sale; and

a plurality of data records corresponding to items already sold.

8. The method of aggregating a database of items for sale according to claim 6, wherein:

said normalized database is partitioned into separate sub-databases based on a common association with a same identification unit.

9. The method of aggregating a database of items for sale according to claim 1, wherein:

said items for sale are used vehicles.

10. The method of aggregating a database of items for sale according to claim 9, wherein:

said used vehicles are used automobiles.

11. The method of aggregating a database of items for sale according to claim 10, wherein:

said validating confirms that a data record includes at least one data field relating to a year, make and model of said used automobile.

12. The method of aggregating a database of items for sale according to claim 11, wherein:

said validating further confirms that a data record includes at least one data field relating to a price of said used automobile.

13. The method of aggregating a database of items for sale according to claim 11, wherein:

said validating further confirms that a data record includes at least one data field relating to a mileage of said used automobile.

14. The method of aggregating a database of items for sale according to claim 1, wherein:

said normalizing matches a data record with a unique combination of year, make and model of said item for sale.

15. The method of aggregating a database of items for sale according to claim 1, wherein:

said items for sale are used boats.

16. The method of aggregating a database of items for sale according to claim 1, wherein:

said items for sale are collectibles.

17. The method of aggregating a database of items for sale according to claim 1, wherein:

said identification unit is numerical.

18. The method of aggregating a database of items for sale according to claim 1, wherein:

said identification unit is alphanumerical.

19. The method of aggregating a database of items for sale according to claim 1, further comprising:

generating a relationship between said particular condition of said item for sale and said price.

20. The method of aggregating a database of items for sale according to claim 19, wherein:

said item for sale is a used automobile; and

said particular condition of said item for sale is a mileage;

wherein a plot of mileage vs. said price is generated from historical data including items that have previously sold.

21. Apparatus for aggregating a database of items for sale, comprising:

means for activating a web crawler into a plurality of different network sites;

means for collecting a plurality of data records corresponding to said items for sale from a plurality of different network sites;

means for validating each of said plurality of data records to confirm that it is a item for sale of the desired type for sale;

means for normalizing each of said plurality of data records with one of a pre-defined list of identification units; and

means for providing a user with market price information for a particular condition of a particular item for sale from said items for sale, said market price information based on said plurality of data records from said plurality of different network sites.

22. The apparatus for aggregating a database of items for sale according to claim 21, wherein said means for collecting comprises:

means for querying at least one search engine for the identity of network sites of items corresponding to a search term relevant to finding said items for sale.

23. The apparatus for aggregating a database of items for sale according to claim 21, further comprising:

means for moving said data record to a discard administration database if said data record could not be validated.

24. The apparatus for aggregating a database of items for sale according to claim 21, further comprising:

means for moving each of said plurality of data records that are successful in both validating and normalizing to a normalized database.

25. The apparatus for aggregating a database of items for sale according to claim 21, wherein:

said items for sale are used vehicles.

26. The apparatus for aggregating a database of items for sale according to claim 25, wherein:

said vehicles are used automobiles.

27. The apparatus for aggregating a database of items for sale according to claim 26, wherein said means for validating comprises:

confirming that a data record includes at least one data field relating to a year, make and model of said used automobile.

28. The apparatus for aggregating a database of items for sale according to claim 27, wherein said means for validating further comprises:

confirming that a data record includes at least one data field relating to said price of said used automobile.

29. The apparatus for aggregating a database of items for sale according to claim 28, wherein said normalized database comprises:

a plurality of data records corresponding to items currently for sale; and

a plurality of data records corresponding to items already sold.

30. The apparatus for aggregating a database of items for sale according to claim 28, wherein:

said normalized database is partitioned into separate sub-databases based on a common association with a same identification unit.

31. The apparatus for aggregating a database of items for sale according to claim 27, wherein:

said means for validating further confirms that a data record includes at least one data field relating to a mileage of said used automobile.

32. The apparatus for aggregating a database of items for sale according to claim 25, wherein:

said items for sale are used boats.

33. The apparatus for aggregating a database of items for sale according to claim 25, wherein:

said items are collectibles.

34. The apparatus for aggregating a database of items for sale according to claim 25, wherein:

said identification unit is numerical.

35. The apparatus for aggregating a database of items for sale according to claim 25, wherein:

said identification unit is alphanumerical.

36. The apparatus for aggregating a database of items for sale according to claim 25, further comprising:

means for generating a relationship between said particular condition of said item for sale, and said price.

37. The apparatus for aggregating a database of items for sale according to claim 36, wherein:

said item for sale is a automobile; and

said particular condition of said item for sale is a mileage;

wherein a plot of mileage vs. said price is generated from historical data including items that have previously sold.

38. The apparatus for aggregating a database of items for sale according to claim 21, wherein said means for normalizing comprises:

matching a data record with a unique combination of year, make and model of said item for sale.