Cart
[Home] [By Thread] [By Date] [Recent Entries]
If the question is schema the right place to capture constraints I think u nailed it in your post - however - given that constraints have validity periods I don't see database constraints supporting such a mechanism - whether that validity period is driven by a start date , end date or locale based or some other policies, etc is question for an individual application to anwser.
I was trying to address the part of being "wary of constraints" - to me constraints need to be enforced - would i opt for database constraints or declarative constraints based system or procedural constraints or processes - the anwser is it depends on the scenario - each come with tradeoffs.
for example consider the constraint the expiry date should be after effective date - in most scenarios that constraint holds true! prakash Michael Kay <michael.h.kay@n...> wrote:
Do you Yahoo!? http://us.rd.yahoo.com/mail_us/taglines/100/*http://promotions.yahoo.com/new_mail/static/efficiency.html - 100MB free storage!
|
