Re: Database Re-eng

[Dave Duerr <dduerr@xxxxxxxxxxxxx>]

At 10:39 PM 4/3/98 -0500, you wrote:
>>If you are going to reengineer your database the first thing I would do is
>>to forget DDS for data files.  DDS is one of the most archaic features left
>>on the AS/400.  Go with one of the many modern SQL based data modeling
>>tools such as ERwin(by Logic Works) to design, create, and maintain your
>>database.  Creating and maintaining a complex database, complete with
>>referential integrity constraints and triggers, takes days with a modeling
>>tool, as compared to weeks if not months if using DDS and DB2/400 commands.
>> And DDS provides virtually no documentation in regard to relationships,
>>foreign keys, etc.  The issues you raised are non-issues if using a data
>>modeling tool.
>
>
>En Garde!
>
>Tools, schmools.  The key in -any- data base design is the legwork to talk
>to users and the drawing on the walls to plan the thing out that precedes
>the first touch of a finger to a key.
>
>--Paul E Musselman
>PaulMmn@ix.netcom.com
>
I agree with the legwork stuff, but to draw your ERD's by hand, then pound
them into DDS using SEU and then use CL commands to establish your
relationships is a bit neanderthal.  I hope you are still not using 132
column paper to manually design your display and printer files then enter
the DDS specs using SEU.  I would hope that you are using SDA and RLU for
this purpose.  Tools like these, the new DSU, and ERwin greatly enhance an
iterative design process by eliminating alot of the grunt work.  
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---