RE: [AM] Database "refactoring" effort question

Well, parsing a full name isn't a big deal. If you want to split out
Taxpayer Name (which I assume isn't the real field name - spaces not usually
allowed) into ForeName and Surname than can we assume every Taxpayer Name is
made up of a firat name and surname/ if it's not then you're screwed anyway
:-) If so, it's still quite easy to parse a full name. I wouldn't expect the
whole change to take longer than a day for 10,000,000+ records, if you've
got a decent DB platform.

Any code still depandant on Taxpayer Name can be easily serviced by a view
that concatenates first name and last name - assuming the BD developer was
sensible enough to decouple table schemas from return views.

(Unless this is a trick question, of course)

Jason Gorman
http://www.objectmonkey.com
"A say what I like, and I like what I say"

-----Original Message-----
From: Graham [mailto:[email protected]] 
Sent: 01 February 2004 23:13
To: [email protected]
Subject: [AM] Database "refactoring" effort question

Here is a question for you

END OF LAST ITERATION
We have a database system for processing tax statements and revenue from tax
papers.
The database well encapsulated, hidden from applications behind "views".
We have a test database containing data for 1,000 taxpayers We have a
regression test suite that will, at the push of a button
- push each table through its life cycle from creation through state changes
to archive
- navigate each relationship.
We have a production database containing data for 10 million taxpayers,

CHANGE REQUEST TO BE PROCESSED IN NEXT ITERATION In the kernel entity - the
Taxpayer table. 
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?

For more information about AM, visit the Agile Modeling Home Page at
www.agilemodeling.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
--^----------------------------------------------------------------