Are there any tools especially designed for very large/complex domain/database models? I am speaking of 200+ or 500+ entities/tables?

Common standard tools don't cope well with this amount, both in terms of performance and usability.

  • Probably be good to list the 'common standard tools' rather than assume people agree on what those are. Also do you care about operating system, pricing, open sourceness? May 18 '14 at 16:12

In my experience the tools from larger vendors easily handle such amounts. I have no experience above 5,000 tables but up to that amount it should be possible. Some samples: Oracle Designer, ERwin. I myself use yEd plus an own case-tool. I find the essential feature that makes large volume manageable that a tool can auto-layout and auto-group tables that have strong relations between them.

For my interest: what problems are you running into? Can you add those to your question?

  • In the past I was using ObjectMapper2005 which had a terrible performance for larger models, in .NET development we use integrated editors from Visual Studio which have a terrible perf. as well, but don't even have any concepts for larger models (e.g. no packaging/namespaces!!)
    – andreas
    May 18 '14 at 8:20
  • A perfect tool provide higher abstractions for layering relations.
    – andreas
    May 18 '14 at 8:21
  • Yes, when you can bring similar relations together it gets more easily readable in general. For some entities, like Person, you will find a relationship absolutely everywhere so these can be placed in a "information infrastructure". PS. So far we are using our own objectmapper for ORM. Most CASE-tools allow you to query their data and generate your own C# data access layer. May 19 '14 at 5:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.