OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   RE: [xml-dev] To Normalize or Not to Normalize

[ Lists Home | Date Index | Thread Index ]

> 
> Here's a fun question that pits theory against experience. 

That's your idea of fun?
> 
> 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:

When a system needs significant enhancement, which seems to be the case
here, my preferred strategy is always to make the new system(*) look as much
as possible like the system that I would design if I were starting from
scratch.

(*)or at any rate, those subsystems that need to be changed

Sometimes that's not possible, usually because the system is too fragile to
change or because it's impossible to nail down all its interfaces to other
systems. That situation is no fun at all: the preferred strategy is to find
another project...

Michael Kay
http://www.saxonica.com/






 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS