Re: how to build a database from scratch
From: DBMS_Plumber <paul_geoffrey_brown_at_yahoo.com>
Date: 8 Dec 2006 15:28:37 -0800
Message-ID: <1165620516.980218.58580_at_n67g2000cwd.googlegroups.com>
Date: 8 Dec 2006 15:28:37 -0800
Message-ID: <1165620516.980218.58580_at_n67g2000cwd.googlegroups.com>
paul c wrote:
> I knew one advanced product, eg., it had a predicate lock
> manager long before any of the big-name dbms'es, that was designed to
> eliminate dba's. Sales were abysmal, in part because dba's in big
> corporations saw this as a big threat and did every thing they could to
> keep the product out.
If you believe that you can, please explain how you can determine whether the predicates "F.Y = 5" and "F.Y = B.Y" collide? Which is why none of the big-name DBMSs use predicate based locking.