2005-08-24: "Schemaball" - Schema Viewer for SQL Databases

From InfoVis:Wiki
Jump to navigation Jump to search
Visualization of a MySQL Database schema
[Krzywinski, 2004]
Schemaball is a flexible schema visualizer for SQL databases. The purpose of Schemaball is to help visualize the relationships between tables. Tables are related by foreign keys, which are fields which store the value of a record field from another table. Foreign keys create a lookup relationship between two tables. Large schemas can have hundreds of tables and table relationships. Keeping track of them call can be tedious, error-prone and slow down the schema development process. Schemaball provides a means to create flexible, static graphic images of a schema. Tables and table links can be hidden, highlighted and foreign key relationships can be traversed forward or backward to highlight connected tables.

Schemaball produces images called schema balls. Schema balls are schema visualizations in which tables are ordered along a circle with table relationships drawn as curves or straight lines. Using an input configuration file, all elements of the schema ball can be configured.

Schemaball is free software, licensed under GPL. It is written in Perl and requires a few CPAN modules to run. It's simple to use, while being able to produce high quality schema balls suitable for publication. In particular, you can use Schemaball to generate elements of a schema ball and then create a composite in an image editing program. One such result is shown in the figure at right.
[Krzywinski, 2004]



via information aesthetics blog

References[edit]

[Krzywinski, 2004] Martin Krzywinski, Schemaball - Schema Viewer for SQL Databases, Created at: 2004, Retrieved at: 2005-08-24, http://mkweb.bcgsc.ca/schemaball/