Subject RE: [firebird-support] Avoiding pessimistic locking
Author Alan McDonald
> On 7 Oct 2005 at 8:09, Kjell Rilbe wrote:
> >Dmitry Sibiryakov wrote:
> >
> >> Actually, the problem is a matter of authority. Why all A, B and C
> >> are allowed to edit the same record? Who has "more right"
> >> information?
> >
> >A is updating the order record because she got a notification that the
> >goods has been delivered while B is updating it because he's just
> >mailed the invoice, and C is updating it because the customer just
> >called to say that she will be returning one of the items because it
> >was damaged?
> It smells like denormalized DB structure.
> Can't say about delivery confirmation, but history of sent invoices
> and accepted reclamations I'd put into separate tables...

definitely - you can even have queries pertaining to different fields in the
same table and not have conflict

> --
> SY, Dimitry Sibiryakov.