Systems and methods of managing a database of alphanumeric values

• US 10,409,867 B1
• Filed: 06/15/2017
• Issued: 09/10/2019
• Est. Priority Date: 06/16/2016
• Status: Active Grant

• Current Assignee: Experian Information Solutions Incorporated (Experian plc)
• Original Assignee: Experian Information Solutions Incorporated (Experian plc)
• Inventors: Von Busch, Kirsten Marie, Cain, Ryan B., DeGuiseppe, Dominic Edward, Zhang, Wen, Hjermstad, Erik Peter
• Primary Examiner(s): Arjomandi, Noosha
• Application Number:
  US15/624,609
• Time in Patent Office: 817 Days
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G08B 21/182 Level alarms, e.g. alarms responsive to variables exceeding a threshold
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

One aspect of the subject matter described herein comprises a database management system. The database management system comprises a communication circuit, an interface, and a processor. The communication circuit receives information from databases via a communication network. The interface allows user operation and interaction via the communication network and the database management system. The processor provides data to and receives data from the interface, including a plurality of alphanumeric records comprising at least one unique identifier, obtains database records from other databases for each unique identifier, identifies a number of alphanumeric records in the plurality having events in their histories, determines a percentage of alphanumeric records in the plurality having negative events in their histories, generates a report including the determined percentages, and conveys the report to the user.

Claims

1. A system for historical vehicle analysis, comprising:

a communication circuit configured to transmit and receive information over a communication network;

an interface configured to allow user operation and interaction via the communication network; and

a processor configured to execute computer-executable instructions in order to;

provide data to and receive data from the interface,

receive, via the interface, a first list of records, the list comprising one or more alphanumeric records, wherein at least one unique identifier exists for each alphanumeric record;

generate a second list of records comprising one or more alphanumeric records based on validating each of the alphanumeric records of the first list, wherein only validated alphanumeric records of the first list are included in the second list;

for each alphanumeric record in the second list;

generate a request for one or more database records from one or more databases based on the at least one unique identifier,

transmit the request to the one or more databases via the communication network, and

receive the one or more database records from the one or more databases via the communication network, wherein each received database record includes a history of events associated with the at least one unique identifier;

determine, for each received one or more database records, whether the database record is received from an exclusive database of the one or more databases;

filter the received one or more database records to identify a subset of database records, wherein each record in the subset includes a negative history event and is received from the exclusive database, wherein the negative history event includes one or more of an accident, a theft, vehicle damage, or a title issue;

determine a count of records in the subset;

determine whether the count exceeds a corresponding threshold value;

automatically generate an electronic, negative event notification when the count exceeds the threshold value; and

transmit the electronic, negative event notification to a remote user device via the communication circuit.

2. The system of claim 1, wherein the processor generates the electronic, negative event notification to include the unique identifiers of all records in the subset.

3. The system of claim 2, wherein the processor is further configured to determine a percentage of alphanumeric records in the second list having events identified by the exclusive database and include the percentage in the electronic, negative event notification.

4. The system of claim 3, wherein the processor generates the electronic, negative event notification to further include details of the negative history events.

5. The system of claim 3, wherein the first list of records is a vehicle inventory of a dealership, wherein each alphanumeric record corresponds to a vehicle of the vehicle inventory, wherein the one or more databases are one or more vehicle history report databases, and wherein the processor is further configured to determine a risk faced by the dealership, the risk determined based on an average reduction of value for vehicles having negative events identified based on vehicle history reports and the determined percentage of vehicles having negative history events identified by the exclusive database.

6. The system of claim 5, wherein the processor further generates a value based at least in part on the determined risk.

7. The system of claim 5, wherein the processor is further configured to compare a percentage of vehicles on the vehicle inventory of the dealership with one or more corresponding percentages from one or more other dealerships in a vicinity of the dealership.

8. The system of claim 5, wherein the processor is further configured to determine when the risk faced by the dealership exceeds a threshold amount and generate an alert for transmission to the remote user device regarding the risk exceeding the threshold.

9. A method of historical vehicle analysis, comprising:

receiving, via an interface, a first list of records, the list comprising one or more alphanumeric records, wherein at least one unique identifier exists for each alphanumeric record;

generating a second list of records comprising one or more alphanumeric records based on validating each of the alphanumeric records of the first list, wherein only validated alphanumeric records of the first list are included in the second list;

storing the second list of records in a database;

for each alphanumeric record in the second list;

requesting one or more database records from one or more databases via a communication network based on the at least one unique identifier, and

receiving the one or more database records from the one or more databases via the communication network, wherein each received database record includes a history of events associated with the at least one unique identifier;

determining, for each received one or more database records, whether the database record is received from an exclusive database of the one or more databases;

filtering the received one or more database records to identify a subset of database records, wherein each record in the subset includes a negative history event and is received from the exclusive database, wherein the negative history event includes one or more of an accident, a theft, vehicle damage, or a title issue;

determining a count of records in the subset;

determining whether the count exceeds a corresponding threshold value;

automatically generating an electronic, negative event notification when the count exceeds the threshold value; and

transmitting the electronic, negative event notification to a remote user device via the communication circuit.

10. The method of claim 9, wherein generating the report comprises generating the electronic, negative event notification to include the unique identifiers of all alphanumeric records in the subset.

11. The method of claim 10, further comprising determining a percentage of alphanumeric records in the second list having events identified by the exclusive database and include the percentage in the electronic, negative event notification.

12. The method of claim 11, wherein the electronic, negative event notification is generated to further include details of the negative events identified by the exclusive database.

13. The method of claim 12, wherein the first list of records is a vehicle inventory of a dealership, wherein each alphanumeric record corresponds to a vehicle of the vehicle inventory, wherein the one or more databases are one or more vehicle history report databases, and further comprising determining a risk faced by the dealership, the risk determined based on an average reduction of value for vehicles having negative events identified based on vehicle history reports and the determined percentage of vehicles having negative history events identified by the exclusive database.

14. The method of claim 13, further comprising generating a value based at least in part on the determined risk.

15. The method of claim 14, further comprising comparing a percentage of vehicles on the vehicle inventory of the dealership with one or more corresponding percentages from one or more other dealerships in a vicinity of the dealership.

16. The method of claim 14, further comprising determining when the risk faced by the dealership exceeds a threshold amount and generating an alert for transmission to the remote user device regarding the risk exceeding the threshold.

17. Non-transitory, computer-readable storage media storing computer-executable instructions that, when executed by a computer system, configure the computer system to perform operations comprising:

receiving, via an interface, a first list of records, the list comprising one or more alphanumeric records, wherein at least one unique identifier exists for each alphanumeric record;

generating a second list of records comprising one or more alphanumeric records based on validating each of the alphanumeric records of the first list, wherein only validated alphanumeric records of the first list are included in the second list;

storing the second list of records in a local database;

for each alphanumeric record in the second list;

requesting one or more database records from one or more databases via the communication network based on the at least one unique identifier, and

receiving the one or more database records from the one or more databases via the communication network, wherein each received database record includes a history of events associated with the at least one unique identifier;

determining, for each received one or more database records, whether the database record is received from an exclusive database of the one or more databases;

filtering the received one or more database records to identify a subset of database records, wherein each record in the subset includes a negative history event and is received from the exclusive database, wherein the negative history event includes one or more of an accident, a theft, vehicle damage, or a title issue;

determining a count of records in the subset;

automatically generating an electronic, negative event notification when the count exceeds the threshold value; and

transmitting the electronic, negative event notification to a remote user device via the communication circuit.