Automobile inventory engine

• US 20040039646A1
• Filed: 08/22/2002
• Published: 02/26/2004
• Est. Priority Date: 08/22/2002
• Status: Abandoned Application

• Current Assignee: Reynolds and Reynolds Holdings Incorporated
• Original Assignee: Reynolds and Reynolds Holdings Incorporated
• Inventors: Hacker, Bruce
• Application Number:
  US10/226,568
• Publication Number:
  US 20040039646A1
• Time in Patent Office: Days
• US Class Current: 705/22
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/203 Inventory monitoring

Abstract

In the disclosed automobile inventory system and methods, automobile report data is received from information sources having incompatible data formats. The report data is reformatted in a uniform format. A vehicle identification number (VIN) for the automobile is decoded to produce a set of automobile attributes. Attributes are matched with received third party automobile report data. A photograph is selected to represent the automobile. The color of the selected photograph substantially matches an identified color of the automobile. A database is populated with database data, including the reformatted report data, attribute matching data, and data associated with the colorized photograph. The database data is filtered or modified based on at least one dealer business rule, and the database data is electronically communicated to a World Wide Web accessible server. The database data is updated in real time.

Claims

1. A method of delivering real-time automobile inventory information over the World Wide Web, the method comprising:

(a) receiving automobile report data from a plurality of information sources, the information sources having distinct incompatible data formats, an information source including a dealer management system, a third party information provider, and a sticker service company, the report data relating to at least one automobile associated with a dealer location,

wherein the receiving includes at least one of accessing an information source and receiving report data via FTP (File Transfer Protocol);

(b) reformatting the report data in a single uniform format, the reformatting involving at least one API (application programmatic interface), the at least one API including at least one XML (Extensible Markup Language) configuration file associated with an information source, the configuration file including information to map the report data to the single uniform format;

(c) decoding a vehicle identification number (VIN) associated with the at least one automobile, the decoding producing a set of automobile attributes;

(d) matching at least one among the produced set of automobile attributes with received third party automobile report data;

(e) selecting, from a set of photographs, a photograph to represent the at least one automobile, the selecting including running an algorithm based at least in part on model number information of the at least one automobile, wherein the selected photograph is colorized to substantially match an identified color of the at least one automobile;

(f) populating at least one database with database data, the database data including the reformatted report data, data associated with the matching of automobile attributes, and optionally data associated with the colorized photograph;

(g) filtering or modifying the database data based at least in part on at least one dealer business rule, the filtering or modifying involving applying a dealer discount rule to the database data;

(h) electronically communicating at least a portion of the database data to a World Wide Web accessible server;

(i) updating the database data in real time, the updating involving multithreading;

(j) sending, by an information source, report data via HTML (Hypertext Markup Language);

(k) comparing first report data with second report data, the comparing producing update information for a database update;

(l) correcting errors in received data based at least in part on agreement of data between information sources;

(m) formatting the filtered or modified database data for a target web server;

(n) monitoring sales data of automobiles associated with the dealer location;

(o) recording sales data associated with sales of automobiles; and

(p) storing, at least in part, the received or reformatted report data in a data warehouse.

2. A method of delivering automobile inventory information over the World Wide Web, the method comprising:

(a) receiving automobile report data from a plurality of information sources, the information sources having distinct incompatible data formats, the report data relating to at least one automobile associated with a dealer location;

(b) reformatting the report data in a single uniform format, the reformatting involving at least one API (application programmatic interface);

(c) decoding a vehicle identification number (VIN) associated with the at least one automobile, the decoding producing a set of automobile attributes;

(d) matching at least one among the produced set of automobile attributes with received third party automobile report data;

(e) populating at least one database with database data, the database data including the reformatted report data and data associated with the matching of automobile attributes; and

(f) electronically communicating at least a portion of the database data to a World Wide Web accessible server.

3. The method of claim 2, further comprising selecting, from a set of photographs, a photograph to represent the at least one automobile.

4. The method of claim 3, wherein the selected photograph is colorized to substantially match an identified color of the at least one automobile.

5. The method of claim 3, wherein the selecting includes running an algorithm based at least in part on model number information of the at least one automobile.

