发明授权
US07805423B1 System and method for quiescing select data modification operations against an object of a database during one or more structural operations
有权
用于在一个或多个结构操作期间停止对数据库对象的选择数据修改操作的系统和方法
- 专利标题: System and method for quiescing select data modification operations against an object of a database during one or more structural operations
- 专利标题(中): 用于在一个或多个结构操作期间停止对数据库对象的选择数据修改操作的系统和方法
-
申请号: US09713479申请日: 2000-11-15
-
公开(公告)号: US07805423B1公开(公告)日: 2010-09-28
- 发明人: William Romine , Ross Doering
- 申请人: William Romine , Ross Doering
- 申请人地址: US CA Aliso Viejo
- 专利权人: Quest Software, Inc.
- 当前专利权人: Quest Software, Inc.
- 当前专利权人地址: US CA Aliso Viejo
- 代理机构: Knobbe, Martens Olson & Bear, LLP
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
信息查询