DocumentCode :
650480
Title :
Graph-Based Relational Data Visualization
Author :
De Lima, Daniel Mario ; Rodrigues, Jose F. ; Machado Traina, Agma Juci
Author_Institution :
Inst. de Cienc. Mat. e de Comput., Univ. de Sao Paulo, Sao Carlos, Brazil
fYear :
2013
fDate :
16-18 July 2013
Firstpage :
210
Lastpage :
219
Abstract :
Relational databases are rigid-structured data sources characterized by complex relationships among a set of relations (tables). Making sense of such relationships is a challenging problem because users must consider multiple relations, understand their ensemble of integrity constraints, interpret dozens of attributes, and draw complex SQL queries for each desired data exploration. In this scenario, we introduce a twofold methodology, we use a hierarchical graph representation to efficiently model the database relationships and, on top of it, we designed a visualization technique for rapidly relational exploration. Our results demonstrate that the exploration of databases is deeply simplified as the user is able to visually browse the data with little or no knowledge about its structure, dismissing the need for complex SQL queries. We believe our findings will bring a novel paradigm in what concerns relational data comprehension.
Keywords :
SQL; data integrity; data visualisation; graph theory; relational databases; tree data structures; complex SQL query; data exploration; database relationship model; graph-based relational data visualization; hierarchical graph representation; integrity constraint; relational data comprehension; relational database; relational exploration; rigid structured data source; visual data browsing; hierarchical visualization; relational databases; visual analytics;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Information Visualisation (IV), 2013 17th International Conference
Conference_Location :
London
ISSN :
1550-6037
Type :
conf
DOI :
10.1109/IV.2013.28
Filename :
6676565
Link To Document :
بازگشت