Re: [AM] Database "refactoring" effort question

Paul Oldfield <[email protected]>
Newsgroups gmane.comp.programming.modeling.agile
Message-ID <[email protected]>
(responding to Graham)

> Please replace the column Taxpayer Name (40 characters)
> by two columns Taxpayer ForeName (25 characters) and
> Taxpayer Surname (25 characters).
>
> THE QUESTION
> How long will it take make this small change
> - to the test database?
> - to the production database?

"How are you intending to supply me with the data I need,
 that I don't have?  I need to know where to split the 
 Taxpayer Name.  That data seems to be absent."

This isn't a refactoring problem if you are intending to
create new data - or capture new data.  The refactoring
takes little effort.  The data capture of the required new
data is what will take the effort.

Is there any case where, now or in the future, the total
length of name would be more than 40 characters?
We can truncate the forename now, and deal with the
problems on our to-do list.

I guess it's an improvement for the Cholmondeley-
Hartington-Smythe family that we have an extra 10
characters to play with... 


Paul Oldfield

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
www.aptprocess.com

any opinions expressed herein are not necessarily those of
Mentors of Cally or the Appropriate Process Movement
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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
--^----------------------------------------------------------------
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.