DbView Database visualization
An exporter is a peace of software that is used to generate a representation of a given database.
Actually, DbView supports the following representations:
- Graphviz representation with a low level of details.
- Graphviz representation with a moderate level of details.
- Graphviz representation with a high level of details.
You can get the list of all available exporters by typing the following command:
dbview.bat list-table-exporters
dbview.sh list-table-exporters
dbview.sh list-table-exporters
DbView is design in a way that adding a new exporter is easy, if you know Java.
Basically, adding a new exporter involves the following steps:
- Create a new package for the new adaptor.
- Create 3 classes, within the previously created package: "Cli.java", "Description.java" and "Exporter.java".
- Recompile DbView using the provided ANT script.
This exporter produces a Graphviz representation with a low level of details.
Options:
| Option | Description |
|---|---|
| -layout |
This option defines the "layout" of the produced GpahViz's representation. Possible values are:
Please see the examples above. |
| -path | This option defines the path to the output file. By default, the exporter prints the GraphViz representation to the standard output. |
dbview.sh export -exporter dot-light -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
dbview.sh export -exporter dot-light -layout h -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
This exporter produces a Graphviz representation with a moderate level of details.
Options:
| Option | Description |
|---|---|
| -layout |
This option defines the "layout" of the produced GpahViz's representation. Possible values are:
Please see the examples above. |
| -path | This option defines the path to the output file. By default, the exporter prints the GraphViz representation to the standard output. |
dbview.sh export -exporter dot-medium -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
dbview.sh export -exporter dot-medium -layout h -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
This exporter produces a Graphviz representation with a high level of details.
Options:
| Option | Description |
|---|---|
| -layout |
This option defines the "layout" of the produced GpahViz's representation. Possible values are:
Please see the examples above. |
| -path | This option defines the path to the output file. By default, the exporter prints the GraphViz representation to the standard output. |
dbview.sh export -exporter dot-full -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
dbview.sh export -exporter dot-full -layout h -zoom table2A,table2B -db-adaptor mysql -host localhost -user root -password root -dbname mydb -port 8889
