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 tangible medium storing computer readable software for programming a parallel and asynchronous database architecture and data processing system for marketing campaign management and analysis, the tangible medium storing computer readable software comprising:

• a first program construct of a plurality of program constructs, the first program construct comprising a plurality of modifiable parameters adapted to be modifiable during data processing, the first program construct further defining a plurality of selectable input data sources and a plurality of selectable attributes;
• a second program construct of the plurality of program constructs, the second program construct having a corresponding metadata linkage to the first program construct, the second program construct defining a plurality of data structures for a plurality of data repositories of the computer system, the plurality of data structures comprising at least one relational data structure and at least one multidimensional data structure;
• a third program construct of the plurality of program constructs, the second program construct having corresponding metadata linkages to the first and second program constructs, the third program construct adapted to provide for execution of a plurality of data processes using the plurality of modifiable parameters, the plurality of input data sources and the plurality of selectable attributes, the third program construct further adapted to store a plurality of results of the plurality of data processes in the plurality of data structures;
• and
• a fourth program construct of the plurality of program constructs, the fourth program construct having corresponding metadata linkages to the first, second and third program constructs, the fourth program construct adapted to use the plurality of selectable attributes for a dimensioning and aggregating data for storage in the multidimensional data structure.