Path: utzoo!utgpu!watserv1!watmath!att!att!dptg!ulysses!andante!mit-eddie!wuarchive!usc!snorkelwacker!apple!sun-barr!newstop!sun!yosemite.Eng.Sun.COM!trogers
From: trogers@yosemite.Eng.Sun.COM (Tom Rogers - Database Engineering)
Newsgroups: comp.databases
Subject: predicate locking
Keywords: IMAGE 3000 - around way over 10 years
Message-ID: <143942@sun.Eng.Sun.COM>
Date: 19 Oct 90 15:06:30 GMT
Sender: news@sun.Eng.Sun.COM
Lines: 12

>The idea of using predicate locks for database concurrency control
>has been around for over ten years.  But still there are not many
>commercial systems which use predicate locking as a primary method
>for concurrency control.
>My question is the following:  Are there really no commercial systems
>that use predicate locking ?

Predicate locking has been around in a commercial database system for well 
over 10 years. Check out HP's IMAGE 3000. At some point testing for 
arbitrarily complex predicates becomes extremely expensive, and implementors
have found that row and page level locking is superior in terms of ease
of implementation and speed.