Online and dynamic table reconfiguration
AssigneeTeradata US, Inc.
InventorsTirunagari Venkata Rama Krishna, Srinath Boppudi, Frederick Stuart Kaufmann
Life of this patent
Estimating the term…
Abstract
A table reconfiguration command is received. A READ lock is placed on the table while original table data for the table is moved from a first network location to a second network location into a temporary table according to a new map for the table. An EXCLUSIVE lock on the table is obtained, a data dictionary is modified with the new map for the table, the original table data at the first network location is deleted, and the temporary table is renamed to be the table at the second network location; then, the EXCLUSIVE lock is released.
Claims20
A method, comprising:
- creating a map representing moving a table from a first network location to a second network location;
- obtaining a READ lock on the table;
- moving original table data for the table from the first network location into a temporary table at the second network location using the map;
- acquiring an EXCLUSIVE lock on the table;
- and
- updating a data dictionary with the map, deleting the original table data from the first network location, renaming the temporary table to be the table, and releasing the EXCLUSIVE lock.
A method, comprising:
- issuing a READ lock on a table;
- moving original table data for the table to a temporary table according to a map that links to the temporary table within a data dictionary table;
- obtaining an EXCLUSIVE lock for the table;
- and
- replacing an existing map for the table within the data dictionary table with the map, deleting the original table data, renaming the temporary table to be the table, and releasing the EXCLUSIVE lock.
A system, comprising:
- a data warehouse including:
- an alter table map operation;
- wherein the alter table map operation is configured to:
- i) execute on at least one network node of the data warehouse ii) perform processing that permits a table of the data warehouse to be moved according to a map associated with the table reconfigured in a data dictionary table while the table remains online and accessible for access within the data warehouse device.
Dependencies are inferred from the claim text.