Systems and methods of managing a database of alphanumeric values
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.
1 . A system comprising:
a communication portal 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:
access, from one or more databases, one or more database records for each alphanumeric record in a list of alphanumeric records received via the interface, wherein at least one unique vehicle identifier exists for each alphanumeric record and is associated with a vehicle, wherein each database record includes a history of vehicle events associated with the at least one unique vehicle identifier;
identify, for each of the one or more database records, a vehicle event for inclusion in an electronic event notification based on applying one or more rules to the one or more database records;
determine a count of vehicle events for each of a plurality of subsets of vehicle events;
determine an estimated risk associated with the count of vehicle events;
in response to a determination that the estimated risk meets or exceeds a corresponding threshold value, automatically generate the electronic event notification; and
transmit, to a remote user device via the communication portal, the electronic event notification.
2 . The system of claim 1 , wherein the processor is further configured to identify multiple similar vehicle events between different database records and generates a single vehicle event for a report in place of the multiple similar vehicle events based on a first rule of the one or more rules.
3 . The system of claim 1 , wherein at least one of the one or more databases is a private database storing historical vehicle events, wherein the private database is not publicly accessible and wherein the processor is further configured to identify vehicle events in database records from only the private database as exclusive vehicle events based on a first rule of the one or more rules.
4 . The system of claim 3 , wherein the processor is further configured to identify vehicle events in database records from both the private database and at least one other database of the one or more databases as being not exclusive vehicle events based on a second rule of the one or more rules.
5 . The system of claim 3 , wherein one of the plurality of subsets of vehicle events is a subset of exclusive vehicle events and wherein the processor is further configured to filter the one or more database records to identify a subset of database records, wherein each record in the subset of database records includes a negative history vehicle event and is received from the private database, wherein the negative history vehicle event includes one or more of an accident, a theft, vehicle damage, or a title issue.
6 . The system of claim 1 , wherein the processor is further configured to exclude vehicle events that occur after a sale date identified in the one or more database records based on a first rule of the one or more rules.
7 . The system of claim 1 , wherein the processor generates the electronic event notification to include the unique vehicle identifiers of all database records in one of the plurality of subsets of vehicle events.
8 . The system of claim 3 , wherein the processor is further configured to determine a percentage of alphanumeric records in the list of alphanumeric records having vehicle events identified by the private database and to include the percentage in the electronic event notification.
9 . The system of claim 1 , wherein the processor generates the electronic event notification to further include details of one or more of the vehicle events.
10 . A method of historical vehicle analysis, comprising:
accessing, from one or more databases, one or more database records for each alphanumeric record in a list of alphanumeric records received via an interface that allows user operation and interaction via a communication network, wherein at least one unique vehicle identifier exists for each alphanumeric record and is associated with a vehicle, wherein each database record includes a history of vehicle events associated with the at least one unique vehicle identifier;
identifying, for each of the one or more database records, a vehicle event for inclusion in an electronic event notification based on applying one or more rules to the one or more database records;
determining a count of vehicle events for each of a plurality of subsets of vehicle events;
determining an estimated risk associated with the count of vehicle events;
in response to a determination that the estimated risk meets or exceeds a corresponding threshold value, automatically generating the electronic event notification; and
transmitting, to a remote user device via a communication portal, the electronic event notification.
11 . The method of claim 10 , further comprising:
identifying, multiple similar vehicle events between different database records; and
generating a single vehicle event for a report in place of the multiple similar vehicle events based on a first rule of the one or more rules.
12 . The method of claim 10 , wherein at least one of the one or more databases is a private database storing historical vehicle events, wherein the private database is not publicly accessible and further comprising identifying vehicle events in database records from only the private database as exclusive vehicle events based on a first rule of the one or more rules.
13 . The method of claim 12 , further comprising identifying vehicle events in database records from both the private database and at least one other database of the one or more databases as being not exclusive vehicle events based on a second rule of the one or more rules.
14 . The method of claim 12 , wherein one of the plurality of subsets of vehicle events is a subset of exclusive vehicle events and further comprising filtering the one or more database records to identify a subset of database records, wherein each record in the subset of database records includes a negative history vehicle event and is received from the private database, wherein the negative history vehicle event includes one or more of an accident, a theft, vehicle damage, or a title issue.
15 . The method of claim 10 , further comprising excluding vehicle events that occur after a sale date identified in the one or more database records based on a first rule of the one or more rules.
16 . The method of claim 10 , wherein generating the electronic event notification comprises including the unique vehicle identifiers of all database records in one of the plurality of subsets of vehicle events in the electronic event notification.
17 . The method of claim 12 , further comprising determining a percentage of alphanumeric records in the list of alphanumeric records having vehicle events identified by the private database and to include the percentage in the electronic event notification.
18 . The method of claim 10 , wherein generating the electronic event notification comprising including details of one or more of the vehicle events in the electronic event notification.
19 . 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:
accessing, from one or more databases, one or more database records for each alphanumeric record in a list of alphanumeric records received via an interface and that allows user operation and interaction via a communication network, wherein at least one unique vehicle identifier exists for each alphanumeric record and is associated with a vehicle, wherein each database record includes a history of vehicle events associated with the at least one unique vehicle identifier;
identifying, for each of the one or more database records, a vehicle event for inclusion in an electronic event notification based on applying one or more rules to the one or more database records;
determining a count of vehicle events for each of a plurality of subsets of vehicle events;
determining an estimated risk associated with the count of vehicle events;
in response to a determination that the estimated risk meets or exceeds a corresponding threshold value, automatically generating the electronic event notification; and
transmitting, to a remote user device via a communication portal, the electronic event notification.
20 . The non-transitory, computer-readable storage media of claim 19 , wherein the computer system is further configured to perform operations comprising:
identifying multiple similar vehicle events between different database records; and
generating a single vehicle event for a report in place of the multiple similar vehicle events based on a first rule of the one or more rules.