[ic] database table redesign

[D Zhang - msi]

----- Original Message -----
From: "Dan Browning" <dbml@kavod.com>
To: <interchange-users@icdevgroup.org>
Sent: Friday, April 04, 2003 3:43 PM
Subject: Re: [ic] database table redesign


> At 10:56 AM 4/4/2003 -0800, you wrote:
> >I was wondering if anyone has ever thought of redesigning the interchange
> >table designs? They don't appear to be well normalized.
> >I understand that IC can run on anything from text files to rdbms, so I
> >was wondering if the tables aren't normalized because of a limitation due
> >to the text or dbm tables or because it would just be too large a
project.
> >If anyone has any insight into how big a project this would be to really
> >clean up the table designs for optimial usage by an rdbms like
> >Oracle I would be interested in hearing from you.
>
> Hello Jason, it's a pleasure to have you on the list.  I hope you'll
excuse
> my asking you to get up to speed with these threads:
>
>
http://www.icdevgroup.org/pipermail/interchange-users/2001-April/006781.html
>
>
http://www.icdevgroup.org/pipermail/interchange-users/2002-July/023499.html
>
> My own position is:
>
> The database is the way it is because it is
>
>   * Easy (e.g. storing the address information in 'transactions' allows
the
> 'historical' information to stick around very easily).
>

"storing the address information in 'transactions' " is also necessary to
keep order history, as Janothon pointed out in replying to the post cited
above (2002-July/023499.html)

> >If anyone has any insight into how big a project this would be to really
> >clean up the table designs for optimial usage by an rdbms like
> >Oracle I would be interested in hearing from you.

I would suggest you to get familiar with the business operation before
considering to re-design something.


David
http://www.msihosting.com
Expert -- ecommerce solution, interchange hosting