Re: Database Schema Question

"Sébastien Boutté" wrote:
>
> We are developing a 3 tiers architecture (GUI Java/Swing - J2EE WebLogic -
> IBM As/400)
> and we have some questions about design of database.
>
> 1. Do we have to implement a physical delete for our system or keep
> everything ?
> 2. In case we implement a logical delete from GUI point of view, can we do
> that by adding a flag field on tables ?
> (We will have problems with unique constraints in this case.)
>
> For these two questions, we would like to know what's done in reality for
> some big projects about "delete" implementation.
>

This may not apply to your situation, but tables on AS/400 (iSeries) are typically journaled. OS/400 provides journal exit points, so it should be possible to capture physical deletes in that way as well.

-- 
Karl Hanson