Invention Grant
- Patent Title: Transactional table truncation for concurrent transactions
-
Application No.: US15078433Application Date: 2016-03-23
-
Publication No.: US10204130B2Publication Date: 2019-02-12
- Inventor: Praveen Mohandas , Sunil K. Sarin , Knut Stolze
- 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: Edell, Shapiro & Finnan, LLC
- Agent Anthony Curro
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
A method, a processing device, and a computer program product are provided. A truncate table command for truncating all or a subset of one or more rows of a database table is received from a first transaction executing on a processing device. At least one read operation on the truncated database table is performed for at least one transaction concurrent with the first transaction, wherein the truncated rows are visible to the at least one concurrent transaction and invisible to subsequent transactions. Storage units that store the truncated rows are reclaimed in response to completion of the at least one concurrent transaction.
Public/Granted literature
- US20170277744A1 TRANSACTIONAL TABLE TRUNCATION FOR CONCURRENT TRANSACTIONS Public/Granted day:2017-09-28
Information query