Software and Metadata Structures for Distributed And Interactive Database Architecture For Parallel And Asynchronous Data Processing Of Complex Data And For Real-Time Query Processing

A computing system, comprising:

• a data network;
• a plurality of data storage devices coupled to the data network, the plurality of data storage devices storing a first program module defining a plurality of modifiable parameters adapted to be modifiable during data processing and a plurality of selectable attributes;
• a second program module defining a plurality of selectable input data sources, the plurality of selectable input data sources comprising at least one consumer database and a plurality of consumer lists of individuals and households;
• and a third program module defining a plurality of data structures for a plurality of data repositories of the computer system, the plurality of data structures comprising a first relational data structure, a second relational data structure storing a subset of information from the first relational data structure, and at least one multidimensional data structure;
• and
• a plurality of computing devices coupled to the plurality of data storage devices through the data network, each computing device of the plurality of computing devices comprising one or more processors, a memory, and network interface coupled to the data network, one or more computing devices of the plurality of computing devices adapted to execute a plurality of marketing campaign management data processes using the plurality of modifiable parameters, the plurality of selectable input data sources and the plurality of selectable attributes;
• to perform a first plurality of data assembly processes and store assembled data in the first relational data structure, to perform a second plurality of data reduction processes on the assembled data and store reduced data in the second relational data structure, to use the plurality of selectable attributes for dimensioning and aggregation of the reduced data for storage in the multidimensional data structure;
• to correlate invocation of the plurality of marketing campaign management data processes with accounting functions and resource utilization;
• and to track selection of the plurality of consumer lists.

A computing system, comprising:

• a data network;
• a plurality of data storage devices coupled to the data network, the plurality of data storage devices storing a first metadata module of a plurality of metadata modules, the first metadata module comprising a plurality of modifiable parameters adapted to be modifiable during data processing;
• a second metadata module of the plurality of metadata modules, the second metadata module defining a plurality of selectable input data sources comprising at least one consumer database and a plurality of consumer lists;
• a third metadata module of the plurality of metadata modules, the third metadata module defining a plurality of data structures for a plurality of data repositories of the data processing system, the plurality of data structures comprising a first relational data structure storing a first subset of information, a second relational data structure storing a second subset of information from the first relational data structure, and at least one multidimensional data structure storing a third subset of information from the second relational data structure which has been dimensioned and aggregated;
• a plurality of computing devices coupled to the plurality of data storage devices through the data network, each computing device of the plurality of computing devices comprising one or more processors, a memory, and network interface coupled to the data network, one or more computing devices of the plurality of computing devices adapted to execute a plurality of data assembly processes using the plurality of selectable input data sources and the plurality of modifiable parameters to form the first subset of information;
• to execute a plurality of data reduction processes using plurality of modifiable parameters to form the second subset of information;
• to dimension and aggregate the second subset of information to form the third subset of information, using a plurality of selectable attributes;
• to perform a plurality of set operation on the third subset of information using the plurality of selectable attributes;
• to utilize the multidimensional data structure to process a query and to generate a response to the query;
• and to provide at least one selection recommendation for the plurality of modifiable parameters, the plurality of selectable input data sources, or the plurality of selectable attributes.