Re: -- insert instead of an update

"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message news: 3fcb199a$0$14056$afc38c87_at_news.optusnet.com.au...
>
> "Alkos" <azerty_at_nospam.org> wrote in message
> news:bqf2p2$p715_at_news.rd.francetelecom.fr...
> >
> > "Galen Boyer" <galenboyer_at_hotpop.com> a écrit dans le message news:
> > u3cc7aooz.fsf_at_standardandpoors.com...
> > > On Thu, 20 Nov 2003, rtd45Rd_at_nospam.org wrote:
> > > >
> > > >> Obviously they don't want to live in the same mess as you seem
> > > >> to be desiring to get in.
> > > >
> > > > Hope this was intended to be ironical :-/ My only wish is to
> > > > discover what's new with that version because some companies
> > > > are using it so I don't want to close myself some job
> > > > opportunities. But maybe a Senior Oracle DBA has some good
> > > > advice to give me, hasn't you, Sybrand ;)
> > >
> > > Sybrand's answer wasn't ironical. He just isn't usually all that
> > > warm and fuzzy.
> > >
> > > I try not to criticize designs that I know nothing about, but I
> > > am suspicious of your design. Why should an update ever cause an
> > > insert to the same table? I am assuming auditing is stored in
> > > your entity table? What's your primary key to this entity table?
> > >
> > > --
> > > Galen Boyer
> >
> > Hi Galen,
> >
> > The purpose of my design was simply to find a use for instead of
triggers.
> > Another purpose was to see how far it was possible to separate the
logical
> > view of the data
> > from their implementation in a table.
> >
> > Logical view behaves simply as we expect (delete deletes record, update
> > updates and insert inserts)
> > the underlying table behaves another way (delete marks a record as
> deleted,
> > update updates but insert the old version into a new row)
> >
> > My goal is to keep many versions of reference data in my database so I'm
> > testing different solutions (triggers was one, I keep on searching ;-).
> > Needless to say that I give up the "instead of triggers" solution :))
>
> I haven't been following this thread, so my apologies if this is out of
left
> field. But if you need the database to contain many versions of the same
> data, have you investigated 9i's Workspace Manager feature?
>
> Sheer brilliance, in MHO. (Oh, and it uses instead of triggers, too!)
>
> You might not even be running on 9i, so my apologies for an unwonted
> intrustion if so.
>
> Regards
> HJR
>
>

Hello Howard,

Running 8.1.7.4
Not even talking of 9i

Thank you for the idea
Alkos Received on Mon Dec 01 2003 - 05:24:29 CST