Interactive Visual Exploration of Big Relational Datasets

We propose and implement a tool for the access, analysis, and visual exploration of very large relational databases and data warehouses. To this end, we represent the database as a graph in which each table is represented by a tree rooted at the key and in which there is an edge from table T to table T' if there is an attribute of T which is a foreign key of T'. The interface allows the user to define analytic queries by clicking on nodes and edges of the graph. The user actions are then translated into SQL group-by queries that are evaluated by the underlying database management system. Additionally, the interface allows the user to visualize the analysis results, and to interact with visualizations in order to explore the database content.

Automated summary

This paper proposes and implements a tool for accessing, analyzing, and visually exploring large relational databases and data warehouses. The tool represents the database as a graph and allows users to define analytic queries through a user interface, which are then translated into SQL group-by queries. The tool also provides visualization of the analysis results and allows users to interact with the visualizations to explore the database content.