Database system for dynamically generating customized models
Embodiments of a system may comprise databases and a processor that receives a first filter item and a database filter item, generates a first database based on the first filter item, integrate data from the first database into the user database to create an updated plurality of user records, generate a second database based on a selected set of records, in the updated plurality of user records, corresponding to the database filter item, determine metrics that correspond to the second database, generate a model to segregate the second database using the metrics, receive criteria, compare the segregated second database with the criteria to remove records that do not meet the criteria, cause a subsequent update to the updated second database to integrate data from the event database to create an updated diminished second database, and generate a notification including information included in the updated diminished second database.
1. A data processing system for accessing databases and updated data items, the data processing system comprising:
a user database including a plurality of user records relating to demographics or marketing preferences of a population including vehicle owners;
an event database including a plurality of event records relating to the vehicle owners; and
a hardware processor configured to execute computer-executable instructions to:
receive, via an interactive user interface displayed on a user device, a first filter item regarding calculating a number of households for each of a plurality of geographic zones;
generate a first database including a first plurality of records by identifying, in the plurality of event records, event records that include information regarding events experienced by the vehicle owners but not specific owner identifying information;
cause a first update to the user records of the user database to integrate event data from the generated first database into the demographics or marketing preferences data of the plurality of user records to create an updated plurality of user records;
receive, via the interactive user interface displayed on the user device, a database filter item comprising one or more of a geographic area, a vehicle make, a vehicle model, or a time period;
generate a second database including a second plurality of records by extracting from the updated plurality of user records, a selected set of household level records of the updated plurality of user records matching the database filter item;
determine a first set of database metrics that correspond to the second plurality of records, the first set of database metrics comprising at least a comparison of a number of relevant household level records to a total number of household level records in the geographic area;
generate a customized dynamic model configured to segregate the second plurality of records using the determined first set of database metrics;
receive criteria of one or more selected metrics of the first set of database metrics to filter the second plurality of records;
compare the segregated second plurality of records with the criteria to update the segregated second plurality of records to remove records that do not meet the criteria, creating a diminished second plurality of records that includes records that meet one or more of the first set of database metrics;
cause a subsequent update to the diminished second plurality of records to integrate data from the event database into the diminished second plurality of records to create an updated diminished second plurality of records; and
based on an identification of one or more records existing in the update diminished second plurality of records, update the interact user interface to include information included in the updated diminished plurality of records.
2. The data processing system of claim 1 further comprising:
a scoring engine;
wherein the hardware processor configured is further configured to execute computer-executable instructions to:
execute the scoring engine using the updated diminished second plurality of records to generate a score file; and
cause a third update to the updated diminished second plurality of records to integrate data from the score file into the updated diminished second plurality of records to create a scored diminished second plurality of records.
3. The data processing system of claim 2 , wherein the hardware processor is further configured to execute computer-executable instructions in order to analyze historical purchase rates and corresponding score file information and update the scoring engine accordingly.
4. The data processing system of claim 1 , wherein the first filter item comprises at least one geographic zone for which a total number of households is calculated.
5. The data processing system of claim 1 , wherein the event database comprises records relating to at least one of life events of the vehicle owners, vehicle equity information, vehicle events, and vehicle loan information.
6. The data processing system of claim 1 , wherein the event notification comprises a user interface indicating a quantity of households in the geographic area that satisfy the filter items and a breakdown of the quantity of households in the geographic area that satisfy the filter items according to one or more of: the vehicle make, the vehicle model, the time period, and a vehicle type.
7. The data processing system of claim 1 , wherein the hardware processor is further configured to execute computer-executable instructions in order to analyze historical purchase rates as compared to and update one or more of the first set of database metrics.
8. A computer implemented method for generating an event notification, the method comprising:
accessing, by a database system, a user database including a plurality of user records relating to demographics or marketing preferences of a population including vehicle owners;
accessing, by the database system, an event database including a plurality of event records relating to the vehicle owners;
receiving, via an interactive user interface displayed on a user device, a first filter item regarding calculating a number of households for each of a plurality of geographic zones;
generating a first database including a first plurality of records by identifying, in the plurality of event records, event records that include information regarding events experienced by the vehicle owners but not specific owner identifying information;
causing a first update to the user records of the user database to integrate event data from the generated first database into the demographics or marketing preferences data of the plurality of user records to create an updated plurality of user records;
receiving, via the interactive user interface displayed on the user device, a database filter item comprising one or more of a geographic area, a vehicle make, a vehicle model, or a time period;
generating a second database including a second plurality of records by extracting from the updated plurality of user records, a selected set of household level records of the updated plurality of user records matching to the database filter item;
determining a first set of database metrics that correspond to the second plurality of records, the first set of database metrics comprising at least a comparison of a number of relevant household level records to a total number of household level records in the geographic area;
generating a customized dynamic model configured to segregate the second plurality of records using the determined first set of database metrics;
receiving criteria of one or more selected metrics of the first set of database metrics to filter the second plurality of records;
comparing the segregated second plurality of records with the criteria to update the segregated second plurality of records to remove records that do not meet the criteria, creating a diminished second plurality of records that includes records that meet one or more of the first set of database metrics;
causing a subsequent update to the diminished second plurality of records to integrate data from the event database into the diminished second plurality of records to create an updated diminished second plurality of records; and
based on an identification of one or more records existing in the update diminished second plurality of records, update the interactive user interface to include information included in the updated diminished plurality of records.
9. The method of claim 8 further comprising:
executing a scoring engine based on the updated diminished second plurality of records to generate a score file; and
causing a third update to the updated diminished second plurality of records to integrate data from the score file into the updated diminished second plurality of records to create a scored diminished second plurality of records.
10. The method of claim 9 , further comprising analyzing historical purchase rates and corresponding score file information and updating the scoring engine accordingly.
11. The method of claim 8 , wherein the first filter item comprises at least one geographic zone for which a total number of households is calculated.
12. The method of claim 8 , wherein the event database comprises records relating to at least one of life events of the vehicle owners, vehicle equity information, vehicle events, and vehicle loan information.
13. The method of claim 8 , wherein the event notification comprises a user interface indicating a quantity of households in the geographic area that satisfy the filter items and a breakdown of the quantity of households in the geographic area that satisfy the filter items according to one or more of: the vehicle make, the vehicle model, the time period, and a vehicle type.
14. The method of claim 9 , further comprising analyzing historical purchase rates as compared to and update one or more of the first set of database metrics.
15. 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 a user database including a plurality of user records relating to demographics or marketing preferences of a population including vehicle owners;
accessing an event database including a plurality of event records relating to the vehicle owners;
receiving, via an interactive user interface displayed on a user device, a first filter item regarding calculating a number of households for each of a plurality of geographic zones;
generating a first database including a first plurality of records by identifying, in the plurality of event records, event records that include information regarding events experienced by the vehicle owners but not specific owner identifying information;
causing a first update to the user records of the user database to integrate event data from the generated first database into the demographics or marketing preferences data of the plurality of user records to create an updated plurality of user records;
receiving, via the interactive user interface displayed on the user device, a database filter item comprising one or more of a geographic area, a vehicle make, a vehicle model, or a time period;
generating a second database including a second plurality of records by extracting from the updated plurality of user records, a selected set of household level records of the updated plurality of user records matching to the database filter item;
determining a first set of database metrics that correspond to the second plurality of records, the first set of database metrics comprising at least a comparison of a number of relevant household level records to a total number of household level records in the geographic area;
generating a customized dynamic model configured to segregate the second plurality of records using the determined first set of database metrics;
receiving criteria of one or more selected metrics of the first set of database metrics to filter the second plurality of records;
comparing the segregated second plurality of records with the criteria to update the segregated second plurality of records to remove records that do not meet the criteria, creating a diminished second plurality of records that includes records that meet one or more of the first set of database metrics;
causing a subsequent update to the diminished second plurality of records to integrate data from the event database into the diminished second plurality of records to create an updated diminished second plurality of records; and
based on an identification of one or more records existing in the update diminished second plurality of records, updating the interactive user interface to include information included in the updated diminished plurality of records.
16. The non-transitory, computer-readable storage media of claim 15 , further storing computer-executable instructions that, when executed by a computer system, configure the computer system to perform operations comprising:
executing a scoring engine based on the updated diminished second plurality of records to generate a score file; and
causing a third update to the updated diminished second plurality of records to integrate data from the score file into the updated diminished second plurality of records to create a scored diminished second plurality of records.
17. The non-transitory, computer-readable storage media of claim 16 , further storing computer-executable instructions that, when executed by a computer system, configure the computer system to perform operations comprising analyzing historical purchase rates and corresponding score file information and updating the scoring engine accordingly.
18. The non-transitory, computer-readable storage media of claim 15 , wherein the first filter item comprises at least one geographic zone for which a total number of households is calculated.
19. The non-transitory, computer-readable storage media of claim 15 , wherein the event database comprises records relating to at least one of life events of the vehicle owners, vehicle equity information, vehicle events, and vehicle loan information.
20. The non-transitory, computer-readable storage media of claim 15 , wherein the event notification comprises a user interface indicating a quantity of households in the geographic area that satisfy the filter items and a breakdown of the quantity of households in the geographic area that satisfy the filter items according to one or more of: the vehicle make, the vehicle model, the time period, and a vehicle type.