Home -> Usenet -> comp.databases.theory -> Database Schema Question

Database Schema Question

From: (wrong string) ébastien Boutté <boutte_at_wfinance.fr>
Date: Wed, 28 Aug 2002 10:46:08 +0200
Message-ID: <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 ?
  
  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.



Thanks



Sebastien Boutte
Received on Wed Aug 28 2002 - 10:46:08 CEST












Original text of this message