6. The method of claim 3, wherein the database data includes data associated with the selected photograph.

7. The method of claim 2, further comprising filtering or modifying the database data based at least in part on at least one dealer business rule.

8. The method of claim 7, wherein the filtering or modifying involves applying a dealer discount rule to the database data.

9. The method of claim 7, further comprising formatting the filtered or modified database data for a target web server.

10. The method of claim 2, further comprising updating the database data in real time.

11. The method of claim 10, wherein the updating the database data involves multithreading.

12. The method of claim 2, wherein an information source includes a dealer management system.

13. The method of claim 2, wherein an information source includes a third party information provider.

14. The method of claim 2, wherein an information source includes a sticker service company.

15. The method of claim 2, further comprising receiving automobile report data from information sources having compatible data formats.

16. The method of claim 2, wherein the receiving includes accessing an information source.

17. The method of claim 2, wherein the receiving includes receiving report data via FTP (File Transfer Protocol).

18. The method of claim 2, further comprising sending, by an information source, report data via HTML (Hypertext Markup Language).

19. The method of claim 2, further comprising comparing first report data with second report data, the comparing producing update information for a database update.

20. The method of claim 2, further comprising correcting errors in received data based at least in part on agreement of data between information sources.

21. The method of claim 2, wherein the at least one API includes at least one XML (Extensible Markup Language) configuration file associated with an information source, the configuration file including information to map the report data to the single uniform format.

22. The method of claim 2, further comprising monitoring sales data of automobiles associated with the dealer location.

23. The method of claim 2, further comprising recording sales data associated with sales of automobiles.

24. The method of claim 2, further comprising storing, at least in part, the received or reformatted report data in a data warehouse.

25. A system to deliver real-time automobile inventory information over the World Wide Web, the system comprising:

(a) a reformatter to reformat automobile report data in a single uniform format, the automobile report data being received from a plurality of information sources having distinct incompatible data formats, the report data relating to at least one automobile associated with a dealer location, the reformatter configured to apply a plurality of application programmatic interfaces (APIs) to transform the respective data formats to the single uniform format, wherein the reformatter includes an inventory processor configured to process report data based at least in part on a priority associated with an information source, and wherein the reformatter utilizes Enterprise Java Beans (EJBs);

(b) a vehicle identification number (VIN) decoder to decode a VIN associated with the at least one automobile, the decoder producing a set of automobile attributes;

(c) a third party data matching application to match at least one among the produced set of automobile attributes with received third party automobile report data;

(d) a database having database data including the reformatted report data and data matched by the third party data matching application;

(e) a filter to filter or modify the database data based at least in part on at least one dealer business rule, wherein the at least one dealer business rule is stored in a module that is specific to the filter and involves custom logic;

(f) a configuration utility to configure a webpage by which the filtered or modified database data is made available to the user; and

(g) a photo matching application to select a photograph from a set of photographs to represent the at least one automobile, wherein a color of the selected photograph substantially matches an identified color of the at least one automobile, wherein a colorizing engine colorizes a photograph to produce the selected photograph, wherein the database data includes data associated with the selected photograph, wherein

the database data is updated in real time,

the received or reformatted report data is stored, at least in part, in a data warehouse, and

at least a portion of the database data is electronically communicated to a World Wide Web accessible server.

26. A system to deliver real-time automobile inventory information over the World Wide Web, the system comprising:

(a) a reformatter to reformat automobile report data in a single uniform format, the automobile report data being received from a plurality of information sources having distinct incompatible data formats, the report data relating to at least one automobile associated with a dealer location, the reformatter configured to apply a plurality of application programmatic interfaces (APIs) to transform the respective data formats to the single uniform format;

(b) a vehicle identification number (VIN) decoder to decode a VIN associated with the at least one automobile, the decoder producing a set of automobile attributes;

(c) a third party data matching application to match at least one among the produced set of automobile attributes with received third party automobile report data; and

(d) a database having database data including the reformatted report data and data matched by the third party data matching application,

wherein at least a portion of the database data is electronically communicated to a World Wide Web accessible server.

27. The system of claim 26, further comprising a filter to filter or modify the database data based at least in part on at least one dealer business rule.

