The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 19, 2016
Filed:
Jan. 13, 2014
International Business Machines Corporation, Armonk, NY (US);
Craig A. Friske, Morgan Hill, CA (US);
Charles H. Lin, San Jose, CA (US);
Regina J. Liu, San Jose, CA (US);
Jerry Mukai, San Jose, CA (US);
Kalpana Shyam, Los Altos, CA (US);
Cherri Vidmar, Gilroy, CA (US);
Julie A. Watts, Morgan Hill, CA (US);
Jay A. Yothers, Gilroy, CA (US);
Binghui Zhong, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
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.