Live database schema tree change
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 man...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | 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. |
|---|