Patent ID: 8156110
Filing Date: 2012-04-10
Classification: G06F

Abstract:
1. A method performed by software embodied in a computer-readable storage medium and executed by a computer in a database system that stores a join view associated with plural base relations, the method comprising: receiving modification operations that modify at least two of the base relations of the join view, wherein the at least two base relations comprise a first base relation and a second base relation; performing partitioning of the received modification operations by submitting at least some of the modification operations operating on the first base relation to a first session, and submitting at least another of the modification operations that operate on the second base relation to a second session; grouping the at least some of the modification operations in the first session operating on the first base relation into a first transaction, wherein the at least another modification operation in the second session is part of a second transaction; and scheduling the transactions to avoid execution of modification operations of more than one of the at least two base relations at one time in the database system.