Messy data models (Re: Visualize database schema) - Mailing list pgsql-general

From Wolfgang Keller
Subject Messy data models (Re: Visualize database schema)
Date
Msg-id 20120817150742.901788f145841f73138f20f4@gmx.net
Whole thread Raw
In response to Re: Visualize database schema  (Sébastien Lorion <sl@thestrangefactory.com>)
Responses Re: Messy data models (Re: Visualize database schema)  ("David Johnston" <polobo@yahoo.com>)
Re: Messy data models (Re: Visualize database schema)  (Sébastien Lorion <sl@thestrangefactory.com>)
List pgsql-general
> 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 is a mess from the modeling point of
view?

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.

Could the "messy-ness" (or not) of the display of a data model (given
a standard alorithm such as Graphviz) be used as a criterion to judge
whether the model is actually well-structured?

Sincerely,

Wolfgang


pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Re: Best practice non privilege postgres-user
Next
From: "Albe Laurenz"
Date:
Subject: Re: Best practice non privilege postgres-user