Patent ID: 8738619
Filing Date: 2014-05-27
Classification: G06F

Abstract:
1. A method for data aggregation, targeting and acquisition, comprising: receiving data and storing the data in one or more source data tables; selecting one of the one or more source data tables, wherein the selected source data table includes updated data fields; identifying a plurality of destination data tables that need to be updated, wherein each destination data table is linked to and contains an aggregation of a subset of data from the selected source data table; identifying one or more data fields in the identified destination data tables that need to be updated with data from the updated data fields in the selected source data table; determining for each identified destination data table, a best aggregation source data table, wherein the best aggregation source data table is a data table that contains all of the data fields of the each identified destination data table and has the fewest data fields, and the best aggregation source data table is the selected source data table or another destination data table; de-activating the each identified destination data table, wherein the de-activated destination tables are prevented from being accessed for reporting; updating data fields in the each de-activated identified destination data table, wherein the data fields in the each identified destination data table are updated with data aggregated from the determined best aggregation source data table associated with the each identified destination data table; re-activating the each identified destination data table after the updating; receiving, using a processor and memory, a request for a data report; identifying, using the processor, from the request, data fields needed to fulfill the request; finding, using the processor, data tables that contain the identified data fields; determining, using the processor, which found data tables are active for reporting from one or more binary flags; selecting, from the determined found active data tables, a data table with the fewest data fields; retrieving data directly from the identified data fields from the selected data table with the fewest data fields; creating a data request query; and transmitting the data request query to the selected data table with the fewest data fields.