Invention Grant
US07181452B1 Locking mechanism using predefined locks for aggregate materialized views in a database system
有权
在数据库系统中使用预定义的锁集合物化视图的锁定机制
- Patent Title: Locking mechanism using predefined locks for aggregate materialized views in a database system
- Patent Title (中): 在数据库系统中使用预定义的锁集合物化视图的锁定机制
-
Application No.: US10324456Application Date: 2002-12-20
-
Publication No.: US07181452B1Publication Date: 2007-02-20
- Inventor: Gang Luo , Michael W. Watzke , Curt J. Ellmann
- Applicant: Gang Luo , Michael W. Watzke , Curt J. Ellmann
- Applicant Address: US OH Dayton
- Assignee: NCR Corp.
- Current Assignee: NCR Corp.
- Current Assignee Address: US OH Dayton
- Agency: Trop, Pruner & Hu, P.C.
- Agent Adam Bennett
- Main IPC: G06F17/30
- IPC: G06F17/30
Abstract:
A database system includes a locking mechanism for an aggregate materialized view defined on base relations. In response to updates of a base relation, predefined locks are placed on the aggregate materialized view. With locking mechanisms, transaction concurrency is enhanced by enabling concurrent updates of the materialized view by plural transactions in certain cases, while avoiding the situation in which multiple tuples belonging to the same group are integrated as separate tuples into the aggregate materialized view.
Information query
