Re: db constraints evaluation question

>> how do I determine which deferred constraint checks are needed

I was more thinking in terms of an implementors point I view.

When I do an update on x in a table y and if is there is a constraint x<10 on the table, the transaction manager has to check that for updated row(s). If there is another constraint z>10, then checking that, would be a waste of time - given that the value of z doesn't depend on the one of x.

A beter to ask my question would probably be: Is there any work on how to implement such a transaction manager with more complex modelling languges?

Thanks,
Martin Received on Sun Mar 19 2000 - 00:00:00 CET