Reporting and summarizing metrics in sparse relationships on an oltp database

A computer system comprising:

• a processor(s) set;
• and
• a computer readable storage medium;
• wherein:
• the processor set is structured, located, connected and/or programmed to run program instructions stored on the computer readable storage medium;
• and
• the program instructions include:
• first program instructions programmed to select a set of base tables in a transactional database;
• and
• second program instructions programmed to introduce a layer of materialized query tables (MQTs), where the MQTs represent a database view that physically stores data and the MQTs store the primary keys related back to base tables that make up the dimension, and have a null flag indicating missing key for values that don't exist.