System and method for quiescing select data modification operations against an object of a database during one or more structural operations
US7805423B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 15, 2000 |
| Grant date | Sep 28, 2010 |
| Priority date | — |
| Expiry date | Feb 26, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/289
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.