RE: [AM] [dm-discuss] ZZZ Farewell Fellow Agilists

the coupling between the databases and the programs that use them. Where I
work, we have 30 years of coupling program code directly to databases, and
as a result any change to a database can affect hundreds of programs. As a
result we cannot get  
 
We have the same problem, and it only compounds the DBAs' resistance.
 
One thing we are doing, however, is proceding to isolate the read-only
access (usually reporting) programs and have built views that are identical
to the underlying tables. Then we do the detective work of going through the
code and changing the queries to use the views. Why this was never done in
the first place (or at least 10 years ago!), I have no idea but, it's a
start. The next step is to identify the functions in programs that just do
lookups and we'll follow the same process. Finally, we can deal with the
updates which has just become a much smaller unknown due to process of
elimination. At that point, the re-factoring and migration task is much more
realistic.

For more information about AM, visit the Agile Modeling Home Page at www.agilemodeling.com
--^----------------------------------------------------------------
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrKDA.bWnbtk.Z2NtYS1h
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
--^----------------------------------------------------------------