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:
Dec. 24, 2013
Filed:
Jul. 01, 2011
Lynette D Adyilamuriyil, Olathe, KS (US);
Naresh K Chainani, Portland, OR (US);
Raghupathi K Murthy, Union City, CA (US);
Sitaram Vemulapalli, San Jose, CA (US);
Liping Zhang, Portland, OR (US);
Lynette D Adyilamuriyil, Olathe, KS (US);
Naresh K Chainani, Portland, OR (US);
Raghupathi K Murthy, Union City, CA (US);
Sitaram Vemulapalli, San Jose, CA (US);
Liping Zhang, Portland, OR (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Method for attaching one or more tables online to a range partitioned table, includes: starting a child transaction; obtaining an exclusive lock on a source table; obtaining an intent exclusive lock on a target table; soft invalidating queries on the target table where compiled form of queries are cached for reuse; attaching the source table(s) to the target table as a new partition(s) of the target table; modifying indices and table structure of the target table to reflect the attaching of the new partition; committing the child transaction; and releasing the exclusive lock and the intent exclusive lock, where concurrently running queries over the target table continue to run without considering the partition until the intent exclusive lock and the exclusive lock are released. Queries on the target table only consider existing partitions when the attaching is in progress. The new partition is available once the attach operation is complete.