Single view presentation of multiple queries in a data visualization application

A data visualization data processing system configured for single view presentation of multiple query, the system comprising:

• a host computing system comprising one or more computers, each with memory and at least one processor;
• a database coupled to the host computing system and storing data therein;
• a database visualization application executing in the memory of the host computing system and adapted to issue queries against the database and receive result sets in response to the queries;
• and,
• a single view dimensionalization module coupled to the application and comprising computer program instructions that when executing in the memory of the host computing system perform:
• directing a query against a database along a first selected dimension of multiple different elements and receiving in response, a primary result set comprising selected dimension records and a corresponding value for each selected dimension record;
• organizing the selected dimension records and the corresponding values of the primary result set into a tabular view of cells according to the first selected dimension and the corresponding value for each selected dimension record;
• for each selected dimension record:
• directing a respective nested query against the database along a second selected dimension;
• and
• receiving, in response to the respective nested query, a corresponding result set;
• and
• inserting the corresponding result set into a cell of the tabular view associated with the selected dimension record.

A computer program product for single view presentation of multiple query, the computer program product including a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a device to cause the device to perform a method including:

• directing a query against a database along a first selected dimension of multiple different elements and receiving in response, a primary result set comprising selected dimension records and a corresponding value for each selected dimension record;
• organizing the selected dimension records and the corresponding values of the primary result set into a tabular view of cells according to the first selected dimension and the corresponding value for each selected dimension record;
• for each selected dimension record:
• directing a respective nested query against the database along a second selected dimension;
• and
• receiving, in response to the respective nested query, a corresponding result set;
• and
• inserting the corresponding result set into a cell of the tabular view associated with the selected dimension record.