7 January 2009
Database Schema Visualization

Adam Buchsbaum, Emden Gansner, Cecilia Procopiuc, Suresh Venkatasubramanian

The project addresses the problem of visualizing database schemata. A schema of a relational database can be naturally represented as a graph, with the nodes corresponding to entities and the edges representing relations. Directed edges reflect a one-to-many relation from tail to head. For purposes of understanding and navigating the schema, it can be useful to draw the schema as a graph. Traditional graph drawings, however, with edges drawn as line segments, can use too much space and appear too cluttered, especially if used as part of a user interface where the nodes serve as buttons. An alternative drawing can be based on rectangular layouts and contact graphs, in which two nodes sharing an edge are placed abutting each other. If an edge is directed, one can require the additional constraint that the drawing honor edge directions in the sense that the head node must appear to the right or below the tail node. We have been working on the algorithmic aspects of generating such drawings. We have derived various existence and complexity results, and have constructed efficient heuristics for generating such drawings in both the undirected and directed cases, especially for the important case when the underlying (undirected) graph is a tree.

Database join tree
Retangular layout of tree

<< Back to Projects & Software

 


Terms & Conditions | Privacy Statement | Copyright © 2009 AT&T