X-Received: by 10.180.21.198 with SMTP id x6mr438311wie.2.1379396181441; Mon, 16 Sep 2013 22:36:21 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.85.212.215.MISMATCH!g3no22456622wic.0!news-out.google.com!v3ni128045wiv.1!nntp.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Jeremy Newsgroups: comp.databases.oracle.server Subject: Re: Triggers - :new - pseudorecord Date: Tue, 17 Sep 2013 06:36:20 +0100 Lines: 15 Message-ID: References: <2fdbe7f1-46c7-423a-8891-09c44d87a8c5@googlegroups.com> <0ee09b41-bc62-431e-b00b-36f44d640d65@googlegroups.com> Mime-Version: 1.0 X-Trace: individual.net XVhtXp5Fo2SpdHdZkJpNAgum/baQArSzMAXV2IWrdJ9OBkRd8t Cancel-Lock: sha1:0lMZWsijImQgfY2iHrl3FGzlCm8= User-Agent: MicroPlanet-Gravity/3.0.4 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Xref: news.cambrium.nl In article <0ee09b41-bc62-431e-b00b-36f44d640d65@googlegroups.com>, joel-garry@home.com says... > Having dealt with "database blind" and "infinitely flexible schema" stuff in databases for far too long, I would run screaming from what you are trying to do, as minimizing the maintainability effort in that manner maximizes the maintainability effort in a more fundamental manner. But that probably just reflects the horribly bad way I've seen xml abused, as well as keeping referential integrity in the app and other such religious persecution. > > But don't let me stop you. > No you misunderstnd me - the *original* idea was around XML which already attracted sufficient negative feedback that we have elsected to implement shadow tables which more or less mirror the tables we are tracking change on. Downside is that it appears that the developers have code some column assignments :) -- jeremy