Re: [AM] Database "refactoring" effort question
Scott Ambler <[email protected]>
| Newsgroups | gmane.comp.programming.modeling.agile |
|---|---|
| Message-ID | <[email protected]> |
At 09:53 AM 2/3/2004 -0500, Paul wrote: ><snip> >My point is that you are creating two columns of *new* data. Where is the new data coming from? If I had one column with "Ambler Scott" in it and new have two columns, one with "Ambler" and one with "Scott" there isn't any new data. This is the extent of the split column refactoring. Anything you do beyond that is something else. >It is possible that there is some arbitrarily complex rule that >can derive the new data from the old data that you already >have, and that this may turn out to be an acceptable way >to create the new data, with an acceptable level of dirty >data created in the process. Yes, and it won't be pleasant I would think. > Yet there is nowhere in the >system that contains all the data needed to create the new >data from what is already there. Why not? Source data + rule ==> refactored data. Yes, you may also decide to go in by hand at some point and clean up the dirty data, but that's above and beyond the refactoring. > In populating the new >columns, one needs to add information that is not yet >available. Like what? >This is not merely a refactoring. Exactly, that's a transformation. >For the >10,000,000 records quoted, you need to create one new >piece of information each - at minimum. What information? -Scott ><snip> ==================================================== 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 --^----------------------------------------------------------------