Invention Grant
US07805423B1 System and method for quiescing select data modification operations against an object of a database during one or more structural operations
有权
用于在一个或多个结构操作期间停止对数据库对象的选择数据修改操作的系统和方法
- Patent Title: System and method for quiescing select data modification operations against an object of a database during one or more structural operations
- Patent Title (中): 用于在一个或多个结构操作期间停止对数据库对象的选择数据修改操作的系统和方法
-
Application No.: US09713479Application Date: 2000-11-15
-
Publication No.: US07805423B1Publication Date: 2010-09-28
- Inventor: William Romine , Ross Doering
- Applicant: William Romine , Ross Doering
- Applicant Address: US CA Aliso Viejo
- Assignee: Quest Software, Inc.
- Current Assignee: Quest Software, Inc.
- Current Assignee Address: US CA Aliso Viejo
- Agency: Knobbe, Martens Olson & Bear, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The invention is a reorganization system having a reorganization application, a database management system, and one or more database files. The reorganization application communicates with the database management system and the one or more database files to reorganize an object, such as, for example, a table or index, while providing one or more clients substantially continuous access to the object. The reorganization application employs one or more trigger locks to synchronize the data in an original table and a reorganized table. The one or more trigger locks block select data modification operations while allowing one or more read-only operations and structural modification operations.
Information query