[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Physical data schema



Hi all,

I reversed the SL schema into Dia as UML, just to see if it looks
useful. It looks like a LedgerSMB version might be worth having as a
design artifact: ie physical data model. I shall split the generated
diagram into about 6, one per 'subject area' and see how useful it
might be for making changes and forward engineering it back to DML.

Then all it needs is something to reverse the physical model back to
logical and the attributes and thus column names can be controlled for
consistency more easily.

Dia diagrams are xml so good as version-controlled artifacts. Plus here
is a graphic (png) generated from one subject area that would be great
in the technical side of any doco. It would need future work on the
subject area and the diagram prettied up, but it gives you the general
idea.

If you think it looks like being useful, let me know and I should have
time to look further into it later this week.

Attachment: sl-vendor-733x550-50pc.jpg
Description: JPEG image