| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: Database Schema Question
"Sébastien Boutté" <boutte_at_wfinance.fr> wrote in message
news:3d6c8de5$0$27142$afc38c87_at_news.easynet.fr...
> Hi,
>
> 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 ?
Both. Delete from current production
databases but archive elsewhere.
> 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.)
YES. Sample column name "ALIVE".
Value 1 is alive, value 0 is not alive.
No other values permitted.
The GUI examines only "alive=1" matters. etc
> For these two questions, we would like to know what's done in reality for
> some big projects about "delete" implementation.
>
> Thanks
>
> Sebastien Boutte
Step 1): Archival old data to some cheap (or appropriate) media. Step 2): Purge old data from the current production database.
Farmer Brown
 |
 |