• 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