RE: [AM] Unfounded assertion

Are both of these refactoring?

1. Split a field into two others (typically, Name into Forename and
Surname.)
2. The warehouse has an internal customer number, and looks up the original
system customer id on a cross reference table. But every report we produce
uses the original id (and a system id). So add the system of origin and the
original id to the customer table on the warehouse.

I wonder if 1 is a design change, and 2 is a refactoring (to save hammering
the cross-reference table, which is narrow, very deep and used in every
update and extract).

(BTW - jargon alert - if anyone wonders what I mean by 'narrow' and 'deep',
'narrow' is the width of a row, 'deep' is the number of rows - this type of
table can be the Marianas Trench of your database.)

But if the users want the name field split, don't waste time wondering what
to call it - that time would be better spent explaining to the person who
designed the database that they messed up and should have thought of this
one, and then finding out that they did, but the contents of Name are in no
clear format - surname + initials, forename + surname, initials + surname,
all in one field in the source system (which isn't this one)... 

Regards,

Dagna

Dagna Gaythorpe
Data Architect
International IT
> tttt COLT TELECOM GROUP PLC
> Beaufort House, 15 St Botolph Street,
> London EC3A 7QN
t   (+ 44) 020 7 390 7896
f   (+ 44) 020 7 947 1176
e [email protected]



-----Original Message-----
From: Jason Gorman [mailto:[email protected]
<mailto:[email protected]> ] 
Sent: 03 February 2004 00:17
To: [email protected]
Subject: RE: [AM] Unfounded assertion


Is refactoring "problem domain stuff"? I thought it was about improving the
technical design without changing what the system does. Surely refactoring
is "solution domain"?

Jason Gorman
http://www.objectmonkey.com <http://www.objectmonkey.com>  



*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Beaufort House, 15 St. Botolph Street, London, EC3A 7QN
Tel. +44 20 7390 3900


This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************

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