Non-blocking database table alteration
US10417257B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 16, 2016 |
| Grant date | Sep 17, 2019 |
| Priority date | — |
| Expiry date | Aug 6, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/214
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems for managing large database systems. Storage devices hold a set of one or more subject database tables that hold subject data accessed by one or more users. A data definition statement to perform a table alteration operation (e.g., a table partition operation) over a particular table in the subject database is received, parsed, and the table alteration operation over the particular table is initiated. During the processing of the data definition statement to complete the table alteration operation, a data manipulation statement to perform a table access operation over the same table is received and parsed. The data manipulation statement is not blocked, even while the table alteration operations are ongoing. Rather, during the time that the table alteration operations are ongoing, the data manipulation statement is processed using hidden tables. After the table alteration operations have completed, incoming data manipulation statements are performed over the altered database tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.