Invention Grant
- Patent Title: Reducing the cost of update, delete, and append-only insert operations in a database
-
Application No.: US15366611Application Date: 2016-12-01
-
Publication No.: US09881049B2Publication Date: 2018-01-30
- Inventor: Ronald J. Barber , Bishwaranjan Bhattacharjee , Guy M. Lohman , Chandrasekaran Mohan , Vijayshankar Raman , Mohammad Sadoghi Hamedani , Richard S. Sidle , Adam J. Storm , Xun Xue
- 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
- Agent Joseph W. Cruz
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.
Public/Granted literature
- US20170075951A1 REDUCING THE COST OF UPDATE, DELETE, AND APPEND-ONLY INSERT OPERATIONS IN A DATABASE Public/Granted day:2017-03-16
Information query