[Ilja]

see subject

except from OmniGraffle, I mean one that is totally focussed on database design

[bousozoku]

Those I've seen are hugely expensive. You might be able to use an application which does UML (Unified Modeling Language) for database design.

[gralem]

There is a product distributed with WebObjects called EOModeller. I doubt it is a full-featured data modeller, but it works well for webobjects data design and work. I do not think it's compatible with UML. It outputs plist data. But I have written shell scripts that conver to/from this plist data, so it may be possible to get UML out.

But like I say, I don't have that much experience with other data modellers.

---gralem

[Arkham_c]

Depending on your goal, you could use an EJB design tool. It will generate the database schema and EJB CMP description XML based on your data requirements.


I would say that automated tools are rarely the most efficient answer to these problems. It's better to understand how databases and queries work and design the schema and indexes by hand to maximize performance.

[Ilja]

I know, but it's more for presentation sake and for quickly be able to generate a database-scheme.

[Radio Child]

I think you might find this one useful:

SQL4X Manager

--
RC