Re: Normalization was Left the AS/400...

Hey, Ken, try a google on "normalization tools" - there are a number of hits.

Vern

At 07:24 AM 5/3/2005, you wrote:

Good points Brad

On passing, I was wondering, and I imagine several others in the group would also, if there is a software tool
available, that can analyze a DB, and make recommendations towards normalization.
This really is an 'elephant' of a problem, because one knows full well that continuing down the road will simply lead
to a lot of excessive work, and coding, etc, while getting managements approval to 'normalize' the data base will
in all likelihood fall on deaf ears.

This problem is, as you are aware, is not limited to home grown databases, but also to a plethora of 'professionally' designed
systems,(usually out-sourced), that are very prone to non normalized databases.(gosh, what a wonderful way to generate $)

        Any hints?..

Ken Shields
PPG Canada Inc
Ph: 905 725 1144 (326)
Fx: 905 433 8712
kenshields@xxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.