Database optimization and distributed computing using thin locator style records
Systems and methods of database optimization and distributed computing using thin locator style records are described herein. In some embodiments, a method includes distributing remote agents to a plurality of remote computing systems, generating standardized inventory records received via the remote agents, generating a database of available inventory that comprises complete standardized inventory records, generating thin locator style records for the complete standardized inventory records, the thin locator style records comprising key record identifiers receiving a query, the query comprising a price quote request, generating a standardized query based on the received query; selecting the thin locator style records in response to the standardized query; obtaining the complete standardized inventory records corresponding to the thin locator style records of the key record identifiers included in the price quote request; and providing the complete inventory records to a requestor.
1. A computer-implemented method, comprising:
distributing remote agents to a plurality of remote computing systems;
generating standardized inventory records received via the remote agents;
generating a database of available inventory that comprises complete standardized inventory records;
generating and storing in cache memory thin locator style records, the thin locator style records configured to be used for periodic updates to the database, for the complete standardized inventory records, the thin locator style records comprising key record identifiers that are indicative of content included in the complete standardized inventory records;
receiving a query, the query comprising a price quote request;
generating a standardized query based on the received query;
selecting the thin locator style records in response to the standardized query;
obtaining the complete standardized inventory records corresponding to the thin locator style records of the key record identifiers included in the price quote request; and
providing the complete standardized inventory records to a requestor.
2. The method according to claim 1 , wherein each of the plurality of remote computing systems is coupled with an original equipment manufacturer system and at least a portion of the complete standardized inventory records are obtained from the original equipment manufacturer system.
3. The method according to claim 1 , wherein each of the plurality of remote computing systems is coupled with a non-dealership system and at least a portion of the complete standardized inventory records are obtained from the non-dealership system.
4. The method according to claim 1 , wherein incoming inventory is received periodically from the remote agents.
5. The method according to claim 1 , wherein the database stores information concerning a plurality of vehicles available for sale, the stored information including a plurality of features for each vehicle.
6. The method according to claim 5 , wherein the price quote request specifies a make and model for a requested vehicle.
7. The method according to claim 6 , wherein the complete standardized inventory records comprise a first set of vehicles from the plurality of vehicles which match the make and model of the requested vehicle.
8. The method according to claim 7 , further comprising
determining that a first set of complete standardized inventory records does not meet a predefined target, the predefined target including a minimum number of vehicles for inclusion in the price quote response;
identifying a body style of the requested vehicle; and
retrieving a second set of complete standardized inventory records from the database, the second set of complete standardized inventory records including a second set of vehicles from the plurality of vehicles which match at least the body style of the requested vehicle.
9. The method according to claim 8 , further comprising:
selecting a third set of vehicles from the first and second sets of complete standardized inventory records for a price quote response in accordance with the predefined target; and
generating the price quote response.
10. The method of claim 1 , wherein a minimum number of vehicles is defined prior to receiving the price quote request.
11. The method of claim 1 , wherein incoming inventory is received and thin locator style records are generated such that the database of available inventory never more than 24 hours old.
12. A system comprising:
remote agents distributed to a plurality of remote computing systems; and
a server in communication with the remote agents that:
distributes remote agents to a plurality of remote computing systems;
generates standardized inventory records received via the remote agents;
generates a database of available inventory that comprises complete standardized inventory records;
generates and stores in cache memory thin locator style records, the thin locator style records configured to be used for periodic updates to the database, for the complete standardized inventory records, the thin locator style records comprising key record identifiers that are indicative of the content included in the complete record;
receives a query, the query comprising a price quote request;
generates a standardized query based on the received query;
selects the thin locator style records in response to the standardized query;
obtains the complete standardized inventory records corresponding to the thin locator style records of the key record identifiers included in the price quote request; and
provides the complete standardized inventory records to a requestor.
13. The system according to claim 12 , wherein each of the plurality of remote computing systems is coupled with an original equipment manufacturer system and at least a portion of the complete standardized inventory records are obtained from the original equipment manufacturer system.
14. The system according to claim 12 , wherein each of the plurality of remote computing systems is coupled with an non-dealership system and at least a portion of the complete standardized inventory records are obtained from the non-dealership system.
15. The system according to claim 12 , wherein the incoming inventory is received periodically from the remote agents in an incremental manner.
16. The system according to claim 12 , wherein the database stores information concerning a plurality of vehicles available for sale, the stored information including a plurality of features for each vehicle.
17. The system according to claim 16 , further comprising:
determining that a first set of complete standardized inventory records does not meet a predefined target, the predefined target including a minimum number of vehicles for inclusion in the price quote response;
identifying a body style of the requested vehicle;
retrieving a second set of complete standardized inventory records from the database, the second set of complete standardized inventory records including a second set of vehicles from the plurality of vehicles which match at least the body style of the requested vehicle;
selecting a third set of vehicles from the first and second sets of complete standardized inventory records for the price quote response in accordance with the predefined target; and
generating the price quote response.
18. The system according to claim 17 , wherein the query comprises a price quote request, the price quote request specifying a make and model for the requested vehicle, and further wherein the complete standardized inventory records comprise a first set of vehicles from the plurality of vehicles which match the make and model of the requested vehicle.
19. The system according to claim 18 , wherein the remote agents are located in specific geographical locations, further wherein if a prior query for another vehicle in a geographical location has been resolved by one or more remote agents, the server will use a solution generated by the one or more remote agents rather than refreshing a response to the query.
20. A computer-implemented method, comprising:
distributing remote agents to a plurality of remote computing systems;
generating standardized inventory records received via the remote agents;
generating a database of available inventory that comprises complete standardized inventory records;
generating and storing in cache memory thin locator style records, the thin locator style records configured to be used for execution of one or more standardized queries for the complete standardized inventory records, the thin locator style records comprising key record identifiers that are indicative of the content included in the complete record;
receiving a query, the query comprising a price quote request;
generating a standardized query based on the received query;
selecting the thin locator style records in response to the standardized query;
obtaining the complete standardized inventory records corresponding to the thin locator style records of the key record identifiers included in the price quote request; and
providing the complete standardized inventory records to a requestor.
21. The method of claim 1 , wherein the query includes a permutation of the key record identifiers, which enables the paring of the complete standardized inventory records from the obtained complete standardize inventory records.
22. The method of claim 1 , wherein the key record identifiers include one or more of VIN, year, make, model, MSRP, and region or the available inventory.
23. The method of claim 1 , further comprising the step of tokenizing each field received via the remote agents when generating the standardized inventory records.
24. The method of claim 1 , wherein the selecting the thin locator style records includes fuzzy matching of some but not all of the key record identifiers.
25. The method of claim 1 , wherein the key record identifiers are included in the quote to cull or select the thin locator style records that correspond to the key record identifiers.
26. The system of claim 12 , wherein the query includes a permutation of the key record identifiers, which enables the paring of the complete standardize inventory records from the obtained complete standardize inventory records.
27. The system of claim 1 , wherein the key record identifiers include one or more of VIN, year, make, model, MSRP, and region or the available inventory.
28. The method of claim 12 , further comprising the step of tokenizing each field received via the remote agents when generating the standardized inventory records.
29. The system of claim 12 , wherein the selecting the thin locator style records includes fuzzy matching of some but not all of the key record identifiers.
30. The system of claim 12 , wherein the key record identifiers are included in the quote to cull or select the thin locator style records that correspond to the key record identifiers.