This is actually a complete list of the types of concurrency control that can be used in database systems. People who claim to have a novel concurrency control scheme type either don't realize their scheme reduces to one of the above or, in Andy's words, "they don't know what they're talking about".
Levy
Interesting when compared to how transactional memory keep isolation. I don't know if I've got the correct understanding:
In transactional memory, both optimistic and pessimistic way is similar to optimistic way in database, because neither of them use locks, nor they make conflicted transaction wait for the other.
sushi
@Levy I believe two-phase locking uses locks because it contains growing phases when locks are required. It's different from what we learned in class that it uses more coarse-grained locking where locks are held through the transaction.
This is actually a complete list of the types of concurrency control that can be used in database systems. People who claim to have a novel concurrency control scheme type either don't realize their scheme reduces to one of the above or, in Andy's words, "they don't know what they're talking about".
Interesting when compared to how transactional memory keep isolation. I don't know if I've got the correct understanding:
In transactional memory, both optimistic and pessimistic way is similar to optimistic way in database, because neither of them use locks, nor they make conflicted transaction wait for the other.
@Levy I believe two-phase locking uses locks because it contains growing phases when locks are required. It's different from what we learned in class that it uses more coarse-grained locking where locks are held through the transaction.