Single view presentation of multiple queries in a data visualization application
Embodiments of the present invention provide a method, system and computer program product for single view presentation of multiple query. In an embodiment of the invention, a method for single view presentation of multiple query includes directing a query against a database along a selected dimension of multiple different elements. In response, a primary result set is received. The result set is then organized into a tabular view of cells according to the selected dimension and values for the selected dimension. Thereafter, a set of nested queries may be directed for each of the elements in the selected dimension against the result set utilizing a different dimension. In response to each directed set of nested queries, a corresponding result set is thus received. Finally, each corresponding result set is inserted into a cell associated with a common one of the elements.
1. A method for single view presentation of multiple query comprising:
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.
2. The method of claim 1 , further comprising, for each selected dimension record:
generating a graph; and
inserting the graph into a cell of the tabular view associated with the selected dimension record.
3. The method of claim 2 , further comprising, for each selected dimension record:
directing a second respective nested query against the database along a third selected dimension;
receiving, in response to the second respective nested query, a second corresponding result set;
generating a second graph; and
inserting the generated second graph into a cell of the tabular view associated with the selected dimension record.
4. The method of claim 1 , further comprising limiting each corresponding result set to a maximum number of values.
5. The method of claim 1 , further comprising receiving the second selected dimension in response to a selection of a dimensionalization menu entry in a pop-up menu for the tabular view.
6. The method of claim 5 , wherein the dimensionalization menu entry upon selection presents a dialog box providing for a selection of a sort order of each corresponding result set.
7. 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.
8. The system of claim 7 , wherein the program instructions further perform, for each selected dimension record:
generating a graph; and
inserting the graph into a cell of the tabular view associated with the selected dimension record.
9. The system of claim 8 , wherein the program instructions further perform, for each selected dimension record:
directing a second respective nested query against the database along a third selected dimension;
receiving, in response to the second respective nested query, a second corresponding result set;
generating a second graph; and
inserting the generated second graph into a cell of the tabular view associated with the selected dimension record.
10. The system of claim 8 , wherein the program instructions further perform limiting each corresponding result set to a maximum number of values.
11. The system of claim 8 , wherein the program instructions further perform receiving the second selected dimension in response to a selection of a dimensionalization menu entry in a pop-up menu for the tabular view.
12. The system of claim 11 , wherein the dimensionalization menu entry upon selection presents a dialog box providing for a selection of a sort order of each corresponding result set.
13. 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.
14. The computer program product of claim 13 , wherein the method further comprises, for each selected dimension record:
generating a graph; and
inserting the graph into a cell of the tabular view associated with the selected dimension record.
15. The computer program product of claim 14 , wherein the method further comprises, for each selected dimension record:
directing a second respective nested query against the database along a third selected dimension;
receiving, in response to the second respective nested query, a second corresponding result set;
generating a second graph; and
inserting the generated second graph into a cell of the tabular view associated with the selected dimension record.
16. The computer program product of claim 13 , wherein the method further comprises limiting each corresponding result set to a maximum number of values.
17. The computer program product of claim 13 , wherein the method further comprises receiving the second selected dimension in response to a selection of a dimensionalization menu entry in a pop-up menu for the tabular view.
18. The computer program product of claim 17 , wherein the dimensionalization menu entry upon selection presents a dialog box providing for a selection of a sort order of each corresponding result set.