Live database schema tree change
US9779118B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 17, 2015 |
| Grant date | Oct 3, 2017 |
| Priority date | — |
| Expiry date | Apr 4, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2282
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database management system (DBMS) in control of the computerized database, to: create an intermediate database table having a column configured to reference the parent database table; in the child database table: create a column configured to reference the intermediate database table, insert an identifier of the intermediate database table into all fields of the column configured to reference the intermediate database table, and overwrite all fields of the column configured to reference the parent database table with data from the fields of the column configured to reference the intermediate database table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.