Forum OpenACS Q&A: There exists an ER or UML description for OACS 4.5???

Collapse
1: There exists an ER or UML description for OACS 4.5???
Posted by Jorge Garcia on 06/21/02 10:43 AM
It will be very useful.

For ACS 3 there was ER docs.

Something similar for OACS 4.5?

Anybody knows?

Thanks.

Collapse
2: Response to There exists an ER or UML description for OACS 4.5??? (response to 1)
Posted by Roberto Mello on 07/01/02 03:50 PM
I don't think there are, although the design docs explain much of that. But if you'd liek to generate them for us, that would be a great contribution for the project.
Collapse
3: Response to There exists an ER or UML description for OACS 4.5??? (response to 1)
Posted by Jorge Garcia on 07/02/02 02:31 PM
Hi, Roberto

Could you suggest us any software could help us to produce such a model?

We are learning to use Dia, a free UML tool.

There exists an add to this tool, dia-to-sql, who produces a sql output from our diagrams.

i.e. do you know any software who can read the database estructure from a package of OACS and output graphics with the relations between the tables?

I mean a tool like the menu 'Tools-Relations' in Microsoft Access.

Regards,

Collapse
4: Response to There exists an ER or UML description for OACS 4.5??? (response to 1)
Posted by Talli Somekh on 07/02/02 03:10 PM
Jorge, we use Dezign by Datanamic. It's not free, but it's not expensive either. It does what you are looking for.

talli

Datanamic - http://www.datanamic.com/
Dezign - http://www.datanamic.com/dezign

Collapse
5: Response to There exists an ER or UML description for OACS 4.5??? (response to 1)
Posted by Jorge Garcia on 07/03/02 10:52 AM
Thanks, Talli.

I will try.

Collapse
6: Response to There exists an ER or UML description for OACS 4.5??? (response to 1)
Posted by Roberto Mello on 07/04/02 02:02 AM
Jorge,

I've used DbVisualizer, a free-as-in-beer app. It's in Java and connects to the database through JDBC. You need to use the PG 7.2's JDBC driver, even if running PG 7.1 or lower.

It does the entity-relation thingy quite well. http://www.minq.se/products/dbvis/dbvis3.html