Systems and methods for reorganizing a database object
US7970748B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 26, 2010 |
| Grant date | Jun 28, 2011 |
| Priority date | — |
| Expiry date | Aug 26, 2030 |
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.