Visualizing Your Databases
DbVisualizer provides a graphical tool, built with the Java programming
language, for viewing data in databases, as well as executing
Structured Query Language (SQL) commands. DbVisualizer uses the Java
Database Connectivity (JDBC) interface to work with any database for
which you can get a JDBC driver. This includes all the major commercial
players such as Oracle, DB2, and Sybase. You can also get JDBC drivers
for free databases such as MySQL, PostgreSQL, and McKoi SQL.
DbVisualizer runs on many platforms and works with virtually all
databases, making it a truly generic tool.
To connect to a database, you need the JDBC driver for that database
(see your database documentation for details) and a URL that specifies
how to talk to your database. You also need a user name and password to
connect to the database. After connecting DbVisualizer to a database,
the program presents a tree view of all the tables in the database. You
can then select a table and query or modify data in the table by
executing SQL commands, saving the results to HTML for CSV (comma-
separated-value) files. DbVisualizer also displays the structure, or
schema, of the database table by showing you the primary keys, indices,
and row counts. I really like how DbVisualizer shows the structure of
the entire database with the tree view.
Unlike many database tools, DbVisualizer also supports BLOB and CLOB
data types, binary and character (text) large objects.
To run DbVisualizer, you need a Java runtime engine version 1.2.2 or
higher, which you can get for Linux from Sun at
http://java.sun.com/j2se/1.3/download-linux.html, from IBM at
http://www-106.ibm.com/developerworks/java/jdk/linux130/?dwzone=java,
and from Blackdown at http://www.blackdown.org/. Blackdown provides
Java runtime engines for more than just Linux on Intel. So if you run
Linux on PowerPC or other non-Intel platforms, check Blackdown first.
DbVisualizer is a commercial product but is freely available from
http://www.minq.se/products/dbvis. You simply need to fill out a
registration form at http://www.minq.se/products/dbvis/download.html to
download the software.
Read more about opinion in ITworld's Opinion section
» posted by ITworld staff
ITworld
Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world
Brian Proffitt
Microsoft/Novell: Breaking Down the Coupon Numbers
Esther Schindler
Drupal's Dries Buytaert on Building the Next Drupal
Tom Henderson
Top Ten General Operating Systems Rants
pasmith
PS3 motion controller delayed; goes up against Project Natal
sjvn
Neolithic Windows security hole alive and well in Windows 7
claird
Perl source code comparison makes for good reading
mikelgan
Cell phones don't create stress or interrupt much
Sandra Henry-Stocker
How to: The Unix Interview
Where Google Chrome security fails: the password
I heard mention that the Chrome OS will have some sort of encryption available a la bitlocker. If it's possible to encrypt personal data using another password or key, then it may have potential for very secure data.... And Ubuntu has an 'encrypt home directory' option, perhaps google should follow suit.
- Dann
Join the conversation here
Quick, practical advice for IT pros. Made fresh daily.
- Ubuntu advances: Why Ubuntu server installations will surge in 2010
- Social media marketing: How to make friends with benefits
- More...
Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.






