Patent · US Active

Providing snapshot isolation to a database management system

US10585876B2 · kind B2 · utility

10Cited by

7References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Andreas Brodt · Gerlingen, DE
Daniel Martin · Stuttgart, DE
Oliver Schiller · Seligenstadt, DE
Knut Stolze · Jena, DE

Key dates

Filing date	Aug 1, 2016
Grant date	Mar 10, 2020
Priority date	—
Expiry date	Jul 21, 2038

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2365
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.