[
Lists Home |
Date Index |
Thread Index
]
Bullard, Claude L (Len) wrote:
> Here's a fun question that pits theory against experience.
>
> You get a job to create a new generation of an old relational
> database system. Upon reading the as-is schema, you discover
> some amount of denormalization and gnomic names. Do you:
Are you sure you know whether the data is unnormalised or denormalised?
Have you read some documented schema, or actually the database and
reverse engineered a schema from it?
> Yes, the existing system is still deployed, still being sold,
> and still being relied upon for mission critical applications.
Check what uses the database and how the database is used. Confirm you
know about all the applications that use the database.
> Yes the new system will be using XML more than the comma-delimited
> exports it relied upon before.
>
> Yes, old customers will be upgraded in some yet as unspecified
> way when the new system goes online.
>
> What is your best strategy?
A. Find out more, including evaluating the option of doing nothing.
B. This will be based on A :)
cheers
Bill
|
