Abstract

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.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.