Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2005

Tip: Looking for answers? Try searching our database.

db2look to generate tex - options to vizualize the schema

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Juliane - 21 Jul 2005 13:58 GMT
I have a database which is fully generated by a (java) persistence layer; so
I have practically no layer where pure database modelling will be done, no
Erwin no nothing.
All I can do is giving the persistence layer hints on which objects actually
make persistent(own table), and other objects whose data will be kept with
parent or child objects(sub and super).

Now that makes tuning kind of tough, even to get the picture about the actual
data modell is rather difficult.

What I am thinking of, is that I use db2look to generate the TeX output of
the data model.
I have heard in TeX it can even return the graphic output returning also
constraints.

Two problems:
First big one: I do not get the teX output compiled with TeX. I have no TeX
on AIX, on windows it returns only error messages and an empty dvi file. TeX
itself works fine with any other document.  Anybody has an idea here ?

Second: Will informational constraints be included ? We have no constraints
implemented, generally the persistence layer takes care of that. But I was
generally thinkting to add informational constraints also to ensure indexes
are there etc.
Well, second does not help me if first one is not solved ...

Any other option on how to intelligently visualize the schema is highly
appreciated. I have no tools like Erwin or so at hand

I've never been in such an environment, any help appreciated.

Thanks

Juliane
N. Shamsundar - 24 Jul 2005 15:03 GMT
The TeX output from db2look is for LaTex, not plain TeX. For example,

db2look -d sample -z db2user > sample.tex; latex sample; dvipdfm sample

produces the details in the SAMPLE database for schema DB2USER, into a PDF file.

However, there are problems with this; in particular, tables that are too wide to fit
on a standard page can be seen with a DVI viewer, but will not print correctly. Some
TeX work will be needed to change to landscape mode or use small fonts.

An alternative is to use a third party tool such as DBDesigner ( www.fabforce.net )
to produce the E-R diagrams of the type that you want.

N. Shamsundar
University of Houston

> I have a database which is fully generated by a (java) persistence layer; so
> I have practically no layer where pure database modelling will be done, no
[quoted text clipped - 24 lines]
> Any other option on how to intelligently visualize the schema is highly
> appreciated. I have no tools like Erwin or so at hand
Gert van der Kooij - 24 Jul 2005 15:17 GMT
> An alternative is to use a third party tool such as DBDesigner ( www.fabforce.net )
> to produce the E-R diagrams of the type that you want.

Unfortunately support for DbDesigner has stopped. I hope the MySQL
Workbench mentioned at the forum page will support the same db's as
DbDesigner.

Copied from the forum page:

Dear DBDesigner4 users,

Due to several attacks against the DBDesigner4 forum it has now been
closed down. We simply cannot understand the sick motivation of
people to attack Open Source projects. So please understand that we
will not provide any support from now on.

We will continue to host the DBD4 download till the release of the
MySQL Workbench, its successor application that will be an official
MySQL product. Then this project will rest in peace.

Best regards,
fabFORCE.net team
Juliane - 28 Jul 2005 10:44 GMT
Thank you for your comments,
I'Il will give the DB Designer a try.

Juliane

>> An alternative is to use a third party tool such as DBDesigner ( www.fabforce.net )
>> to produce the E-R diagrams of the type that you want.
[quoted text clipped - 18 lines]
>Best regards,
>fabFORCE.net team
Juliane - 29 Jul 2005 12:36 GMT
BTW: I used LaTeX (on Windows, may be that matters?) and it does not work
Did you actually try it? I've never found anybody trying it besides me. :-)

Juliane

>The TeX output from db2look is for LaTex, not plain TeX. For example,
>
[quoted text clipped - 17 lines]
>> Any other option on how to intelligently visualize the schema is highly
>> appreciated. I have no tools like Erwin or so at hand
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.