Invention Grant
- Patent Title: Dropping columns from a table with minimized unavailability
- Patent Title (中): 从最小化不可用的表中删除列
-
Application No.: US14154000Application Date: 2014-01-13
-
Publication No.: US09317543B2Publication Date: 2016-04-19
- Inventor: Craig A. Friske , Charles H. Lin , Regina J. Liu , Jerry Mukai , Kalpana Shyam , Cherri Vidmar , Julie A. Watts , Jay A. Yothers , Binghui Zhong
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.
Public/Granted literature
- US20150199393A1 DROPPING COLUMNS FROM A TABLE WITH MINIMIZED UNAVAILABILITY Public/Granted day:2015-07-16
Information query