Patent ID: 7181452
Filing Date: 2007-02-20
Classification: G06F,Y10S

Abstract:
1. A method of updating an aggregate view in a database system, comprising: providing an initial instance of a predefined first lock for placing on the aggregate view, the initial instance of the predefined first lock conflicting with a shared lock and an exclusive lock placed on the aggregate view, but not conflicting with an additional instance of the predefined first lock placed on the aggregate view; receiving a first transaction that causes a first tuple to be integrated into the aggregate view; and in response to the first transaction, placing an initial instance of a predefined second lock on the aggregate view, the initial instance of the predefined second lock conflicting with any one of a shared lock, exclusive lock, and an additional instance of the predefined second lock placed on the aggregate view, but not conflicting with the initial instance or the additional instance of the predefined first lock placed on the aggregate view, wherein the predefined first lock and predefined second lock are different types of locks; and; whereby each of the predefined first lock and predefined second lock differ in lock type from either a shared lock and an exclusive lock; and wherein the predefined first lock comprises a Y lock, and the predefined second lock comprises a W lock.