28. The system of claim 27, wherein the at least one dealer business rule is stored in a module that is specific to the filter.

29. The system of claim 27, wherein the at least one dealer business rule involves custom logic.

30. The system of claim 26, wherein the database data is updated in real time.

31. The system of claim 26, wherein the received or reformatted report data is stored, at least in part, in a data warehouse.

32. The system of claim 26, wherein the reformatter includes an inventory processor configured to process report data based at least in part on a priority associated with an information source.

33. The system of claim 26, wherein the reformatter utilizes Enterprise Java Beans (EJBs).

34. The system of claim 26, further comprising a configuration utility to configure a webpage by which the filtered or modified database data is made available to the user.

35. The system of claim 26, further comprising a photo matching application to select a photograph from a set of photographs to represent the at least one automobile, wherein a color of the selected photograph substantially matches an identified color of the at least one automobile.

36. The system of claim 35, wherein a colorizing engine colorizes a photograph to produce the selected photograph.

37. The system of claim 35, wherein the database data includes data associated with the selected photograph.

38. A computer-readable medium encoded with a plurality of processor-executable instructions for:

(a) receiving automobile report data from a plurality of information sources, the information sources having distinct incompatible data formats, an information source including a dealer management system, a third party information provider, and a sticker service company, the report data relating to at least one automobile associated with a dealer location,

wherein the receiving includes at least one of accessing an information source and receiving report data via FTP (File Transfer Protocol);

(b) reformatting the report data in a single uniform format, the reformatting involving at least one API (application programmatic interface), the at least one API including at least one XML (Extensible Markup Language) configuration file associated with an information source, the configuration file including information to map the report data to the single uniform format;

(c) decoding a vehicle identification number (VIN) associated with the at least one automobile, the decoding producing a set of automobile attributes;

(d) matching at least one among the produced set of automobile attributes with received third party automobile report data;

(e) selecting, from a set of photographs, a photograph to represent the at least one automobile, the selecting including running an algorithm based at least in part on model number information of the at least one automobile, wherein the selected photograph is colorized to substantially match an identified color of the at least one automobile;

(f) populating at least one database with database data, the database data including the reformatted report data, data associated with the matching of automobile attributes, and optionally data associated with the colorized photograph;

(g) filtering or modifying the database data based at least in part on at least one dealer business rule, the filtering or modifying involving applying a dealer discount rule to the database data;

(h) electronically communicating at least a portion of the database data to a World Wide Web accessible server;

(i) updating the database data in real time, the updating involving multithreading;

(j) sending, by an information source, report data via HTML (Hypertext Markup Language);

(k) comparing first report data with second report data, the comparing producing update information for a database update;

(l) correcting errors in received data based at least in part on agreement of data between information sources;

(m) formatting the filtered or modified database data for a target web server;

(n) monitoring sales data of automobiles associated with the dealer location;

(o) recording sales data associated with sales of automobiles; and

(p) storing, at least in part, the received or reformatted report data in a data warehouse.

39. A computer-readable medium encoded with a plurality of processor-executable instructions for:

(a) receiving automobile report data from a plurality of information sources, the information sources having distinct incompatible data formats, the report data relating to at least one automobile associated with a dealer location;

(b) reformatting the report data in a single uniform format, the reformatting involving at least one API (application programmatic interface);

(c) decoding a vehicle identification number (VIN) associated with the at least one automobile, the decoding producing a set of automobile attributes;

(d) matching at least one among the produced set of automobile attributes with received third party automobile report data;

(e) populating at least one database with database data, the database data including the reformatted report data and data associated with the matching of automobile attributes; and

(f) electronically communicating at least a portion of the database data to a World Wide Web accessible server.

40. The computer-readable medium of claim 39, further comprising processor-executable instructions for selecting, from a set of photographs, a photograph to represent the at least one automobile.

41. The computer-readable medium of claim 40, wherein the selected photograph is colorized to substantially match an identified color of the at least one automobile.

42. The computer-readable medium of claim 39, further comprising processor-executable instructions for filtering or modifying the database data based at least in part on at least one dealer business rule.

43. The computer-readable medium of claim 39, further comprising processor-executable instructions for updating the database data in real time.