Re: [GeneX-dev] Re: ERWin File on website

[Michael P. <mic...@ho...>]

Using views for compatibility while changing the underlying schema  is a great idea. But be aware
that you can't directly insert, update or delete from views. There is a mechanism for creating rules
to handle updating the tables behind a view, but I've never experimented with that personally.

Regards,

Michael Pear


----- Original Message -----
From: "Todd F. Peterson" <tf...@nc...>
To: <gen...@li...>
Sent: Saturday, December 15, 2001 9:51 PM
Subject: Re: [GeneX-dev] Re: ERWin File on website


> like i said in previous msg, the original schema can be mimicked by
> using views. what i'm doing is attempting to optimize the underlying db.
> the genex XML, mage XML and links to the other tools *should* behave the
> same when I get this right. i'm only affecting a small portion of the
> schema that should be transparent in the long run. i'm not reinventing the
> wheel, just implementing it in a unique manner.
>
> todd
>
>
>  On 14 Dec 2001, Jason
> E. Stewart wrote:
>
> > "Todd F. Peterson" <tf...@nc...> writes:
> >
> > > oh yeah, it's fast and easy. that was not the case with the curation
> > > tool/xml mechanism. we figure, first get the data in the db and then
> > > annotate as necessary. this will be good for small labs. hopefully,
> > > the design will allow scaleability to larger environments.
> >
> > I'm all for lightwieght, fast, and easy, as well as annotation after
> > the data is in the DB. None of that impacts what schema you use.
> >
> > If you invent a whole new schema you'll have to invent completely new
> > tools that can work with that schema. If you store the data in a
> > subset of the GeneX schema, you can use all the tools that work for
> > GeneX.
> >
> > What is the advantage of the new schema?
> >
> > jas.
> >
> > PS. I'm on the list, you don't have to reply to me personally.
> >
> > _______________________________________________
> > Genex-dev mailing list
> > Gen...@li...
> > https://lists.sourceforge.net/lists/listinfo/genex-dev
> >
>
>
> _______________________________________________
> Genex-dev mailing list
> Gen...@li...
> https://lists.sourceforge.net/lists/listinfo/genex-dev