Invention Grant
- Patent Title: Providing snapshot isolation to a database management system
-
Application No.: US15224959Application Date: 2016-08-01
-
Publication No.: US10585876B2Publication Date: 2020-03-10
- Inventor: Andreas Brodt , Daniel Martin , Oliver Schiller , 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 Richard Wilhelm
- Priority: GB1605937.0 20160407
- Main IPC: G06F16/11
- IPC: G06F16/11 ; G06F16/23

Abstract:
Providing snapshot isolation to a database managed by a database management system includes providing a program module to analyze a plurality of database queries directed at a table of the database and generates a view for said table. The table comprises a counter value column and the view is configured to selectively read, upon being called, data records having assigned particular counter values. The program module modifies the view of said table such that the particular counter values comprise counter values generated at moments when the program module received respective write queries which have already committed at the moment of modifying the view, are free of counter values of data records having become outdated by an update statement committed at the moment of modifying the view, and are free of counter values generated by the counter after the moment of modifying the view.
Public/Granted literature
- US20170293530A1 PROVIDING SNAPSHOT ISOLATION TO A DATABASE MANAGEMENT SYSTEM Public/Granted day:2017-10-12
Information query