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

A common architecture strategy, although not always adopted as Bill tells 
us, is to separate online r/w access from read-only/reporting 
access.  There are several reasons why you want to do this, most 
importantly the design issues with r/w access are often significantly 
different than reporting design issues.  R/W access often requires a highly 
normalized design, R access often a highly denormalized design.

- Scott

At 09:27 AM 2/3/2004 -0500, you wrote:
>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

====================================================
Scott W. Ambler
Senior Consultant, Ronin International, Inc.
www.ronin-intl.com/company/scottAmbler.html

www.agiledata.org
www.agilemodeling.com
www.ambysoft.com
www.enterpriseunifiedprocess.info
www.modelingstyle.info
www.ronin-intl.com

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
--^----------------------------------------------------------------