Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-18 Thread Gavin Flower
On 18/08/12 04:33, David Johnston wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Wolfgang Keller Sent: Friday, August 17, 2012 9:08 AM To: pgsql-general@postgresql.org Subject: Messy data models (Re: [GENERAL

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-18 Thread Wolfgang Keller
> > In fact, shouldn't reasonably well-designed data models at least > > mostly follow SER principles? In that case, they could be displayed > > essentially > as a > > tree. > > No - and what the heck are "SER principles"? Structured Entity Relationship model. It means that the dependency graph

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread Sébastien Lorion
Short answer: no. Even with a good auto-layout, nothing (up to now) beats a human made one because the latter will incorporate semantic which is not available to the modeling tool; for example, positioning, spacing and routing of relations will respect some sense of aesthetic and organization that

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread David Johnston
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Wolfgang Keller > Sent: Friday, August 17, 2012 9:08 AM > To: pgsql-general@postgresql.org > Subject: Messy data models (Re: [GENERAL] Visuali

Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread Wolfgang Keller
> Concerning auto-layout, most if not all tools I have used up to now > make a mess for anything that is not dead simple. If a data model can not be reasonably "untangled" by an auto-layout algorithm (such as e.g. Graphviz) for display as a human-readable graph, wouldn't that mean that this model